units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "Meadows Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
731 | 731 | 730 | {"type": "Polygon", "coordinates": [[[-117.67158, 33.93436], [-117.67145, 33.93446], [-117.67128, 33.93452], [-117.67111, 33.93454], [-117.67088, 33.9345], [-117.67099, 33.93433], [-117.66977, 33.93373], [-117.66924, 33.93354], [-117.66901, 33.93344], [-117.6685, 33.9331], [-117.66796, 33.93279], [-117.66758, 33.93247], [-117.66707, 33.93212], [-117.66681, 33.93198], [-117.66665, 33.93192], [-117.66633, 33.93186], [-117.66334, 33.93185], [-117.66334, 33.93144], [-117.66617, 33.93145], [-117.66637, 33.93126], [-117.66814, 33.9325], [-117.66858, 33.93279], [-117.66919, 33.93312], [-117.67155, 33.93429], [-117.67158, 33.93432], [-117.67158, 33.93436]]]} | Open Access 1 | 4742 | Meadows Park | 22096 | 1054 | Chino Hills, City of 119 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | San Bernardino 22 | 8.121 | Meadows Park | 0 | Local Park 2 | 4 | |
3440 | 3440 | 3439 | {"type": "Polygon", "coordinates": [[[-115.48246, 32.68055], [-115.48244, 32.68268], [-115.48183, 32.68268], [-115.4818, 32.68052], [-115.48243, 32.68051], [-115.48246, 32.68055]]]} | Open Access 1 | 48748 | Meadows Park | 33474 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 3.51 | Meadows Park | 0 | Local Park 2 | 4 | |
8525 | 8525 | 8524 | {"type": "Polygon", "coordinates": [[[-121.85977, 37.69562], [-121.85969, 37.69728], [-121.85872, 37.6973], [-121.85841, 37.69714], [-121.85853, 37.69673], [-121.85848, 37.69604], [-121.85861, 37.69577], [-121.85907, 37.69559], [-121.85977, 37.69562]]]} | Open Access 1 | 15392 | Meadows Park | 22098 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 4.869 | Meadows Park | 0 | Local Park 2 | 4 | |
8793 | 8793 | 8792 | {"type": "Polygon", "coordinates": [[[-122.41738, 37.60205], [-122.41705, 37.60239], [-122.4167, 37.60265], [-122.41569, 37.6017], [-122.41576, 37.60149], [-122.41603, 37.60143], [-122.41604, 37.60136], [-122.41629, 37.60156], [-122.41655, 37.60165], [-122.41692, 37.60183], [-122.41692, 37.60186], [-122.41706, 37.60191], [-122.41709, 37.60189], [-122.41738, 37.60205]]]} | Open Access 1 | 14304 | Meadows Park | 22097 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 2.345 | Meadows Park | 1973 | Local Park 2 | 4 | |
10211 | 10211 | 10210 | {"type": "Polygon", "coordinates": [[[-121.85285, 37.27095], [-121.8527, 37.27119], [-121.85266, 37.27143], [-121.85263, 37.27214], [-121.8527, 37.27221], [-121.85264, 37.27227], [-121.85264, 37.27235], [-121.8525, 37.27241], [-121.8524, 37.27268], [-121.85173, 37.27266], [-121.8516, 37.27069], [-121.85194, 37.27072], [-121.85225, 37.27078], [-121.85256, 37.27085], [-121.85285, 37.27095]]]} | Open Access 1 | 17858 | Meadows Park | 22099 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 4.509 | Meadows Park | 1993 | Local Park 2 | 4 | |
14514 | 14514 | 14513 | {"type": "Polygon", "coordinates": [[[-117.09537, 33.50221], [-117.09525, 33.50278], [-117.09519, 33.50314], [-117.09517, 33.5035], [-117.09519, 33.50386], [-117.09465, 33.50394], [-117.09457, 33.504], [-117.09443, 33.50388], [-117.09427, 33.50379], [-117.09409, 33.50372], [-117.0939, 33.50368], [-117.09377, 33.50334], [-117.09357, 33.50308], [-117.09344, 33.50296], [-117.09326, 33.50272], [-117.09343, 33.50273], [-117.09355, 33.50272], [-117.09404, 33.50255], [-117.09418, 33.50253], [-117.09435, 33.50256], [-117.09462, 33.50269], [-117.09471, 33.5027], [-117.0948, 33.50269], [-117.09489, 33.50266], [-117.095, 33.50259], [-117.09524, 33.50231], [-117.09537, 33.50221]]]} | Open Access 1 | 47178 | Meadows Park | 30869 | 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/MeadowsPark.htm | Riverside 10 | 5.02 | Meadows Park | 0 | Local Park 2 | 4 |
14944 | 14944 | 14943 | {"type": "Polygon", "coordinates": [[[-118.1754, 33.88972], [-118.17485, 33.88973], [-118.17485, 33.88933], [-118.17486, 33.88929], [-118.17492, 33.88926], [-118.1754, 33.88926], [-118.1754, 33.88972]]]} | Open Access 1 | 45544 | Meadows Park | 28374 | 1245 | Paramount, City of 285 | City 2 | City Agency 2 | http://www.paramountcity.com/ps.parksrecreation.cfm?ID=6 | City 2 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | http://www.paramountcity.com/parks.cfm?task=detail&ID=10 | Los Angeles 6 | 0.645 | Meadows 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]);