units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where ACCESS_TYP = 1, DES_TP = 2 and YR_EST = 1978
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 12 ✖
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 | |
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 | |
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 | |
6817 | 6817 | 6816 | {"type": "Polygon", "coordinates": [[[-122.45793, 38.29742], [-122.45765, 38.29926], [-122.45762, 38.29937], [-122.45758, 38.29944], [-122.45669, 38.29951], [-122.45533, 38.29937], [-122.45551, 38.29826], [-122.45577, 38.29827], [-122.45582, 38.29787], [-122.45582, 38.29775], [-122.45579, 38.29751], [-122.45582, 38.29721], [-122.45793, 38.29742]]]} | Open Access 1 | 5388 | Arnold Park | 15603 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 11.311 | Arnold Park | 1978 | Local Park 2 | 4 | |
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 | |
9228 | 9228 | 9227 | {"type": "Polygon", "coordinates": [[[-122.66499, 38.21258], [-122.66493, 38.21342], [-122.66496, 38.21991], [-122.65569, 38.21981], [-122.65572, 38.21288], [-122.65887, 38.21287], [-122.65922, 38.2125], [-122.66047, 38.21133], [-122.66499, 38.21258]]]} | Open Access 1 | 16914 | Helen Putnam Park | 19799 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 168.099 | Helen Putnam 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 | |
16282 | 16282 | 16281 | {"type": "Polygon", "coordinates": [[[-122.52557, 38.35429], [-122.52529, 38.35427], [-122.5248, 38.35462], [-122.52536, 38.35545], [-122.52539, 38.35575], [-122.52503, 38.35602], [-122.52486, 38.35606], [-122.52475, 38.35616], [-122.52477, 38.35651], [-122.52474, 38.35681], [-122.52468, 38.35709], [-122.52456, 38.35736], [-122.52425, 38.35777], [-122.52421, 38.35787], [-122.52416, 38.35806], [-122.52425, 38.35824], [-122.52281, 38.35888], [-122.52259, 38.35915], [-122.52234, 38.35954], [-122.52236, 38.35965], [-122.52336, 38.35959], [-122.5236, 38.36051], [-122.52408, 38.36046], [-122.52412, 38.3607], [-122.52367, 38.36077], [-122.52378, 38.36121], [-122.52254, 38.36143], [-122.5227, 38.36212], [-122.5213, 38.36288], [-122.52164, 38.3638], [-122.52138, 38.36391], [-122.5212, 38.36404], [-122.52104, 38.36425], [-122.52107, 38.36436], [-122.52115, 38.36446], [-122.52119, 38.36447], [-122.52126, 38.36458], [-122.52072, 38.36467], [-122.51872, 38.36549], [-122.51876, 38.36587], [-122.51774, 38.3664], [-122.51711, 38.36563], [-122.514, 38.36719], [-122.51335, 38.36655], [-122.51271, 38.36695], [-122.51234, 38.36659], [-122.51065, 38.36488], [-122.51199, 38.36403], [-122.51199, 38.36401], [-122.51098, 38.36304], [-122.50966, 38.36392], [-122.50786, 38.36203], [-122.50409, 38.35769], [-122.5035, 38.35687], [-122.50362, 38.35661], [-122.50486, 38.35638], [-122.50626, 38.35783], [-122.50884, 38.36008], [-122.5115, 38.36128], [-122.51253, 38.36145], [-122.51698, 38.36], [-122.51733, 38.35999], [-122.52143, 38.35607], [-122.52185, 38.35259], [-122.52229, 38.35282], [-122.52313, 38.35341], [-122.52273, 38.35355], [-122.52312, 38.35407], [-122.52331, 38.35389], [-122.52472, 38.35344], [-122.52557, 38.35429]]]} | Open Access 1 | 1008 | Sonoma Valley Regional Park | 25619 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 254.384 | Sonoma Valley RP | 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]);