units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2 and MNG_AGENCY = 998
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13011 | 13011 | 13010 | {"type": "Polygon", "coordinates": [[[-122.07488, 37.0773], [-122.07365, 37.07969], [-122.07177, 37.07868], [-122.07123, 37.07859], [-122.07087, 37.07867], [-122.0706, 37.07841], [-122.06987, 37.07846], [-122.06831, 37.0799], [-122.0676, 37.08081], [-122.06757, 37.08181], [-122.0674, 37.08181], [-122.06645, 37.0818], [-122.06648, 37.08068], [-122.06562, 37.08034], [-122.06429, 37.07964], [-122.06405, 37.07935], [-122.06361, 37.07897], [-122.06273, 37.07861], [-122.0623, 37.07823], [-122.06184, 37.07801], [-122.06163, 37.07749], [-122.06148, 37.07742], [-122.06095, 37.07731], [-122.05935, 37.07846], [-122.05927, 37.07841], [-122.0585, 37.07752], [-122.05958, 37.07597], [-122.06208, 37.07574], [-122.06383, 37.07431], [-122.06382, 37.07429], [-122.06238, 37.07428], [-122.06239, 37.07328], [-122.06498, 37.0733], [-122.06525, 37.07244], [-122.06613, 37.07145], [-122.06767, 37.07161], [-122.06781, 37.07262], [-122.06938, 37.0739], [-122.06959, 37.07377], [-122.07205, 37.07535], [-122.07488, 37.0773]], [[-122.07175, 37.07565], [-122.07196, 37.07546], [-122.07196, 37.07544], [-122.07076, 37.07466], [-122.06983, 37.07409], [-122.06966, 37.07396], [-122.06957, 37.07398], [-122.06941, 37.07409], [-122.06767, 37.07267], [-122.06754, 37.07171], [-122.06622, 37.07159], [-122.06542, 37.07248], [-122.0654, 37.07262], [-122.0654, 37.07274], [-122.0655, 37.07307], [-122.06558, 37.07324], [-122.06551, 37.07326], [-122.06538, 37.07326], [-122.065, 37.07346], [-122.06466, 37.07354], [-122.06425, 37.07376], [-122.0641, 37.07391], [-122.06408, 37.07403], [-122.06408, 37.07414], [-122.06414, 37.0743], [-122.06426, 37.07443], [-122.06437, 37.07444], [-122.06424, 37.07451], [-122.06414, 37.07462], [-122.0641, 37.07475], [-122.06411, 37.07484], [-122.06413, 37.07487], [-122.06413, 37.0749], [-122.06418, 37.07496], [-122.06431, 37.0756], [-122.06435, 37.07652], [-122.06423, 37.0768], [-122.06416, 37.07684], [-122.06373, 37.07682], [-122.0631, 37.07681], [-122.06288, 37.07708], [-122.06288, 37.07712], [-122.0633, 37.07744], [-122.06373, 37.07753], [-122.06428, 37.07738], [-122.06452, 37.07761], [-122.06488, 37.07782], [-122.06482, 37.07791], [-122.06394, 37.07796], [-122.0639, 37.07807], [-122.06391, 37.07813], [-122.06406, 37.07823], [-122.0641, 37.07828], [-122.0642, 37.07834], [-122.06421, 37.07836], [-122.06441, 37.0785], [-122.06449, 37.07865], [-122.06453, 37.0787], [-122.06462, 37.07888], [-122.06467, 37.07895], [-122.06468, 37.07898], [-122.06482, 37.07902], [-122.06465, 37.07911], [-122.06461, 37.07923], [-122.06478, 37.07936], [-122.06479, 37.07938], [-122.06513, 37.07944], [-122.06538, 37.07958], [-122.06558, 37.07958], [-122.06565, 37.07954], [-122.06571, 37.07948], [-122.06577, 37.07937], [-122.06582, 37.07923], [-122.0676, 37.07962], [-122.06784, 37.07963], [-122.068, 37.07957], [-122.06809, 37.07951], [-122.06927, 37.07843], [-122.06939, 37.07834], [-122.06957, 37.07824], [-122.06984, 37.07814], [-122.07012, 37.07808], [-122.07071, 37.07806], [-122.07104, 37.07807], [-122.07155, 37.07793], [-122.07159, 37.0778], [-122.07169, 37.07759], [-122.07176, 37.07741], [-122.07216, 37.07659], [-122.07221, 37.07631], [-122.07213, 37.07592], [-122.07175, 37.07565]]]} | Restricted Access 2 | 31201 | Quail Hollow Quarry Conservation Areas | 24045 | 6066 | GraniteRock 1036 | Private 7 | Commercial 20 | http://www.graniterock.com/locations/santa_cruz.html | Private 14 | 6066 | GraniteRock 998 | Private 7 | Commercial 18 | Santa Cruz 5 | 78.891 | Quail Hollow Quarry Conservation Areas | 0 | Private Conservation 16 | 2 |
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]);