Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FIELD NAME

PostgreSQL 11 DATA TYPE

PostGIS 2.5 DATA TYPE

DESCRIPTION

1

id

text

2

eas_address_base_id

integer

3

base_address_num

integer

4

base_address_suffix

character varying(10)

5

street_name

character varying(60)

6

street_type

character varying(6)

7

street_post_direction

character varying(10)

8

street_cnn

integer

9

street_full_street_name

character varying(255)

10

base_address_create_tms

timestamp without time zone

11

base_address_retire_tms

timestamp without time zone

12

eas_unit_address_id

integer

13

unit_address_base_flg

boolean

14

unit_address

character varying(10)

15

unit_address_create_tms

timestamp without time zone

16

unit_address_retire_tms

timestamp without time zone

17

disposition_description

character varying(20)

18

map_block_lot

character varying(10)

19

block_lot

character varying(9)

20

parcel_date_map_add

date

21

parcel_date_map_drop

date

22

eas_address_x_parcel_id

integer

23

address_x_parcel_create_tms

timestamp without time zone

24

address_x_parcel_retire_tms

timestamp without time zone

25

zipcode

character varying(50)

26

longitude

float

In the WGS 84 spatial reference system. See EPSG:4326.

27

latitude

float

In the WGS 84 spatial reference system. See EPSG:4326.

28

geometry

geometry

In the NAD83 / California zone 3 (ftUS) spatial reference system. See EPSG:2227.

...