units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, AGNCY_LEV = 2, DES_TP = 2 and YR_EST = 1975
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8774 | 8774 | 8773 | {"type": "Polygon", "coordinates": [[[-122.49163, 37.66643], [-122.49162, 37.66709], [-122.49046, 37.66708], [-122.48986, 37.66709], [-122.48952, 37.66716], [-122.48943, 37.66703], [-122.48945, 37.66693], [-122.48946, 37.66658], [-122.48976, 37.66658], [-122.48983, 37.66646], [-122.48982, 37.66623], [-122.49153, 37.66626], [-122.49153, 37.66642], [-122.49163, 37.66643]]]} | Open Access 1 | 14271 | Longview Park | 21457 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 4.097 | Longview Park | 1975 | Local Park 2 | 4 | |
8784 | 8784 | 8783 | {"type": "Polygon", "coordinates": [[[-122.49422, 37.67986], [-122.49409, 37.68022], [-122.49374, 37.68015], [-122.49378, 37.68003], [-122.49381, 37.67984], [-122.49369, 37.67956], [-122.49403, 37.67946], [-122.49422, 37.67986]]]} | Open Access 1 | 14287 | Northridge Park | 28792 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 0.642 | Northridge Park | 1975 | Local Park 2 | 4 | |
8791 | 8791 | 8790 | {"type": "MultiPolygon", "coordinates": [[[[-122.39528, 37.59394], [-122.38939, 37.59734], [-122.38915, 37.59707], [-122.39089, 37.59607], [-122.3911, 37.59626], [-122.39165, 37.59597], [-122.39165, 37.59595], [-122.39145, 37.59575], [-122.39305, 37.59482], [-122.39471, 37.59366], [-122.39481, 37.59358], [-122.39484, 37.59357], [-122.39494, 37.59351], [-122.39528, 37.59394]]], [[[-122.40184, 37.59691], [-122.40145, 37.59714], [-122.40141, 37.59713], [-122.40108, 37.59693], [-122.40089, 37.59671], [-122.40093, 37.59665], [-122.40068, 37.59652], [-122.40053, 37.59642], [-122.4005, 37.59644], [-122.40022, 37.5962], [-122.39966, 37.59584], [-122.39922, 37.59541], [-122.39908, 37.59509], [-122.39951, 37.59487], [-122.40018, 37.59558], [-122.4007, 37.59603], [-122.40076, 37.59601], [-122.40079, 37.59603], [-122.40093, 37.59596], [-122.40184, 37.59691]]], [[[-122.40762, 37.59812], [-122.40671, 37.59864], [-122.40508, 37.59828], [-122.40481, 37.59844], [-122.40388, 37.59818], [-122.4032, 37.59794], [-122.4025, 37.59763], [-122.40167, 37.59719], [-122.40196, 37.59703], [-122.40249, 37.59715], [-122.40297, 37.59737], [-122.40346, 37.59757], [-122.40377, 37.59739], [-122.4038, 37.59741], [-122.40346, 37.5976], [-122.40346, 37.59762], [-122.40434, 37.59789], [-122.40487, 37.59743], [-122.40752, 37.598], [-122.40762, 37.59812]]]]} | Open Access 1 | 14301 | Spur Trail Park | 25755 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 18.129 | Spur Trail Park | 1975 | Local Park 2 | 4 | |
8856 | 8856 | 8855 | {"type": "Polygon", "coordinates": [[[-122.28792, 38.28849], [-122.28768, 38.28918], [-122.28666, 38.28895], [-122.2869, 38.28829], [-122.28792, 38.28849]]]} | Open Access 1 | 14480 | Kiwanis Park | 20683 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.783 | Kiwanis Park | 1975 | Local Park 2 | 4 | |
9055 | 9055 | 9054 | {"type": "Polygon", "coordinates": [[[-121.90296, 37.44503], [-121.90289, 37.44506], [-121.90284, 37.44514], [-121.90286, 37.44521], [-121.90294, 37.44527], [-121.9028, 37.44554], [-121.90282, 37.44581], [-121.90289, 37.44587], [-121.90282, 37.44599], [-121.90281, 37.44623], [-121.90275, 37.44626], [-121.90226, 37.44629], [-121.90223, 37.44597], [-121.90228, 37.44594], [-121.90232, 37.44588], [-121.90226, 37.44527], [-121.90221, 37.4452], [-121.9021, 37.44518], [-121.90207, 37.4449], [-121.90157, 37.44492], [-121.90155, 37.44464], [-121.90147, 37.4446], [-121.90149, 37.44453], [-121.90145, 37.44409], [-121.90291, 37.44401], [-121.90287, 37.44428], [-121.90293, 37.44432], [-121.90289, 37.4444], [-121.90292, 37.44447], [-121.90287, 37.44451], [-121.90287, 37.44478], [-121.90296, 37.44503]]]} | Open Access 1 | 14988 | Strickroth Park | 25925 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 4.943 | Strickroth Park | 1975 | 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]);