units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 24 and SUID_NMA = 15950
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6544 | 6544 | 6543 | {"type": "MultiPolygon", "coordinates": [[[[-118.50638, 34.30602], [-118.50627, 34.3066], [-118.50623, 34.30664], [-118.50498, 34.30648], [-118.50476, 34.30651], [-118.50455, 34.30658], [-118.50437, 34.30635], [-118.5042, 34.30627], [-118.50383, 34.30681], [-118.50358, 34.30692], [-118.50263, 34.30707], [-118.5025, 34.30682], [-118.50233, 34.30655], [-118.5022, 34.30638], [-118.50184, 34.30599], [-118.5023, 34.30606], [-118.50303, 34.30611], [-118.5032, 34.3061], [-118.50334, 34.30608], [-118.50432, 34.30581], [-118.50432, 34.30574], [-118.50465, 34.30583], [-118.50488, 34.30564], [-118.50502, 34.30574], [-118.50519, 34.30581], [-118.50634, 34.30597], [-118.50637, 34.30598], [-118.50638, 34.30602]]], [[[-118.51064, 34.30748], [-118.51063, 34.30751], [-118.51041, 34.30756], [-118.51051, 34.30784], [-118.51046, 34.308], [-118.51048, 34.30814], [-118.51047, 34.30829], [-118.51044, 34.30844], [-118.51039, 34.30854], [-118.51023, 34.30876], [-118.50968, 34.30927], [-118.50962, 34.30927], [-118.50939, 34.30912], [-118.50914, 34.30904], [-118.50901, 34.30901], [-118.50857, 34.30897], [-118.50839, 34.30892], [-118.50822, 34.30885], [-118.50811, 34.30876], [-118.508, 34.30865], [-118.50791, 34.30852], [-118.50785, 34.30832], [-118.50782, 34.30781], [-118.50779, 34.30762], [-118.50769, 34.30737], [-118.50756, 34.30717], [-118.50736, 34.30699], [-118.5071, 34.30683], [-118.50685, 34.30674], [-118.50651, 34.30668], [-118.50648, 34.30666], [-118.50647, 34.30663], [-118.50658, 34.30604], [-118.5066, 34.30601], [-118.50664, 34.306], [-118.50753, 34.30612], [-118.50767, 34.30616], [-118.50778, 34.30621], [-118.50787, 34.30629], [-118.50794, 34.30637], [-118.50833, 34.30711], [-118.50846, 34.30724], [-118.50868, 34.30735], [-118.50892, 34.3074], [-118.50981, 34.3074], [-118.51, 34.30738], [-118.51017, 34.30734], [-118.51023, 34.30737], [-118.51032, 34.30735], [-118.51032, 34.3073], [-118.51061, 34.30744], [-118.51064, 34.30748]]]]} | Open Access 1 | 3219 | Bee Canyon Park | 15950 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 22.278 | Bee Canyon Park | 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]);