units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 8, MNG_AGENCY = 25, MNG_AG_TYP = 5 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Corte-Madera-Marsh-ER"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 1 ✖
MNG_AGENCY 1
- California Department of Fish and Wildlife · 1 ✖
DES_TP 1
- State Conservation Area · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15560 | 15560 | 15559 | {"type": "Polygon", "coordinates": [[[-122.51309, 37.94185], [-122.51233, 37.94165], [-122.5123, 37.94128], [-122.51208, 37.94125], [-122.51177, 37.94123], [-122.51169, 37.94119], [-122.51169, 37.94101], [-122.51168, 37.94095], [-122.51166, 37.94091], [-122.51158, 37.94084], [-122.51147, 37.94082], [-122.51141, 37.94082], [-122.51131, 37.94086], [-122.51124, 37.94093], [-122.51114, 37.94119], [-122.51086, 37.94114], [-122.51089, 37.9414], [-122.50788, 37.94164], [-122.50736, 37.94159], [-122.50735, 37.9416], [-122.50743, 37.94212], [-122.50653, 37.94218], [-122.50612, 37.94214], [-122.50492, 37.94245], [-122.50442, 37.9419], [-122.49822, 37.93785], [-122.49771, 37.9377], [-122.49756, 37.93231], [-122.48843, 37.93247], [-122.48849, 37.93502], [-122.47975, 37.93517], [-122.48032, 37.93167], [-122.47993, 37.92898], [-122.49748, 37.92869], [-122.49757, 37.93231], [-122.49985, 37.93227], [-122.49976, 37.92865], [-122.50159, 37.92862], [-122.50166, 37.92813], [-122.4999, 37.92677], [-122.49976, 37.92573], [-122.49998, 37.92569], [-122.50038, 37.92567], [-122.50082, 37.92572], [-122.50127, 37.92581], [-122.50172, 37.92568], [-122.50214, 37.92546], [-122.5026, 37.92477], [-122.50292, 37.92455], [-122.50322, 37.9245], [-122.50365, 37.92455], [-122.50402, 37.92475], [-122.50465, 37.92518], [-122.50489, 37.92522], [-122.50532, 37.92522], [-122.5058, 37.92533], [-122.50631, 37.92523], [-122.50663, 37.92499], [-122.50678, 37.92501], [-122.50704, 37.92485], [-122.50756, 37.92432], [-122.5082, 37.92432], [-122.50821, 37.92438], [-122.50845, 37.92445], [-122.50852, 37.92451], [-122.50863, 37.92451], [-122.50871, 37.92446], [-122.50872, 37.92433], [-122.50879, 37.92431], [-122.50911, 37.92431], [-122.50936, 37.92435], [-122.50936, 37.92443], [-122.50942, 37.9245], [-122.50953, 37.9245], [-122.50961, 37.92445], [-122.50963, 37.9243], [-122.51036, 37.92429], [-122.51066, 37.92623], [-122.5105, 37.92629], [-122.51062, 37.9269], [-122.51068, 37.92729], [-122.51066, 37.9273], [-122.51068, 37.92739], [-122.5106, 37.92744], [-122.50987, 37.92778], [-122.50954, 37.92788], [-122.50901, 37.92814], [-122.50876, 37.92835], [-122.50865, 37.92853], [-122.50862, 37.92877], [-122.50843, 37.92956], [-122.50839, 37.92998], [-122.50832, 37.93034], [-122.50819, 37.9308], [-122.50798, 37.93199], [-122.50773, 37.93298], [-122.50753, 37.93394], [-122.50733, 37.93514], [-122.50733, 37.93585], [-122.50745, 37.93684], [-122.5122, 37.93636], [-122.5123, 37.93702], [-122.51061, 37.93718], [-122.5106, 37.9372], [-122.51082, 37.93841], [-122.51252, 37.93824], [-122.51309, 37.94185]], [[-122.50446, 37.93582], [-122.50453, 37.93582], [-122.50454, 37.93581], [-122.50437, 37.93562], [-122.50439, 37.93534], [-122.50425, 37.93454], [-122.50398, 37.93421], [-122.50415, 37.93393], [-122.50367, 37.93329], [-122.50374, 37.93288], [-122.50282, 37.93222], [-122.50222, 37.93178], [-122.50214, 37.93161], [-122.50225, 37.93586], [-122.50446, 37.93582]]]} | Open Access 1 | 14434 | Corte Madera Marsh Ecological Reserve | 32135 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Corte-Madera-Marsh-ER | Marin 23 | 599.846 | Corte Madera Marsh ER | 1977 | State Conservation Area 8 | 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]);