[postgis-users] shp2pgsql and shx

[Andrea Maschio]

Oh no, thank for this finally I found the .shx it was just the  
curiosity of understanding something new :)

--
Andrea Maschio

http://www.superandrew.it

Il giorno 29/gen/08, alle ore 00:55, "P Kishor" <punk.kish at gmail.com>  
ha scritto:

> On 1/28/08, Andrea Maschio <andrea.maschio at gmail.com> wrote:
>> So the result seems to be actually you can't import Shape files w/out
>> their indexes.
>
> Well, no. At least, I didn't say so, and I don't think enough has been
> said in this thread to definitively arrive at that conclusion. Only
> the creator(s) of shp2pgsql will be definitively able to establish the
> above. What we can say definitively is that you *can* read both the
> geometry and its corresponding attributes using whatever method as
> long as you remember the order of the entries in the respective files.
> You just can't do it with a program that uses the SHX as the
> cross-reference.
>
> In the meantime, there could be a multitude of reasons by shp2pgsql
> can't read your file.
>
> In other words, while we all have learned something new, you are still
> at square 1.
>
> :-(
>
>>
>> Thanks a lot
>>
>> Andrea Maschio
>>
>> Il giorno 29/gen/08, alle ore 00:27, P Kishor ha scritto:
>>
>>> On 1/28/08, Martin Davis <mbdavis at refractions.net> wrote:
>>>> Actually the SHP and DBF files are "linked" simply by the order of
>>>> the
>>>> records in the files.  So the SHX file isn't needed to read the  
>>>> data.
>>>> It is only required if you want to read the data through the index.
>>>
>>> You are absolutely correct on both counts. I realized my misleading
>>> message after I had sent it as I have been happily reading DBF files
>>> and modifying them using Perl directly and the parent Shapefile has
>>> been ok. Thanks for pointing it out.
>>>
>>> To the OP -- one of them (between SHP and DBF) is indexed starting  
>>> at
>>> 0 and the other one starting at 1 (I always forget which one is
>>> which).
>>>
>>> Perhaps shp2pgsql does exactly that... read the attributes for each
>>> shape via the index.
>>>
>>>>
>>>> P Kishor wrote:
>>>>> On 1/28/08, Andrea Maschio <andrea.maschio at gmail.com> wrote:
>>>>>
>>>>>> Hello all, is it normal that trying to convert a shape into sql
>>>>>> with
>>>>>> shp2pgsql I have an error stating that i need the .shx index
>>>>>> file? Is there
>>>>>> an option for importing having only the .shp file?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> Andrea Maschio
>>>>>>
>>>>>>
>>>>>
>>>>> The .shx file is the link between the geometry (.shp) and the
>>>>> attributes (.dbf). These three are the minimum necessary
>>>>> components of
>>>>> an ESRI Shapefile. If your .shx/.dbf are missing then you have any
>>>>> incomplete Shapefile.
>>>>> _______________________________________________
>>>>> postgis-users mailing list
>>>>> postgis-users at postgis.refractions.net
>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>
>>>>>
>>>>
>>>> --
>>>> Martin Davis
>>>> Senior Technical Architect
>>>> Refractions Research, Inc.
>>>> (250) 383-3022
>>>>
>>>>
>>>
>>>
>>> --
>>> Puneet Kishor http://punkish.eidesis.org/
>>> Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
>>> Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
>
> -- 
> Puneet Kishor http://punkish.eidesis.org/
> Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
> Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/