ud_samplepoint - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table of spatial objects representing sample points.
Fields:
| Column name | Data type | Description |
|---|---|---|
| sample_id | character varying(16) | Description |
| code | text | Description |
| lab_code | character varying(30) | Description |
| feature_id | character varying(16) | Description |
| featurecat_id | character varying(30) | Description |
| dma_id | int | Description |
| state | smallint | Description |
| builtdate | date | Description |
| enddate | date | Description |
| workcat_id | character varying(255) | Description |
| workcat_id_end | character varying(255) | Description |
| rotation | numeric(12, 3) | Description |
| muni_id | int | Description |
| postcode | character varying(16) | Description |
| streetaxis_id | character varying(16) | Description |
| postnumber | int | Description |
| postcomplement | character varying(100) | Description |
| streetaxis2_id | character varying(16) | Description |
| postnumber2 | int | Description |
| postcomplement2 | character varying(100) | Description |
| place_name | character varying(254) | Description |
| cabinet | character varying(150) | Description |
| observations | character varying(254) | Description |
| verified | character varying(30) | Description |
| the_geom | public.geometry(point, 25831) | Description |
| expl_id | int | Description |
| tstamp | timestamp | Description |
| link | character varying(512) | Description |
| district_id | int | Description |
| sector_id | int | Description |