units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1978
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194 | 194 | 193 | {"type": "Polygon", "coordinates": [[[-121.94552, 37.31845], [-121.94347, 37.31848], [-121.94348, 37.31762], [-121.94351, 37.31759], [-121.94354, 37.31758], [-121.94357, 37.31766], [-121.94364, 37.31768], [-121.94368, 37.31766], [-121.9437, 37.31764], [-121.94369, 37.31755], [-121.94377, 37.31753], [-121.94543, 37.31734], [-121.94548, 37.31734], [-121.94551, 37.31739], [-121.94552, 37.31845]]]} | Open Access 1 | 550 | Santana Park | 25148 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.009 | Santana Park | 1978 | Local Park 2 | 4 | |
751 | 751 | 750 | {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30262], [-122.02649, 37.30263], [-122.02622, 37.30302], [-122.02611, 37.30314], [-122.02528, 37.30385], [-122.02406, 37.30433], [-122.02399, 37.30413], [-122.02384, 37.30385], [-122.0238, 37.30366], [-122.02375, 37.30168], [-122.0238, 37.30147], [-122.02381, 37.30133], [-122.02383, 37.30129], [-122.02389, 37.30126], [-122.02608, 37.30126], [-122.02635, 37.30123], [-122.02668, 37.30115], [-122.02681, 37.30115]]]} | Open Access 1 | 5576 | Calabazas | 16668 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 16.77 | Calabazas | 1978 | None 69 | ||
1009 | 1009 | 1008 | {"type": "Polygon", "coordinates": [[[-121.85208, 37.24596], [-121.85169, 37.24702], [-121.85135, 37.24693], [-121.85055, 37.24676], [-121.8482, 37.24621], [-121.84858, 37.24515], [-121.85208, 37.24596]]]} | Open Access 1 | 5500 | Cahalan | 16655 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 9.757 | Cahalan | 1978 | None 91 | ||
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 | |
5880 | 5880 | 5879 | {"type": "Polygon", "coordinates": [[[-121.87433, 37.3454], [-121.87431, 37.34541], [-121.87413, 37.3459], [-121.87387, 37.34635], [-121.87387, 37.34678], [-121.8738, 37.34722], [-121.87341, 37.34738], [-121.8724, 37.34787], [-121.87134, 37.34646], [-121.87243, 37.34597], [-121.87186, 37.3452], [-121.8739, 37.34423], [-121.87425, 37.34471], [-121.87433, 37.3454]]]} | Open Access 1 | 272 | Roosevelt | 24592 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 15.014 | Roosevelt | 1978 | None 471 | ||
5947 | 5947 | 5946 | {"type": "Polygon", "coordinates": [[[-121.97624, 37.27999], [-121.97415, 37.28001], [-121.97397, 37.27964], [-121.97428, 37.2795], [-121.97443, 37.27938], [-121.97475, 37.27908], [-121.97486, 37.27901], [-121.97499, 37.27896], [-121.97526, 37.27891], [-121.97613, 37.27893], [-121.97617, 37.27894], [-121.97619, 37.27898], [-121.97617, 37.27919], [-121.97624, 37.27999]]]} | Open Access 1 | 511 | San Tomas Park | 24995 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 4.806 | San Tomas Park | 1978 | Local Park 2 | 4 | |
7138 | 7138 | 7137 | {"type": "Polygon", "coordinates": [[[-118.24127, 33.93867], [-118.24126, 33.93886], [-118.24082, 33.93867], [-118.24091, 33.93867], [-118.24127, 33.93867]]]} | Open Access 1 | 6221 | Watts Towers of Simon Rodia State Historic Park | 30713 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.109 | Watts Towers of Simon Rodia SHP | 1978 | None 584 | ||
8582 | 8582 | 8581 | {"type": "Polygon", "coordinates": [[[-121.89592, 37.31933], [-121.89588, 37.32002], [-121.89304, 37.31991], [-121.89309, 37.31912], [-121.89526, 37.3192], [-121.89525, 37.3194], [-121.89529, 37.31941], [-121.89538, 37.31938], [-121.89542, 37.31931], [-121.89592, 37.31933]]]} | Open Access 1 | 13634 | Biebrach Park | 16071 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.305 | Biebrach 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 | |
9732 | 9732 | 9731 | {"type": "Polygon", "coordinates": [[[-121.85272, 37.23577], [-121.85243, 37.2366], [-121.85264, 37.23691], [-121.85239, 37.23705], [-121.85219, 37.23711], [-121.85198, 37.23713], [-121.85162, 37.2371], [-121.85147, 37.23711], [-121.85126, 37.23716], [-121.85122, 37.23715], [-121.85108, 37.23701], [-121.85096, 37.2369], [-121.85064, 37.23671], [-121.85053, 37.23661], [-121.8504, 37.23645], [-121.85033, 37.23629], [-121.85032, 37.23621], [-121.85035, 37.23607], [-121.85042, 37.23587], [-121.85051, 37.23575], [-121.85073, 37.23558], [-121.85083, 37.2359], [-121.85102, 37.23602], [-121.85121, 37.23584], [-121.85211, 37.23531], [-121.8522, 37.23564], [-121.85225, 37.23572], [-121.85272, 37.23577]]]} | Open Access 1 | 16483 | Foothill Park | 18979 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 6.907 | Foothill Park | 1978 | Local Park 2 | 4 | |
9893 | 9893 | 9892 | {"type": "Polygon", "coordinates": [[[-121.82711, 37.33885], [-121.82645, 37.33931], [-121.82597, 37.33976], [-121.82509, 37.34035], [-121.82503, 37.34034], [-121.82348, 37.33884], [-121.8235, 37.33878], [-121.82558, 37.33734], [-121.82566, 37.33737], [-121.82711, 37.33885]]]} | Open Access 1 | 16962 | Hillview Park | 19994 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 13.613 | Hillview Park | 1978 | Local Park 2 | 4 | |
10533 | 10533 | 10532 | {"type": "Polygon", "coordinates": [[[-121.85019, 37.25398], [-121.85019, 37.25444], [-121.85016, 37.25448], [-121.84869, 37.25448], [-121.84852, 37.25447], [-121.84847, 37.25442], [-121.8485, 37.2543], [-121.84877, 37.25364], [-121.84912, 37.25368], [-121.84947, 37.25375], [-121.84951, 37.25381], [-121.84958, 37.25384], [-121.84965, 37.25384], [-121.84974, 37.25381], [-121.84978, 37.25381], [-121.85002, 37.25388], [-121.85017, 37.25395], [-121.85019, 37.25398]]]} | Open Access 1 | 18743 | Playa Del Rey Park | 23774 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 2.792 | Playa Del Rey Park | 1978 | Local Park 2 | 4 | |
16467 | 16467 | 16466 | {"type": "MultiPolygon", "coordinates": [[[[-122.02819, 36.95221], [-122.02734, 36.95194], [-122.02712, 36.9519], [-122.0266, 36.95189], [-122.0264, 36.95193], [-122.02623, 36.95203], [-122.02612, 36.95217], [-122.02604, 36.95238], [-122.02594, 36.95255], [-122.02585, 36.95251], [-122.02559, 36.95287], [-122.02549, 36.95286], [-122.02547, 36.95282], [-122.0254, 36.95277], [-122.02542, 36.95275], [-122.02547, 36.95275], [-122.0255, 36.95273], [-122.02551, 36.95268], [-122.0255, 36.95258], [-122.02551, 36.95253], [-122.02561, 36.95261], [-122.02567, 36.95261], [-122.02583, 36.9525], [-122.02594, 36.95232], [-122.02597, 36.95232], [-122.02598, 36.95234], [-122.02599, 36.95233], [-122.02596, 36.95216], [-122.02586, 36.95205], [-122.02584, 36.95195], [-122.02584, 36.95187], [-122.02588, 36.95181], [-122.02595, 36.95176], [-122.02599, 36.95176], [-122.02604, 36.95178], [-122.02602, 36.9517], [-122.02603, 36.95156], [-122.02601, 36.95153], [-122.02587, 36.95145], [-122.02587, 36.95137], [-122.02595, 36.95118], [-122.02609, 36.95108], [-122.02615, 36.95114], [-122.02615, 36.95122], [-122.0263, 36.95131], [-122.02639, 36.95133], [-122.02644, 36.95132], [-122.02647, 36.95129], [-122.02648, 36.95126], [-122.02647, 36.95118], [-122.02654, 36.95106], [-122.02655, 36.95099], [-122.02649, 36.95085], [-122.02647, 36.95057], [-122.02651, 36.9505], [-122.02653, 36.9504], [-122.02655, 36.95038], [-122.02659, 36.95039], [-122.02674, 36.95059], [-122.0267, 36.95074], [-122.0267, 36.95082], [-122.02671, 36.95086], [-122.02677, 36.95093], [-122.02678, 36.95099], [-122.0268, 36.95099], [-122.02683, 36.95096], [-122.02683, 36.95077], [-122.02688, 36.95071], [-122.02695, 36.95071], [-122.02706, 36.95083], [-122.02708, 36.95096], [-122.02693, 36.95104], [-122.02688, 36.95112], [-122.02696, 36.95112], [-122.02702, 36.9511], [-122.02705, 36.95111], [-122.02703, 36.95123], [-122.02706, 36.95127], [-122.02709, 36.9514], [-122.02719, 36.95155], [-122.02732, 36.95167], [-122.02736, 36.95166], [-122.02738, 36.95162], [-122.02746, 36.95163], [-122.02762, 36.95175], [-122.02765, 36.95175], [-122.02767, 36.95173], [-122.02773, 36.95175], [-122.02773, 36.95165], [-122.02779, 36.95164], [-122.02795, 36.95178], [-122.02796, 36.95182], [-122.02801, 36.95188], [-122.0281, 36.95192], [-122.02819, 36.95188], [-122.02819, 36.95221]]], [[[-122.03355, 36.95212], [-122.03327, 36.95213], [-122.0328, 36.95202], [-122.0323, 36.95194], [-122.03229, 36.95186], [-122.03352, 36.95195], [-122.03355, 36.95212]]]]} | Open Access 1 | 17345 | Lighthouse Field State Beach | 21231 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.parks.ca.gov/?page_id=550 | Santa Cruz 5 | 4.44 | Lighthouse Field SB | 1978 | None 1407 |
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]);