calands: units_with_maps: 1 row where ACCESS_TYP = 3, LAYER = 5 and MNG

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where ACCESS_TYP = 3, LAYER = 5 and MNG_AGENCY = 758

Search:

descending

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]);