units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where ACCESS_TYP = 1 and MNG_AGENCY = 356 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 42 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14516 | 14516 | 14515 | {"type": "Polygon", "coordinates": [[[-117.14791, 33.49437], [-117.14766, 33.49416], [-117.14786, 33.49399], [-117.14794, 33.49397], [-117.14803, 33.49397], [-117.14808, 33.494], [-117.14813, 33.49406], [-117.14814, 33.49415], [-117.14811, 33.4942], [-117.14791, 33.49437]]]} | Open Access 1 | 47180 | Town Square | 30871 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 0.288 | Town Square | 0 | Local Park 2 | 4 | |
12000 | 12000 | 11999 | {"type": "Polygon", "coordinates": [[[-117.11583, 33.50748], [-117.11567, 33.50773], [-117.11554, 33.50786], [-117.11541, 33.50795], [-117.11516, 33.50761], [-117.11542, 33.50749], [-117.11557, 33.50746], [-117.11583, 33.50748]]]} | Open Access 1 | 24660 | Bahia Vista Park | 15757 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 0.448 | Bahia Vista Park | 0 | Local Park 2 | 4 | |
12127 | 12127 | 12126 | {"type": "Polygon", "coordinates": [[[-117.1166, 33.50629], [-117.11631, 33.50635], [-117.11602, 33.50645], [-117.11596, 33.50643], [-117.11587, 33.50631], [-117.11612, 33.50616], [-117.11647, 33.50585], [-117.1166, 33.50629]]]} | Open Access 1 | 25091 | Calle Aragon Park | 16734 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 0.518 | Calle Aragon Park | 0 | Local Park 2 | 4 | |
2851 | 2851 | 2850 | {"type": "Polygon", "coordinates": [[[-117.13417, 33.5384], [-117.13414, 33.53866], [-117.13392, 33.5387], [-117.13353, 33.53869], [-117.13336, 33.53866], [-117.1325, 33.5387], [-117.13407, 33.53834], [-117.13417, 33.5384]]]} | Open Access 1 | 22140 | Voorburg Park | 27197 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 0.728 | Voorburg Park | 0 | Local Park 2 | 4 | |
14504 | 14504 | 14503 | {"type": "Polygon", "coordinates": [[[-117.12483, 33.54045], [-117.12482, 33.5405], [-117.12439, 33.5407], [-117.1243, 33.54083], [-117.1236, 33.54113], [-117.12349, 33.54113], [-117.12349, 33.5408], [-117.12355, 33.54074], [-117.12483, 33.54045]]]} | Open Access 1 | 47161 | Nakayama Park | 30841 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/NakayamaPark.htm | Riverside 10 | 0.85 | Nakayama Park | 0 | Local Park 2 | 4 |
10707 | 10707 | 10706 | {"type": "Polygon", "coordinates": [[[-117.11049, 33.47644], [-117.11016, 33.47649], [-117.10983, 33.47658], [-117.10978, 33.47649], [-117.10973, 33.47622], [-117.10966, 33.47605], [-117.11027, 33.47583], [-117.11049, 33.47644]]]} | Open Access 1 | 19945 | John Magee Park | 20454 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 1.004 | John Magee Park | 0 | Local Park 2 | 4 | |
14509 | 14509 | 14508 | {"type": "Polygon", "coordinates": [[[-117.09846, 33.46835], [-117.09812, 33.46893], [-117.09775, 33.4688], [-117.09757, 33.46869], [-117.09743, 33.46855], [-117.09731, 33.46834], [-117.09734, 33.46829], [-117.09782, 33.46814], [-117.09819, 33.46799], [-117.09846, 33.46835]]]} | Open Access 1 | 47175 | Sunset Park | 30866 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/SunsetPark.htm | Riverside 10 | 1.613 | Sunset Park | 0 | Local Park 2 | 4 |
3398 | 3398 | 3397 | {"type": "Polygon", "coordinates": [[[-117.09041, 33.45956], [-117.08996, 33.45999], [-117.08989, 33.46], [-117.08897, 33.45931], [-117.08964, 33.45898], [-117.09041, 33.45956]]]} | Open Access 1 | 24673 | Paseo Gallante Park | 23497 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 1.822 | Paseo Gallante Park | 0 | Local Park 2 | 4 | |
2514 | 2514 | 2513 | {"type": "Polygon", "coordinates": [[[-117.14777, 33.48896], [-117.14754, 33.48901], [-117.1464, 33.48571], [-117.14663, 33.48566], [-117.14777, 33.48896]]]} | Open Access 1 | 19949 | Rotary Park | 24698 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.063 | Rotary Park | 0 | Local Park 2 | 4 | |
4132 | 4132 | 4131 | {"type": "Polygon", "coordinates": [[[-117.07627, 33.4742], [-117.07537, 33.47446], [-117.07523, 33.47432], [-117.07478, 33.47396], [-117.07499, 33.47382], [-117.07522, 33.47371], [-117.07546, 33.47361], [-117.07588, 33.47347], [-117.07599, 33.47351], [-117.07627, 33.4742]]]} | Open Access 1 | 47167 | Stephen Linen Jr. Memorial Park | 30852 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/StephenLinenJrMemorialPark.htm | Riverside 10 | 2.187 | Stephen Linen Jr. Memorial Park | 0 | Local Park 2 | 4 |
4133 | 4133 | 4132 | {"type": "Polygon", "coordinates": [[[-117.10489, 33.52993], [-117.10489, 33.52993], [-117.10464, 33.5314], [-117.10454, 33.53111], [-117.10447, 33.53097], [-117.10391, 33.53015], [-117.10394, 33.53007], [-117.10426, 33.52989], [-117.10456, 33.52969], [-117.10484, 33.52947], [-117.1049, 33.52951], [-117.10493, 33.52956], [-117.10492, 33.5296], [-117.10487, 33.52967], [-117.10489, 33.5297], [-117.10483, 33.52975], [-117.10481, 33.52981], [-117.10483, 33.52988], [-117.10489, 33.52993]]]} | Open Access 1 | 47168 | Serena Hills Park | 30855 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/SerenaHillsPark.htm | Riverside 10 | 2.237 | Serena Hills Park | 0 | Local Park 2 | 4 |
1402 | 1402 | 1401 | {"type": "Polygon", "coordinates": [[[-117.08454, 33.47208], [-117.0844, 33.47245], [-117.0842, 33.47242], [-117.08399, 33.47242], [-117.08296, 33.47253], [-117.08286, 33.47192], [-117.0832, 33.47194], [-117.08362, 33.47192], [-117.084, 33.47187], [-117.08447, 33.47176], [-117.08454, 33.47208]]]} | Open Access 1 | 24672 | Pablo Apis Park | 23288 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.311 | Pablo Apis Park | 0 | Local Park 2 | 4 | |
11355 | 11355 | 11354 | {"type": "Polygon", "coordinates": [[[-117.15188, 33.49686], [-117.15163, 33.49762], [-117.15159, 33.4976], [-117.15143, 33.49804], [-117.15136, 33.49802], [-117.15092, 33.49756], [-117.15013, 33.49809], [-117.15002, 33.49794], [-117.15099, 33.4971], [-117.15102, 33.49711], [-117.15113, 33.49701], [-117.15094, 33.49684], [-117.15137, 33.49681], [-117.15137, 33.49683], [-117.15167, 33.49683], [-117.15188, 33.49686]]]} | Open Access 1 | 22136 | Sam Hicks Monument Park | 24817 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.612 | Sam Hicks Monument Park | 0 | Local Park 2 | 4 | |
12001 | 12001 | 12000 | {"type": "Polygon", "coordinates": [[[-117.07232, 33.49361], [-117.07254, 33.49376], [-117.07268, 33.49391], [-117.0728, 33.49405], [-117.07282, 33.49416], [-117.07282, 33.49428], [-117.0727, 33.49468], [-117.07266, 33.49507], [-117.07261, 33.49514], [-117.0725, 33.49519], [-117.07242, 33.49519], [-117.07234, 33.49515], [-117.07199, 33.49485], [-117.07171, 33.49426], [-117.07232, 33.49361]]]} | Open Access 1 | 24661 | Butterfield Stage Park | 16610 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.798 | Butterfield Stage Park | 0 | Local Park 2 | 4 | |
11354 | 11354 | 11353 | {"type": "MultiPolygon", "coordinates": [[[[-117.11599, 33.46106], [-117.11574, 33.46129], [-117.11556, 33.46115], [-117.11541, 33.46097], [-117.11535, 33.46094], [-117.11528, 33.46094], [-117.11525, 33.46092], [-117.11581, 33.4604], [-117.11594, 33.4605], [-117.1159, 33.46055], [-117.1159, 33.46061], [-117.11593, 33.46067], [-117.11597, 33.46071], [-117.11577, 33.4609], [-117.11599, 33.46106]]], [[[-117.11583, 33.46164], [-117.11582, 33.4617], [-117.11559, 33.46182], [-117.1155, 33.46171], [-117.11575, 33.46154], [-117.11583, 33.46164]]], [[[-117.1169, 33.46281], [-117.11663, 33.46291], [-117.1164, 33.46307], [-117.11633, 33.46307], [-117.11625, 33.46301], [-117.11649, 33.46273], [-117.11645, 33.46267], [-117.11623, 33.46263], [-117.11609, 33.46256], [-117.1159, 33.46244], [-117.1157, 33.46211], [-117.11561, 33.46201], [-117.11591, 33.46184], [-117.11597, 33.46186], [-117.11624, 33.4623], [-117.1163, 33.46233], [-117.11636, 33.46234], [-117.11647, 33.4623], [-117.11674, 33.46255], [-117.11681, 33.46253], [-117.1169, 33.46281]]], [[[-117.1174, 33.46295], [-117.11732, 33.46333], [-117.11706, 33.46324], [-117.11694, 33.46328], [-117.11684, 33.46334], [-117.11662, 33.46312], [-117.11679, 33.46302], [-117.11699, 33.46296], [-117.1172, 33.46294], [-117.1174, 33.46295]]]]} | Open Access 1 | 22135 | Loma Linda Park | 21404 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.824 | Loma Linda Park | 0 | Local Park 2 | 4 | |
2850 | 2850 | 2849 | {"type": "Polygon", "coordinates": [[[-117.13628, 33.53783], [-117.1363, 33.53802], [-117.13629, 33.53814], [-117.13615, 33.53855], [-117.13606, 33.53872], [-117.13577, 33.53862], [-117.13556, 33.53846], [-117.13547, 33.53844], [-117.13542, 33.53845], [-117.13535, 33.53849], [-117.13532, 33.53853], [-117.13532, 33.53858], [-117.13521, 33.53864], [-117.13517, 33.53863], [-117.1351, 33.53885], [-117.13473, 33.53879], [-117.13436, 33.53867], [-117.13439, 33.5383], [-117.13445, 33.53824], [-117.13628, 33.53783]]]} | Open Access 1 | 22139 | Nicholas Road Park | 22746 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.913 | Nicholas Road Park | 0 | Local Park 2 | 4 | |
14445 | 14445 | 14444 | {"type": "Polygon", "coordinates": [[[-117.12141, 33.49859], [-117.12135, 33.49929], [-117.12075, 33.49932], [-117.12005, 33.4992], [-117.11986, 33.49909], [-117.12002, 33.4985], [-117.12015, 33.49817], [-117.12032, 33.49805], [-117.12098, 33.49847], [-117.12104, 33.49844], [-117.12141, 33.49859]]]} | Open Access 1 | 47173 | Temecula Skate Park | 30864 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/SkatePark.htm | Riverside 10 | 3.466 | Temecula Skate Park | 0 | Local Recreation Area 3 | 4 |
12002 | 12002 | 12001 | {"type": "Polygon", "coordinates": [[[-117.07528, 33.4991], [-117.07508, 33.49922], [-117.07485, 33.49926], [-117.07477, 33.49928], [-117.07472, 33.49934], [-117.07471, 33.49943], [-117.07466, 33.49937], [-117.07456, 33.4991], [-117.07455, 33.49897], [-117.07444, 33.49883], [-117.07437, 33.49867], [-117.07419, 33.49838], [-117.0741, 33.49817], [-117.07404, 33.49763], [-117.07405, 33.49747], [-117.07413, 33.49735], [-117.07447, 33.49703], [-117.07482, 33.49778], [-117.07483, 33.4979], [-117.07478, 33.49807], [-117.07479, 33.49817], [-117.07528, 33.4991]]]} | Open Access 1 | 24663 | Crown Hill Park | 17836 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 3.554 | Crown Hill Park | 0 | Local Park 2 | 4 | |
12008 | 12008 | 12007 | {"type": "Polygon", "coordinates": [[[-117.07633, 33.48251], [-117.07622, 33.48256], [-117.07614, 33.48257], [-117.0761, 33.48266], [-117.07614, 33.48271], [-117.07615, 33.48275], [-117.07614, 33.48278], [-117.07611, 33.48279], [-117.07597, 33.48279], [-117.07579, 33.48273], [-117.07547, 33.4828], [-117.07518, 33.48289], [-117.07445, 33.48317], [-117.07403, 33.48341], [-117.07357, 33.4835], [-117.07323, 33.48353], [-117.07275, 33.48352], [-117.0723, 33.48347], [-117.07213, 33.48348], [-117.07194, 33.48346], [-117.07155, 33.48349], [-117.07143, 33.48347], [-117.07142, 33.48348], [-117.07124, 33.48344], [-117.07103, 33.48343], [-117.0709, 33.4834], [-117.07081, 33.48336], [-117.07069, 33.48328], [-117.07045, 33.48316], [-117.07034, 33.48305], [-117.07025, 33.48301], [-117.07009, 33.48299], [-117.06983, 33.48303], [-117.06961, 33.48299], [-117.06975, 33.48277], [-117.0705, 33.48258], [-117.07043, 33.48242], [-117.07028, 33.48217], [-117.07037, 33.48214], [-117.07062, 33.48252], [-117.07068, 33.48277], [-117.07073, 33.48286], [-117.07082, 33.48297], [-117.07098, 33.48307], [-117.07144, 33.48326], [-117.07158, 33.48329], [-117.07198, 33.48326], [-117.07236, 33.4833], [-117.07313, 33.48334], [-117.07367, 33.48331], [-117.07392, 33.48324], [-117.07413, 33.4831], [-117.07441, 33.48296], [-117.07461, 33.4829], [-117.0753, 33.48262], [-117.07548, 33.48258], [-117.07598, 33.48256], [-117.0761, 33.48252], [-117.07614, 33.48249], [-117.07615, 33.48242], [-117.07605, 33.4822], [-117.07605, 33.48217], [-117.07608, 33.48214], [-117.07633, 33.48251]]]} | Open Access 1 | 24677 | Temecula Creek Trail Park | 26226 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 4.345 | Temecula Creek Trail Park | 0 | Local Park 2 | 4 | |
10728 | 10728 | 10727 | {"type": "Polygon", "coordinates": [[[-117.10272, 33.48405], [-117.10188, 33.48425], [-117.10114, 33.4824], [-117.10199, 33.48216], [-117.10272, 33.48405]]]} | Open Access 1 | 19944 | Paloma Del Sol | 23362 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 4.482 | Paloma Del Sol | None 939 |
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]);