superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Crestwood Hills Park" and MNG_AGENCY = 24
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3329 | 3329 | 3328 | {"type": "MultiPolygon", "coordinates": [[[[-118.48969, 34.07906], [-118.48952, 34.07908], [-118.48847, 34.07851], [-118.48835, 34.07847], [-118.48799, 34.07877], [-118.48756, 34.07945], [-118.4868, 34.07865], [-118.48649, 34.07876], [-118.48631, 34.0785], [-118.48616, 34.07836], [-118.48615, 34.07832], [-118.48626, 34.07815], [-118.48645, 34.0782], [-118.48663, 34.07786], [-118.48655, 34.07759], [-118.48664, 34.07721], [-118.4868, 34.07707], [-118.48692, 34.07767], [-118.48757, 34.07772], [-118.48873, 34.07716], [-118.4887, 34.07703], [-118.48837, 34.07678], [-118.48837, 34.07676], [-118.48842, 34.07674], [-118.48844, 34.07666], [-118.48878, 34.07638], [-118.48894, 34.07663], [-118.48902, 34.07673], [-118.48917, 34.07685], [-118.48929, 34.07692], [-118.48954, 34.07732], [-118.48958, 34.07741], [-118.48957, 34.07752], [-118.48933, 34.07804], [-118.48931, 34.07823], [-118.48934, 34.07838], [-118.48941, 34.07851], [-118.48952, 34.07863], [-118.48963, 34.07871], [-118.48969, 34.07906]]], [[[-118.48872, 34.07628], [-118.48849, 34.07646], [-118.48828, 34.07615], [-118.4879, 34.07635], [-118.4879, 34.07608], [-118.4873, 34.07613], [-118.4873, 34.07595], [-118.48745, 34.07523], [-118.48783, 34.07528], [-118.48792, 34.07531], [-118.48809, 34.07538], [-118.48821, 34.07548], [-118.48829, 34.07557], [-118.48847, 34.0759], [-118.48872, 34.07628]]], [[[-118.48986, 34.07829], [-118.48957, 34.07835], [-118.4896, 34.07854], [-118.48959, 34.07854], [-118.4895, 34.07844], [-118.48945, 34.07834], [-118.48943, 34.07824], [-118.48944, 34.07809], [-118.48947, 34.078], [-118.48948, 34.07799], [-118.48986, 34.07829]]], [[[-118.49027, 34.07742], [-118.49021, 34.07769], [-118.48961, 34.07769], [-118.48969, 34.07752], [-118.48969, 34.07742], [-118.48966, 34.0773], [-118.48954, 34.07712], [-118.48954, 34.07708], [-118.48958, 34.07704], [-118.48962, 34.07704], [-118.49012, 34.07709], [-118.49017, 34.07711], [-118.49021, 34.07714], [-118.49024, 34.07718], [-118.49027, 34.07731], [-118.49027, 34.07742]]], [[[-118.49448, 34.08015], [-118.49419, 34.08019], [-118.49416, 34.08014], [-118.49423, 34.08013], [-118.49442, 34.07991], [-118.49448, 34.08015]]], [[[-118.49497, 34.08151], [-118.49483, 34.08157], [-118.49472, 34.08117], [-118.49472, 34.08117], [-118.49497, 34.08151]]]]} | Open Access 1 | Crestwood Hills Park | 17816 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 16.002 | Crestwood Hills Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);