units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 10 and UNIT_NAME = "Mary Elizabeth Miller Preserve at Black Mountain"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16903 | 16903 | 16902 | {"type": "Polygon", "coordinates": [[[-119.4705, 37.00923], [-119.48101, 37.00954], [-119.47739, 37.01125], [-119.47204, 37.01411], [-119.47068, 37.01486], [-119.4707, 37.01538], [-119.47069, 37.01639], [-119.47003, 37.01635], [-119.46892, 37.01634], [-119.46835, 37.0174], [-119.46819, 37.01854], [-119.4683, 37.01929], [-119.46862, 37.02004], [-119.4699, 37.02217], [-119.47038, 37.02338], [-119.47044, 37.02372], [-119.46563, 37.0237], [-119.46181, 37.02347], [-119.46199, 37.02735], [-119.46646, 37.02738], [-119.46647, 37.02727], [-119.46727, 37.02728], [-119.46728, 37.02724], [-119.46817, 37.02723], [-119.46838, 37.02694], [-119.46854, 37.02693], [-119.46852, 37.02545], [-119.46871, 37.02564], [-119.46871, 37.02728], [-119.46864, 37.02729], [-119.46876, 37.03083], [-119.47022, 37.03086], [-119.47022, 37.03104], [-119.46884, 37.03101], [-119.46206, 37.03098], [-119.46199, 37.02735], [-119.45751, 37.02724], [-119.45743, 37.02365], [-119.453, 37.02364], [-119.45298, 37.01999], [-119.45282, 37.0164], [-119.44827, 37.01635], [-119.44815, 37.01283], [-119.44373, 37.0128], [-119.43919, 37.01275], [-119.43493, 37.0126], [-119.435, 37.00904], [-119.42135, 37.00884], [-119.42131, 36.99474], [-119.43021, 36.99511], [-119.43034, 37.00213], [-119.43485, 37.00214], [-119.43493, 37.00554], [-119.43947, 37.00563], [-119.45272, 37.00573], [-119.45268, 37.00919], [-119.45269, 37.0092], [-119.46145, 37.00922], [-119.46598, 37.00928], [-119.4705, 37.00923]], [[-119.43034, 37.00215], [-119.42581, 37.00206], [-119.42587, 37.00554], [-119.43037, 37.00554], [-119.43034, 37.00215]]]} | Open Access 1 | 7684 | Mary Elizabeth Miller Preserve at Black Mountain | 29280 | 3077 | Sierra Foothill Conservancy 323 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sierrafoothill.org/ | Non Governmental Organization 10 | 3077 | Sierra Foothill Conservancy 320 | Non Profit 6 | Non Profit - Land Trust 10 | http://awww.sierrafoothill.org/index.php/land/preserves/mary-elizabeth-miller-preserve/ | Fresno 9 | 1460.655 | Mary Elizabeth Miller Preserve at Black Mtn. | 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]);