units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, MNG_AG_TYP = 2 and UNIT_NAME = "City of Santa Cruz Open Space"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16189 | 16189 | 16188 | {"type": "MultiPolygon", "coordinates": [[[[-122.03412, 37.11263], [-122.03141, 37.11264], [-122.025, 37.11282], [-122.025, 37.10683], [-122.02315, 37.1068], [-122.02315, 37.10572], [-122.02271, 37.10572], [-122.02314, 37.10563], [-122.0235, 37.1056], [-122.02383, 37.10552], [-122.02415, 37.10539], [-122.02472, 37.10509], [-122.02486, 37.105], [-122.025, 37.10493], [-122.025, 37.1065], [-122.02567, 37.10651], [-122.02568, 37.10491], [-122.02585, 37.10495], [-122.02607, 37.10497], [-122.02641, 37.10496], [-122.02672, 37.1049], [-122.02706, 37.10479], [-122.02747, 37.10473], [-122.02789, 37.10461], [-122.02828, 37.10445], [-122.02887, 37.10426], [-122.02924, 37.10409], [-122.0296, 37.10391], [-122.03009, 37.10359], [-122.0304, 37.10336], [-122.03068, 37.1031], [-122.03257, 37.10162], [-122.03253, 37.10192], [-122.03283, 37.10195], [-122.03284, 37.10209], [-122.0332, 37.10212], [-122.03321, 37.1021], [-122.03338, 37.1021], [-122.03341, 37.10276], [-122.03379, 37.10248], [-122.03412, 37.11263]]], [[[-122.0376, 37.0972], [-122.03743, 37.09732], [-122.03725, 37.09741], [-122.03678, 37.09759], [-122.03659, 37.09769], [-122.03641, 37.0978], [-122.03607, 37.09807], [-122.03589, 37.09819], [-122.03554, 37.09835], [-122.03554, 37.09836], [-122.03558, 37.09837], [-122.03584, 37.09856], [-122.03556, 37.09892], [-122.03561, 37.09909], [-122.03592, 37.09925], [-122.03595, 37.09929], [-122.03596, 37.09934], [-122.03591, 37.09949], [-122.03588, 37.09953], [-122.03567, 37.09965], [-122.03551, 37.09977], [-122.03547, 37.09983], [-122.03543, 37.09992], [-122.03537, 37.09992], [-122.03512, 37.09976], [-122.03491, 37.0997], [-122.03469, 37.0997], [-122.03448, 37.09976], [-122.03435, 37.09982], [-122.03421, 37.09996], [-122.03415, 37.10005], [-122.03402, 37.10041], [-122.03393, 37.10055], [-122.03378, 37.10067], [-122.03368, 37.10074], [-122.03363, 37.10074], [-122.03351, 37.10062], [-122.0335, 37.10055], [-122.03362, 37.10039], [-122.03367, 37.1003], [-122.03396, 37.09952], [-122.03405, 37.09947], [-122.03408, 37.0994], [-122.03407, 37.09934], [-122.03401, 37.09928], [-122.03393, 37.09926], [-122.03382, 37.09928], [-122.03379, 37.09931], [-122.03375, 37.09936], [-122.03376, 37.09943], [-122.03379, 37.09948], [-122.03351, 37.10024], [-122.03344, 37.10037], [-122.03334, 37.10049], [-122.03339, 37.10072], [-122.03347, 37.10082], [-122.03345, 37.10087], [-122.03245, 37.10152], [-122.03054, 37.10302], [-122.03012, 37.10339], [-122.02965, 37.10372], [-122.02931, 37.10392], [-122.02895, 37.1041], [-122.02791, 37.1045], [-122.02746, 37.10464], [-122.02695, 37.10473], [-122.02662, 37.10483], [-122.02642, 37.10487], [-122.0262, 37.10488], [-122.02599, 37.10487], [-122.02561, 37.10479], [-122.02543, 37.10477], [-122.02525, 37.10478], [-122.02508, 37.10481], [-122.02484, 37.1049], [-122.02408, 37.10532], [-122.02375, 37.10545], [-122.0235, 37.10551], [-122.02298, 37.10556], [-122.02269, 37.10563], [-122.0224, 37.10572], [-122.02196, 37.10573], [-122.02195, 37.10605], [-122.0214, 37.10589], [-122.02127, 37.10584], [-122.02097, 37.10566], [-122.02086, 37.10562], [-122.02063, 37.1056], [-122.02018, 37.1056], [-122.01991, 37.10557], [-122.01981, 37.10595], [-122.02156, 37.10626], [-122.0215, 37.10635], [-122.02145, 37.10649], [-122.02143, 37.10664], [-122.02144, 37.10679], [-122.01965, 37.10647], [-122.01974, 37.10615], [-122.01911, 37.10603], [-122.01929, 37.10539], [-122.01866, 37.10516], [-122.01787, 37.1048], [-122.01724, 37.10458], [-122.01728, 37.11272], [-122.01728, 37.11634], [-122.01459, 37.11635], [-122.01457, 37.11701], [-122.01379, 37.11711], [-122.01362, 37.11674], [-122.01332, 37.11662], [-122.01286, 37.1168], [-122.01284, 37.10923], [-122.00835, 37.10924], [-122.00834, 37.10574], [-122.00384, 37.10577], [-122.00383, 37.10253], [-122.00344, 37.10249], [-122.00307, 37.1024], [-122.00274, 37.10225], [-122.00242, 37.10203], [-122.00218, 37.1019], [-122.00193, 37.10179], [-122.00166, 37.10171], [-121.99945, 37.10136], [-121.99945, 37.10078], [-122.00192, 37.1012], [-122.00218, 37.10128], [-122.00243, 37.10139], [-122.00265, 37.10151], [-122.00297, 37.10172], [-122.0032, 37.10183], [-122.00357, 37.10195], [-122.00382, 37.10199], [-122.00381, 37.09871], [-122.0221, 37.09857], [-122.02796, 37.09839], [-122.03088, 37.09826], [-122.0355, 37.09806], [-122.03574, 37.09804], [-122.03606, 37.09778], [-122.03624, 37.09767], [-122.03643, 37.09757], [-122.03679, 37.09743], [-122.03688, 37.09737], [-122.03704, 37.09725], [-122.03725, 37.09704], [-122.0376, 37.0972]], [[-122.03515, 37.09946], [-122.03518, 37.09946], [-122.03552, 37.09906], [-122.03525, 37.09882], [-122.03478, 37.09918], [-122.03474, 37.09939], [-122.03475, 37.0994], [-122.03515, 37.09946]]], [[[-122.01457, 37.1176], [-122.01457, 37.11826], [-122.01437, 37.11823], [-122.01397, 37.11823], [-122.01396, 37.11757], [-122.01457, 37.1176]]], [[[-122.01986, 37.11813], [-122.0196, 37.11843], [-122.01941, 37.11852], [-122.01883, 37.11796], [-122.01887, 37.11764], [-122.01939, 37.11747], [-122.01929, 37.11735], [-122.01923, 37.11643], [-122.01936, 37.11642], [-122.01945, 37.11702], [-122.01948, 37.11716], [-122.01959, 37.11736], [-122.01982, 37.11763], [-122.01989, 37.11792], [-122.01986, 37.11813]]], [[[-122.01673, 37.11835], [-122.01646, 37.11894], [-122.01617, 37.11923], [-122.01564, 37.11929], [-122.01562, 37.11925], [-122.01495, 37.11847], [-122.01499, 37.11832], [-122.01533, 37.1184], [-122.01564, 37.11832], [-122.01647, 37.1182], [-122.01673, 37.11835]]], [[[-122.01728, 37.11983], [-122.01727, 37.12336], [-122.01286, 37.12339], [-122.01286, 37.12153], [-122.01288, 37.11965], [-122.01368, 37.12025], [-122.01402, 37.12055], [-122.01421, 37.12062], [-122.01456, 37.12059], [-122.01473, 37.12059], [-122.01523, 37.12038], [-122.01532, 37.12016], [-122.01554, 37.12001], [-122.01572, 37.11981], [-122.0159, 37.11972], [-122.01625, 37.11979], [-122.01632, 37.12002], [-122.01643, 37.12019], [-122.01668, 37.12015], [-122.01696, 37.11987], [-122.01728, 37.11983]]]]} | Restricted Access 2 | 28268 | City of Santa Cruz Open Space | 17334 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 884.796 | City of Santa Cruz 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]);