units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 16, MNG_AG_TYP = 10 and SUID_NMA = 27735
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Non Profit - Land Trust · 1 ✖
MNG_AGENCY 1
DES_TP 1
- Private Conservation · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7975 | 7975 | 7974 | {"type": "MultiPolygon", "coordinates": [[[[-116.90416, 32.85113], [-116.90303, 32.85114], [-116.90305, 32.84822], [-116.90392, 32.84823], [-116.90392, 32.84829], [-116.90383, 32.84824], [-116.90373, 32.84824], [-116.90364, 32.84831], [-116.90363, 32.84834], [-116.90364, 32.84842], [-116.90369, 32.84847], [-116.90378, 32.84853], [-116.90359, 32.84866], [-116.90348, 32.84888], [-116.90338, 32.84916], [-116.90305, 32.84968], [-116.90404, 32.84984], [-116.904, 32.85004], [-116.90399, 32.85018], [-116.904, 32.85039], [-116.90403, 32.8506], [-116.90416, 32.85113]]], [[[-116.91061, 32.84812], [-116.9106, 32.8522], [-116.90854, 32.85223], [-116.90853, 32.85356], [-116.90821, 32.85353], [-116.90794, 32.85356], [-116.90782, 32.85367], [-116.9078, 32.85371], [-116.90781, 32.85387], [-116.90768, 32.85392], [-116.90665, 32.85386], [-116.90628, 32.85387], [-116.90565, 32.85392], [-116.90525, 32.85392], [-116.90522, 32.8539], [-116.90515, 32.85373], [-116.90496, 32.85341], [-116.90491, 32.85328], [-116.90488, 32.85318], [-116.90488, 32.853], [-116.90491, 32.85293], [-116.90512, 32.85297], [-116.90522, 32.85292], [-116.90531, 32.85279], [-116.90535, 32.85264], [-116.90534, 32.85251], [-116.90527, 32.85238], [-116.90516, 32.85238], [-116.90515, 32.85233], [-116.90511, 32.85229], [-116.90517, 32.85222], [-116.90515, 32.85204], [-116.90512, 32.85197], [-116.90499, 32.85191], [-116.90469, 32.85166], [-116.90444, 32.85173], [-116.90443, 32.85149], [-116.90436, 32.85114], [-116.90423, 32.85057], [-116.90419, 32.85038], [-116.9042, 32.84999], [-116.90424, 32.84983], [-116.90431, 32.84961], [-116.90442, 32.84939], [-116.90466, 32.84949], [-116.90478, 32.84963], [-116.90468, 32.84984], [-116.90498, 32.84995], [-116.90498, 32.85002], [-116.90505, 32.8501], [-116.90516, 32.85012], [-116.90523, 32.85009], [-116.90529, 32.85], [-116.90529, 32.84996], [-116.90527, 32.84993], [-116.90528, 32.84985], [-116.90534, 32.84986], [-116.90534, 32.85151], [-116.90747, 32.85152], [-116.9075, 32.84987], [-116.90768, 32.84987], [-116.90792, 32.84984], [-116.90839, 32.84968], [-116.90851, 32.84966], [-116.90906, 32.8497], [-116.90958, 32.84983], [-116.90986, 32.84983], [-116.90991, 32.84976], [-116.90996, 32.8495], [-116.90997, 32.84811], [-116.91061, 32.84812]]], [[[-116.9082, 32.85673], [-116.90768, 32.85679], [-116.90752, 32.85595], [-116.90804, 32.85588], [-116.9082, 32.85673]]]]} | Open Access 1 | 10863 | Woodridge Preserve | 27735 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/portfolio_page/woodridge/ | San Diego 4 | 52.108 | Woodridge Preserve | 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]);