units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where GAP_STS = 2 and MNG_AGENCY = 821
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6733 | 6733 | 6732 | {"type": "Polygon", "coordinates": [[[-122.26297, 37.36581], [-122.26293, 37.36582], [-122.26294, 37.36592], [-122.26289, 37.366], [-122.26272, 37.36607], [-122.26276, 37.36619], [-122.26253, 37.3663], [-122.26254, 37.36633], [-122.26196, 37.3666], [-122.26183, 37.36669], [-122.26172, 37.36682], [-122.26162, 37.36681], [-122.26152, 37.36705], [-122.26144, 37.36742], [-122.26114, 37.36769], [-122.26095, 37.36784], [-122.25955, 37.36619], [-122.25746, 37.36678], [-122.25731, 37.36693], [-122.25716, 37.36693], [-122.25676, 37.36685], [-122.25656, 37.36685], [-122.25591, 37.36707], [-122.25591, 37.36709], [-122.25754, 37.36708], [-122.25735, 37.36729], [-122.25712, 37.36737], [-122.25659, 37.36747], [-122.25607, 37.3679], [-122.25625, 37.36822], [-122.25641, 37.36838], [-122.25649, 37.36878], [-122.25633, 37.36893], [-122.25575, 37.36932], [-122.25549, 37.36961], [-122.25449, 37.36977], [-122.2546, 37.37023], [-122.25415, 37.37047], [-122.25367, 37.37042], [-122.25352, 37.37051], [-122.25348, 37.37056], [-122.25198, 37.37054], [-122.25143, 37.37084], [-122.24809, 37.36765], [-122.24793, 37.36745], [-122.24782, 37.36723], [-122.24778, 37.36702], [-122.24778, 37.36678], [-122.24781, 37.36661], [-122.24803, 37.36597], [-122.24807, 37.36582], [-122.2481, 37.36551], [-122.24807, 37.36515], [-122.24799, 37.36485], [-122.24783, 37.36452], [-122.24767, 37.36428], [-122.24738, 37.36395], [-122.24723, 37.3637], [-122.24712, 37.36339], [-122.24709, 37.36316], [-122.2471, 37.36294], [-122.24714, 37.36277], [-122.2478, 37.36071], [-122.24787, 37.36035], [-122.24788, 37.35992], [-122.24784, 37.35955], [-122.24775, 37.35918], [-122.24758, 37.35877], [-122.2474, 37.35843], [-122.24716, 37.35811], [-122.24689, 37.35781], [-122.24663, 37.35758], [-122.24617, 37.35725], [-122.24499, 37.35659], [-122.24474, 37.35643], [-122.24434, 37.35615], [-122.24404, 37.35589], [-122.24309, 37.35486], [-122.24322, 37.35412], [-122.24159, 37.35276], [-122.24157, 37.3532], [-122.24052, 37.35199], [-122.24016, 37.35169], [-122.23978, 37.3514], [-122.23934, 37.35112], [-122.23684, 37.34972], [-122.23632, 37.3495], [-122.23577, 37.34935], [-122.23539, 37.34929], [-122.23472, 37.34923], [-122.23411, 37.34915], [-122.23331, 37.34901], [-122.23297, 37.34892], [-122.23255, 37.34879], [-122.23216, 37.34863], [-122.23184, 37.34848], [-122.23141, 37.34823], [-122.23091, 37.34787], [-122.23063, 37.34762], [-122.23043, 37.34741], [-122.23016, 37.34707], [-122.22922, 37.34553], [-122.22907, 37.34532], [-122.22892, 37.34515], [-122.22871, 37.34496], [-122.22832, 37.34469], [-122.22793, 37.3445], [-122.22718, 37.34426], [-122.22658, 37.344], [-122.22617, 37.34379], [-122.22553, 37.34334], [-122.22507, 37.34306], [-122.2247, 37.34286], [-122.2242, 37.34263], [-122.22021, 37.34108], [-122.22031, 37.34095], [-122.22084, 37.3407], [-122.22131, 37.34038], [-122.22208, 37.33983], [-122.22255, 37.33933], [-122.22275, 37.33916], [-122.22312, 37.33907], [-122.22346, 37.33901], [-122.22384, 37.33882], [-122.2241, 37.33836], [-122.22439, 37.33817], [-122.23254, 37.34143], [-122.23255, 37.34137], [-122.23257, 37.33717], [-122.23272, 37.33733], [-122.23292, 37.33764], [-122.23299, 37.33771], [-122.23315, 37.33784], [-122.23331, 37.33794], [-122.23378, 37.33815], [-122.2345, 37.33833], [-122.23478, 37.33847], [-122.23506, 37.33859], [-122.23528, 37.33862], [-122.23581, 37.33858], [-122.23624, 37.33858], [-122.2369, 37.3385], [-122.23723, 37.33848], [-122.23756, 37.3385], [-122.23787, 37.33858], [-122.23834, 37.3388], [-122.23871, 37.339], [-122.23895, 37.33917], [-122.23925, 37.33942], [-122.23996, 37.33994], [-122.24023, 37.34007], [-122.24044, 37.34011], [-122.24066, 37.34013], [-122.24098, 37.34011], [-122.24151, 37.34004], [-122.24164, 37.34006], [-122.24165, 37.34002], [-122.2423, 37.33997], [-122.24265, 37.33987], [-122.24311, 37.34], [-122.24378, 37.3401], [-122.24469, 37.34028], [-122.24808, 37.34109], [-122.24816, 37.34126], [-122.24853, 37.34139], [-122.24874, 37.34137], [-122.24905, 37.34148], [-122.24943, 37.3415], [-122.24971, 37.34147], [-122.24999, 37.34154], [-122.25041, 37.34133], [-122.25051, 37.34144], [-122.25065, 37.34142], [-122.25066, 37.34157], [-122.2594, 37.34161], [-122.25934, 37.34519], [-122.25864, 37.34713], [-122.25656, 37.34655], [-122.25414, 37.3493], [-122.25066, 37.35067], [-122.25064, 37.35264], [-122.25062, 37.3599], [-122.25309, 37.35989], [-122.25303, 37.35994], [-122.25305, 37.36007], [-122.25364, 37.36022], [-122.25401, 37.36053], [-122.25434, 37.36088], [-122.25431, 37.36107], [-122.25349, 37.36171], [-122.25318, 37.36187], [-122.25304, 37.36212], [-122.25312, 37.36237], [-122.25301, 37.3625], [-122.25264, 37.36259], [-122.252, 37.36294], [-122.25208, 37.36308], [-122.25254, 37.36305], [-122.25296, 37.36313], [-122.25341, 37.36297], [-122.25397, 37.36309], [-122.2542, 37.36333], [-122.25427, 37.36359], [-122.25452, 37.36351], [-122.25467, 37.36309], [-122.25502, 37.36297], [-122.25569, 37.36291], [-122.25656, 37.363], [-122.25673, 37.36349], [-122.25668, 37.36381], [-122.25697, 37.36404], [-122.25706, 37.36388], [-122.25925, 37.36259], [-122.25961, 37.36297], [-122.25971, 37.36312], [-122.25991, 37.36308], [-122.26002, 37.36302], [-122.26008, 37.36294], [-122.26015, 37.36277], [-122.26028, 37.36266], [-122.26044, 37.3626], [-122.26061, 37.36259], [-122.26043, 37.36268], [-122.26031, 37.36277], [-122.26021, 37.36289], [-122.26015, 37.36301], [-122.26012, 37.36314], [-122.26012, 37.36329], [-122.26016, 37.36344], [-122.26024, 37.36357], [-122.26034, 37.36367], [-122.26046, 37.36376], [-122.26112, 37.36408], [-122.26113, 37.36413], [-122.26126, 37.3642], [-122.2616, 37.36431], [-122.26212, 37.3644], [-122.26225, 37.36445], [-122.26238, 37.36453], [-122.26252, 37.36467], [-122.26294, 37.3656], [-122.2629, 37.36562], [-122.26297, 37.36581]]]} | No Public Access 3 | 5065 | Audubon Society | 15704 | 3075 | Sequoia Audubon Society 844 | Non Profit 6 | Non Profit - Conservation 12 | http://www.sequoia-audubon.org/ | Non Governmental Organization 10 | 3075 | Sequoia Audubon Society 821 | Non Profit 6 | Non Profit - Conservation 12 | San Mateo 15 | 1126.809 | Audubon Society | 2001 | 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]);