units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 2, COUNTY = 3, DES_TP = 3 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID
MNG_AGENCY 6
MNG_AG_TYP 1
- City Agency · 9 ✖
DES_TP 1
- Local Recreation Area · 9 ✖
ACCESS_TYP 1
- Restricted Access · 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1392 | 1392 | 1391 | {"type": "MultiPolygon", "coordinates": [[[[-117.69075, 33.62392], [-117.68979, 33.62464], [-117.6881, 33.62602], [-117.68796, 33.62602], [-117.68764, 33.62571], [-117.68732, 33.6253], [-117.68703, 33.62485], [-117.68795, 33.62401], [-117.68946, 33.62275], [-117.69075, 33.62392]]], [[[-117.69308, 33.61785], [-117.69279, 33.61798], [-117.69244, 33.61822], [-117.69209, 33.61852], [-117.69108, 33.62006], [-117.69044, 33.6209], [-117.69044, 33.62091], [-117.69115, 33.62121], [-117.69006, 33.62215], [-117.68996, 33.62243], [-117.68983, 33.62274], [-117.68763, 33.62065], [-117.68806, 33.62016], [-117.68832, 33.61992], [-117.68852, 33.6197], [-117.68907, 33.61929], [-117.68969, 33.61891], [-117.69138, 33.61803], [-117.69201, 33.61773], [-117.69254, 33.61741], [-117.69268, 33.61741], [-117.69308, 33.61785]]]]} | Restricted Access 2 | 30526 | Lake Forest Golf Course | 33099 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 40.437 | Lake Forest GC | 0 | Local Recreation Area 3 | 4 | |
5739 | 5739 | 5738 | {"type": "Polygon", "coordinates": [[[-117.86368, 33.71492], [-117.86366, 33.71591], [-117.86257, 33.71591], [-117.86257, 33.715], [-117.86248, 33.71499], [-117.86248, 33.71487], [-117.86359, 33.71488], [-117.86359, 33.71492], [-117.86368, 33.71492]]]} | Restricted Access 2 | 47437 | Monroe Elementary School Field | 31153 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 2.918 | Monroe Elementary School Field | 0 | Local Recreation Area 3 | 4 | |
5740 | 5740 | 5739 | {"type": "Polygon", "coordinates": [[[-117.90815, 33.749], [-117.90761, 33.74987], [-117.90711, 33.75063], [-117.9066, 33.75137], [-117.9061, 33.75206], [-117.90563, 33.75177], [-117.9056, 33.75179], [-117.90382, 33.75069], [-117.90435, 33.74984], [-117.90502, 33.75014], [-117.90503, 33.75021], [-117.90483, 33.75055], [-117.90576, 33.75095], [-117.90624, 33.75015], [-117.90651, 33.75028], [-117.90653, 33.75028], [-117.90651, 33.74904], [-117.90667, 33.74904], [-117.90668, 33.74906], [-117.90714, 33.74906], [-117.90715, 33.74901], [-117.90815, 33.749]]]} | Restricted Access 2 | 47438 | Spurgeon Intermediate School Field | 31154 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 12.376 | Spurgeon Intermediate School Field | 0 | Local Recreation Area 3 | 4 | |
6328 | 6328 | 6327 | {"type": "Polygon", "coordinates": [[[-117.89836, 33.72183], [-117.8983, 33.72317], [-117.89797, 33.72315], [-117.89796, 33.72316], [-117.89797, 33.72355], [-117.89832, 33.72355], [-117.89835, 33.72428], [-117.8943, 33.72425], [-117.8943, 33.72338], [-117.89435, 33.72295], [-117.89452, 33.72237], [-117.89471, 33.72195], [-117.89481, 33.72179], [-117.89488, 33.72177], [-117.89525, 33.72176], [-117.89683, 33.72176], [-117.897, 33.72177], [-117.89752, 33.72184], [-117.89836, 33.72183]]]} | Restricted Access 2 | 47436 | Valley High School Field | 31152 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 24.28 | Valley High School Field | 0 | Local Recreation Area 3 | 4 | |
6335 | 6335 | 6334 | {"type": "Polygon", "coordinates": [[[-117.91058, 33.72179], [-117.91047, 33.72176], [-117.91041, 33.72186], [-117.91048, 33.72189], [-117.91044, 33.72198], [-117.91045, 33.722], [-117.91032, 33.72232], [-117.91024, 33.72234], [-117.91017, 33.72238], [-117.91007, 33.72251], [-117.90997, 33.7225], [-117.90995, 33.72254], [-117.90986, 33.72251], [-117.90986, 33.72247], [-117.90977, 33.72248], [-117.9096, 33.72254], [-117.90953, 33.72264], [-117.90952, 33.72269], [-117.9094, 33.72266], [-117.90937, 33.72271], [-117.90927, 33.7227], [-117.90916, 33.72291], [-117.90914, 33.72327], [-117.90867, 33.72327], [-117.90855, 33.72329], [-117.90838, 33.72335], [-117.90792, 33.72336], [-117.90848, 33.72176], [-117.90871, 33.72179], [-117.90924, 33.72182], [-117.90951, 33.72176], [-117.90978, 33.72154], [-117.90996, 33.72132], [-117.91058, 33.72179]]]} | Restricted Access 2 | 47439 | Hector G. Godinez High School Field | 31155 | 2308 | Santa Ana Unified School District 816 | Special District 4 | School District 14 | http://www.sausd.us/site/default.aspx?PageID=1 | Special District 4 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.664 | Hector G. Godinez High School Field | 0 | Local Recreation Area 3 | 4 | |
6341 | 6341 | 6340 | {"type": "Polygon", "coordinates": [[[-117.84173, 33.89423], [-117.83972, 33.89424], [-117.83966, 33.89199], [-117.8408, 33.89197], [-117.84079, 33.89285], [-117.84024, 33.89286], [-117.84024, 33.89331], [-117.84092, 33.89332], [-117.84092, 33.89378], [-117.84123, 33.89378], [-117.84122, 33.89348], [-117.84171, 33.89348], [-117.84173, 33.89423]]]} | Restricted Access 2 | 47441 | Rose Drive Elementary School Recreational Facilities | 31157 | 2410 | Placentia-Yorba Linda Unified School District 833 | Special District 4 | School District 14 | http://www.pylusd.org/ | Special District 4 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | Orange 3 | 7.295 | Rose Drive Elementary School Recreational Facilities | 0 | Local Recreation Area 3 | 4 | |
12783 | 12783 | 12782 | {"type": "Polygon", "coordinates": [[[-117.93489, 33.66312], [-117.93485, 33.66379], [-117.93477, 33.66411], [-117.9345, 33.66461], [-117.93433, 33.66497], [-117.93425, 33.66529], [-117.93426, 33.66553], [-117.93434, 33.66577], [-117.93453, 33.666], [-117.93474, 33.66616], [-117.93478, 33.66862], [-117.92476, 33.6687], [-117.92473, 33.66822], [-117.92475, 33.66793], [-117.92484, 33.66736], [-117.92489, 33.6672], [-117.92497, 33.66701], [-117.92513, 33.66676], [-117.92522, 33.66666], [-117.92542, 33.66648], [-117.92548, 33.66643], [-117.92616, 33.66626], [-117.92641, 33.66623], [-117.92763, 33.666], [-117.92836, 33.66592], [-117.92909, 33.66525], [-117.92957, 33.66396], [-117.92835, 33.66366], [-117.92837, 33.66356], [-117.92773, 33.66339], [-117.92855, 33.66129], [-117.92855, 33.66091], [-117.92852, 33.66079], [-117.92846, 33.66068], [-117.92838, 33.66059], [-117.92826, 33.66047], [-117.92805, 33.66034], [-117.92801, 33.66028], [-117.92781, 33.66029], [-117.92391, 33.65934], [-117.92331, 33.65933], [-117.92288, 33.6595], [-117.9227, 33.65963], [-117.92122, 33.66345], [-117.92117, 33.66352], [-117.92111, 33.6636], [-117.92105, 33.66365], [-117.92095, 33.66369], [-117.92085, 33.6637], [-117.92035, 33.66362], [-117.91985, 33.66334], [-117.91972, 33.66324], [-117.91959, 33.66319], [-117.91947, 33.66318], [-117.91935, 33.6632], [-117.9193, 33.658], [-117.93043, 33.65793], [-117.93046, 33.6587], [-117.9315, 33.65867], [-117.93263, 33.66], [-117.9333, 33.65962], [-117.93389, 33.66032], [-117.93417, 33.66057], [-117.93451, 33.66076], [-117.93473, 33.66086], [-117.93476, 33.66311], [-117.93489, 33.66312]]]} | Restricted Access 2 | 30213 | Golf and Country Club | 33096 | 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 | Orange 3 | 239.277 | Golf and Country Club | 0 | Local Recreation Area 3 | 4 | |
15651 | 15651 | 15650 | {"type": "Polygon", "coordinates": [[[-117.92866, 33.89741], [-117.92882, 33.89797], [-117.92866, 33.89899], [-117.92858, 33.89939], [-117.9284, 33.89986], [-117.9283, 33.90048], [-117.92833, 33.90094], [-117.92835, 33.90216], [-117.92806, 33.90241], [-117.92794, 33.9026], [-117.92782, 33.90285], [-117.92789, 33.90288], [-117.9279, 33.90291], [-117.92781, 33.90302], [-117.9277, 33.9032], [-117.92761, 33.90344], [-117.92753, 33.90373], [-117.92731, 33.90489], [-117.92713, 33.90576], [-117.92694, 33.90573], [-117.92669, 33.905], [-117.92544, 33.90564], [-117.92569, 33.9054], [-117.92485, 33.90469], [-117.92436, 33.90485], [-117.92358, 33.90507], [-117.92102, 33.90616], [-117.92255, 33.90495], [-117.9231, 33.90426], [-117.92225, 33.90389], [-117.9208, 33.90429], [-117.91838, 33.90369], [-117.91643, 33.90441], [-117.91697, 33.90527], [-117.91723, 33.90563], [-117.91661, 33.906], [-117.91638, 33.9061], [-117.91608, 33.90635], [-117.91599, 33.90644], [-117.91597, 33.90666], [-117.91591, 33.90694], [-117.91599, 33.9071], [-117.91639, 33.90737], [-117.9165, 33.90748], [-117.91741, 33.90864], [-117.91682, 33.90936], [-117.91585, 33.90911], [-117.91587, 33.90892], [-117.91585, 33.9087], [-117.9158, 33.90844], [-117.91565, 33.90813], [-117.91565, 33.90737], [-117.91479, 33.90656], [-117.91478, 33.9065], [-117.91495, 33.90578], [-117.91552, 33.90519], [-117.91512, 33.90406], [-117.914, 33.90357], [-117.91408, 33.90356], [-117.91405, 33.90301], [-117.92042, 33.90291], [-117.92104, 33.9032], [-117.92165, 33.90284], [-117.9233, 33.90281], [-117.92395, 33.90322], [-117.92419, 33.903], [-117.92478, 33.90242], [-117.92545, 33.90204], [-117.92462, 33.90094], [-117.92431, 33.90085], [-117.92499, 33.90051], [-117.92625, 33.90048], [-117.92705, 33.89942], [-117.92638, 33.89873], [-117.92586, 33.89916], [-117.92559, 33.89875], [-117.92565, 33.89751], [-117.92502, 33.89756], [-117.92475, 33.89873], [-117.92401, 33.89851], [-117.92397, 33.89859], [-117.92398, 33.89926], [-117.92302, 33.89914], [-117.92231, 33.89932], [-117.92197, 33.89983], [-117.92155, 33.89925], [-117.92203, 33.89917], [-117.92261, 33.89901], [-117.92316, 33.89878], [-117.92376, 33.89842], [-117.92436, 33.89784], [-117.9253, 33.89671], [-117.92571, 33.89644], [-117.92618, 33.89618], [-117.92651, 33.89606], [-117.92665, 33.89614], [-117.92714, 33.89625], [-117.92701, 33.89671], [-117.92702, 33.89673], [-117.92798, 33.89658], [-117.92793, 33.89672], [-117.92771, 33.89701], [-117.92866, 33.89741]]]} | Restricted Access 2 | 760 | Fullerton Municipal Golf Course | 32990 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 120.084 | Fullerton Municipal GC | 0 | Local Recreation Area 3 | 4 | |
15702 | 15702 | 15701 | {"type": "MultiPolygon", "coordinates": [[[[-117.91497, 33.90831], [-117.91484, 33.90848], [-117.91467, 33.90864], [-117.91453, 33.90875], [-117.9144, 33.90883], [-117.91391, 33.90906], [-117.91312, 33.90932], [-117.91275, 33.90948], [-117.91244, 33.90963], [-117.91188, 33.90995], [-117.91038, 33.91092], [-117.90986, 33.91115], [-117.90929, 33.91152], [-117.90912, 33.91163], [-117.90869, 33.91201], [-117.90844, 33.91228], [-117.908, 33.91291], [-117.90689, 33.91291], [-117.90842, 33.91113], [-117.90921, 33.9113], [-117.90971, 33.91111], [-117.91091, 33.91015], [-117.9114, 33.90963], [-117.91173, 33.90907], [-117.91198, 33.90885], [-117.91239, 33.90854], [-117.91283, 33.90838], [-117.91293, 33.90836], [-117.91322, 33.90838], [-117.91425, 33.90836], [-117.91497, 33.90831]]], [[[-117.91559, 33.90881], [-117.91519, 33.9088], [-117.91482, 33.90887], [-117.91474, 33.90929], [-117.9144, 33.90962], [-117.91353, 33.90955], [-117.91302, 33.90979], [-117.91327, 33.91038], [-117.91303, 33.91072], [-117.912, 33.91106], [-117.91189, 33.91127], [-117.91107, 33.91127], [-117.91017, 33.91196], [-117.90906, 33.91289], [-117.90829, 33.9129], [-117.90856, 33.9125], [-117.90874, 33.91229], [-117.90888, 33.91214], [-117.90928, 33.91179], [-117.90961, 33.91157], [-117.91226, 33.90991], [-117.9127, 33.90967], [-117.91319, 33.90946], [-117.91422, 33.90912], [-117.91452, 33.90899], [-117.91468, 33.90888], [-117.91488, 33.90872], [-117.91503, 33.90857], [-117.91521, 33.90836], [-117.91559, 33.90833], [-117.91559, 33.90881]]]]} | Restricted Access 2 | 30306 | Brea Creek Municipal Golf Course | 33097 | 1033 | Brea, City of 233 | City 2 | City Agency 2 | http://www.ci.brea.ca.us/index.aspx?NID=439 | City 2 | 1033 | Brea, City of 229 | City 2 | City Agency 2 | Orange 3 | 26.104 | Brea Creek Municipal GC | 0 | Local Recreation Area 3 | 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]);