superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
66 rows where ACCESS_TYP = 1, MNG_AGENCY = 156 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1014 | 1014 | 1013 | {"type": "Polygon", "coordinates": [[[-117.15686, 33.69873], [-117.15685, 33.69915], [-117.1563, 33.69916], [-117.15626, 33.69919], [-117.15628, 33.69997], [-117.15634, 33.70003], [-117.15639, 33.70004], [-117.1564, 33.70034], [-117.15589, 33.70031], [-117.15545, 33.70012], [-117.15443, 33.69945], [-117.15435, 33.69919], [-117.15465, 33.69866], [-117.15483, 33.69828], [-117.15493, 33.69823], [-117.15632, 33.69856], [-117.15633, 33.69861], [-117.15637, 33.69863], [-117.15674, 33.69872], [-117.15686, 33.69873]]]} | Open Access 1 | Aldergate Park | 15348 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 8.125 | Aldergate Park | ||
1032 | 1032 | 1031 | {"type": "Polygon", "coordinates": [[[-116.89525, 33.7441], [-116.89337, 33.74412], [-116.89328, 33.74405], [-116.89328, 33.74281], [-116.89515, 33.74281], [-116.89518, 33.74327], [-116.89525, 33.74369], [-116.89525, 33.7441]]]} | Open Access 1 | Valle Vista Community Center Park | https://www.gorecreation.org/valle-vista-community-center | 32811 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 6.349 | Valle Vista Community Ctr. Park | |
1036 | 1036 | 1035 | {"type": "Polygon", "coordinates": [[[-117.0966, 33.59065], [-117.09652, 33.59071], [-117.09467, 33.59071], [-117.09467, 33.59033], [-117.09462, 33.59028], [-117.09464, 33.59021], [-117.09463, 33.59014], [-117.09458, 33.5901], [-117.09451, 33.59007], [-117.09451, 33.58973], [-117.0966, 33.58973], [-117.0966, 33.59065]]]} | Open Access 1 | Butterfield Park | https://www.gorecreation.org/butterfield-park | 32812 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 5.011 | Butterfield Park | |
1037 | 1037 | 1036 | {"type": "Polygon", "coordinates": [[[-117.09164, 33.59241], [-117.09164, 33.59294], [-117.09127, 33.59294], [-117.09128, 33.59241], [-117.09164, 33.59241]]]} | Open Access 1 | Wagon Wheel Park | https://www.gorecreation.org/wagon-wheel-pocket-park | 32813 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.493 | Wagon Wheel Park | |
1043 | 1043 | 1042 | {"type": "Polygon", "coordinates": [[[-117.09337, 33.59269], [-117.09337, 33.59287], [-117.09303, 33.59287], [-117.09303, 33.59269], [-117.09337, 33.59269]]]} | Open Access 1 | Northfield Park | https://www.gorecreation.org/northfield-park | 32814 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.152 | Northfield Park | |
1044 | 1044 | 1043 | {"type": "Polygon", "coordinates": [[[-117.09722, 33.59201], [-117.09679, 33.59201], [-117.09676, 33.59226], [-117.09668, 33.59227], [-117.09652, 33.59204], [-117.09625, 33.59204], [-117.09621, 33.59183], [-117.09621, 33.59161], [-117.09646, 33.59165], [-117.09678, 33.59166], [-117.09722, 33.59161], [-117.09722, 33.59201]]]} | Open Access 1 | Adeline's Farm Park | https://www.gorecreation.org/adeline-s-farm | 32815 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 1.082 | Adeline's Farm Park | |
1054 | 1054 | 1053 | {"type": "Polygon", "coordinates": [[[-116.99122, 33.70431], [-116.98836, 33.70483], [-116.98832, 33.70447], [-116.9881, 33.70417], [-116.98774, 33.70391], [-116.98732, 33.70372], [-116.98685, 33.70363], [-116.98649, 33.70367], [-116.98616, 33.70376], [-116.98571, 33.70384], [-116.98516, 33.70373], [-116.98444, 33.70319], [-116.98418, 33.70319], [-116.98331, 33.70296], [-116.98311, 33.70272], [-116.98287, 33.70237], [-116.98231, 33.70215], [-116.98164, 33.70201], [-116.98124, 33.70207], [-116.98106, 33.70207], [-116.98083, 33.70195], [-116.98095, 33.70139], [-116.98119, 33.70138], [-116.98148, 33.70133], [-116.98177, 33.70121], [-116.98204, 33.701], [-116.98228, 33.7007], [-116.98262, 33.6997], [-116.98616, 33.69994], [-116.98807, 33.70009], [-116.9889, 33.70009], [-116.98983, 33.69993], [-116.99006, 33.70029], [-116.99122, 33.70431]]]} | Open Access 1 | Diamond Valley Lake Community Park | https://www.gorecreation.org/diamond-valley-lake-community-park | 32828 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 83.3 | Diamond Valley Lake Community Park | |
1057 | 1057 | 1056 | {"type": "Polygon", "coordinates": [[[-116.89403, 33.75911], [-116.89402, 33.7592], [-116.89372, 33.75945], [-116.89348, 33.75971], [-116.89336, 33.7599], [-116.89326, 33.7601], [-116.89319, 33.76013], [-116.89307, 33.7601], [-116.89305, 33.75874], [-116.8932, 33.75872], [-116.89319, 33.75788], [-116.89322, 33.75789], [-116.89332, 33.75814], [-116.89345, 33.75837], [-116.89366, 33.75869], [-116.89321, 33.75894], [-116.89321, 33.75896], [-116.89355, 33.75931], [-116.89398, 33.75906], [-116.89403, 33.75911]]]} | Open Access 1 | Valle Vista | 32830 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2.049 | Valle Vista | ||
1058 | 1058 | 1057 | {"type": "Polygon", "coordinates": [[[-117.10104, 33.61814], [-117.10099, 33.61815], [-117.09946, 33.61994], [-117.09898, 33.61995], [-117.09889, 33.61989], [-117.09899, 33.61984], [-117.09924, 33.6196], [-117.09937, 33.61964], [-117.0994, 33.6196], [-117.09934, 33.61951], [-117.09945, 33.61938], [-117.09905, 33.61906], [-117.09888, 33.61919], [-117.09878, 33.61912], [-117.09874, 33.61914], [-117.09878, 33.61926], [-117.09857, 33.6194], [-117.0983, 33.6194], [-117.09822, 33.61937], [-117.09817, 33.61938], [-117.09814, 33.61941], [-117.09791, 33.61928], [-117.09793, 33.61925], [-117.09829, 33.61916], [-117.09853, 33.61889], [-117.09858, 33.61865], [-117.09868, 33.61843], [-117.09879, 33.61824], [-117.09903, 33.61795], [-117.09915, 33.61771], [-117.0992, 33.61745], [-117.09919, 33.61713], [-117.09914, 33.61694], [-117.09893, 33.61631], [-117.10101, 33.6163], [-117.10104, 33.61814]]]} | Open Access 1 | Abelia Sports Park | 32831 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 15.617 | Abelia Sports Park | ||
1064 | 1064 | 1063 | {"type": "Polygon", "coordinates": [[[-117.11078, 33.59922], [-117.11047, 33.59922], [-117.11042, 33.59918], [-117.11042, 33.59883], [-117.11047, 33.59863], [-117.11044, 33.59855], [-117.11077, 33.59833], [-117.11078, 33.59922]]]} | Open Access 1 | Avignon Park | 32832 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.671 | Avignon Park | ||
1132 | 1132 | 1131 | {"type": "Polygon", "coordinates": [[[-117.12996, 33.61098], [-117.12958, 33.61131], [-117.12915, 33.61159], [-117.12869, 33.61184], [-117.12814, 33.61205], [-117.12717, 33.60728], [-117.12708, 33.60616], [-117.12737, 33.60655], [-117.1276, 33.60697], [-117.12776, 33.60736], [-117.12796, 33.60806], [-117.12807, 33.60837], [-117.12822, 33.60871], [-117.1284, 33.60904], [-117.12873, 33.60952], [-117.12905, 33.60992], [-117.12941, 33.61028], [-117.12991, 33.61069], [-117.12996, 33.61098]]]} | Open Access 1 | Heroes Park | https://www.gorecreation.org/heroes-park | 32898 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 14.343 | Heroes Park | |
1181 | 1181 | 1180 | {"type": "Polygon", "coordinates": [[[-117.1072, 33.57315], [-117.10686, 33.57344], [-117.10669, 33.57327], [-117.10654, 33.57305], [-117.10656, 33.57299], [-117.10691, 33.5728], [-117.1072, 33.57315]]]} | Open Access 1 | Honey Pine Park | https://www.gorecreation.org/honey-pine-park | 32899 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.576 | Honey Pine Park | |
1182 | 1182 | 1181 | {"type": "Polygon", "coordinates": [[[-117.11195, 33.60932], [-117.11169, 33.6096], [-117.11136, 33.6097], [-117.11115, 33.60931], [-117.11144, 33.60917], [-117.11189, 33.6092], [-117.1119, 33.60926], [-117.11195, 33.60932]]]} | Open Access 1 | Kona Park | https://www.gorecreation.org/kona-park | 32900 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 0.69 | Kona Park | |
1200 | 1200 | 1199 | {"type": "Polygon", "coordinates": [[[-117.10295, 33.61494], [-117.10289, 33.61502], [-117.10284, 33.61516], [-117.10178, 33.61637], [-117.10172, 33.6164], [-117.10165, 33.61642], [-117.10128, 33.61638], [-117.10127, 33.6163], [-117.10121, 33.6163], [-117.10124, 33.61517], [-117.10122, 33.61452], [-117.10119, 33.61433], [-117.10114, 33.61419], [-117.10107, 33.61407], [-117.10076, 33.61419], [-117.10058, 33.6139], [-117.10062, 33.61381], [-117.10088, 33.61369], [-117.10141, 33.61349], [-117.10151, 33.61352], [-117.1018, 33.61394], [-117.10213, 33.61431], [-117.10251, 33.61463], [-117.10295, 33.61494]]]} | Open Access 1 | Brookfield Park | https://www.gorecreation.org/brookfield-park | 32890 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 8.254 | Brookfield Park | |
1202 | 1202 | 1201 | {"type": "Polygon", "coordinates": [[[-117.10681, 33.57934], [-117.10568, 33.58036], [-117.1054, 33.58065], [-117.10534, 33.58066], [-117.10466, 33.58035], [-117.10443, 33.5802], [-117.10424, 33.58001], [-117.10415, 33.57986], [-117.1041, 33.57976], [-117.10486, 33.57954], [-117.10466, 33.57863], [-117.10506, 33.57859], [-117.10533, 33.57861], [-117.10559, 33.57865], [-117.10585, 33.57871], [-117.1061, 33.57881], [-117.10643, 33.57899], [-117.10681, 33.57929], [-117.10681, 33.57934]]]} | Open Access 1 | Crown Valley Park | https://www.gorecreation.org/crown-valley-park | 32894 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 8.008 | Crown Valley Park | |
1203 | 1203 | 1202 | {"type": "Polygon", "coordinates": [[[-117.14273, 33.71059], [-117.14273, 33.71059], [-117.14015, 33.71058], [-117.1403, 33.71029], [-117.14052, 33.70999], [-117.14079, 33.70972], [-117.14111, 33.70949], [-117.14136, 33.70936], [-117.14176, 33.7092], [-117.14219, 33.70909], [-117.14264, 33.70905], [-117.14271, 33.70911], [-117.14273, 33.70959], [-117.14273, 33.71059]]]} | Open Access 1 | Discovery Park | https://www.gorecreation.org/discovery | 32895 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 7.305 | Discovery Park | |
1209 | 1209 | 1208 | {"type": "Polygon", "coordinates": [[[-117.10627, 33.60302], [-117.10626, 33.60307], [-117.10592, 33.60338], [-117.10576, 33.60354], [-117.10416, 33.60291], [-117.10415, 33.60211], [-117.10504, 33.60211], [-117.1052, 33.60213], [-117.10535, 33.60218], [-117.10548, 33.60225], [-117.1056, 33.60233], [-117.10627, 33.60302]]]} | Open Access 1 | Emerald Park | https://www.gorecreation.org/emerald-park | 32896 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 5.022 | Emerald Park | |
1211 | 1211 | 1210 | {"type": "Polygon", "coordinates": [[[-117.08558, 33.59306], [-117.08555, 33.59312], [-117.08555, 33.59329], [-117.08551, 33.59349], [-117.08543, 33.59368], [-117.08546, 33.59379], [-117.08528, 33.59388], [-117.08528, 33.59418], [-117.08394, 33.59423], [-117.08395, 33.59249], [-117.08487, 33.59316], [-117.08525, 33.59289], [-117.08558, 33.59306]]]} | Open Access 1 | Fieldview Park | https://www.gorecreation.org/fieldview-park | 32897 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 5.011 | Fieldview Park | |
1212 | 1212 | 1211 | {"type": "Polygon", "coordinates": [[[-117.15388, 33.67064], [-117.15386, 33.67362], [-117.15375, 33.67366], [-117.15354, 33.67339], [-117.15343, 33.6733], [-117.15342, 33.67327], [-117.15317, 33.67312], [-117.15276, 33.67299], [-117.15275, 33.67297], [-117.15218, 33.67273], [-117.1521, 33.67268], [-117.15205, 33.67268], [-117.15208, 33.67232], [-117.15206, 33.67228], [-117.15172, 33.67207], [-117.15166, 33.67209], [-117.15161, 33.67209], [-117.15158, 33.67206], [-117.15137, 33.67206], [-117.15113, 33.67216], [-117.15096, 33.67243], [-117.15097, 33.67245], [-117.15093, 33.67262], [-117.15094, 33.67265], [-117.15089, 33.67283], [-117.15091, 33.67286], [-117.15091, 33.67306], [-117.15088, 33.67307], [-117.15083, 33.67326], [-117.15041, 33.67303], [-117.15016, 33.67299], [-117.14999, 33.67287], [-117.14973, 33.67259], [-117.14955, 33.67245], [-117.14936, 33.67232], [-117.14933, 33.67232], [-117.14914, 33.6722], [-117.14911, 33.6722], [-117.14903, 33.67215], [-117.14888, 33.67217], [-117.14849, 33.67226], [-117.1482, 33.67272], [-117.14817, 33.6727], [-117.14817, 33.67261], [-117.14814, 33.67256], [-117.14802, 33.67247], [-117.14822, 33.67254], [-117.14865, 33.67182], [-117.14797, 33.67065], [-117.14945, 33.67065], [-117.14949, 33.67069], [-117.14973, 33.67069], [-117.14978, 33.67065], [-117.15154, 33.67065], [-117.15159, 33.67069], [-117.15183, 33.67069], [-117.15188, 33.67065], [-117.15388, 33.67064]]]} | Open Access 1 | Lago Vista Sports Park | https://www.gorecreation.org/lago-vista-sports-park | 32901 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 28.463 | Lago Vista Sports Park | |
1329 | 1329 | 1328 | {"type": "Polygon", "coordinates": [[[-117.11809, 33.60912], [-117.1177, 33.60913], [-117.11763, 33.60919], [-117.11757, 33.60916], [-117.11748, 33.60914], [-117.11728, 33.60917], [-117.11713, 33.60916], [-117.11713, 33.60891], [-117.11707, 33.6089], [-117.11708, 33.60844], [-117.11675, 33.60837], [-117.11676, 33.60828], [-117.11681, 33.60805], [-117.11687, 33.60802], [-117.1173, 33.60803], [-117.11751, 33.60806], [-117.11765, 33.60802], [-117.11808, 33.60802], [-117.11809, 33.60912]]]} | Open Access 1 | Leon Park | https://www.gorecreation.org/leon-park | 32942 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 3.124 | Leon Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);