units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
45 rows where MNG_AG_TYP = 20 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 5
- Private Recreation or Education 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 2
MNG_AG_TYP 1
- Non Profit - Other · 5 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3710 | 3710 | 3709 | {"type": "Polygon", "coordinates": [[[-117.12997, 34.00757], [-117.12565, 34.00736], [-117.12569, 34.01105], [-117.12135, 34.01083], [-117.12136, 34.0124], [-117.11672, 34.01318], [-117.11671, 34.01471], [-117.11253, 34.01494], [-117.11247, 34.01855], [-117.11191, 34.01851], [-117.1119, 34.01823], [-117.11177, 34.01822], [-117.1117, 34.01827], [-117.11153, 34.01825], [-117.11138, 34.01805], [-117.11128, 34.01822], [-117.11086, 34.01823], [-117.10962, 34.01775], [-117.10954, 34.01781], [-117.10954, 34.01786], [-117.10942, 34.01774], [-117.10934, 34.01772], [-117.10927, 34.01772], [-117.10918, 34.01753], [-117.10925, 34.01752], [-117.10915, 34.01654], [-117.10816, 34.01601], [-117.10719, 34.01448], [-117.10708, 34.0126], [-117.10573, 34.01116], [-117.10685, 34.01022], [-117.10756, 34.01071], [-117.11261, 34.01028], [-117.1126, 34.01067], [-117.11262, 34.01068], [-117.11494, 34.0093], [-117.1164, 34.00859], [-117.11749, 34.00742], [-117.11913, 34.0066], [-117.11913, 34.00658], [-117.11825, 34.00577], [-117.11884, 34.00524], [-117.11984, 34.00498], [-117.12059, 34.00429], [-117.12243, 34.00429], [-117.12244, 34.00434], [-117.12273, 34.00488], [-117.12362, 34.00456], [-117.12395, 34.00465], [-117.12397, 34.00461], [-117.12449, 34.00464], [-117.12498, 34.0043], [-117.12991, 34.0043], [-117.12997, 34.00757]]]} | Open Access 1 | 48815 | Live Oak Canyon Open Space | 33535 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 3302 | Redlands Conservancy 660 | Non Profit 6 | Non Profit - Other 20 | San Bernardino 22 | 338.281 | Live Oak Canyon OS | None 309 | |||
3034 | 3034 | 3033 | {"type": "Polygon", "coordinates": [[[-122.39104, 37.75772], [-122.39035, 37.75777], [-122.39033, 37.7576], [-122.39101, 37.75756], [-122.39104, 37.75772]]]} | Open Access 1 | 48833 | Woods Yard | 33552 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/woods-yard | San Francisco 13 | 0.275 | Woods Yard | None 249 | ||
13784 | 13784 | 13783 | {"type": "Polygon", "coordinates": [[[-122.39106, 37.77842], [-122.38914, 37.77988], [-122.38862, 37.78032], [-122.38843, 37.78055], [-122.38828, 37.78079], [-122.38819, 37.78101], [-122.38806, 37.78144], [-122.388, 37.78149], [-122.38791, 37.78151], [-122.38783, 37.7815], [-122.38776, 37.78145], [-122.38774, 37.78141], [-122.38768, 37.7806], [-122.38752, 37.77914], [-122.38746, 37.77826], [-122.38762, 37.77821], [-122.38757, 37.77824], [-122.38779, 37.78026], [-122.38849, 37.78024], [-122.38856, 37.78029], [-122.391, 37.77836], [-122.39106, 37.77842]]]} | Open Access 1 | 48834 | South Beach Park | 33553 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/south-beach-park | San Francisco 13 | 2.826 | South Beach Park | None 1186 | ||
13918 | 13918 | 13917 | {"type": "Polygon", "coordinates": [[[-122.47779, 37.71752], [-122.47794, 37.71754], [-122.47824, 37.71766], [-122.47842, 37.71779], [-122.47855, 37.71794], [-122.47864, 37.71809], [-122.47866, 37.71822], [-122.47864, 37.7183], [-122.4786, 37.71838], [-122.47849, 37.71848], [-122.47836, 37.71855], [-122.47824, 37.71859], [-122.4781, 37.71859], [-122.47795, 37.71857], [-122.47777, 37.71849], [-122.47759, 37.71838], [-122.47748, 37.71829], [-122.47737, 37.71816], [-122.47731, 37.71806], [-122.47729, 37.71796], [-122.47729, 37.71787], [-122.47733, 37.71778], [-122.47742, 37.71767], [-122.47753, 37.71758], [-122.47763, 37.71754], [-122.47779, 37.71752]]]} | Open Access 1 | 48836 | Robert Pender Park | 33555 | 6134 | Parkmerced Owner LLC 1068 | Private 7 | Home Owners Association 16 | https://www.parkmerced.com/ | Private 14 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/robert-pender-park | San Francisco 13 | 2.548 | Robert Pender Park | 0 | Private Recreation or Education 65 | 4 |
2489 | 2489 | 2488 | {"type": "Polygon", "coordinates": [[[-122.44958, 37.76633], [-122.44898, 37.76641], [-122.44881, 37.76647], [-122.44849, 37.76654], [-122.44848, 37.76657], [-122.44806, 37.76662], [-122.44802, 37.76642], [-122.44844, 37.76637], [-122.44846, 37.7664], [-122.44872, 37.76635], [-122.44892, 37.76627], [-122.44902, 37.7662], [-122.44899, 37.76602], [-122.4495, 37.76595], [-122.44958, 37.76633]]]} | Open Access 1 | 48909 | Richard Gamble Memorial Park | 33627 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | https://www.sfparksalliance.org/our-parks/parks/gamble-memorial-park | San Francisco 13 | 0.912 | Richard Gamble Memorial Park | None 205 |
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]);