units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, COUNTY = 4, MNG_AGENCY = 373 and YR_EST = 0
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1523 | 1523 | 1522 | {"type": "Polygon", "coordinates": [[[-116.78494, 33.12411], [-116.78019, 33.12414], [-116.7802, 33.12031], [-116.7849, 33.12029], [-116.78494, 33.12411]]]} | Open Access 1 | 12843 | Corral Mountain Open Space | 17655 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 46.202 | Corral Mtn. OS | 0 | Private Recreation or Education 65 | 4 | |
8330 | 8330 | 8329 | {"type": "Polygon", "coordinates": [[[-117.09055, 33.05824], [-117.08987, 33.06472], [-117.0888, 33.0652], [-117.08779, 33.06623], [-117.08762, 33.06754], [-117.08752, 33.06778], [-117.08632, 33.06777], [-117.08589, 33.06832], [-117.08581, 33.06924], [-117.08613, 33.07024], [-117.08537, 33.07057], [-117.08523, 33.07125], [-117.08374, 33.07112], [-117.08344, 33.0707], [-117.08373, 33.0701], [-117.08329, 33.06941], [-117.08281, 33.06838], [-117.08267, 33.06775], [-117.08203, 33.06715], [-117.08234, 33.06662], [-117.08253, 33.06494], [-117.08257, 33.06486], [-117.0825, 33.06439], [-117.08259, 33.06429], [-117.08265, 33.06402], [-117.08265, 33.06372], [-117.08256, 33.06359], [-117.08246, 33.06348], [-117.0824, 33.06321], [-117.08242, 33.06312], [-117.08251, 33.06298], [-117.08256, 33.06263], [-117.08304, 33.06214], [-117.08335, 33.0619], [-117.08367, 33.0615], [-117.08376, 33.06128], [-117.08385, 33.06118], [-117.08378, 33.06105], [-117.08379, 33.06096], [-117.08386, 33.06082], [-117.08427, 33.06051], [-117.08432, 33.06043], [-117.08444, 33.06032], [-117.08499, 33.05989], [-117.0857, 33.05861], [-117.08713, 33.058], [-117.08766, 33.05785], [-117.08761, 33.0577], [-117.0876, 33.05758], [-117.08766, 33.05738], [-117.08773, 33.05731], [-117.08795, 33.05728], [-117.08817, 33.05732], [-117.0884, 33.05745], [-117.08853, 33.05762], [-117.08965, 33.0578], [-117.08988, 33.05787], [-117.09024, 33.05791], [-117.09039, 33.058], [-117.09055, 33.05824]], [[-117.08681, 33.06677], [-117.0869, 33.06677], [-117.087, 33.06674], [-117.08714, 33.06664], [-117.08713, 33.0657], [-117.08615, 33.0657], [-117.08616, 33.06666], [-117.08668, 33.06676], [-117.08681, 33.06677]]]} | Open Access 1 | 12833 | Bernardo Mountain Open Space | 10792 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | http://sdrvc.org/accomplishments/bernardo-mountain/171 | San Diego 4 | 175.923 | Bernardo Mtn. OS | 0 | Private Recreation or Education 65 | 4 |
14625 | 14625 | 14624 | {"type": "Polygon", "coordinates": [[[-117.26035, 32.96792], [-117.26005, 32.96812], [-117.25973, 32.9678], [-117.2599, 32.96778], [-117.2601, 32.96779], [-117.26023, 32.96784], [-117.26035, 32.96792]]]} | Open Access 1 | 44860 | San Dieguito Lagoon | 24865 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | http://sandieguitorivervalleyconservancy.org/sdrvc1_projects_acquisitions1.html | San Diego 4 | 0.286 | San Dieguito Lagoon | 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]);