units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "26.137" and MNG_AGENCY = 27
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 1 ✖
DES_TP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4494 | 4494 | 4493 | {"type": "MultiPolygon", "coordinates": [[[[-118.48772, 34.08391], [-118.48608, 34.08433], [-118.48643, 34.08403], [-118.48641, 34.0838], [-118.48584, 34.08367], [-118.48547, 34.08363], [-118.48523, 34.08321], [-118.48495, 34.08305], [-118.48428, 34.08244], [-118.48405, 34.08227], [-118.48404, 34.08202], [-118.48463, 34.08151], [-118.48463, 34.08149], [-118.48417, 34.0812], [-118.4839, 34.08119], [-118.48367, 34.08055], [-118.48292, 34.08084], [-118.48286, 34.08076], [-118.48285, 34.0806], [-118.48289, 34.08051], [-118.48297, 34.08043], [-118.48317, 34.0803], [-118.48326, 34.08018], [-118.48328, 34.08012], [-118.48328, 34.07998], [-118.48324, 34.07986], [-118.48355, 34.07978], [-118.48394, 34.07935], [-118.48368, 34.07917], [-118.48344, 34.07892], [-118.48336, 34.07889], [-118.48328, 34.07888], [-118.48317, 34.07892], [-118.48311, 34.07896], [-118.48289, 34.07935], [-118.48269, 34.07953], [-118.48254, 34.07962], [-118.48232, 34.0797], [-118.48228, 34.07956], [-118.48232, 34.07959], [-118.48237, 34.07958], [-118.48254, 34.0795], [-118.48269, 34.0794], [-118.48282, 34.07926], [-118.48301, 34.0789], [-118.48309, 34.07884], [-118.48318, 34.0788], [-118.48332, 34.07878], [-118.48341, 34.0788], [-118.48349, 34.07883], [-118.48374, 34.07908], [-118.48385, 34.07916], [-118.48394, 34.07908], [-118.48445, 34.079], [-118.48445, 34.07898], [-118.48415, 34.07889], [-118.48396, 34.07875], [-118.48384, 34.07863], [-118.48446, 34.0785], [-118.48438, 34.07781], [-118.48492, 34.07793], [-118.48528, 34.07785], [-118.48533, 34.07853], [-118.48703, 34.08031], [-118.48658, 34.08035], [-118.48608, 34.0803], [-118.4858, 34.08015], [-118.48551, 34.08012], [-118.48549, 34.08052], [-118.48531, 34.08051], [-118.48524, 34.08052], [-118.48522, 34.08048], [-118.48494, 34.08073], [-118.4849, 34.08089], [-118.48507, 34.08107], [-118.48499, 34.08114], [-118.48513, 34.08124], [-118.48487, 34.08145], [-118.48542, 34.08176], [-118.4851, 34.08231], [-118.48522, 34.08266], [-118.48577, 34.08254], [-118.48602, 34.08284], [-118.48633, 34.0829], [-118.48701, 34.08282], [-118.48705, 34.08368], [-118.48753, 34.08379], [-118.48757, 34.0837], [-118.48772, 34.08391]]], [[[-118.48863, 34.08368], [-118.48838, 34.08375], [-118.48802, 34.08326], [-118.48819, 34.08317], [-118.48834, 34.08321], [-118.48831, 34.08326], [-118.48838, 34.08346], [-118.48863, 34.08368]]]]} | Open Access 1 | 6379 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 26.137 | 0 | Local Other or Unknown 14 | 4 |
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]);