units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where AGNCY_TYP = 2, DES_TP = 3 and YR_EST = 2000
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1902 | 1902 | 1901 | {"type": "Polygon", "coordinates": [[[-122.4742, 37.72523], [-122.47387, 37.72523], [-122.4735, 37.72527], [-122.47349, 37.72487], [-122.47322, 37.72486], [-122.47322, 37.7248], [-122.47411, 37.72426], [-122.47414, 37.72425], [-122.47416, 37.72427], [-122.47426, 37.72486], [-122.4742, 37.72523]]]} | Open Access 1 | 16307 | Junipero Serra Playground | 20533 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.545 | Junipero Serra Playground | 2000 | Local Recreation Area 3 | 4 | |
6205 | 6205 | 6204 | {"type": "Polygon", "coordinates": [[[-122.04485, 37.87597], [-122.04472, 37.87736], [-122.04387, 37.87733], [-122.04101, 37.87676], [-122.04099, 37.87593], [-122.04031, 37.87511], [-122.03931, 37.87563], [-122.03914, 37.87627], [-122.03425, 37.87555], [-122.03426, 37.86945], [-122.03267, 37.86947], [-122.03165, 37.8692], [-122.03108, 37.8697], [-122.03024, 37.86962], [-122.02981, 37.86905], [-122.03238, 37.86704], [-122.03531, 37.86692], [-122.036, 37.86506], [-122.03714, 37.86599], [-122.03803, 37.86832], [-122.0388, 37.86827], [-122.04027, 37.87005], [-122.04246, 37.87304], [-122.04417, 37.87519], [-122.04485, 37.87597]]]} | Open Access 1 | 1250 | Sugarloaf Recreation Area | 25946 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 184.864 | Sugarloaf Rec. Area | 2000 | Local Recreation Area 3 | 4 | |
6300 | 6300 | 6299 | {"type": "Polygon", "coordinates": [[[-122.00948, 38.34308], [-122.00872, 38.34467], [-122.00701, 38.34922], [-122.00683, 38.34903], [-122.00699, 38.34894], [-122.00699, 38.34892], [-122.00674, 38.34867], [-122.00658, 38.34877], [-122.00653, 38.34873], [-122.00669, 38.34811], [-122.00525, 38.34739], [-122.00384, 38.34625], [-122.00365, 38.34649], [-122.00372, 38.3469], [-122.00364, 38.34691], [-122.00347, 38.34659], [-122.00335, 38.3466], [-122.00333, 38.34675], [-122.00313, 38.34708], [-122.00328, 38.34718], [-122.0034, 38.34738], [-122.00345, 38.34758], [-122.00328, 38.34776], [-122.00331, 38.34791], [-122.00325, 38.34817], [-122.00307, 38.34857], [-122.00277, 38.34889], [-122.00279, 38.3491], [-122.00256, 38.34887], [-122.00265, 38.34871], [-122.00284, 38.34855], [-122.00297, 38.34837], [-122.00309, 38.34797], [-122.00303, 38.34764], [-122.00318, 38.34745], [-122.00312, 38.34727], [-122.00301, 38.34719], [-122.00296, 38.34712], [-122.00307, 38.3466], [-122.00299, 38.34644], [-122.00268, 38.34637], [-122.00253, 38.3462], [-122.00226, 38.34601], [-122.00198, 38.34544], [-122.00181, 38.34515], [-122.00175, 38.34498], [-122.00215, 38.34482], [-122.00702, 38.34317], [-122.00825, 38.343], [-122.00928, 38.34317], [-122.00948, 38.34308]]]} | No Public Access 3 | 1417 | Alamo Terrace Open Space | 15323 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 55.193 | Alamo Terrace OS | 2000 | Local Recreation Area 3 | 4 | |
15673 | 15673 | 15672 | {"type": "MultiPolygon", "coordinates": [[[[-121.89541, 37.37943], [-121.89427, 37.37942], [-121.89269, 37.38197], [-121.8899, 37.37991], [-121.88744, 37.38246], [-121.88659, 37.38185], [-121.88541, 37.38076], [-121.88537, 37.38074], [-121.88537, 37.38072], [-121.88526, 37.38062], [-121.88521, 37.38053], [-121.88522, 37.38051], [-121.88453, 37.37987], [-121.88737, 37.37696], [-121.88571, 37.37551], [-121.88156, 37.37982], [-121.88142, 37.37967], [-121.88134, 37.37955], [-121.88131, 37.37944], [-121.88131, 37.37918], [-121.88142, 37.3789], [-121.88145, 37.37874], [-121.88145, 37.37859], [-121.88141, 37.37841], [-121.88133, 37.37826], [-121.88121, 37.37811], [-121.8811, 37.37802], [-121.88083, 37.37784], [-121.88082, 37.37781], [-121.88084, 37.37775], [-121.88072, 37.37768], [-121.8857, 37.3726], [-121.88699, 37.37171], [-121.88727, 37.37166], [-121.88755, 37.37144], [-121.8885, 37.37244], [-121.88866, 37.37235], [-121.88949, 37.37327], [-121.8897, 37.37398], [-121.88948, 37.37413], [-121.88976, 37.37467], [-121.89069, 37.37628], [-121.89054, 37.3768], [-121.89386, 37.37757], [-121.89432, 37.37694], [-121.8944, 37.37697], [-121.89454, 37.37694], [-121.89449, 37.37698], [-121.89447, 37.37703], [-121.89448, 37.37707], [-121.89453, 37.37712], [-121.8946, 37.37714], [-121.89468, 37.37713], [-121.89481, 37.37704], [-121.89517, 37.37697], [-121.89523, 37.37698], [-121.89525, 37.37701], [-121.89534, 37.37741], [-121.8954, 37.37782], [-121.89544, 37.3783], [-121.89545, 37.37859], [-121.89545, 37.37896], [-121.89541, 37.37943]]], [[[-121.89521, 37.37684], [-121.89516, 37.37689], [-121.89478, 37.37696], [-121.89463, 37.37692], [-121.8952, 37.37682], [-121.89521, 37.37684]]]]} | Restricted Access 2 | 9687 | San Jose Municipal Golf Course | 33028 | 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 | 169.542 | San Jose Municipal GC | 2000 | Local Recreation Area 3 | 4 | |
15983 | 15983 | 15982 | {"type": "Polygon", "coordinates": [[[-122.04704, 37.90031], [-122.04439, 37.90084], [-122.04401, 37.90062], [-122.04279, 37.90015], [-122.04225, 37.90071], [-122.04092, 37.89995], [-122.04078, 37.90009], [-122.04011, 37.89962], [-122.03885, 37.90096], [-122.03872, 37.90096], [-122.03864, 37.90084], [-122.03851, 37.90082], [-122.03847, 37.90071], [-122.03837, 37.90076], [-122.03771, 37.90074], [-122.0376, 37.90038], [-122.0373, 37.90052], [-122.0373, 37.90039], [-122.03678, 37.90022], [-122.03675, 37.90034], [-122.03652, 37.90009], [-122.03614, 37.90024], [-122.03554, 37.89975], [-122.03564, 37.89966], [-122.03564, 37.89964], [-122.03527, 37.89957], [-122.03516, 37.89946], [-122.03529, 37.89927], [-122.03483, 37.89932], [-122.03438, 37.89889], [-122.03412, 37.89857], [-122.03386, 37.89876], [-122.03363, 37.89904], [-122.03309, 37.89903], [-122.03298, 37.89839], [-122.03256, 37.89826], [-122.03243, 37.89849], [-122.03233, 37.89858], [-122.03221, 37.89864], [-122.03206, 37.89867], [-122.0319, 37.89867], [-122.03177, 37.89863], [-122.03163, 37.89856], [-122.03158, 37.89854], [-122.03152, 37.89857], [-122.03136, 37.89872], [-122.03124, 37.89886], [-122.03117, 37.89901], [-122.03097, 37.89987], [-122.03093, 37.89997], [-122.03087, 37.90008], [-122.03226, 37.90119], [-122.03203, 37.90145], [-122.03204, 37.90146], [-122.03221, 37.90155], [-122.03246, 37.90126], [-122.03332, 37.90151], [-122.03346, 37.90426], [-122.02664, 37.90248], [-122.02662, 37.90256], [-122.02634, 37.90502], [-122.02609, 37.90487], [-122.02599, 37.90464], [-122.0255, 37.90442], [-122.0252, 37.90426], [-122.02483, 37.90418], [-122.02382, 37.90386], [-122.02362, 37.90412], [-122.023, 37.90415], [-122.02291, 37.90404], [-122.0231, 37.90387], [-122.0231, 37.90386], [-122.02276, 37.9038], [-122.022, 37.90357], [-122.02103, 37.90346], [-122.02, 37.9039], [-122.01935, 37.90443], [-122.01944, 37.90509], [-122.0193, 37.90557], [-122.01913, 37.9059], [-122.01634, 37.90511], [-122.01708, 37.90336], [-122.01707, 37.90335], [-122.00881, 37.90183], [-122.00868, 37.90229], [-122.0072, 37.90201], [-122.0072, 37.90196], [-122.00381, 37.90134], [-122.00542, 37.89941], [-122.00353, 37.89968], [-122.00416, 37.89666], [-122.00354, 37.89485], [-122.00247, 37.89153], [-121.99981, 37.88434], [-122.01488, 37.88053], [-122.01029, 37.87187], [-122.0154, 37.87274], [-122.01487, 37.87325], [-122.01366, 37.87323], [-122.0132, 37.87377], [-122.0138, 37.87426], [-122.0144, 37.8741], [-122.01453, 37.87396], [-122.01467, 37.87388], [-122.0157, 37.87401], [-122.01562, 37.87431], [-122.01543, 37.87454], [-122.01478, 37.87498], [-122.01419, 37.87578], [-122.0142, 37.87579], [-122.01454, 37.876], [-122.01536, 37.87535], [-122.01615, 37.87546], [-122.01628, 37.87536], [-122.0162, 37.87481], [-122.01605, 37.87472], [-122.01624, 37.87436], [-122.01674, 37.87415], [-122.0173, 37.87408], [-122.01843, 37.87446], [-122.01948, 37.8754], [-122.01968, 37.87547], [-122.02022, 37.87554], [-122.02051, 37.87581], [-122.02087, 37.87701], [-122.02304, 37.87768], [-122.02327, 37.87813], [-122.01502, 37.88078], [-122.01795, 37.8863], [-122.01788, 37.88645], [-122.01755, 37.88785], [-122.01636, 37.88771], [-122.01473, 37.88726], [-122.01381, 37.88723], [-122.01376, 37.88791], [-122.02023, 37.89056], [-122.02028, 37.89063], [-122.02065, 37.89021], [-122.0213, 37.89012], [-122.02436, 37.89057], [-122.02589, 37.89149], [-122.02568, 37.89171], [-122.02588, 37.89183], [-122.0261, 37.89162], [-122.02655, 37.89189], [-122.02883, 37.8921], [-122.02934, 37.8923], [-122.03022, 37.89302], [-122.03089, 37.89309], [-122.03148, 37.89336], [-122.03345, 37.89467], [-122.03681, 37.89619], [-122.04199, 37.89973], [-122.04208, 37.89975], [-122.04224, 37.89983], [-122.04241, 37.89994], [-122.04292, 37.90012], [-122.04311, 37.89981], [-122.04326, 37.89983], [-122.04345, 37.89985], [-122.04377, 37.8998], [-122.04392, 37.89976], [-122.04407, 37.89969], [-122.0443, 37.89952], [-122.04465, 37.89984], [-122.04477, 37.8998], [-122.04524, 37.90051], [-122.04545, 37.9004], [-122.04546, 37.90021], [-122.04623, 37.90014], [-122.04645, 37.90001], [-122.04638, 37.89981], [-122.04682, 37.89969], [-122.04704, 37.90031]], [[-122.0263, 37.89222], [-122.02629, 37.8922], [-122.02603, 37.89205], [-122.02583, 37.89227], [-122.0261, 37.89243], [-122.0263, 37.89222]], [[-122.02932, 37.90175], [-122.02932, 37.90177], [-122.03057, 37.9026], [-122.03106, 37.90214], [-122.02981, 37.9013], [-122.02932, 37.90175]]]} | Open Access 1 | 741 | Shell Ridge Open Space | 14668 | 1371 | Walnut Creek, City of 178 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | http://www.walnut-creek.org/citygov/depts/ps/openspace/shellridge.asp | Contra Costa 12 | 1364.266 | Shell Ridge OS | 2000 | 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]);