units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3 and AGNCY_NAME = 409
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10437 | 10437 | 10436 | {"type": "Polygon", "coordinates": [[[-122.52097, 37.59402], [-122.52099, 37.59408], [-122.52099, 37.59428], [-122.52093, 37.59439], [-122.52074, 37.59442], [-122.52061, 37.59443], [-122.52058, 37.59449], [-122.5205, 37.59453], [-122.52033, 37.59455], [-122.52025, 37.5946], [-122.52017, 37.59463], [-122.51975, 37.59464], [-122.51958, 37.59469], [-122.51917, 37.5947], [-122.51892, 37.59484], [-122.5185, 37.59485], [-122.51834, 37.5949], [-122.51828, 37.59497], [-122.51819, 37.59501], [-122.51778, 37.59502], [-122.51761, 37.59507], [-122.5172, 37.59508], [-122.51701, 37.59512], [-122.5165, 37.59512], [-122.51626, 37.59515], [-122.51597, 37.59524], [-122.51588, 37.59529], [-122.51571, 37.59531], [-122.51551, 37.59536], [-122.51537, 37.59549], [-122.51529, 37.59554], [-122.51512, 37.59554], [-122.51347, 37.5945], [-122.51307, 37.59399], [-122.51275, 37.59381], [-122.51286, 37.59367], [-122.51259, 37.59352], [-122.51246, 37.59366], [-122.51204, 37.59343], [-122.51179, 37.5931], [-122.51141, 37.59296], [-122.51096, 37.5922], [-122.51093, 37.59187], [-122.51242, 37.59017], [-122.51143, 37.5896], [-122.5106, 37.59054], [-122.50989, 37.59015], [-122.50851, 37.59172], [-122.50851, 37.59173], [-122.50923, 37.59212], [-122.50899, 37.5924], [-122.50912, 37.59248], [-122.50907, 37.59254], [-122.5089, 37.59244], [-122.50899, 37.59235], [-122.50899, 37.59233], [-122.50527, 37.59026], [-122.50488, 37.59071], [-122.50595, 37.59129], [-122.50626, 37.59184], [-122.50652, 37.59183], [-122.5066, 37.59185], [-122.50666, 37.59189], [-122.50673, 37.59199], [-122.50671, 37.59213], [-122.50673, 37.59224], [-122.50679, 37.59234], [-122.50687, 37.59241], [-122.5066, 37.59296], [-122.50602, 37.59278], [-122.50591, 37.59294], [-122.5053, 37.59136], [-122.5043, 37.5909], [-122.50421, 37.59074], [-122.50415, 37.59057], [-122.50414, 37.59037], [-122.50418, 37.59018], [-122.50428, 37.58995], [-122.50441, 37.58976], [-122.50463, 37.58956], [-122.50567, 37.58884], [-122.50567, 37.58774], [-122.50485, 37.58713], [-122.50475, 37.58703], [-122.50464, 37.58689], [-122.50455, 37.5867], [-122.5045, 37.58648], [-122.50452, 37.58628], [-122.50459, 37.58606], [-122.50469, 37.5859], [-122.50485, 37.58574], [-122.50504, 37.5856], [-122.50526, 37.5855], [-122.50551, 37.58544], [-122.50715, 37.58515], [-122.50722, 37.58527], [-122.50759, 37.58522], [-122.50801, 37.58521], [-122.50802, 37.58514], [-122.50851, 37.58519], [-122.50903, 37.58529], [-122.5102, 37.58561], [-122.51049, 37.58565], [-122.51078, 37.58567], [-122.51721, 37.58515], [-122.51708, 37.58537], [-122.51708, 37.58545], [-122.51701, 37.58552], [-122.51696, 37.58562], [-122.517, 37.58572], [-122.51692, 37.58581], [-122.51691, 37.58593], [-122.51688, 37.586], [-122.51689, 37.58611], [-122.51688, 37.58625], [-122.51688, 37.58632], [-122.51694, 37.58652], [-122.51691, 37.58657], [-122.5169, 37.58663], [-122.51692, 37.58697], [-122.51697, 37.58714], [-122.51697, 37.5872], [-122.51701, 37.58738], [-122.51702, 37.5875], [-122.51706, 37.58756], [-122.51708, 37.58761], [-122.51709, 37.58791], [-122.51712, 37.58797], [-122.51713, 37.58803], [-122.5171, 37.58821], [-122.51708, 37.58827], [-122.51707, 37.58845], [-122.51703, 37.58857], [-122.51704, 37.58868], [-122.517, 37.5888], [-122.51702, 37.58904], [-122.51698, 37.5891], [-122.51697, 37.58916], [-122.517, 37.58945], [-122.51696, 37.58958], [-122.51694, 37.5897], [-122.517, 37.58982], [-122.517, 37.58994], [-122.51698, 37.59006], [-122.51702, 37.59017], [-122.51705, 37.59065], [-122.51712, 37.59077], [-122.51717, 37.59088], [-122.51717, 37.59094], [-122.51723, 37.591], [-122.51731, 37.59112], [-122.51739, 37.59117], [-122.5174, 37.59123], [-122.51747, 37.59125], [-122.51756, 37.5913], [-122.51758, 37.59136], [-122.51771, 37.59147], [-122.51787, 37.59143], [-122.51794, 37.59144], [-122.51799, 37.59156], [-122.51814, 37.59154], [-122.51822, 37.59157], [-122.5182, 37.59168], [-122.51826, 37.59174], [-122.51827, 37.5918], [-122.51849, 37.59195], [-122.51864, 37.59202], [-122.51887, 37.59216], [-122.51892, 37.59222], [-122.51919, 37.59238], [-122.51931, 37.59251], [-122.51932, 37.59264], [-122.51948, 37.59273], [-122.51965, 37.59273], [-122.51972, 37.59279], [-122.5198, 37.59285], [-122.51982, 37.59291], [-122.51991, 37.59304], [-122.52011, 37.59324], [-122.52015, 37.5933], [-122.52032, 37.59337], [-122.5204, 37.59342], [-122.52047, 37.59348], [-122.52052, 37.59361], [-122.52061, 37.59367], [-122.52066, 37.59373], [-122.52074, 37.59377], [-122.52086, 37.5939], [-122.52088, 37.59396], [-122.52097, 37.59402]], [[-122.51472, 37.59234], [-122.51471, 37.59235], [-122.51473, 37.59276], [-122.51516, 37.59274], [-122.51515, 37.59234], [-122.51472, 37.59234]]]} | No Public Access 3 | 18442 | Pedro Point Headlands | 23562 | 1239 | Pacifica, City of 409 | City 2 | City Agency 2 | http://www.cityofpacifica.org/depts/rec_department/default.asp | City 2 | 1239 | Pacifica, City of 403 | City 2 | City Agency 2 | San Mateo 15 | 237.836 | Pedro Point Headlands | None 911 |
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]);