Revision 13132
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 13478 | 13478 |
-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 13479 | 13479 |
-- |
| 13480 | 13480 |
|
| 13481 |
CREATE UNIQUE INDEX coordinates_unique ON coordinates USING btree (source_id, latitude_deg, longitude_deg, (COALESCE(verbatimlatitude, '\N'::text)), (COALESCE(verbatimlongitude, '\N'::text)), (COALESCE(verbatimcoordinates, '\N'::text)), (COALESCE(footprintgeometry_dwc, '\N'::text))); |
|
| 13481 |
CREATE UNIQUE INDEX coordinates_unique ON coordinates USING btree (source_id, latitude_deg, longitude_deg, (COALESCE(verbatimlatitude, '\N'::text)), (COALESCE(verbatimlongitude, '\N'::text)), (COALESCE(verbatimcoordinates, '\N'::text)), (COALESCE(footprintgeometry_dwc, '\N'::text)), (COALESCE(coordsaccuracy_m, 'NaN'::double precision)));
|
|
| 13482 | 13482 |
|
| 13483 | 13483 |
|
| 13484 | 13484 |
-- |
Also available in: Unified diff
bugfix: schemas/vegbien.sql: coordinates_unique: added coordsaccuracy_m