units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, LABEL_NAME = "Sabre Springs North OS" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16161 | 16161 | 16160 | {"type": "MultiPolygon", "coordinates": [[[[-117.09551, 32.94905], [-117.09566, 32.9494], [-117.0957, 32.94962], [-117.0957, 32.94991], [-117.09561, 32.95011], [-117.09538, 32.9505], [-117.09526, 32.95082], [-117.09521, 32.95105], [-117.09525, 32.95136], [-117.09525, 32.95148], [-117.09523, 32.95167], [-117.09521, 32.95168], [-117.09517, 32.95176], [-117.09514, 32.95223], [-117.0951, 32.95224], [-117.0948, 32.95307], [-117.09343, 32.9527], [-117.09313, 32.95301], [-117.09304, 32.95326], [-117.09238, 32.95347], [-117.09217, 32.95359], [-117.0919, 32.95359], [-117.09171, 32.95375], [-117.09148, 32.95376], [-117.09028, 32.95439], [-117.08985, 32.95476], [-117.08974, 32.95491], [-117.08969, 32.95512], [-117.0895, 32.95525], [-117.08939, 32.95543], [-117.08929, 32.95563], [-117.08918, 32.95621], [-117.08913, 32.95636], [-117.08848, 32.95631], [-117.08834, 32.95616], [-117.08816, 32.95605], [-117.08777, 32.95604], [-117.08757, 32.95617], [-117.0875, 32.9563], [-117.08784, 32.95651], [-117.08783, 32.95657], [-117.08758, 32.95653], [-117.08741, 32.95654], [-117.08733, 32.95685], [-117.08761, 32.95708], [-117.0891, 32.95725], [-117.08913, 32.95756], [-117.0893, 32.95774], [-117.08956, 32.9581], [-117.08961, 32.9583], [-117.08938, 32.95846], [-117.08902, 32.95812], [-117.08875, 32.95802], [-117.08838, 32.95797], [-117.08811, 32.95825], [-117.08808, 32.95837], [-117.08819, 32.95878], [-117.0882, 32.95907], [-117.08779, 32.95913], [-117.08754, 32.95929], [-117.08746, 32.95953], [-117.0875, 32.95968], [-117.08776, 32.95997], [-117.08772, 32.96003], [-117.08726, 32.9603], [-117.08702, 32.96056], [-117.08664, 32.96046], [-117.08635, 32.96063], [-117.08628, 32.96073], [-117.08633, 32.96111], [-117.08641, 32.96144], [-117.08693, 32.96185], [-117.08711, 32.96203], [-117.08689, 32.96211], [-117.08671, 32.96229], [-117.08657, 32.96266], [-117.08673, 32.96299], [-117.08699, 32.96318], [-117.08725, 32.96328], [-117.08748, 32.96335], [-117.08779, 32.96334], [-117.08808, 32.9634], [-117.08836, 32.96333], [-117.0886, 32.96402], [-117.08953, 32.96412], [-117.08968, 32.96409], [-117.09016, 32.96421], [-117.09015, 32.96423], [-117.09004, 32.96421], [-117.08997, 32.96443], [-117.08877, 32.96446], [-117.08701, 32.96517], [-117.0859, 32.96583], [-117.0849, 32.96622], [-117.08402, 32.9668], [-117.08383, 32.96659], [-117.08325, 32.9666], [-117.08286, 32.96641], [-117.08263, 32.96624], [-117.08252, 32.96598], [-117.08253, 32.96457], [-117.08425, 32.96458], [-117.08426, 32.96457], [-117.08397, 32.94974], [-117.07572, 32.94964], [-117.07572, 32.9496], [-117.07586, 32.94959], [-117.07589, 32.9496], [-117.07605, 32.9496], [-117.07618, 32.94958], [-117.07637, 32.94959], [-117.07649, 32.94957], [-117.07653, 32.94958], [-117.07668, 32.94957], [-117.07729, 32.94945], [-117.07757, 32.94937], [-117.07787, 32.94926], [-117.07823, 32.94907], [-117.07806, 32.94883], [-117.07907, 32.94832], [-117.07964, 32.94799], [-117.08001, 32.94783], [-117.08016, 32.94807], [-117.08043, 32.94796], [-117.08085, 32.94783], [-117.08166, 32.94766], [-117.08202, 32.94759], [-117.08214, 32.94759], [-117.08257, 32.9477], [-117.08274, 32.94772], [-117.08396, 32.94774], [-117.08397, 32.94795], [-117.08433, 32.94795], [-117.08493, 32.94757], [-117.08744, 32.94711], [-117.08804, 32.94726], [-117.0884, 32.94726], [-117.08841, 32.94739], [-117.08979, 32.94739], [-117.08995, 32.9477], [-117.09022, 32.94794], [-117.09186, 32.94833], [-117.09224, 32.94826], [-117.09245, 32.94809], [-117.09264, 32.94805], [-117.0931, 32.94866], [-117.09459, 32.94949], [-117.09531, 32.94957], [-117.09529, 32.94945], [-117.09536, 32.94906], [-117.09551, 32.94905]]], [[[-117.09301, 32.96351], [-117.09299, 32.96361], [-117.09284, 32.96387], [-117.0925, 32.96423], [-117.09248, 32.96436], [-117.09054, 32.96442], [-117.0906, 32.96421], [-117.09071, 32.96398], [-117.09128, 32.96409], [-117.09217, 32.96406], [-117.09227, 32.96378], [-117.09226, 32.96348], [-117.09217, 32.96331], [-117.09233, 32.96284], [-117.09256, 32.96241], [-117.09276, 32.96245], [-117.093, 32.96247], [-117.09295, 32.96266], [-117.09277, 32.96295], [-117.09277, 32.96314], [-117.09286, 32.96332], [-117.09301, 32.96351]]], [[[-117.09784, 32.95334], [-117.09747, 32.95361], [-117.0973, 32.95394], [-117.09727, 32.95458], [-117.09688, 32.95504], [-117.09684, 32.95527], [-117.097, 32.95547], [-117.09729, 32.95691], [-117.09666, 32.95755], [-117.09584, 32.95844], [-117.09505, 32.95936], [-117.09488, 32.9596], [-117.09479, 32.95976], [-117.09472, 32.95997], [-117.09449, 32.96121], [-117.09441, 32.96144], [-117.09427, 32.96166], [-117.09402, 32.96191], [-117.09372, 32.96207], [-117.09338, 32.96218], [-117.09303, 32.96222], [-117.09335, 32.96195], [-117.09349, 32.96134], [-117.09369, 32.96088], [-117.09324, 32.96043], [-117.09344, 32.95977], [-117.09352, 32.9594], [-117.09356, 32.95908], [-117.09399, 32.95909], [-117.09445, 32.95889], [-117.09508, 32.95822], [-117.09541, 32.95753], [-117.0957, 32.9572], [-117.09621, 32.95678], [-117.09632, 32.95632], [-117.09658, 32.95563], [-117.09634, 32.95483], [-117.09599, 32.95451], [-117.09649, 32.95408], [-117.09682, 32.95372], [-117.09696, 32.95354], [-117.09718, 32.95319], [-117.0973, 32.95295], [-117.0976, 32.95311], [-117.09784, 32.95334]]], [[[-117.10349, 32.94706], [-117.1033, 32.9473], [-117.10299, 32.94708], [-117.10264, 32.94705], [-117.10204, 32.94695], [-117.10167, 32.94725], [-117.10149, 32.94751], [-117.1012, 32.94763], [-117.10042, 32.94826], [-117.10028, 32.94838], [-117.10011, 32.94859], [-117.10005, 32.9488], [-117.10001, 32.94919], [-117.0996, 32.94962], [-117.09953, 32.94972], [-117.09948, 32.94986], [-117.09948, 32.95003], [-117.09954, 32.95027], [-117.09965, 32.95046], [-117.09985, 32.95064], [-117.10012, 32.95073], [-117.10014, 32.95078], [-117.10012, 32.951], [-117.10018, 32.95175], [-117.10008, 32.95175], [-117.09997, 32.95185], [-117.09972, 32.95221], [-117.09978, 32.95248], [-117.09911, 32.95286], [-117.09874, 32.95293], [-117.09859, 32.95302], [-117.09829, 32.95326], [-117.09816, 32.95325], [-117.09809, 32.95316], [-117.09804, 32.95318], [-117.09774, 32.95293], [-117.09738, 32.95273], [-117.09749, 32.95239], [-117.09756, 32.95202], [-117.09759, 32.95169], [-117.09758, 32.95133], [-117.09753, 32.95098], [-117.09745, 32.95065], [-117.09732, 32.95031], [-117.09713, 32.94995], [-117.09756, 32.9498], [-117.09762, 32.94946], [-117.09738, 32.94925], [-117.09723, 32.94893], [-117.09727, 32.94858], [-117.09744, 32.94821], [-117.09742, 32.94794], [-117.09782, 32.9472], [-117.09828, 32.94717], [-117.0983, 32.94722], [-117.09937, 32.94715], [-117.09942, 32.94709], [-117.10042, 32.94696], [-117.10164, 32.94644], [-117.10221, 32.94634], [-117.10349, 32.94706]]], [[[-117.10465, 32.94771], [-117.10453, 32.94907], [-117.10418, 32.94969], [-117.10294, 32.95067], [-117.10244, 32.95123], [-117.10242, 32.95123], [-117.10246, 32.95102], [-117.10244, 32.9508], [-117.10238, 32.95062], [-117.10225, 32.95041], [-117.10286, 32.94972], [-117.10298, 32.94957], [-117.10307, 32.94937], [-117.10316, 32.94915], [-117.10317, 32.94892], [-117.10314, 32.9487], [-117.10305, 32.94844], [-117.10317, 32.94784], [-117.10337, 32.94749], [-117.10346, 32.9475], [-117.10371, 32.94718], [-117.10465, 32.94771]]]]} | Open Access 1 | 18675 | Sabre Springs North Open Space | 10516 | 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 | 402.115 | Sabre Springs North 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]);