units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where AGNCY_NAME = 443 and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1873 | 1873 | 1872 | {"type": "Polygon", "coordinates": [[[-122.46707, 37.88146], [-122.46653, 37.88124], [-122.46589, 37.88087], [-122.46559, 37.88065], [-122.46532, 37.88041], [-122.46513, 37.88021], [-122.46483, 37.87984], [-122.46419, 37.87897], [-122.46388, 37.87861], [-122.46349, 37.87828], [-122.4633, 37.87796], [-122.46307, 37.87767], [-122.46282, 37.87739], [-122.46263, 37.87722], [-122.46342, 37.87788], [-122.46385, 37.87832], [-122.46603, 37.88068], [-122.46632, 37.88098], [-122.46669, 37.88126], [-122.46707, 37.88146]]]} | Open Access 1 | 16022 | Belvedere Lands 004 | 15999 | 1026 | Belvedere, City of 443 | City 2 | City Agency 2 | http://www.cityofbelvedere.org/ | City 2 | 1026 | Belvedere, City of 437 | City 2 | City Agency 2 | Marin 23 | 2.781 | Belvedere Lands 004 | None 152 | |||
8017 | 8017 | 8016 | {"type": "Polygon", "coordinates": [[[-122.46369, 37.87289], [-122.46367, 37.87292], [-122.46363, 37.87294], [-122.46327, 37.873], [-122.46321, 37.87299], [-122.46318, 37.87294], [-122.4632, 37.8729], [-122.4635, 37.87274], [-122.46356, 37.87275], [-122.46367, 37.87284], [-122.46369, 37.87289]]]} | Open Access 1 | 38048 | Mini Park | 32006 | 1026 | Belvedere, City of 443 | City 2 | City Agency 2 | http://www.cityofbelvedere.org/ | City 2 | 1026 | Belvedere, City of 437 | City 2 | City Agency 2 | Marin 23 | 0.193 | MP | 0 | Local Park 2 | 4 | |
16992 | 16992 | 16991 | {"type": "Polygon", "coordinates": [[[-122.46713, 37.87489], [-122.46694, 37.8751], [-122.46677, 37.87504], [-122.4658, 37.87478], [-122.46568, 37.87471], [-122.46552, 37.87458], [-122.46513, 37.87406], [-122.46517, 37.87404], [-122.46544, 37.87409], [-122.46684, 37.87479], [-122.46713, 37.87489]]]} | Open Access 1 | 17692 | Belvedere Community Center | 15997 | 1026 | Belvedere, City of 443 | City 2 | City Agency 2 | http://www.cityofbelvedere.org/ | City 2 | 1026 | Belvedere, City of 437 | City 2 | City Agency 2 | Marin 23 | 1.643 | Belvedere Community Ctr. | 0 | 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]);