units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 428 and SUID_NMA = 18590
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8745 | 8745 | 8744 | {"type": "Polygon", "coordinates": [[[-122.26381, 38.16293], [-122.26252, 38.16345], [-122.26264, 38.16365], [-122.26255, 38.1637], [-122.26252, 38.16376], [-122.26253, 38.16382], [-122.26259, 38.16389], [-122.26266, 38.16391], [-122.26266, 38.1641], [-122.26273, 38.16422], [-122.26319, 38.16423], [-122.26317, 38.16429], [-122.26289, 38.16436], [-122.26289, 38.16451], [-122.26264, 38.16468], [-122.26261, 38.16464], [-122.26264, 38.16454], [-122.26258, 38.1643], [-122.26259, 38.16413], [-122.26236, 38.16404], [-122.26238, 38.164], [-122.26237, 38.16393], [-122.26233, 38.16387], [-122.26228, 38.16385], [-122.26231, 38.16364], [-122.2622, 38.1636], [-122.26122, 38.16399], [-122.26118, 38.16408], [-122.26112, 38.16399], [-122.26094, 38.16407], [-122.26094, 38.16408], [-122.261, 38.16415], [-122.26088, 38.16412], [-122.26026, 38.16437], [-122.26017, 38.16457], [-122.26029, 38.16463], [-122.26027, 38.16469], [-122.26028, 38.16473], [-122.26032, 38.16479], [-122.26024, 38.16484], [-122.26014, 38.16486], [-122.26011, 38.1648], [-122.26, 38.16474], [-122.26004, 38.16457], [-122.25984, 38.1645], [-122.25975, 38.16449], [-122.25901, 38.1648], [-122.25887, 38.16495], [-122.2584, 38.16471], [-122.25929, 38.16434], [-122.25919, 38.16431], [-122.2592, 38.16426], [-122.25912, 38.16413], [-122.25905, 38.1641], [-122.25907, 38.16402], [-122.25905, 38.16398], [-122.25897, 38.16392], [-122.25889, 38.1639], [-122.25871, 38.16368], [-122.2586, 38.1635], [-122.25868, 38.16346], [-122.25887, 38.16359], [-122.25902, 38.16376], [-122.25919, 38.16378], [-122.25919, 38.16383], [-122.25922, 38.16389], [-122.25936, 38.16395], [-122.25936, 38.16412], [-122.25945, 38.1642], [-122.26059, 38.16367], [-122.26063, 38.16358], [-122.26075, 38.16375], [-122.26092, 38.16368], [-122.26083, 38.1635], [-122.26095, 38.16353], [-122.26168, 38.16324], [-122.26202, 38.16317], [-122.26244, 38.163], [-122.26245, 38.16286], [-122.26218, 38.16277], [-122.2622, 38.16271], [-122.26217, 38.16264], [-122.26214, 38.1626], [-122.26203, 38.16257], [-122.26192, 38.1623], [-122.26187, 38.16206], [-122.26198, 38.16204], [-122.26204, 38.16223], [-122.26226, 38.1624], [-122.26245, 38.16248], [-122.26244, 38.16254], [-122.26246, 38.1626], [-122.26251, 38.16265], [-122.2625, 38.16279], [-122.26256, 38.16286], [-122.26269, 38.1629], [-122.26369, 38.16249], [-122.26373, 38.16254], [-122.26373, 38.16272], [-122.26381, 38.16293]]]} | Open Access 1 | 14202 | Elliott Park | 18590 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 8.099 | Elliott 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]);