units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, MNG_AGENCY = 391 and YR_EST = 1978
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1831 | 1831 | 1830 | {"type": "Polygon", "coordinates": [[[-122.25021, 37.5256], [-122.24964, 37.5261], [-122.2493, 37.52562], [-122.24918, 37.52553], [-122.24903, 37.52546], [-122.2489, 37.52543], [-122.24873, 37.52543], [-122.24826, 37.52554], [-122.24808, 37.52556], [-122.24787, 37.52556], [-122.2478, 37.52546], [-122.24787, 37.52541], [-122.24792, 37.52534], [-122.24799, 37.52472], [-122.24796, 37.52444], [-122.24786, 37.52424], [-122.24781, 37.5241], [-122.24779, 37.52394], [-122.2478, 37.52381], [-122.24792, 37.52383], [-122.24796, 37.524], [-122.24805, 37.52413], [-122.24924, 37.52518], [-122.24939, 37.52527], [-122.24954, 37.52533], [-122.24994, 37.52541], [-122.25021, 37.5256]]]} | Open Access 1 | 13927 | Mariner Park | 21853 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 4.052 | Mariner Park | 1978 | Local Park 2 | 4 | |
5103 | 5103 | 5102 | {"type": "MultiPolygon", "coordinates": [[[[-122.25474, 37.52654], [-122.2544, 37.52655], [-122.25441, 37.52681], [-122.25397, 37.52683], [-122.25398, 37.5271], [-122.25365, 37.52712], [-122.25354, 37.52714], [-122.25339, 37.5272], [-122.25324, 37.52731], [-122.25321, 37.52732], [-122.25318, 37.52731], [-122.25322, 37.5273], [-122.25463, 37.52605], [-122.25474, 37.52613], [-122.25472, 37.52627], [-122.25474, 37.52654]]], [[[-122.25693, 37.52551], [-122.25691, 37.52553], [-122.25615, 37.52556], [-122.25562, 37.52518], [-122.256, 37.52484], [-122.25693, 37.52551]]]]} | Open Access 1 | 13914 | Dolphin Park | 18193 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 2.184 | Dolphin Park | 1978 | Local Park 2 | 4 | |
8662 | 8662 | 8661 | {"type": "MultiPolygon", "coordinates": [[[[-122.25846, 37.46818], [-122.25814, 37.46833], [-122.25834, 37.4685], [-122.25793, 37.46876], [-122.25797, 37.46931], [-122.25783, 37.46935], [-122.25634, 37.46817], [-122.25647, 37.46807], [-122.25679, 37.46821], [-122.25688, 37.46822], [-122.25699, 37.46821], [-122.25707, 37.46819], [-122.25714, 37.46814], [-122.25731, 37.46791], [-122.25738, 37.46787], [-122.25752, 37.46785], [-122.25769, 37.46789], [-122.25778, 37.46789], [-122.2581, 37.46776], [-122.25841, 37.4677], [-122.25846, 37.46818]]], [[[-122.25795, 37.46767], [-122.25777, 37.46781], [-122.25771, 37.46781], [-122.25753, 37.46777], [-122.25742, 37.46777], [-122.25731, 37.46781], [-122.25716, 37.46793], [-122.25703, 37.4681], [-122.25693, 37.46815], [-122.25679, 37.46814], [-122.2565, 37.46801], [-122.25658, 37.4679], [-122.25665, 37.46777], [-122.25683, 37.46778], [-122.25704, 37.46749], [-122.25737, 37.46724], [-122.25795, 37.46767]]]]} | Open Access 1 | 13923 | Garret Park | 19223 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 5.231 | Garret Park | 1978 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);