units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and SUID_NMA = 3581
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6680 | 6680 | 6679 | {"type": "Polygon", "coordinates": [[[-117.0696, 33.07388], [-117.06955, 33.07528], [-117.06859, 33.07537], [-117.06861, 33.07532], [-117.06859, 33.07526], [-117.06853, 33.07522], [-117.06844, 33.07522], [-117.0684, 33.07524], [-117.06834, 33.07529], [-117.06836, 33.07536], [-117.0684, 33.07541], [-117.06751, 33.07607], [-117.06746, 33.07642], [-117.06738, 33.07674], [-117.06728, 33.07693], [-117.06669, 33.0783], [-117.06684, 33.07836], [-117.06684, 33.08016], [-117.06724, 33.08017], [-117.06724, 33.08071], [-117.06727, 33.08106], [-117.06726, 33.08271], [-117.06242, 33.08188], [-117.06247, 33.08295], [-117.06255, 33.08402], [-117.06256, 33.0847], [-117.06239, 33.08465], [-117.06222, 33.08464], [-117.06204, 33.08466], [-117.06187, 33.08472], [-117.06173, 33.08482], [-117.06157, 33.085], [-117.06149, 33.08491], [-117.0611, 33.08424], [-117.06065, 33.08347], [-117.06058, 33.08332], [-117.06057, 33.08324], [-117.06059, 33.0823], [-117.06106, 33.08167], [-117.06106, 33.08165], [-117.05982, 33.08144], [-117.05954, 33.08279], [-117.05659, 33.08229], [-117.05686, 33.08093], [-117.05755, 33.07775], [-117.05763, 33.07737], [-117.05775, 33.07701], [-117.05893, 33.07405], [-117.06037, 33.07055], [-117.06068, 33.06987], [-117.06079, 33.0699], [-117.06093, 33.0696], [-117.06107, 33.06938], [-117.0666, 33.07404], [-117.06715, 33.07426], [-117.06752, 33.07433], [-117.06788, 33.07435], [-117.0682, 33.07433], [-117.0685, 33.07426], [-117.0696, 33.07388]]]} | Open Access 1 | 4952 | Kit Carson Park | 3581 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/kit-carson-park.aspx | San Diego 4 | 266.929 | Kit Carson Park | 0 | Local Park 2 | 4 |
7596 | 7596 | 7595 | {"type": "Polygon", "coordinates": [[[-117.06814, 33.09539], [-117.06642, 33.09508], [-117.06657, 33.0945], [-117.06594, 33.09413], [-117.06589, 33.09394], [-117.06597, 33.09372], [-117.06597, 33.09333], [-117.06587, 33.09317], [-117.06558, 33.09294], [-117.06558, 33.09234], [-117.06519, 33.09203], [-117.06485, 33.09148], [-117.06459, 33.0906], [-117.06431, 33.09019], [-117.06367, 33.08997], [-117.06336, 33.0886], [-117.06291, 33.08778], [-117.06237, 33.08737], [-117.06182, 33.08668], [-117.0615, 33.08596], [-117.06085, 33.08598], [-117.06106, 33.08588], [-117.06119, 33.0858], [-117.06138, 33.08563], [-117.0615, 33.08547], [-117.06172, 33.08508], [-117.06179, 33.08499], [-117.06189, 33.08491], [-117.06219, 33.08556], [-117.06249, 33.08579], [-117.06308, 33.08611], [-117.06376, 33.08623], [-117.06343, 33.08657], [-117.06317, 33.08654], [-117.06288, 33.08656], [-117.06295, 33.08689], [-117.06326, 33.08714], [-117.06367, 33.08793], [-117.06408, 33.08816], [-117.06454, 33.08864], [-117.06536, 33.08865], [-117.06536, 33.08901], [-117.06542, 33.08949], [-117.06528, 33.0895], [-117.06478, 33.0893], [-117.06469, 33.08945], [-117.0651, 33.09035], [-117.06571, 33.09133], [-117.06634, 33.09192], [-117.06571, 33.09167], [-117.0657, 33.09168], [-117.06577, 33.09193], [-117.06601, 33.09227], [-117.0662, 33.09267], [-117.0667, 33.0933], [-117.06699, 33.09335], [-117.06692, 33.09368], [-117.06748, 33.094], [-117.06747, 33.09404], [-117.06691, 33.09424], [-117.06695, 33.09458], [-117.06734, 33.09493], [-117.06776, 33.09498], [-117.06803, 33.09517], [-117.06814, 33.09539]]]} | Open Access 1 | 7306 | Kit Carson Park | 3581 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/kit-carson-park.aspx | San Diego 4 | 26.619 | Kit Carson 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]);