units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, AGNCY_LEV = 2, AGNCY_TYP = 2 and DES_TP = 1395
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16235 | 16235 | 16234 | {"type": "Polygon", "coordinates": [[[-121.90527, 37.49358], [-121.9052, 37.49364], [-121.90471, 37.49366], [-121.90456, 37.49364], [-121.90442, 37.49372], [-121.90408, 37.49378], [-121.90368, 37.49411], [-121.90363, 37.49437], [-121.90355, 37.49439], [-121.90348, 37.49455], [-121.90325, 37.49465], [-121.90315, 37.49491], [-121.90248, 37.49516], [-121.9024, 37.49534], [-121.90229, 37.49542], [-121.90177, 37.49562], [-121.90156, 37.49585], [-121.90097, 37.49594], [-121.90084, 37.49614], [-121.90056, 37.49617], [-121.89998, 37.49613], [-121.8998, 37.49602], [-121.89974, 37.49574], [-121.89986, 37.4957], [-121.89973, 37.49537], [-121.89955, 37.49532], [-121.89943, 37.49536], [-121.89882, 37.49529], [-121.89845, 37.49496], [-121.89838, 37.49473], [-121.89801, 37.49457], [-121.89793, 37.49432], [-121.8977, 37.49424], [-121.89727, 37.49438], [-121.89699, 37.49434], [-121.89673, 37.49487], [-121.89596, 37.49633], [-121.89529, 37.49776], [-121.89423, 37.49959], [-121.87661, 37.50034], [-121.87655, 37.50024], [-121.87577, 37.49798], [-121.87328, 37.49109], [-121.8745, 37.48905], [-121.87416, 37.48824], [-121.88426, 37.48716], [-121.88426, 37.48713], [-121.88511, 37.48551], [-121.88591, 37.48351], [-121.88572, 37.48314], [-121.88587, 37.48215], [-121.88616, 37.48178], [-121.88617, 37.48153], [-121.88602, 37.48132], [-121.88578, 37.48131], [-121.88506, 37.48093], [-121.88517, 37.48071], [-121.88332, 37.47962], [-121.88417, 37.47872], [-121.88427, 37.47857], [-121.88435, 37.4784], [-121.88432, 37.4782], [-121.89052, 37.47614], [-121.89123, 37.47752], [-121.88921, 37.47817], [-121.88976, 37.47925], [-121.89093, 37.47887], [-121.89129, 37.4789], [-121.8913, 37.48002], [-121.89194, 37.47978], [-121.89223, 37.47964], [-121.89264, 37.47948], [-121.89322, 37.47935], [-121.89409, 37.4794], [-121.89446, 37.47931], [-121.89499, 37.47944], [-121.89526, 37.47959], [-121.89528, 37.48093], [-121.89506, 37.48116], [-121.89528, 37.48185], [-121.89638, 37.48301], [-121.89647, 37.48309], [-121.89662, 37.48318], [-121.89683, 37.48327], [-121.89701, 37.48331], [-121.89717, 37.48333], [-121.89718, 37.48355], [-121.89721, 37.48373], [-121.89729, 37.48393], [-121.89741, 37.48415], [-121.89758, 37.48434], [-121.89775, 37.48449], [-121.89793, 37.48461], [-121.89818, 37.48474], [-121.89803, 37.4849], [-121.89793, 37.48504], [-121.89786, 37.48522], [-121.89782, 37.4854], [-121.89782, 37.48558], [-121.89785, 37.48576], [-121.89791, 37.48594], [-121.898, 37.48609], [-121.89811, 37.48622], [-121.89824, 37.48633], [-121.89841, 37.48643], [-121.89859, 37.48651], [-121.8988, 37.48657], [-121.899, 37.48661], [-121.89922, 37.48663], [-121.89944, 37.48662], [-121.89949, 37.48682], [-121.8996, 37.48709], [-121.89974, 37.48732], [-121.89991, 37.48754], [-121.90012, 37.48773], [-121.90031, 37.48789], [-121.90053, 37.48802], [-121.9008, 37.48815], [-121.90118, 37.48828], [-121.90167, 37.48838], [-121.90203, 37.4884], [-121.90318, 37.48839], [-121.90331, 37.48903], [-121.90383, 37.4901], [-121.90369, 37.49084], [-121.90527, 37.49358]]]} | No Public Access 3 | 45940 | Hill Face Open Space City of Fremont | 29020 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 1038.333 | Hill Face OS City of Fremont | 1976 | None 1395 |
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]);