units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where ACCESS_TYP = 1, LABEL_NAME = "Memorial Park" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
534 | 534 | 533 | {"type": "Polygon", "coordinates": [[[-117.63644, 34.10514], [-117.63631, 34.10514], [-117.63631, 34.10521], [-117.63512, 34.10522], [-117.63512, 34.10561], [-117.63519, 34.10561], [-117.63519, 34.10572], [-117.63522, 34.10582], [-117.63536, 34.10606], [-117.6354, 34.10616], [-117.63542, 34.10628], [-117.63542, 34.10671], [-117.63555, 34.10676], [-117.63555, 34.10693], [-117.63327, 34.10694], [-117.63267, 34.10692], [-117.63274, 34.10671], [-117.63274, 34.10637], [-117.63265, 34.10308], [-117.63508, 34.10198], [-117.63515, 34.10211], [-117.63511, 34.10213], [-117.63514, 34.1022], [-117.63525, 34.10227], [-117.63537, 34.10238], [-117.63577, 34.10306], [-117.6358, 34.10326], [-117.63587, 34.10327], [-117.63588, 34.10332], [-117.63571, 34.10333], [-117.63571, 34.1035], [-117.63605, 34.10351], [-117.63627, 34.10395], [-117.6364, 34.10438], [-117.63644, 34.10471], [-117.63644, 34.10514]]]} | Open Access 1 | 2499 | Memorial Park | 22136 | 1363 | Upland, City of 145 | City 2 | City Agency 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | City 2 | 1363 | Upland, City of 141 | City 2 | City Agency 2 | San Bernardino 22 | 34.792 | Memorial Park | 0 | Local Park 2 | 4 | |
697 | 697 | 696 | {"type": "Polygon", "coordinates": [[[-119.55003, 36.51801], [-119.54995, 36.51892], [-119.54785, 36.51891], [-119.54782, 36.51837], [-119.54847, 36.51799], [-119.55003, 36.51801]]]} | Open Access 1 | 3784 | Memorial Park | 22127 | 1153 | Kingsburg, City of 234 | City 2 | City Agency 2 | http://www.cityofkingsburg-ca.gov/ | City 2 | 1153 | Kingsburg, City of 230 | City 2 | City Agency 2 | Fresno 9 | 4.565 | Memorial Park | 0 | Local Park 2 | 4 | |
789 | 789 | 788 | {"type": "Polygon", "coordinates": [[[-117.72013, 34.10336], [-117.71855, 34.10336], [-117.71855, 34.10171], [-117.72012, 34.10172], [-117.72013, 34.10336]]]} | Open Access 1 | 5280 | Memorial Park | 22124 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | Los Angeles 6 | 6.563 | Memorial Park | 0 | Local Park 2 | 4 | |
886 | 886 | 885 | {"type": "Polygon", "coordinates": [[[-118.48199, 34.02107], [-118.48103, 34.02182], [-118.48014, 34.02248], [-118.47881, 34.02134], [-118.48061, 34.01989], [-118.48199, 34.02107]]]} | Open Access 1 | 5717 | Memorial Park | 22134 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 10.305 | Memorial Park | 0 | Local Park 2 | 4 | |
1072 | 1072 | 1071 | {"type": "Polygon", "coordinates": [[[-118.05819, 34.16144], [-118.05754, 34.16144], [-118.05753, 34.16175], [-118.05667, 34.16176], [-118.05667, 34.16071], [-118.05819, 34.16069], [-118.05819, 34.16144]]]} | Open Access 1 | 6974 | Memorial Park | 22135 | 1333 | Sierra Madre, City of 311 | City 2 | City Agency 2 | http://www.cityofsierramadre.com/parks | City 2 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 3.536 | Memorial Park | 0 | Local Park 2 | 4 | |
1290 | 1290 | 1289 | {"type": "Polygon", "coordinates": [[[-118.20604, 34.20728], [-118.20566, 34.20729], [-118.20564, 34.20751], [-118.20461, 34.2075], [-118.20465, 34.20708], [-118.20465, 34.20675], [-118.20468, 34.20669], [-118.20604, 34.20728]]]} | Open Access 1 | 5716 | Memorial Park | 22128 | 1154 | La Canada Flintridge, City of 333 | City 2 | City Agency 2 | http://www.lcf.ca.gov/parks-rec | City 2 | 1154 | La Canada Flintridge, City of 330 | City 2 | City Agency 2 | Los Angeles 6 | 1.652 | Memorial Park | 0 | Local Park 2 | 4 | |
2537 | 2537 | 2536 | {"type": "Polygon", "coordinates": [[[-119.28155, 34.28091], [-119.28137, 34.2815], [-119.28137, 34.28152], [-119.28144, 34.28152], [-119.28131, 34.282], [-119.2812, 34.28198], [-119.2812, 34.28195], [-119.27995, 34.28168], [-119.27993, 34.28171], [-119.27875, 34.28146], [-119.27908, 34.28039], [-119.28155, 34.28091]]]} | Open Access 1 | 17763 | Memorial Park | 22137 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 7.12 | Memorial Park | 0 | Local Park 2 | 4 | |
3041 | 3041 | 3040 | {"type": "Polygon", "coordinates": [[[-121.23462, 38.78913], [-121.23412, 38.78977], [-121.23355, 38.78951], [-121.23407, 38.78888], [-121.23462, 38.78913]]]} | Open Access 1 | 20841 | Memorial Park | 22130 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.143 | Memorial Park | 0 | Local Park 2 | 4 | |
4879 | 4879 | 4878 | {"type": "Polygon", "coordinates": [[[-122.15029, 37.72826], [-122.14873, 37.72907], [-122.14835, 37.72813], [-122.15002, 37.72768], [-122.15029, 37.72826]]]} | Open Access 1 | 14728 | Memorial Park | 22132 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 3.469 | Memorial Park | 0 | Local Park 2 | 4 | |
6273 | 6273 | 6272 | {"type": "Polygon", "coordinates": [[[-119.30992, 36.33057], [-119.30889, 36.33058], [-119.30888, 36.33016], [-119.30991, 36.33016], [-119.30992, 36.33057]]]} | Open Access 1 | 1369 | Memorial Park | 22138 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 1.046 | Memorial Park | 0 | Local Park 2 | 4 | |
6742 | 6742 | 6741 | {"type": "Polygon", "coordinates": [[[-122.04596, 37.32656], [-122.04581, 37.32656], [-122.04571, 37.32659], [-122.04442, 37.32659], [-122.04425, 37.32656], [-122.04382, 37.32642], [-122.04356, 37.32637], [-122.04169, 37.32636], [-122.04165, 37.32633], [-122.04163, 37.3263], [-122.04163, 37.32543], [-122.04167, 37.32537], [-122.04175, 37.32532], [-122.04219, 37.32527], [-122.04425, 37.32525], [-122.04425, 37.32305], [-122.04594, 37.32304], [-122.04596, 37.32656]]]} | Open Access 1 | 5082 | Memorial Park | 22126 | 1076 | Cupertino, City of 195 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | Santa Clara 19 | 21.687 | Memorial Park | 1966 | Local Park 2 | 4 | |
6881 | 6881 | 6880 | {"type": "Polygon", "coordinates": [[[-117.75657, 34.05757], [-117.75572, 34.05759], [-117.75569, 34.05688], [-117.75655, 34.05686], [-117.75657, 34.05757]]]} | Open Access 1 | 5604 | Memorial Park | 22129 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 1.562 | Memorial Park | 0 | Local Park 2 | 4 | |
7683 | 7683 | 7682 | {"type": "Polygon", "coordinates": [[[-117.08258, 32.63861], [-117.08125, 32.63898], [-117.08121, 32.63891], [-117.07936, 32.63942], [-117.07909, 32.63876], [-117.08144, 32.6381], [-117.08147, 32.63821], [-117.08142, 32.63826], [-117.08141, 32.6383], [-117.08142, 32.63834], [-117.08146, 32.63839], [-117.08153, 32.6384], [-117.08172, 32.63836], [-117.08173, 32.63841], [-117.08179, 32.63844], [-117.08197, 32.63839], [-117.08203, 32.63852], [-117.08249, 32.63839], [-117.08258, 32.63861]]]} | Open Access 1 | 7628 | Memorial Park | 22123 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/memorial-park | San Diego 4 | 5.257 | Memorial Park | 0 | Local Park 2 | 4 |
8751 | 8751 | 8750 | {"type": "MultiPolygon", "coordinates": [[[[-122.56578, 37.98282], [-122.56573, 37.98336], [-122.56561, 37.98361], [-122.5654, 37.98349], [-122.56509, 37.98379], [-122.56509, 37.9838], [-122.56525, 37.9839], [-122.56491, 37.98426], [-122.56455, 37.98405], [-122.56455, 37.98372], [-122.56383, 37.98375], [-122.56303, 37.98382], [-122.56403, 37.98314], [-122.5649, 37.98298], [-122.56534, 37.98279], [-122.56578, 37.98282]]], [[[-122.5661, 37.98446], [-122.56571, 37.98423], [-122.56589, 37.98406], [-122.5659, 37.98416], [-122.56596, 37.9843], [-122.5661, 37.98446]]], [[[-122.56682, 37.98284], [-122.566, 37.98369], [-122.56578, 37.98356], [-122.56589, 37.98336], [-122.56596, 37.98255], [-122.5661, 37.98241], [-122.56645, 37.98262], [-122.56612, 37.98298], [-122.56612, 37.983], [-122.56648, 37.98263], [-122.56682, 37.98284]]], [[[-122.56738, 37.98316], [-122.56621, 37.98435], [-122.56621, 37.98435], [-122.5661, 37.98416], [-122.56606, 37.98403], [-122.56606, 37.9839], [-122.56699, 37.98293], [-122.56738, 37.98316]]], [[[-122.56799, 37.98253], [-122.56746, 37.98306], [-122.56608, 37.98228], [-122.56663, 37.98173], [-122.5674, 37.98218], [-122.56742, 37.98218], [-122.56799, 37.98253]]]]} | Open Access 1 | 14223 | Memorial Park | 22131 | 1292 | San Anselmo, City of 437 | City 2 | City Agency 2 | http://www.townofsananselmo.org/index.aspx?nid=106 | City 2 | 1292 | San Anselmo, City of 431 | City 2 | City Agency 2 | Marin 23 | 10.371 | Memorial Park | 0 | Local Park 2 | 4 | |
9645 | 9645 | 9644 | {"type": "Polygon", "coordinates": [[[-122.01493, 39.21475], [-122.01467, 39.21544], [-122.01359, 39.21519], [-122.01385, 39.2145], [-122.01493, 39.21475]]]} | Open Access 1 | 16268 | Memorial Park | 22125 | 1063 | Colusa, City of 491 | City 2 | City Agency 2 | http://colusa.hosted.civiclive.com/recreation__tourism/city_parks/ | City 2 | 1063 | Colusa, City of 482 | City 2 | City Agency 2 | Colusa 49 | 1.909 | Memorial Park | 0 | Local Park 2 | 4 | |
10174 | 10174 | 10173 | {"type": "Polygon", "coordinates": [[[-119.52614, 34.40551], [-119.52615, 34.40556], [-119.52583, 34.40662], [-119.52527, 34.4065], [-119.52535, 34.40625], [-119.52529, 34.4062], [-119.52531, 34.40614], [-119.52529, 34.40603], [-119.52549, 34.40539], [-119.52554, 34.40537], [-119.52611, 34.40549], [-119.52614, 34.40551]]]} | Open Access 1 | 17754 | Memorial Park | 22121 | 1047 | Carpinteria, City of 72 | City 2 | City Agency 2 | http://www.carpinteria.ca.us/parks_rec/index.shtml | City 2 | 1047 | Carpinteria, City of 70 | City 2 | City Agency 2 | Santa Barbara 7 | 1.916 | Memorial Park | 0 | Local Park 2 | 4 | |
11301 | 11301 | 11300 | {"type": "Polygon", "coordinates": [[[-121.97305, 37.75923], [-121.97264, 37.75935], [-121.97238, 37.7594], [-121.97211, 37.75943], [-121.97184, 37.75943], [-121.97157, 37.75941], [-121.97131, 37.75937], [-121.97113, 37.75933], [-121.97053, 37.75914], [-121.97021, 37.75907], [-121.96989, 37.75901], [-121.96957, 37.75897], [-121.96925, 37.75897], [-121.96893, 37.75899], [-121.96861, 37.75904], [-121.96816, 37.75914], [-121.96813, 37.75913], [-121.96809, 37.7591], [-121.96797, 37.75882], [-121.96789, 37.7587], [-121.96823, 37.75858], [-121.96858, 37.75762], [-121.96929, 37.75712], [-121.97281, 37.75831], [-121.97288, 37.75846], [-121.9728, 37.75859], [-121.97305, 37.75923]]]} | Open Access 1 | 21972 | Memorial Park | 22133 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 17.079 | Memorial Park | 0 | Local Park 2 | 4 | |
12222 | 12222 | 12221 | {"type": "Polygon", "coordinates": [[[-120.65746, 40.41862], [-120.65737, 40.41884], [-120.65689, 40.41872], [-120.65681, 40.41889], [-120.65676, 40.41889], [-120.65671, 40.41903], [-120.65723, 40.41917], [-120.65707, 40.41957], [-120.65304, 40.41858], [-120.65356, 40.4172], [-120.65359, 40.41718], [-120.65691, 40.41799], [-120.65709, 40.41757], [-120.65715, 40.41759], [-120.65699, 40.418], [-120.65714, 40.41805], [-120.65712, 40.41811], [-120.65504, 40.41759], [-120.65487, 40.41798], [-120.65746, 40.41862]]]} | Open Access 1 | 25416 | Memorial Park | 22140 | 1437 | Susanville, City of 1013 | City 2 | City Agency 2 | http://www.cityofsusanville.org/ | City 2 | 1437 | Susanville, City of 975 | City 2 | City Agency 2 | Lassen 54 | 11.523 | Memorial Park | 0 | Local Park 2 | 4 | |
13089 | 13089 | 13088 | {"type": "Polygon", "coordinates": [[[-121.05633, 39.21384], [-121.05624, 39.2148], [-121.05553, 39.21478], [-121.05558, 39.21505], [-121.05434, 39.21508], [-121.05425, 39.21443], [-121.0543, 39.21412], [-121.05428, 39.21375], [-121.05416, 39.21327], [-121.05422, 39.21324], [-121.05475, 39.21318], [-121.055, 39.21318], [-121.05574, 39.21354], [-121.05609, 39.21357], [-121.05608, 39.21382], [-121.05633, 39.21384]]]} | Open Access 1 | 35006 | Memorial Park | 22141 | 1673 | Grass Valley, City of 1042 | City 2 | City Agency 2 | http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks | City 2 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 7.576 | Memorial Park | 0 | Local Park 2 | 4 | |
14060 | 14060 | 14059 | {"type": "Polygon", "coordinates": [[[-116.46672, 33.78273], [-116.46671, 33.7829], [-116.46666, 33.78295], [-116.46641, 33.78294], [-116.46641, 33.78273], [-116.46672, 33.78273]]]} | Open Access 1 | 39064 | Memorial Park | 22122 | 1049 | Cathedral City, City of 595 | City 2 | City Agency 2 | http://www.cathedralcity.gov/index.aspx?page=490 | City 2 | 1049 | Cathedral City, City of 585 | City 2 | City Agency 2 | Riverside 10 | 0.163 | Memorial 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]);