Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>First you need to determine if the problem is with the shapefile. Try loading the file using a true GIS tool such as QuantumGIS. Once you are sure your SHP file is correct, post your code so we can see how you are using shapefile.py. My guess is that the SHP file is incorrect in some way andn Quantum GIS will either fix it or tell you whats wrong. Bonus: QuantumGIS has python embeded as a plugin development tool.</p> <p><strong>EDIT:</strong> I downloaded the file dryclean_apr12.shp from the Florida DEP. According to the dbf data, there are 1423 records. When I use your code snippet I get 1423 shapes all of shapetype=1 which indicates that each shape is a single point.</p> <p>Therefore your code is correct, the issue has to be with the file.</p> <p>I noticed in your sample data that the shapetype is 21 or a PointM which is defined as </p> <p>Position Field Value Type Number Order</p> <pre><code>Byte 0 Shape Type 21 Integer 1 Little Byte 4 X X Double 1 Little Byte 12 Y Y Double 1 Little Byte 20 M M Double 1 Little </code></pre> <p>A Point is defined as </p> <pre><code>Position Field Value Type Number Order Byte 0 Shape Type 1 Integer 1 Little Byte 4 X X Double 1 Little Byte 12 Y Y Double 1 Little </code></pre> <p>Either the Shapefile is corrupt or there is a bug in shapefile.py.</p> <p>A Shapefile with PointM has a layout of </p> <pre><code>IDDD IDDD IDDD IDDD IDDD IDDD </code></pre> <p>If Shapefile is reading this as a Point (IDD)</p> <p>Then the file is read as </p> <pre><code>IDD Rec 1 Read OK did Rec 2 Error on Type ddi Rec 3 error on Type ddd Rec 4 error on Type IDD Rec 5 Read OK </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POOnly every 5th shape valid reading shapefile
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USWombatPM
    1. USWombatPM
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POOnly every 5th shape valid reading shapefile
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThe shapefile is published by the Florida DEP and displays correctly in Google Earth Professional (according to my colleague who obtained the file). Code is just a couple of lines, I'll add it to question.
      singulars
      1. PO
      1. USLarry Lustig
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload