Revision 5992
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4161 | 4161 |
|
| 4162 | 4162 |
|
| 4163 | 4163 |
-- |
| 4164 |
-- Name: place_matched_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4165 |
-- |
|
| 4166 |
|
|
| 4167 |
CREATE INDEX place_matched_place_id_idx ON place (matched_place_id); |
|
| 4168 |
|
|
| 4169 |
|
|
| 4170 |
-- |
|
| 4164 | 4171 |
-- Name: place_unique_within_creator_by_code; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4165 | 4172 |
-- |
| 4166 | 4173 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 2497 | 2497 |
-- |
| 2498 | 2498 |
|
| 2499 | 2499 |
CREATE VIEW geoscrub_input_view AS |
| 2500 |
SELECT DISTINCT analytical_aggregate.country, analytical_aggregate."stateProvince", analytical_aggregate.county, analytical_aggregate."decimalLatitude", analytical_aggregate."decimalLongitude" FROM analytical_aggregate;
|
|
| 2500 |
SELECT DISTINCT place.country, place.stateprovince AS "stateProvince", place.county, coordinates.latitude_deg AS "decimalLatitude", coordinates.longitude_deg AS "decimalLongitude" FROM (place JOIN coordinates USING (coordinates_id));
|
|
| 2501 | 2501 |
|
| 2502 | 2502 |
|
| 2503 | 2503 |
-- |
| ... | ... | |
| 5085 | 5085 |
|
| 5086 | 5086 |
|
| 5087 | 5087 |
-- |
| 5088 |
-- Name: place_matched_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5089 |
-- |
|
| 5090 |
|
|
| 5091 |
CREATE INDEX place_matched_place_id_idx ON place USING btree (matched_place_id); |
|
| 5092 |
|
|
| 5093 |
|
|
| 5094 |
-- |
|
| 5088 | 5095 |
-- Name: place_unique_within_creator_by_code; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5089 | 5096 |
-- |
| 5090 | 5097 |
|
Also available in: Unified diff
schemas/vegbien.sql: place: Added index on matched_place_id to facilitate looking up places by matched_place_id in place_set_canon_place_id()