units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 3, AGNCY_WEB = "http://www.egret.org" and MNG_AG_TYP = 12
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Non Profit - Conservation · 2 ✖
MNG_AGENCY 1
DES_TP 1
ACCESS_TYP 1
- No Public Access · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6810 | 6810 | 6809 | {"type": "MultiPolygon", "coordinates": [[[[-122.65173, 37.90384], [-122.65158, 37.90401], [-122.65115, 37.90382], [-122.65129, 37.90362], [-122.65173, 37.90384]]], [[[-122.81765, 38.06146], [-122.81754, 38.06146], [-122.81245, 38.06286], [-122.81194, 38.06173], [-122.81125, 38.0612], [-122.81059, 38.06056], [-122.81039, 38.06027], [-122.81315, 38.06025], [-122.812, 38.0582], [-122.81371, 38.05837], [-122.81468, 38.05828], [-122.81566, 38.05855], [-122.81608, 38.05902], [-122.81638, 38.05949], [-122.81568, 38.05977], [-122.8158, 38.06056], [-122.81601, 38.06082], [-122.8167, 38.06063], [-122.81701, 38.06047], [-122.81765, 38.06146]]], [[[-122.84113, 38.10518], [-122.84095, 38.10548], [-122.84078, 38.10549], [-122.84085, 38.1053], [-122.84071, 38.10517], [-122.8379, 38.10183], [-122.83231, 38.09736], [-122.8317, 38.09725], [-122.83173, 38.09716], [-122.83238, 38.09725], [-122.83803, 38.10165], [-122.84015, 38.10423], [-122.84113, 38.10518]]], [[[-122.83548, 38.08171], [-122.8341, 38.08231], [-122.83189, 38.08006], [-122.83318, 38.07953], [-122.83486, 38.08077], [-122.83548, 38.08171]]], [[[-122.84228, 38.08864], [-122.84103, 38.08934], [-122.84025, 38.08854], [-122.8415, 38.08785], [-122.84196, 38.08828], [-122.84228, 38.08864]]], [[[-122.85899, 38.10407], [-122.85845, 38.10455], [-122.85783, 38.10436], [-122.85849, 38.10377], [-122.85899, 38.10407]]], [[[-122.88891, 38.15011], [-122.88843, 38.15017], [-122.88843, 38.15004], [-122.88809, 38.14962], [-122.88773, 38.14911], [-122.88745, 38.14878], [-122.8871, 38.14862], [-122.88702, 38.1485], [-122.88743, 38.14817], [-122.88891, 38.15011]]], [[[-122.90414, 38.17203], [-122.90388, 38.1729], [-122.90099, 38.17342], [-122.90073, 38.17342], [-122.90071, 38.17341], [-122.90057, 38.17348], [-122.89968, 38.17359], [-122.89957, 38.17346], [-122.89817, 38.17223], [-122.89797, 38.1721], [-122.89788, 38.17201], [-122.8981, 38.17137], [-122.89817, 38.17107], [-122.89817, 38.17075], [-122.89666, 38.16946], [-122.89646, 38.16909], [-122.89614, 38.16871], [-122.89591, 38.16839], [-122.89553, 38.16803], [-122.89503, 38.16771], [-122.89481, 38.16759], [-122.89522, 38.16725], [-122.89567, 38.16713], [-122.89675, 38.16701], [-122.89643, 38.16566], [-122.89875, 38.16535], [-122.89916, 38.16474], [-122.89978, 38.16476], [-122.89978, 38.16475], [-122.89764, 38.16335], [-122.8959, 38.16296], [-122.89509, 38.16292], [-122.89436, 38.16304], [-122.89316, 38.16389], [-122.89236, 38.16462], [-122.89211, 38.16516], [-122.89186, 38.16501], [-122.89146, 38.16489], [-122.89135, 38.16483], [-122.89129, 38.16478], [-122.89125, 38.16471], [-122.89124, 38.1646], [-122.89127, 38.16448], [-122.89132, 38.16436], [-122.8914, 38.16425], [-122.8915, 38.16416], [-122.89186, 38.1639], [-122.89328, 38.16265], [-122.89357, 38.16257], [-122.89441, 38.16289], [-122.8947, 38.16257], [-122.89613, 38.16248], [-122.89614, 38.16233], [-122.89659, 38.16232], [-122.89876, 38.16323], [-122.89926, 38.16406], [-122.8998, 38.16436], [-122.8998, 38.16438], [-122.9005, 38.16468], [-122.90055, 38.16467], [-122.9016, 38.16537], [-122.90178, 38.16563], [-122.90182, 38.16565], [-122.90374, 38.16866], [-122.90376, 38.17108], [-122.90414, 38.17203]]], [[[-122.8953, 38.15984], [-122.89499, 38.16023], [-122.89451, 38.16011], [-122.89461, 38.15988], [-122.89466, 38.15964], [-122.89466, 38.15951], [-122.89463, 38.15927], [-122.89519, 38.15913], [-122.89532, 38.15957], [-122.8953, 38.15984]]], [[[-122.9089, 38.17946], [-122.90852, 38.17959], [-122.90767, 38.17868], [-122.90822, 38.1784], [-122.90889, 38.17903], [-122.9089, 38.17946]]], [[[-122.91023, 38.18131], [-122.90988, 38.18144], [-122.90983, 38.18128], [-122.90925, 38.18048], [-122.9092, 38.18027], [-122.90917, 38.18024], [-122.90944, 38.18015], [-122.90968, 38.18042], [-122.91023, 38.18131]]], [[[-122.9139, 38.18884], [-122.91364, 38.18905], [-122.91333, 38.18876], [-122.91308, 38.18846], [-122.91357, 38.18817], [-122.91378, 38.18817], [-122.9139, 38.18884]]], [[[-122.9214, 38.19643], [-122.9201, 38.19691], [-122.91995, 38.19678], [-122.9198, 38.19668], [-122.91973, 38.1966], [-122.91967, 38.1965], [-122.91962, 38.19635], [-122.91961, 38.19605], [-122.91957, 38.19585], [-122.91937, 38.19542], [-122.91927, 38.19517], [-122.92039, 38.19433], [-122.92138, 38.19633], [-122.9214, 38.19643]]], [[[-122.93386, 38.21111], [-122.9338, 38.21165], [-122.93265, 38.21197], [-122.93186, 38.21209], [-122.93142, 38.21286], [-122.92912, 38.21517], [-122.92848, 38.21643], [-122.9281, 38.21748], [-122.9263, 38.21878], [-122.92671, 38.21776], [-122.92653, 38.21229], [-122.92681, 38.20867], [-122.92772, 38.20701], [-122.92895, 38.20698], [-122.92999, 38.20915], [-122.93386, 38.21111]]], [[[-122.95406, 38.21874], [-122.95301, 38.22084], [-122.95266, 38.22165], [-122.95101, 38.22065], [-122.94925, 38.22001], [-122.94862, 38.21989], [-122.94773, 38.22016], [-122.94698, 38.21992], [-122.94759, 38.21871], [-122.94857, 38.21768], [-122.94896, 38.21746], [-122.94924, 38.2168], [-122.95, 38.21597], [-122.94996, 38.21568], [-122.95169, 38.21495], [-122.95283, 38.21445], [-122.95303, 38.21456], [-122.9531, 38.21482], [-122.95354, 38.21541], [-122.95386, 38.21699], [-122.95364, 38.2184], [-122.95369, 38.21852], [-122.95406, 38.21874]]]]} | No Public Access 3 | 5363 | Audubon Canyon Ranch | 15702 | 3005 | Audubon Canyon Ranch 837 | Non Profit 6 | Non Profit - Conservation 12 | http://www.egret.org | Non Governmental Organization 10 | 3005 | Audubon Canyon Ranch 814 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 380.201 | Audubon Canyon Ranch | 0 | Private Conservation 16 | 2 | |
15642 | 15642 | 15641 | {"type": "Polygon", "coordinates": [[[-122.7593, 38.69993], [-122.75919, 38.70741], [-122.75872, 38.7141], [-122.7511, 38.71424], [-122.7511, 38.72102], [-122.74372, 38.72095], [-122.73443, 38.72113], [-122.73435, 38.72474], [-122.72489, 38.72494], [-122.72492, 38.72128], [-122.72038, 38.72127], [-122.72039, 38.71391], [-122.72507, 38.71387], [-122.72506, 38.71074], [-122.72548, 38.7106], [-122.72596, 38.71055], [-122.72626, 38.71048], [-122.72695, 38.71021], [-122.72733, 38.71014], [-122.72789, 38.70998], [-122.7289, 38.70972], [-122.72889, 38.70667], [-122.73433, 38.70664], [-122.73433, 38.69959], [-122.74354, 38.69953], [-122.7593, 38.69993]]]} | No Public Access 3 | 38036 | Modini Ingalls Ecological Preserve | 22341 | 3005 | Audubon Canyon Ranch 837 | Non Profit 6 | Non Profit - Conservation 12 | http://www.egret.org | Non Governmental Organization 10 | 3005 | Audubon Canyon Ranch 814 | Non Profit 6 | Non Profit - Conservation 12 | Sonoma 16 | 1585.152 | Modini Ingalls EP | 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]);