units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
782 rows where ACCESS_TYP = 1, COUNTY = 3 and DES_TP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
MNG_AGENCY >30
- Huntington Beach, City of 74
- Irvine, City of 59
- Newport Beach, City of 50
- Anaheim, City of 49
- Orange, County of 41
- Santa Ana, City of 37
- Fullerton, City of 37
- Mission Viejo, City of 35
- Costa Mesa, City of 30
- Laguna Niguel, City of 26
- Lake Forest, City of 25
- Yorba Linda, City of 24
- Westminster, City of 24
- La Habra, City of 22
- San Juan Capistrano, City of 20
- Cypress, City of 19
- San Clemente, City of 19
- Dana Point, City of 18
- Fountain Valley, City of 18
- Orange, City of 17
- Aliso Viejo, City of 17
- Laguna Beach, City of 16
- Garden Grove, City of 14
- Tustin, City of 14
- Laguna Hills, City of 13
- Placentia, City of 12
- Buena Park, City of 10
- Brea, City of 10
- Los Alamitos, City of 9
- Seal Beach, City of 8
- …
MNG_AG_TYP 3
ACCESS_TYP 1
- Open Access · 782 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | 5 | 4 | {"type": "MultiPolygon", "coordinates": [[[[-118.10598, 33.73945], [-118.10581, 33.73968], [-118.1051, 33.73933], [-118.10527, 33.73909], [-118.10598, 33.73945]]], [[[-118.10701, 33.73996], [-118.10683, 33.7402], [-118.10615, 33.73985], [-118.10632, 33.73962], [-118.10701, 33.73996]]], [[[-118.10746, 33.7402], [-118.10729, 33.74044], [-118.10691, 33.74024], [-118.10708, 33.74], [-118.10746, 33.7402]]]]} | Open Access 1 | 25 | Eisenhower Park | 18475 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.46 | Eisenhower Park | 0 | Local Park 2 | 4 | |
28 | 28 | 27 | {"type": "Polygon", "coordinates": [[[-117.89558, 33.75242], [-117.89529, 33.75244], [-117.89531, 33.75329], [-117.8936, 33.75333], [-117.89359, 33.75197], [-117.89397, 33.75194], [-117.89398, 33.75162], [-117.89558, 33.75161], [-117.89558, 33.75242]]]} | Open Access 1 | 154 | El Salvador Park | 18538 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 7.57 | El Salvador Park | 0 | Local Park 2 | 4 | |
126 | 126 | 125 | {"type": "Polygon", "coordinates": [[[-117.92158, 33.62047], [-117.92075, 33.62131], [-117.92059, 33.62077], [-117.92003, 33.62037], [-117.92034, 33.62006], [-117.92071, 33.62032], [-117.92089, 33.62015], [-117.92158, 33.62047]]]} | Open Access 1 | 318 | Ensign View Park | 18682 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 2.134 | Ensign View Park | 0 | Local Park 2 | 4 | |
149 | 149 | 148 | {"type": "Polygon", "coordinates": [[[-117.77568, 33.85853], [-117.77547, 33.85861], [-117.77421, 33.85892], [-117.77404, 33.85905], [-117.77384, 33.85876], [-117.77385, 33.85867], [-117.77384, 33.85862], [-117.77368, 33.85847], [-117.77332, 33.85794], [-117.77303, 33.85744], [-117.77303, 33.85684], [-117.77418, 33.8563], [-117.77437, 33.85656], [-117.77436, 33.85678], [-117.77438, 33.8569], [-117.77443, 33.85701], [-117.77465, 33.85731], [-117.77471, 33.85734], [-117.77478, 33.85736], [-117.7749, 33.85735], [-117.77568, 33.85853]]]} | Open Access 1 | 381 | Eucalyptus Park | 18740 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 9.905 | Eucalyptus Park | 0 | Local Park 2 | 4 | |
153 | 153 | 152 | {"type": "Polygon", "coordinates": [[[-117.95453, 33.79354], [-117.95368, 33.79353], [-117.95366, 33.79224], [-117.9545, 33.79224], [-117.95453, 33.79354]]]} | Open Access 1 | 483 | Faylane Park | 18859 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 2.786 | Faylane Park | 0 | Local Park 2 | 4 | |
166 | 166 | 165 | {"type": "Polygon", "coordinates": [[[-117.79359, 33.89318], [-117.7925, 33.89354], [-117.79204, 33.89354], [-117.79144, 33.89368], [-117.79082, 33.89369], [-117.79105, 33.89335], [-117.79115, 33.89317], [-117.79126, 33.89285], [-117.79131, 33.8926], [-117.79133, 33.89305], [-117.79295, 33.89303], [-117.79295, 33.89283], [-117.79312, 33.89283], [-117.79312, 33.89263], [-117.79317, 33.89262], [-117.79317, 33.89234], [-117.79344, 33.89233], [-117.79343, 33.89188], [-117.79357, 33.89188], [-117.79359, 33.89318]]]} | Open Access 1 | 437 | Fairmont Knolls Park | 18803 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 4.085 | Fairmont Knolls Park | 0 | Local Park 2 | 4 | |
168 | 168 | 167 | {"type": "Polygon", "coordinates": [[[-117.89514, 33.614], [-117.89456, 33.61397], [-117.89358, 33.61385], [-117.8935, 33.61387], [-117.89229, 33.61421], [-117.89219, 33.61426], [-117.89104, 33.61503], [-117.89096, 33.61513], [-117.89091, 33.61526], [-117.89088, 33.61554], [-117.89077, 33.61565], [-117.89026, 33.61591], [-117.88975, 33.61562], [-117.88988, 33.61545], [-117.89005, 33.61555], [-117.89018, 33.61539], [-117.89068, 33.61565], [-117.89078, 33.61558], [-117.89081, 33.61554], [-117.89085, 33.61536], [-117.8908, 33.61528], [-117.89079, 33.61519], [-117.8908, 33.61509], [-117.89113, 33.61463], [-117.891, 33.61454], [-117.89084, 33.6145], [-117.89066, 33.61444], [-117.89044, 33.61441], [-117.89041, 33.61439], [-117.89036, 33.61433], [-117.89018, 33.6143], [-117.89004, 33.61433], [-117.8898, 33.61442], [-117.88968, 33.61453], [-117.88966, 33.61452], [-117.89069, 33.61325], [-117.89076, 33.61318], [-117.89086, 33.61314], [-117.89096, 33.61312], [-117.89107, 33.61312], [-117.89435, 33.61364], [-117.89433, 33.61373], [-117.89514, 33.614]]]} | Open Access 1 | 536 | Back Bay View Park | 15751 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 10.648 | Back Bay View Park | 0 | Local Park 2 | 4 | |
203 | 203 | 202 | {"type": "Polygon", "coordinates": [[[-117.8759, 33.77057], [-117.8759, 33.77164], [-117.87387, 33.77142], [-117.871, 33.77154], [-117.87088, 33.77167], [-117.87063, 33.77133], [-117.87169, 33.77125], [-117.8717, 33.77141], [-117.87384, 33.77134], [-117.87386, 33.77119], [-117.87472, 33.7711], [-117.8756, 33.77074], [-117.8759, 33.77057]]]} | Open Access 1 | 544 | Fisher Park | 18919 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 3.993 | Fisher Park | 0 | Local Park 2 | 4 | |
225 | 225 | 224 | {"type": "Polygon", "coordinates": [[[-117.64157, 33.50229], [-117.64232, 33.50243], [-117.64251, 33.5025], [-117.64268, 33.5026], [-117.64283, 33.50272], [-117.64301, 33.50296], [-117.64302, 33.503], [-117.64253, 33.50326], [-117.64249, 33.50326], [-117.64136, 33.5029], [-117.6415, 33.50259], [-117.64157, 33.50229]]]} | Open Access 1 | 612 | Four Oaks Park | 19025 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 2.499 | Four Oaks Park | 0 | Local Park 2 | 4 | |
274 | 274 | 273 | {"type": "Polygon", "coordinates": [[[-117.72318, 33.87548], [-117.72312, 33.87587], [-117.7229, 33.87584], [-117.72266, 33.87578], [-117.72254, 33.87582], [-117.72248, 33.87589], [-117.72204, 33.87581], [-117.72218, 33.87558], [-117.72251, 33.87523], [-117.72255, 33.87523], [-117.72297, 33.87543], [-117.72318, 33.87548]]]} | Open Access 1 | 47365 | Vista Lampara Park | 31088 | 1384 | Yorba Linda, City of 64 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 1.193 | Vista Lampara Park | 0 | Local Park 2 | 4 | |
287 | 287 | 286 | {"type": "Polygon", "coordinates": [[[-117.89292, 33.66951], [-117.89279, 33.6695], [-117.89269, 33.66962], [-117.89278, 33.66984], [-117.89242, 33.66996], [-117.89271, 33.67061], [-117.89241, 33.67062], [-117.8924, 33.67015], [-117.89135, 33.67016], [-117.89223, 33.66934], [-117.89259, 33.66924], [-117.89292, 33.66924], [-117.89292, 33.66951]]]} | Open Access 1 | 47380 | Bark Park | 31103 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=1207 | Orange 3 | 2.234 | Bark Park | 0 | Local Park 2 | 4 |
293 | 293 | 292 | {"type": "Polygon", "coordinates": [[[-117.95895, 33.78192], [-117.95877, 33.78192], [-117.95878, 33.78147], [-117.95882, 33.78141], [-117.95886, 33.7814], [-117.95894, 33.7814], [-117.95895, 33.78192]]]} | Open Access 1 | 47369 | Bicentennial Park | 31093 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 0.219 | Bicentennial Park | 0 | Local Park 2 | 4 | |
299 | 299 | 298 | {"type": "Polygon", "coordinates": [[[-117.89118, 33.62744], [-117.89109, 33.6275], [-117.89102, 33.62758], [-117.89077, 33.62794], [-117.89073, 33.62809], [-117.89075, 33.62825], [-117.8904, 33.62835], [-117.8906, 33.62779], [-117.89072, 33.62716], [-117.8909, 33.6271], [-117.89118, 33.62744]]]} | Open Access 1 | 803 | Galaxy View Park | 19171 | 1224 | Newport Beach, City of 54 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | Orange 3 | 0.948 | Galaxy View Park | 0 | Local Park 2 | 4 | |
305 | 305 | 304 | {"type": "Polygon", "coordinates": [[[-118.01213, 33.73489], [-118.01191, 33.73503], [-118.01177, 33.73516], [-118.0117, 33.73525], [-118.01163, 33.7355], [-118.01163, 33.73585], [-118.01122, 33.73585], [-118.01119, 33.73402], [-118.01212, 33.73402], [-118.01213, 33.73489]]]} | Open Access 1 | 1042 | Glen View Park | 19325 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.31 | Glen View Park | 0 | Local Park 2 | 4 | |
329 | 329 | 328 | {"type": "MultiPolygon", "coordinates": [[[[-117.66596, 33.50768], [-117.66577, 33.5077], [-117.66572, 33.50768], [-117.66541, 33.50707], [-117.66567, 33.50698], [-117.66596, 33.50768]]], [[[-117.66901, 33.51494], [-117.66882, 33.51458], [-117.66808, 33.51326], [-117.66775, 33.51256], [-117.6669, 33.5106], [-117.66646, 33.50942], [-117.66623, 33.50895], [-117.6658, 33.50793], [-117.66583, 33.50788], [-117.66603, 33.50784], [-117.66648, 33.50895], [-117.66686, 33.50979], [-117.66745, 33.51124], [-117.66772, 33.51189], [-117.66779, 33.512], [-117.66792, 33.5123], [-117.66884, 33.51451], [-117.66901, 33.51494]]]]} | Open Access 1 | 1112 | El Camino Real Park | 18482 | 1305 | San Juan Capistrano, City of 92 | City 2 | City Agency 2 | http://www.sanjuancapistrano.org/ | City 2 | 1305 | San Juan Capistrano, City of 90 | City 2 | City Agency 2 | Orange 3 | 4.569 | El Camino Real Park | 0 | Local Park 2 | 4 | |
330 | 330 | 329 | {"type": "Polygon", "coordinates": [[[-117.67006, 33.45754], [-117.67005, 33.45792], [-117.66979, 33.45796], [-117.66978, 33.45783], [-117.66974, 33.45773], [-117.66967, 33.45761], [-117.66935, 33.45735], [-117.66951, 33.45716], [-117.67006, 33.45754]]]} | Open Access 1 | 887 | Palisades Gazebo Park | 23328 | 1079 | Dana Point, City of 134 | City 2 | City Agency 2 | http://www.danapoint.org/index.aspx?page=170 | City 2 | 1079 | Dana Point, City of 131 | City 2 | City Agency 2 | Orange 3 | 0.658 | Palisades Gazebo Park | 0 | Local Park 2 | 4 | |
334 | 334 | 333 | {"type": "Polygon", "coordinates": [[[-118.01117, 33.86901], [-118.00852, 33.86905], [-118.0085, 33.86928], [-118.00512, 33.86932], [-118.00511, 33.86863], [-118.0042, 33.86862], [-118.0042, 33.86848], [-118.00834, 33.86842], [-118.00833, 33.86716], [-118.01114, 33.86713], [-118.01117, 33.86901]]]} | Open Access 1 | 913 | George Bellis Park | 19259 | 1037 | Buena Park, City of 136 | City 2 | City Agency 2 | http://www.buenapark.com/ | City 2 | 1037 | Buena Park, City of 133 | City 2 | City Agency 2 | Orange 3 | 20.977 | George Bellis Park | 0 | Local Park 2 | 4 | |
349 | 349 | 348 | {"type": "Polygon", "coordinates": [[[-117.81409, 33.75983], [-117.81374, 33.7598], [-117.81369, 33.75976], [-117.81367, 33.75975], [-117.81366, 33.75914], [-117.81378, 33.75944], [-117.81391, 33.75962], [-117.81409, 33.75983]]]} | Open Access 1 | 959 | Holderman Park | 20027 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.281 | Holderman Park | 0 | Local Park 2 | 4 | |
376 | 376 | 375 | {"type": "Polygon", "coordinates": [[[-118.01093, 33.77007], [-118.01083, 33.77015], [-118.01069, 33.77031], [-118.01061, 33.77047], [-118.01056, 33.77071], [-118.01055, 33.77119], [-118.01052, 33.77121], [-118.01012, 33.77121], [-118.01011, 33.76991], [-118.01073, 33.76991], [-118.01093, 33.77007]]]} | Open Access 1 | 1108 | Goldenwest Park | 19378 | 1378 | Westminster, City of 153 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | Orange 3 | 1.77 | Goldenwest Park | 0 | Local Park 2 | 4 | |
386 | 386 | 385 | {"type": "Polygon", "coordinates": [[[-118.05417, 33.72241], [-118.05416, 33.72158], [-118.05339, 33.72158], [-118.05338, 33.72109], [-118.05364, 33.72108], [-118.05364, 33.72069], [-118.05357, 33.72068], [-118.05357, 33.72042], [-118.05361, 33.72031], [-118.05367, 33.72022], [-118.05376, 33.72014], [-118.054, 33.72003], [-118.05407, 33.72006], [-118.05425, 33.7205], [-118.05433, 33.72078], [-118.05441, 33.72126], [-118.05443, 33.72234], [-118.0544, 33.72239], [-118.05436, 33.72241], [-118.05417, 33.72241]]]} | Open Access 1 | 1408 | Harbour View Park | 19671 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.406 | Harbour View Park | 0 | 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]);