units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 138, MNG_AG_TYP = 3 and SUID_NMA = 16844
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16335 | 16335 | 16334 | {"type": "Polygon", "coordinates": [[[-117.84081, 33.91747], [-117.84062, 33.91771], [-117.84005, 33.91815], [-117.84016, 33.9185], [-117.84014, 33.91877], [-117.83994, 33.91936], [-117.83958, 33.91975], [-117.83945, 33.92005], [-117.83939, 33.92038], [-117.83938, 33.92078], [-117.83918, 33.92087], [-117.839, 33.92111], [-117.8389, 33.92137], [-117.83888, 33.9215], [-117.83893, 33.92208], [-117.83903, 33.92225], [-117.83881, 33.92223], [-117.83872, 33.92209], [-117.83801, 33.92164], [-117.83711, 33.92165], [-117.83543, 33.9219], [-117.83374, 33.92221], [-117.83331, 33.92223], [-117.83294, 33.92223], [-117.83257, 33.92218], [-117.8321, 33.92207], [-117.82931, 33.9212], [-117.82933, 33.91975], [-117.83179, 33.91978], [-117.83245, 33.91978], [-117.83255, 33.91974], [-117.83271, 33.91964], [-117.83293, 33.9196], [-117.83383, 33.91935], [-117.83395, 33.91926], [-117.83431, 33.91914], [-117.83501, 33.91861], [-117.83512, 33.91829], [-117.83517, 33.91802], [-117.83534, 33.91767], [-117.83557, 33.91723], [-117.83587, 33.91692], [-117.83632, 33.91667], [-117.83665, 33.91659], [-117.83725, 33.91655], [-117.8379, 33.91659], [-117.83793, 33.91649], [-117.83791, 33.91625], [-117.83794, 33.916], [-117.83791, 33.91583], [-117.83802, 33.91567], [-117.83789, 33.91556], [-117.8375, 33.91587], [-117.83722, 33.9158], [-117.83683, 33.91583], [-117.83697, 33.91571], [-117.83719, 33.91545], [-117.83709, 33.91536], [-117.83692, 33.91546], [-117.83668, 33.91546], [-117.8359, 33.91553], [-117.8354, 33.91519], [-117.835, 33.91504], [-117.83482, 33.91515], [-117.83466, 33.9154], [-117.83443, 33.91491], [-117.83425, 33.91476], [-117.83364, 33.91477], [-117.83345, 33.91455], [-117.83388, 33.91428], [-117.83389, 33.91413], [-117.83372, 33.914], [-117.83322, 33.9139], [-117.83316, 33.91373], [-117.83358, 33.91346], [-117.83387, 33.9134], [-117.83408, 33.91345], [-117.83412, 33.91358], [-117.83451, 33.91377], [-117.83486, 33.9138], [-117.83487, 33.91418], [-117.83498, 33.91428], [-117.83512, 33.91427], [-117.83515, 33.91425], [-117.83546, 33.91352], [-117.8389, 33.91521], [-117.84081, 33.91747]]]} | Open Access 1 | 14098 | Carbon Canyon Regional Park | 16844 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 116.108 | Carbon Canyon RP | 0 | Local Park 2 | 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]);