units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 49 and LABEL_NAME = "Whittier Narrows GC"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4884 | 4884 | 4883 | {"type": "MultiPolygon", "coordinates": [[[[-118.08173, 34.04994], [-118.0805, 34.04993], [-118.07751, 34.04834], [-118.07751, 34.04837], [-118.08049, 34.04996], [-118.08013, 34.04996], [-118.08012, 34.04997], [-118.08074, 34.05031], [-118.08073, 34.05157], [-118.07969, 34.05156], [-118.07753, 34.05168], [-118.07752, 34.05165], [-118.07733, 34.05166], [-118.07732, 34.05169], [-118.07317, 34.05171], [-118.07316, 34.05168], [-118.07307, 34.05168], [-118.07312, 34.04139], [-118.07467, 34.04125], [-118.07526, 34.04117], [-118.07525, 34.04275], [-118.07528, 34.04276], [-118.07529, 34.04116], [-118.07647, 34.04099], [-118.07643, 34.0414], [-118.07572, 34.04156], [-118.07534, 34.04238], [-118.07559, 34.04268], [-118.0763, 34.04268], [-118.07649, 34.04247], [-118.07747, 34.04247], [-118.07748, 34.04209], [-118.07802, 34.04182], [-118.07839, 34.04182], [-118.0791, 34.04225], [-118.07943, 34.04272], [-118.07964, 34.04272], [-118.07965, 34.04362], [-118.08009, 34.04362], [-118.0801, 34.04407], [-118.08087, 34.04407], [-118.08088, 34.04451], [-118.08114, 34.04452], [-118.08114, 34.04512], [-118.0817, 34.04512], [-118.08173, 34.04994]], [[-118.07717, 34.04812], [-118.07728, 34.04818], [-118.0773, 34.04818], [-118.07729, 34.04815], [-118.07602, 34.04748], [-118.07556, 34.04718], [-118.07541, 34.04706], [-118.07513, 34.04677], [-118.07499, 34.04658], [-118.07485, 34.04634], [-118.07471, 34.04603], [-118.07464, 34.04577], [-118.07528, 34.04458], [-118.07528, 34.04449], [-118.07525, 34.04449], [-118.07524, 34.04457], [-118.07434, 34.04628], [-118.07421, 34.04779], [-118.07318, 34.04991], [-118.07318, 34.04997], [-118.0732, 34.04997], [-118.07425, 34.0478], [-118.07437, 34.04628], [-118.07462, 34.04582], [-118.07468, 34.04603], [-118.07475, 34.04621], [-118.0749, 34.0465], [-118.07504, 34.0467], [-118.07538, 34.04707], [-118.07565, 34.04729], [-118.07595, 34.04747], [-118.07717, 34.04812]]], [[[-118.08027, 34.05174], [-118.08023, 34.05182], [-118.07834, 34.05181], [-118.07833, 34.05424], [-118.07813, 34.05438], [-118.07758, 34.05533], [-118.07756, 34.05534], [-118.07753, 34.05542], [-118.07671, 34.05543], [-118.07671, 34.05634], [-118.07648, 34.05719], [-118.0757, 34.05687], [-118.07535, 34.05699], [-118.07486, 34.05751], [-118.07467, 34.05792], [-118.07424, 34.05812], [-118.07362, 34.05794], [-118.07302, 34.05794], [-118.07301, 34.05872], [-118.0719, 34.05755], [-118.07222, 34.05543], [-118.073, 34.05542], [-118.07299, 34.0519], [-118.07318, 34.0519], [-118.07318, 34.05187], [-118.07743, 34.05185], [-118.07965, 34.05174], [-118.08027, 34.05174]]]]} | Restricted Access 2 | 6566 | Whittier Narrows Golf Course | 33010 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 268.099 | Whittier Narrows GC | 0 | Recreation Management Area 49 | 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]);