units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where MNG_AGENCY = 391 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 8
- Local Park 31
- Local Other or Unknown 1
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 38
MNG_AGENCY 1
- Redwood City, City of · 38 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1627 | 1627 | 1626 | {"type": "Polygon", "coordinates": [[[-122.2018, 37.48289], [-122.20065, 37.48477], [-122.20046, 37.48474], [-122.20042, 37.48472], [-122.20037, 37.48466], [-122.20038, 37.48459], [-122.20146, 37.48281], [-122.2016, 37.48286], [-122.20164, 37.48282], [-122.2018, 37.48289]]]} | Open Access 1 | 13912 | Andrew Spinas Park | 15485 | 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 | 1.759 | Andrew Spinas Park | 1966 | Local Park 2 | 4 | |
16218 | 16218 | 16217 | {"type": "Polygon", "coordinates": [[[-122.22793, 37.48527], [-122.22733, 37.48531], [-122.22736, 37.48573], [-122.22753, 37.48573], [-122.22757, 37.4862], [-122.22745, 37.48621], [-122.22741, 37.48624], [-122.22744, 37.48647], [-122.22728, 37.48648], [-122.22726, 37.48622], [-122.22687, 37.48623], [-122.22681, 37.48552], [-122.22635, 37.48554], [-122.22634, 37.48545], [-122.22691, 37.48543], [-122.22699, 37.48541], [-122.22702, 37.48538], [-122.22697, 37.48472], [-122.22701, 37.48471], [-122.22698, 37.48425], [-122.22714, 37.48431], [-122.22789, 37.48476], [-122.22793, 37.48527]]]} | Open Access 1 | 13947 | City Center Plaza | 17290 | 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 | 3.295 | City Ctr. Plaza | 1940 | Local Park 2 | 4 | |
8671 | 8671 | 8670 | {"type": "Polygon", "coordinates": [[[-122.23003, 37.48738], [-122.22934, 37.48741], [-122.22928, 37.48659], [-122.22997, 37.48656], [-122.23003, 37.48738]]]} | Open Access 1 | 13949 | Courthouse Square | 17720 | 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 | 1.375 | Courthouse Square | 1940 | Local Park 2 | 4 | |
8672 | 8672 | 8671 | {"type": "Polygon", "coordinates": [[[-122.24787, 37.52556], [-122.24764, 37.52556], [-122.24737, 37.52561], [-122.24712, 37.52573], [-122.24692, 37.52589], [-122.24683, 37.526], [-122.24678, 37.5261], [-122.24609, 37.5276], [-122.24642, 37.52771], [-122.24643, 37.52775], [-122.246, 37.52784], [-122.24583, 37.52772], [-122.246, 37.5275], [-122.24612, 37.52732], [-122.24622, 37.52709], [-122.24632, 37.52674], [-122.2464, 37.52653], [-122.24692, 37.52562], [-122.24707, 37.52552], [-122.24725, 37.52548], [-122.2478, 37.52546], [-122.24787, 37.52556]]]} | Open Access 1 | 13951 | Cringle Park | 17821 | 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 | 1.205 | Cringle Park | 1973 | Local Park 2 | 4 | |
8654 | 8654 | 8653 | {"type": "Polygon", "coordinates": [[[-122.24791, 37.53233], [-122.2468, 37.53333], [-122.24683, 37.53337], [-122.24595, 37.53412], [-122.24595, 37.53416], [-122.24589, 37.53417], [-122.24573, 37.53405], [-122.24778, 37.53226], [-122.24781, 37.53226], [-122.24791, 37.53233]]]} | Open Access 1 | 13878 | Davit Lane | 17956 | 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 | 1.162 | Davit Lane | 1974 | None 726 | ||
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 | |
8655 | 8655 | 8654 | {"type": "Polygon", "coordinates": [[[-122.25411, 37.47894], [-122.25351, 37.47941], [-122.25343, 37.47934], [-122.25337, 37.47924], [-122.25335, 37.4791], [-122.25338, 37.47896], [-122.25347, 37.47885], [-122.25363, 37.47875], [-122.25376, 37.47872], [-122.25392, 37.47871], [-122.2539, 37.47884], [-122.25402, 37.47888], [-122.25411, 37.47894]]]} | Open Access 1 | 13881 | Dove Beeger Park | 18249 | 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 | 0.721 | Dove Beeger Park | 1963 | Local Park 2 | 4 | |
8673 | 8673 | 8672 | {"type": "Polygon", "coordinates": [[[-122.27117, 37.45741], [-122.27093, 37.45788], [-122.26989, 37.45761], [-122.26964, 37.45805], [-122.26951, 37.458], [-122.2692, 37.45781], [-122.26859, 37.45752], [-122.26856, 37.45745], [-122.26882, 37.45705], [-122.26888, 37.45692], [-122.26896, 37.45657], [-122.26895, 37.45638], [-122.27054, 37.45589], [-122.27063, 37.45594], [-122.27091, 37.45618], [-122.27094, 37.45622], [-122.27101, 37.45681], [-122.271, 37.45689], [-122.27095, 37.45703], [-122.27095, 37.45711], [-122.27099, 37.45722], [-122.27117, 37.45741]]]} | Open Access 1 | 13953 | Easter Bowl | 18390 | 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 | 8.862 | Easter Bowl | 1973 | None 728 | ||
8650 | 8650 | 8649 | {"type": "Polygon", "coordinates": [[[-122.21235, 37.47671], [-122.21207, 37.47697], [-122.21157, 37.47664], [-122.21202, 37.47668], [-122.21235, 37.47671]]]} | Open Access 1 | 13955 | Fair Oaks Community Cente | 18784 | 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 | 0.275 | Fair Oaks Community Cente | 1961 | None 723 | ||
5763 | 5763 | 5762 | {"type": "Polygon", "coordinates": [[[-122.2214, 37.47243], [-122.22103, 37.47246], [-122.2208, 37.47275], [-122.22046, 37.47258], [-122.2209, 37.47202], [-122.22124, 37.47218], [-122.22116, 37.47228], [-122.2214, 37.47243]]]} | Open Access 1 | 13921 | Fleishman Park | 18942 | 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 | 0.726 | Fleishman Park | 1939 | 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 | |
6137 | 6137 | 6136 | {"type": "Polygon", "coordinates": [[[-122.23198, 37.47215], [-122.23113, 37.47282], [-122.23092, 37.4728], [-122.23031, 37.47231], [-122.23032, 37.47228], [-122.23124, 37.47156], [-122.23198, 37.47215]]]} | Open Access 1 | 13957 | Hawes Park | 19743 | 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.67 | Hawes Park | 1935 | Local Park 2 | 4 | |
2019 | 2019 | 2018 | {"type": "Polygon", "coordinates": [[[-122.21778, 37.48305], [-122.21644, 37.48394], [-122.21344, 37.48339], [-122.21436, 37.48199], [-122.21537, 37.48239], [-122.21599, 37.4823], [-122.21778, 37.48305]]]} | Open Access 1 | 16988 | Hoover Park | 20081 | 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 | 11.512 | Hoover Park | 1984 | Local Park 2 | 4 | |
8656 | 8656 | 8655 | {"type": "Polygon", "coordinates": [[[-122.22233, 37.48195], [-122.22209, 37.48228], [-122.22181, 37.48214], [-122.22181, 37.48212], [-122.22203, 37.48181], [-122.22233, 37.48195]]]} | Open Access 1 | 13884 | Jardin de Ninos Park | 20365 | 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 | 0.315 | Jardin de Ninos Park | 1981 | Local Park 2 | 4 | |
8659 | 8659 | 8658 | {"type": "Polygon", "coordinates": [[[-122.22766, 37.48359], [-122.22718, 37.48409], [-122.22707, 37.48402], [-122.22692, 37.48377], [-122.2268, 37.4835], [-122.22668, 37.48328], [-122.22659, 37.48302], [-122.22652, 37.48287], [-122.22766, 37.48359]]]} | Open Access 1 | 13895 | John S. Roselli Memorial | 20468 | 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 | 1.258 | John S. Roselli Memorial | 1940 | None 727 | ||
8657 | 8657 | 8656 | {"type": "Polygon", "coordinates": [[[-122.21919, 37.47246], [-122.21905, 37.47264], [-122.21812, 37.47272], [-122.2181, 37.47267], [-122.2181, 37.47261], [-122.21814, 37.47255], [-122.21919, 37.47246]]]} | Open Access 1 | 13887 | Linden Park | 21292 | 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 | 0.406 | Linden Park | 1986 | Local Park 2 | 4 | |
8663 | 8663 | 8662 | {"type": "Polygon", "coordinates": [[[-122.2363, 37.4575], [-122.23548, 37.45765], [-122.23547, 37.45761], [-122.23561, 37.45723], [-122.23544, 37.45712], [-122.23542, 37.45698], [-122.23558, 37.45712], [-122.23592, 37.45706], [-122.23602, 37.45706], [-122.23616, 37.45702], [-122.2363, 37.4575]]]} | Open Access 1 | 13925 | Maddux Park | 21646 | 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 | 0.89 | Maddux Park | 2000 | Local Park 2 | 4 | |
8660 | 8660 | 8659 | {"type": "Polygon", "coordinates": [[[-122.22487, 37.48152], [-122.22446, 37.48126], [-122.2246, 37.48107], [-122.2246, 37.48107], [-122.22487, 37.48152]]]} | Open Access 1 | 13898 | Main Street Park | 21693 | 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 | 0.14 | Main Street Park | 1940 | Local Park 2 | 4 | |
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 | |
8668 | 8668 | 8667 | {"type": "Polygon", "coordinates": [[[-122.25242, 37.52835], [-122.25194, 37.52877], [-122.25218, 37.52896], [-122.25152, 37.52954], [-122.25126, 37.52936], [-122.25076, 37.5298], [-122.25101, 37.53], [-122.25099, 37.53004], [-122.25099, 37.5301], [-122.25102, 37.53016], [-122.25107, 37.53021], [-122.25076, 37.53048], [-122.25069, 37.53043], [-122.25012, 37.53046], [-122.24915, 37.53133], [-122.24909, 37.5313], [-122.24808, 37.53219], [-122.2478, 37.53199], [-122.24802, 37.53178], [-122.24737, 37.53131], [-122.24892, 37.52996], [-122.24925, 37.53019], [-122.24948, 37.52999], [-122.24961, 37.53008], [-122.24968, 37.53007], [-122.25034, 37.5295], [-122.25059, 37.52968], [-122.25109, 37.52924], [-122.25085, 37.52905], [-122.25151, 37.52847], [-122.25176, 37.52865], [-122.25225, 37.52823], [-122.25242, 37.52835]]]} | Open Access 1 | 13937 | Marlin Park | 21880 | 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 | 10.974 | Marlin Park | 1970 | 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]);