units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 104 and SUID_NMA = 26098
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12480 | 12480 | 12479 | {"type": "MultiPolygon", "coordinates": [[[[-122.25932, 37.07222], [-122.2477, 37.07952], [-122.24783, 37.07973], [-122.24768, 37.08009], [-122.24745, 37.08032], [-122.24739, 37.08069], [-122.24722, 37.08094], [-122.24707, 37.08113], [-122.24726, 37.08134], [-122.24731, 37.08166], [-122.24766, 37.08181], [-122.24799, 37.082], [-122.24828, 37.0823], [-122.24863, 37.08254], [-122.24897, 37.08316], [-122.24965, 37.08265], [-122.25006, 37.0833], [-122.25039, 37.0843], [-122.25054, 37.08454], [-122.2508, 37.08473], [-122.25112, 37.08475], [-122.25207, 37.08536], [-122.25255, 37.08587], [-122.25274, 37.08618], [-122.25295, 37.08632], [-122.24433, 37.09295], [-122.23879, 37.0858], [-122.23897, 37.08567], [-122.23907, 37.08552], [-122.2389, 37.08547], [-122.23889, 37.08528], [-122.23878, 37.085], [-122.23898, 37.08496], [-122.23926, 37.085], [-122.23952, 37.08488], [-122.23957, 37.08447], [-122.23968, 37.08419], [-122.23957, 37.08404], [-122.23964, 37.08379], [-122.23985, 37.08369], [-122.23975, 37.08353], [-122.24001, 37.0832], [-122.24018, 37.08319], [-122.24027, 37.08286], [-122.24047, 37.0826], [-122.2404, 37.0824], [-122.24054, 37.0821], [-122.24083, 37.0821], [-122.24103, 37.08214], [-122.24115, 37.08194], [-122.24125, 37.08152], [-122.24194, 37.08099], [-122.24225, 37.08093], [-122.24241, 37.08081], [-122.24246, 37.08071], [-122.24235, 37.08056], [-122.24267, 37.08043], [-122.24279, 37.08003], [-122.24328, 37.07974], [-122.24346, 37.07987], [-122.24368, 37.07986], [-122.24383, 37.07959], [-122.24376, 37.07944], [-122.24339, 37.07936], [-122.24348, 37.07907], [-122.24379, 37.07912], [-122.24386, 37.07891], [-122.2437, 37.07876], [-122.24429, 37.07864], [-122.24429, 37.07862], [-122.24415, 37.07853], [-122.24422, 37.07837], [-122.24453, 37.07821], [-122.24527, 37.07747], [-122.24509, 37.07716], [-122.24464, 37.07674], [-122.24407, 37.07677], [-122.24374, 37.07656], [-122.24331, 37.0764], [-122.24251, 37.07647], [-122.24244, 37.07596], [-122.24219, 37.07562], [-122.24173, 37.07536], [-122.24094, 37.07535], [-122.24062, 37.07472], [-122.24018, 37.07449], [-122.23971, 37.07454], [-122.23887, 37.07392], [-122.23808, 37.07439], [-122.23772, 37.07418], [-122.23742, 37.07379], [-122.23674, 37.07385], [-122.23602, 37.07367], [-122.23567, 37.07302], [-122.23522, 37.073], [-122.23532, 37.07263], [-122.23568, 37.07241], [-122.23569, 37.07217], [-122.2352, 37.07187], [-122.23472, 37.07121], [-122.23418, 37.071], [-122.23371, 37.07114], [-122.23306, 37.07075], [-122.2323, 37.07072], [-122.23185, 37.07024], [-122.23131, 37.06949], [-122.23143, 37.06912], [-122.23119, 37.0686], [-122.23157, 37.06806], [-122.23076, 37.06739], [-122.23052, 37.06711], [-122.23043, 37.06692], [-122.23042, 37.0668], [-122.23013, 37.06664], [-122.2296, 37.06605], [-122.22956, 37.06595], [-122.22946, 37.06513], [-122.22951, 37.06502], [-122.22955, 37.06498], [-122.2298, 37.06441], [-122.22986, 37.06426], [-122.22986, 37.06423], [-122.22984, 37.06419], [-122.22982, 37.06412], [-122.22929, 37.06326], [-122.229, 37.06309], [-122.22884, 37.06302], [-122.22831, 37.06262], [-122.22799, 37.0624], [-122.22785, 37.06224], [-122.2278, 37.06197], [-122.22758, 37.06214], [-122.22753, 37.06233], [-122.2275, 37.06236], [-122.22684, 37.06277], [-122.22643, 37.0628], [-122.22678, 37.06318], [-122.22605, 37.06326], [-122.22583, 37.06301], [-122.22522, 37.06043], [-122.22527, 37.05851], [-122.22499, 37.05703], [-122.22557, 37.05361], [-122.22511, 37.05011], [-122.22388, 37.04905], [-122.22366, 37.04909], [-122.22365, 37.04911], [-122.22493, 37.05017], [-122.22539, 37.0537], [-122.22481, 37.05705], [-122.22509, 37.0585], [-122.22503, 37.06048], [-122.22571, 37.06306], [-122.22573, 37.06308], [-122.22513, 37.06342], [-122.22499, 37.06401], [-122.22431, 37.06432], [-122.2225, 37.06477], [-122.22379, 37.06645], [-122.22114, 37.06783], [-122.22101, 37.06916], [-122.21937, 37.06917], [-122.21481, 37.06924], [-122.21483, 37.07309], [-122.21029, 37.07307], [-122.21033, 37.0767], [-122.20578, 37.0767], [-122.20577, 37.0804], [-122.20572, 37.08394], [-122.19866, 37.084], [-122.20206, 37.06942], [-122.2148, 37.06923], [-122.21478, 37.06698], [-122.20262, 37.067], [-122.2054, 37.05526], [-122.20568, 37.05899], [-122.21012, 37.05896], [-122.21013, 37.0586], [-122.21073, 37.05856], [-122.21131, 37.05849], [-122.21175, 37.0584], [-122.21234, 37.05809], [-122.2132, 37.05748], [-122.21442, 37.05622], [-122.2149, 37.05582], [-122.21527, 37.05548], [-122.21538, 37.05542], [-122.20885, 37.04683], [-122.20996, 37.0465], [-122.21079, 37.04617], [-122.21145, 37.04605], [-122.21236, 37.04611], [-122.21313, 37.04579], [-122.21394, 37.04525], [-122.21397, 37.04466], [-122.21556, 37.04427], [-122.21629, 37.04419], [-122.21929, 37.04322], [-122.22024, 37.04316], [-122.22188, 37.04241], [-122.2223, 37.04216], [-122.22279, 37.04177], [-122.22399, 37.04085], [-122.226, 37.04065], [-122.22594, 37.03993], [-122.22635, 37.03878], [-122.22656, 37.03863], [-122.22733, 37.03926], [-122.22782, 37.03984], [-122.22991, 37.04165], [-122.23083, 37.04275], [-122.23222, 37.04368], [-122.23367, 37.04491], [-122.23433, 37.04571], [-122.23609, 37.04724], [-122.23689, 37.04778], [-122.24179, 37.052], [-122.24307, 37.05325], [-122.2432, 37.0534], [-122.2433, 37.05356], [-122.24344, 37.05375], [-122.24361, 37.05391], [-122.24375, 37.05399], [-122.24386, 37.05409], [-122.24395, 37.05421], [-122.2446, 37.05496], [-122.24513, 37.05544], [-122.24543, 37.05573], [-122.24584, 37.0562], [-122.24673, 37.05716], [-122.24746, 37.05789], [-122.25088, 37.06081], [-122.25149, 37.06138], [-122.25204, 37.06199], [-122.25237, 37.06241], [-122.25431, 37.06517], [-122.25411, 37.06528], [-122.25425, 37.0655], [-122.25457, 37.06578], [-122.25539, 37.06695], [-122.25554, 37.06735], [-122.25616, 37.06795], [-122.25795, 37.07081], [-122.2585, 37.07123], [-122.25932, 37.07222]]], [[[-122.23804, 37.047], [-122.23732, 37.04754], [-122.2372, 37.04744], [-122.23703, 37.04718], [-122.23689, 37.04702], [-122.23662, 37.04683], [-122.23631, 37.04668], [-122.23579, 37.04621], [-122.23673, 37.04552], [-122.23688, 37.0456], [-122.23755, 37.04645], [-122.23804, 37.047]]], [[[-122.25551, 37.06408], [-122.25505, 37.06463], [-122.25468, 37.065], [-122.25273, 37.06223], [-122.25238, 37.0618], [-122.25201, 37.06138], [-122.25161, 37.06097], [-122.25098, 37.0604], [-122.25049, 37.05992], [-122.24946, 37.05918], [-122.24805, 37.05803], [-122.24781, 37.05759], [-122.24713, 37.05694], [-122.24536, 37.05496], [-122.24596, 37.05447], [-122.24644, 37.05502], [-122.24718, 37.05603], [-122.24741, 37.05626], [-122.24838, 37.05674], [-122.24987, 37.05744], [-122.25058, 37.0579], [-122.25123, 37.05841], [-122.25156, 37.05878], [-122.25287, 37.0608], [-122.25315, 37.0612], [-122.25347, 37.06154], [-122.25457, 37.06331], [-122.25497, 37.0637], [-122.25551, 37.06408]]]]} | No Public Access 3 | 28256 | Swanton Pacific Ranch | 26098 | 210 | California State University 778 | State 5 | State Agency 5 | http://www.calstate.edu/ | Other State 5 | 210 | California State University 758 | State 5 | State Agency 5 | Santa Cruz 5 | 3202.67 | Swanton Pacific Ranch | 0 | State Other or Unknown 104 | 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]);