units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and UNIT_NAME = "Mission Peak Regional Preserve"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12619 | 12619 | 12618 | {"type": "Polygon", "coordinates": [[[-121.90962, 37.5042], [-121.90908, 37.50427], [-121.90891, 37.50432], [-121.90874, 37.5044], [-121.90856, 37.50454], [-121.90791, 37.50522], [-121.90852, 37.50826], [-121.90692, 37.50847], [-121.90647, 37.50889], [-121.90638, 37.50913], [-121.90662, 37.50945], [-121.90668, 37.50984], [-121.90655, 37.51047], [-121.90559, 37.51121], [-121.90509, 37.51143], [-121.90475, 37.51146], [-121.90409, 37.51164], [-121.90357, 37.51162], [-121.90283, 37.512], [-121.90193, 37.51238], [-121.90179, 37.51275], [-121.90132, 37.51305], [-121.90086, 37.51305], [-121.90053, 37.5134], [-121.8998, 37.51369], [-121.8995, 37.51384], [-121.89887, 37.51388], [-121.89793, 37.51408], [-121.89749, 37.51456], [-121.89724, 37.51509], [-121.89709, 37.5152], [-121.89675, 37.51533], [-121.89643, 37.51539], [-121.89623, 37.51557], [-121.8957, 37.51581], [-121.8952, 37.51621], [-121.89518, 37.51658], [-121.89505, 37.51675], [-121.89607, 37.51717], [-121.8973, 37.5191], [-121.89559, 37.51979], [-121.89411, 37.52032], [-121.8925, 37.5181], [-121.89141, 37.51714], [-121.89084, 37.5161], [-121.88835, 37.51567], [-121.88969, 37.51394], [-121.8902, 37.51374], [-121.8902, 37.51372], [-121.88923, 37.51314], [-121.8853, 37.51061], [-121.88081, 37.50774], [-121.88034, 37.507], [-121.87949, 37.50554], [-121.87889, 37.50392], [-121.87864, 37.50347], [-121.87699, 37.50033], [-121.90406, 37.49917], [-121.90419, 37.50092], [-121.90436, 37.50153], [-121.90334, 37.50181], [-121.90374, 37.5027], [-121.90413, 37.50285], [-121.90419, 37.50262], [-121.90474, 37.50247], [-121.90481, 37.50262], [-121.9051, 37.50314], [-121.90544, 37.50333], [-121.90595, 37.50335], [-121.9061, 37.50431], [-121.90775, 37.50405], [-121.9092, 37.50408], [-121.9096, 37.50404], [-121.90962, 37.5042]]]} | Open Access 1 | 29420 | Mission Peak Regional Preserve | 3844 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/mission | Alameda 17 | 897.286 | Mission Peak RPr | 1976 | Local Conservation Area 4 | 2 |
16283 | 16283 | 16282 | {"type": "Polygon", "coordinates": [[[-121.90163, 37.52499], [-121.90143, 37.52518], [-121.90117, 37.52558], [-121.90089, 37.52646], [-121.90004, 37.52698], [-121.8994, 37.52728], [-121.8989, 37.52754], [-121.89859, 37.52788], [-121.89608, 37.52775], [-121.89606, 37.52774], [-121.89609, 37.52772], [-121.89615, 37.52753], [-121.89599, 37.52743], [-121.89538, 37.52713], [-121.89494, 37.52682], [-121.89489, 37.5268], [-121.89446, 37.52682], [-121.89391, 37.52652], [-121.89353, 37.52629], [-121.89271, 37.52557], [-121.89219, 37.52474], [-121.8918, 37.52439], [-121.89155, 37.52426], [-121.89098, 37.52416], [-121.89058, 37.52413], [-121.89015, 37.52404], [-121.88943, 37.52381], [-121.88903, 37.52373], [-121.88869, 37.52359], [-121.88847, 37.52339], [-121.88806, 37.52332], [-121.88777, 37.52314], [-121.8874, 37.52302], [-121.8871, 37.52295], [-121.88669, 37.52267], [-121.88646, 37.52233], [-121.88622, 37.52233], [-121.8859, 37.52261], [-121.88537, 37.52265], [-121.88432, 37.5224], [-121.88393, 37.52235], [-121.88353, 37.52238], [-121.88177, 37.52161], [-121.88105, 37.52125], [-121.88073, 37.52121], [-121.8804, 37.52131], [-121.88009, 37.52131], [-121.87958, 37.52089], [-121.87943, 37.5205], [-121.87911, 37.5204], [-121.87807, 37.52046], [-121.87748, 37.52039], [-121.87689, 37.52034], [-121.87638, 37.52024], [-121.87618, 37.52017], [-121.87601, 37.52024], [-121.87586, 37.52036], [-121.87571, 37.52043], [-121.87533, 37.52037], [-121.87515, 37.52032], [-121.87506, 37.52028], [-121.87492, 37.52014], [-121.87481, 37.52002], [-121.87452, 37.51957], [-121.87437, 37.51951], [-121.8742, 37.51948], [-121.87399, 37.5194], [-121.8737, 37.51926], [-121.87351, 37.51914], [-121.87341, 37.51897], [-121.87324, 37.51849], [-121.87319, 37.51827], [-121.87306, 37.51808], [-121.87293, 37.51795], [-121.87274, 37.5179], [-121.87253, 37.51787], [-121.87074, 37.51819], [-121.87046, 37.51796], [-121.87015, 37.51775], [-121.8701, 37.51767], [-121.87009, 37.51747], [-121.87015, 37.51727], [-121.87025, 37.51706], [-121.87031, 37.51688], [-121.87033, 37.51671], [-121.87031, 37.51646], [-121.8702, 37.5163], [-121.87, 37.51607], [-121.86994, 37.51589], [-121.86981, 37.5157], [-121.86971, 37.51549], [-121.8697, 37.51541], [-121.86957, 37.5154], [-121.86957, 37.51447], [-121.87397, 37.51447], [-121.87405, 37.50649], [-121.86196, 37.50648], [-121.86265, 37.50433], [-121.86226, 37.50343], [-121.8629, 37.50172], [-121.86365, 37.50092], [-121.86362, 37.49944], [-121.86466, 37.49523], [-121.86477, 37.49129], [-121.86476, 37.49128], [-121.86014, 37.49153], [-121.86044, 37.48464], [-121.8607, 37.48464], [-121.86071, 37.48469], [-121.86586, 37.48473], [-121.87008, 37.48213], [-121.87029, 37.48192], [-121.87032, 37.48098], [-121.87121, 37.47991], [-121.87279, 37.47895], [-121.87489, 37.47665], [-121.87595, 37.47584], [-121.87713, 37.47518], [-121.87709, 37.47496], [-121.87725, 37.47487], [-121.87723, 37.47464], [-121.87715, 37.47454], [-121.8778, 37.47389], [-121.87862, 37.47317], [-121.87914, 37.47261], [-121.88169, 37.47529], [-121.88432, 37.4782], [-121.88435, 37.4784], [-121.88427, 37.47857], [-121.88417, 37.47872], [-121.88333, 37.47962], [-121.88518, 37.48072], [-121.88507, 37.48094], [-121.88578, 37.48131], [-121.88602, 37.48132], [-121.88617, 37.48153], [-121.88616, 37.48178], [-121.88587, 37.48215], [-121.88572, 37.48313], [-121.88591, 37.48351], [-121.88511, 37.48551], [-121.88426, 37.48713], [-121.88426, 37.48716], [-121.87417, 37.48824], [-121.8745, 37.48905], [-121.87345, 37.49081], [-121.87158, 37.49092], [-121.87153, 37.49412], [-121.87439, 37.49416], [-121.87577, 37.49798], [-121.87655, 37.50024], [-121.87661, 37.50034], [-121.87699, 37.50033], [-121.87864, 37.50347], [-121.87889, 37.50392], [-121.87949, 37.50554], [-121.88034, 37.507], [-121.8808, 37.50774], [-121.8853, 37.51061], [-121.88923, 37.51314], [-121.89022, 37.51373], [-121.88969, 37.51394], [-121.88836, 37.51567], [-121.89084, 37.5161], [-121.89141, 37.51714], [-121.8925, 37.5181], [-121.89411, 37.52031], [-121.89559, 37.51979], [-121.89619, 37.52018], [-121.89583, 37.52053], [-121.89583, 37.52055], [-121.90052, 37.52434], [-121.90162, 37.5244], [-121.90163, 37.52499]], [[-121.87284, 37.4951], [-121.87283, 37.49509], [-121.86922, 37.49507], [-121.86918, 37.49779], [-121.87279, 37.49781], [-121.87284, 37.4951]]]} | Open Access 1 | 17946 | Mission Peak Regional Preserve | 3844 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/mission | Alameda 17 | 1727.899 | Mission Peak RPr | 1976 | Local Conservation Area 4 | 2 |
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]);