units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where COUNTY = 3, MNG_AGENCY = 229 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
662 | 662 | 661 | {"type": "Polygon", "coordinates": [[[-117.89727, 33.91708], [-117.89707, 33.91745], [-117.89698, 33.9175], [-117.89608, 33.91752], [-117.89608, 33.91692], [-117.89678, 33.91691], [-117.89679, 33.91708], [-117.89727, 33.91708]]]} | Open Access 1 | 3273 | Lagos De Moreno Park | 20844 | 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 | 1.461 | Lagos De Moreno Park | 0 | Local Park 2 | 4 | |
6177 | 6177 | 6176 | {"type": "MultiPolygon", "coordinates": [[[[-117.8775, 33.91422], [-117.87732, 33.91439], [-117.87723, 33.91456], [-117.87719, 33.9147], [-117.87705, 33.91547], [-117.877, 33.91558], [-117.87695, 33.91564], [-117.87684, 33.91572], [-117.87675, 33.91577], [-117.8765, 33.91584], [-117.87666, 33.91523], [-117.87683, 33.91489], [-117.87699, 33.91466], [-117.87709, 33.91455], [-117.87722, 33.91443], [-117.8775, 33.91422]]], [[[-117.87909, 33.91436], [-117.87878, 33.9149], [-117.87849, 33.91478], [-117.87832, 33.91481], [-117.87806, 33.9149], [-117.87787, 33.915], [-117.87776, 33.91508], [-117.8776, 33.91527], [-117.8775, 33.91542], [-117.87746, 33.91542], [-117.87758, 33.91475], [-117.87761, 33.91466], [-117.87767, 33.91455], [-117.8778, 33.91445], [-117.87852, 33.91403], [-117.87869, 33.91418], [-117.8788, 33.91425], [-117.87892, 33.9143], [-117.87909, 33.91436]]]]} | Open Access 1 | 1207 | Greenbriar Park | 19475 | 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 | 3.487 | Greenbriar Park | 0 | Local Park 2 | 4 | |
9287 | 9287 | 9286 | {"type": "Polygon", "coordinates": [[[-117.91198, 33.94546], [-117.91169, 33.9456], [-117.91163, 33.94581], [-117.91132, 33.94575], [-117.9114, 33.94543], [-117.91137, 33.94537], [-117.91102, 33.94531], [-117.91107, 33.94526], [-117.91151, 33.94534], [-117.91164, 33.94544], [-117.91191, 33.94536], [-117.91198, 33.94546]]]} | Open Access 1 | 15471 | Woodcrest Park | 27705 | 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 | 0.477 | Woodcrest Park | 0 | Local Park 2 | 4 | |
9482 | 9482 | 9481 | {"type": "Polygon", "coordinates": [[[-117.90314, 33.91356], [-117.90225, 33.91519], [-117.90138, 33.91486], [-117.90226, 33.91323], [-117.90314, 33.91356]]]} | Open Access 1 | 15881 | City Hall Park | 17294 | 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 | 4.345 | City Hall Park | 0 | Local Park 2 | 4 | |
10321 | 10321 | 10320 | {"type": "Polygon", "coordinates": [[[-117.87137, 33.92129], [-117.87131, 33.92148], [-117.87099, 33.92206], [-117.87051, 33.9221], [-117.87025, 33.92207], [-117.86998, 33.92199], [-117.86981, 33.9219], [-117.8696, 33.92171], [-117.86953, 33.92161], [-117.86944, 33.92142], [-117.86941, 33.92127], [-117.86941, 33.9211], [-117.86945, 33.92097], [-117.86963, 33.92052], [-117.86966, 33.92029], [-117.86962, 33.92001], [-117.86963, 33.91997], [-117.86968, 33.91994], [-117.86994, 33.91986], [-117.87008, 33.91984], [-117.87041, 33.91971], [-117.87054, 33.91974], [-117.87069, 33.91991], [-117.87059, 33.91997], [-117.87017, 33.92002], [-117.86984, 33.9204], [-117.87065, 33.9209], [-117.87073, 33.92089], [-117.87137, 33.92129]]]} | Open Access 1 | 18180 | Country Hills Park | 17698 | 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 | 6.38 | Country Hills Park | 0 | Local Park 2 | 4 | |
10347 | 10347 | 10346 | {"type": "MultiPolygon", "coordinates": [[[[-117.90883, 33.9129], [-117.90847, 33.91348], [-117.90806, 33.91392], [-117.90793, 33.91408], [-117.90779, 33.91432], [-117.90776, 33.91459], [-117.90815, 33.91469], [-117.90844, 33.91507], [-117.90845, 33.91536], [-117.90821, 33.91575], [-117.9082, 33.91597], [-117.90787, 33.91616], [-117.90753, 33.91628], [-117.90695, 33.91639], [-117.90685, 33.91639], [-117.90685, 33.91667], [-117.90669, 33.91678], [-117.90649, 33.91684], [-117.90633, 33.91705], [-117.9063, 33.91728], [-117.90581, 33.91729], [-117.90602, 33.91691], [-117.90722, 33.91455], [-117.90737, 33.91427], [-117.90828, 33.9129], [-117.90883, 33.9129]]], [[[-117.908, 33.91291], [-117.90715, 33.91418], [-117.90699, 33.91446], [-117.90593, 33.91656], [-117.9059, 33.91654], [-117.90642, 33.91548], [-117.90618, 33.91425], [-117.90636, 33.91391], [-117.9067, 33.91374], [-117.90688, 33.91358], [-117.90689, 33.91291], [-117.908, 33.91291]]]]} | Open Access 1 | 18267 | Arovista Park | 15605 | 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 | 14.5 | Arovista Park | 0 | Local Park 2 | 4 | |
10752 | 10752 | 10751 | {"type": "Polygon", "coordinates": [[[-117.90008, 33.925], [-117.90001, 33.92741], [-117.89888, 33.92739], [-117.89846, 33.92719], [-117.89999, 33.92493], [-117.90002, 33.92493], [-117.90008, 33.925]]]} | Open Access 1 | 20024 | Tamarack Park | 26176 | 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 | 5.452 | Tamarack Park | 0 | Local Park 2 | 4 | |
10755 | 10755 | 10754 | {"type": "Polygon", "coordinates": [[[-117.84753, 33.9245], [-117.84711, 33.92449], [-117.84698, 33.92442], [-117.84687, 33.9244], [-117.84639, 33.92444], [-117.84634, 33.92447], [-117.84573, 33.92446], [-117.84572, 33.9245], [-117.84543, 33.92449], [-117.84542, 33.92442], [-117.84454, 33.92443], [-117.84452, 33.92441], [-117.84427, 33.92441], [-117.84412, 33.92448], [-117.84176, 33.92442], [-117.84169, 33.92446], [-117.8416, 33.9244], [-117.84152, 33.92439], [-117.84144, 33.92442], [-117.84138, 33.92437], [-117.84106, 33.9244], [-117.84103, 33.92464], [-117.84053, 33.92444], [-117.83931, 33.92407], [-117.83925, 33.92419], [-117.8392, 33.92401], [-117.83892, 33.92379], [-117.83873, 33.9237], [-117.8386, 33.92366], [-117.83862, 33.92361], [-117.83791, 33.92341], [-117.83725, 33.9233], [-117.83677, 33.92325], [-117.83691, 33.9231], [-117.83699, 33.92298], [-117.83705, 33.92281], [-117.83708, 33.92263], [-117.83729, 33.92265], [-117.83732, 33.92256], [-117.83758, 33.9226], [-117.83863, 33.92279], [-117.8391, 33.92291], [-117.84061, 33.92338], [-117.84151, 33.92368], [-117.84248, 33.92389], [-117.84321, 33.92399], [-117.84566, 33.92424], [-117.8467, 33.92428], [-117.84742, 33.92429], [-117.84752, 33.92435], [-117.84753, 33.9245]]]} | Open Access 1 | 20031 | Olinda Ranch Park | 23116 | 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 | 16.006 | Olinda Ranch Park | 0 | Local Park 2 | 4 | |
10756 | 10756 | 10755 | {"type": "Polygon", "coordinates": [[[-117.90928, 33.93405], [-117.90849, 33.93406], [-117.90848, 33.93403], [-117.9083, 33.93403], [-117.90829, 33.93406], [-117.90816, 33.93406], [-117.90815, 33.93403], [-117.90797, 33.93403], [-117.90796, 33.93407], [-117.90721, 33.93407], [-117.90711, 33.93404], [-117.907, 33.93395], [-117.90697, 33.9339], [-117.90699, 33.93382], [-117.90697, 33.93374], [-117.90701, 33.93366], [-117.90706, 33.93361], [-117.90722, 33.93355], [-117.90791, 33.93354], [-117.90792, 33.93357], [-117.90812, 33.93357], [-117.90813, 33.93354], [-117.90824, 33.93354], [-117.90825, 33.93357], [-117.90843, 33.93357], [-117.90844, 33.93354], [-117.90926, 33.93354], [-117.90928, 33.93405]]]} | Open Access 1 | 20032 | Founder's Park | 19018 | 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 | 2.904 | Founder's Park | 0 | Local Park 2 | 4 | |
11603 | 11603 | 11602 | {"type": "Polygon", "coordinates": [[[-117.85081, 33.92761], [-117.84998, 33.92778], [-117.84822, 33.9279], [-117.84813, 33.92759], [-117.84813, 33.92748], [-117.85047, 33.92737], [-117.85061, 33.92727], [-117.85073, 33.9273], [-117.85079, 33.92746], [-117.85081, 33.92761]]]} | Open Access 1 | 48728 | Wildcatters Dog Park | 33455 | 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 | https://www.ci.brea.ca.us/729/Wildcatters-Dog-Park | Orange 3 | 2.562 | Wildcatters Dog Park | 0 | Local Park 2 | 4 |
12855 | 12855 | 12854 | {"type": "Polygon", "coordinates": [[[-117.85381, 33.91855], [-117.85365, 33.91872], [-117.8527, 33.91894], [-117.85263, 33.91899], [-117.85259, 33.91904], [-117.85238, 33.92049], [-117.84828, 33.92053], [-117.8483, 33.92025], [-117.84823, 33.92024], [-117.84831, 33.91952], [-117.84786, 33.91947], [-117.84798, 33.91861], [-117.84808, 33.91851], [-117.84807, 33.91845], [-117.85381, 33.91842], [-117.85381, 33.91855]]]} | Open Access 1 | 30305 | Brea Sports Park | 16343 | 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 | 24.442 | Brea Sports Park | 0 | Local Recreation Area 3 | 4 | |
14210 | 14210 | 14209 | {"type": "Polygon", "coordinates": [[[-117.89549, 33.9268], [-117.89549, 33.92741], [-117.89547, 33.92752], [-117.89199, 33.92753], [-117.89193, 33.92519], [-117.89201, 33.9251], [-117.8935, 33.92506], [-117.89355, 33.9268], [-117.89549, 33.9268]]]} | Restricted Access 2 | 44076 | Brea Junior High Park | 16342 | 2311 | Brea Olinda Unified School District 1100 | Special District 4 | School District 14 | http://www.bousd.k12.ca.us/ | Special District 4 | 1033 | Brea, City of 229 | City 2 | City Agency 2 | Orange 3 | 13.284 | Brea Junior High Park | 0 | Local Park 2 | 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]);