units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and SUID_NMA = 16818
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5839 | 5839 | 5838 | {"type": "Polygon", "coordinates": [[[-117.12352, 32.93435], [-117.12347, 32.93447], [-117.12334, 32.93461], [-117.12333, 32.93474], [-117.12337, 32.93501], [-117.12345, 32.93517], [-117.12349, 32.93548], [-117.11887, 32.9355], [-117.11494, 32.93878], [-117.11486, 32.93848], [-117.11476, 32.93828], [-117.11462, 32.93805], [-117.11453, 32.93791], [-117.11434, 32.9377], [-117.1141, 32.93747], [-117.11366, 32.93719], [-117.11348, 32.93709], [-117.11316, 32.93697], [-117.11291, 32.93709], [-117.11281, 32.93691], [-117.11259, 32.93685], [-117.11222, 32.93673], [-117.11231, 32.93619], [-117.11374, 32.93496], [-117.11388, 32.93453], [-117.11343, 32.93402], [-117.11465, 32.93335], [-117.11548, 32.93082], [-117.11432, 32.92956], [-117.11453, 32.92912], [-117.11471, 32.92867], [-117.1148, 32.92831], [-117.11492, 32.92777], [-117.1152, 32.92622], [-117.11542, 32.92649], [-117.11552, 32.92664], [-117.1156, 32.92684], [-117.11564, 32.92704], [-117.11572, 32.92763], [-117.11603, 32.92796], [-117.11604, 32.92813], [-117.11618, 32.92838], [-117.11648, 32.92855], [-117.11712, 32.92873], [-117.11696, 32.92925], [-117.11698, 32.92969], [-117.11707, 32.92986], [-117.1174, 32.93], [-117.11768, 32.92983], [-117.11775, 32.92986], [-117.1178, 32.92987], [-117.11786, 32.92986], [-117.11792, 32.92982], [-117.11803, 32.92987], [-117.11835, 32.92979], [-117.11897, 32.92937], [-117.11896, 32.92977], [-117.11897, 32.92977], [-117.11913, 32.92962], [-117.11913, 32.92972], [-117.11932, 32.92984], [-117.11934, 32.92993], [-117.1193, 32.93012], [-117.1195, 32.93027], [-117.11965, 32.93031], [-117.11974, 32.93054], [-117.11999, 32.93092], [-117.12009, 32.93121], [-117.12021, 32.93144], [-117.12029, 32.93156], [-117.12047, 32.93199], [-117.12042, 32.93229], [-117.12046, 32.93245], [-117.12087, 32.93264], [-117.12093, 32.93277], [-117.12116, 32.93277], [-117.12142, 32.93308], [-117.12142, 32.93323], [-117.1216, 32.93309], [-117.1217, 32.93305], [-117.12193, 32.93304], [-117.12248, 32.93328], [-117.12272, 32.93331], [-117.12294, 32.93341], [-117.12315, 32.93373], [-117.12338, 32.93397], [-117.12346, 32.93411], [-117.12352, 32.93435]]]} | Open Access 1 | 165 | Canyon Hills Park and Open Space | 16818 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 142.094 | Canyon Hills Park and OS | 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]);