Structure for table EDPNI                      

-------------------------------------------                      

Field Information                  

FIELD FIELD NAME        TYPE        LENGTH            DESCRIPTION

1     taxyear           numeric     (4,0) NOT NULL    Tax year

2     parcel varchar     (9) NOT NULL      Unique identifier for each property

3     DORMARKET         int         NULL              Geographic area used by Department of Revenue (DOR) to analyze valuation performance

4     DORSUBAREA       int         NULL              Smaller geographic area also used by DOR to analyze valuation performance

5     TRACT             varchar     (6) NULL          Census tract number

6     NLRECODIST smallint    NULL              Economic District-Geographic area used for stratifying data in mass appraisal

7     NLRNBHD    varchar     (8) NULL          Neighborhood-Smaller geographic area used to further stratify data in mass appraisal

8     MP                varchar     (8) NOT NULL      Map and plat or book and page number to identify recorded subdivisions

9     LON               numeric     (16,5) NULL       Longitude

10    LAT               numeric     (16,5) NULL       Latitude

11    X                 numeric     (10,1) NULL       Horizontal pixel location of a particular parcel

12    Y                 numeric     (10,1) NULL       Vertical pixel location of a particular parcel

13    Z                 int         NULL              Elevation of parcel

14    POLYS             int         NULL              Number of polygons

15    LANDSQFT          numeric     (16,0) NULL       Approximate GIS land square footage

16    DISTRICT          varchar     (32) NULL         Name of Economic District

17    SUBAREANAM  varchar     (50) NULL         Name of sub area

18    MFRSA             varchar     (28) NULL         Name of multi-family sub area