units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 1359, MNG_AGENCY = 294 and YR_EST = 0
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15387 | 15387 | 15386 | {"type": "MultiPolygon", "coordinates": [[[[-118.20232, 33.76745], [-118.20223, 33.76752], [-118.20217, 33.76759], [-118.20213, 33.76768], [-118.20212, 33.7678], [-118.20212, 33.76788], [-118.20216, 33.76799], [-118.20223, 33.7681], [-118.2023, 33.76819], [-118.20215, 33.7681], [-118.20201, 33.76792], [-118.20196, 33.76778], [-118.20196, 33.76749], [-118.20199, 33.76745], [-118.20232, 33.76745]]], [[[-118.20372, 33.76743], [-118.20369, 33.76768], [-118.20363, 33.76785], [-118.20357, 33.76796], [-118.20341, 33.76813], [-118.2033, 33.7682], [-118.20316, 33.76827], [-118.20298, 33.76831], [-118.20287, 33.76832], [-118.20272, 33.76831], [-118.20261, 33.76829], [-118.20251, 33.76825], [-118.20238, 33.76817], [-118.2023, 33.76809], [-118.20223, 33.76797], [-118.20219, 33.76783], [-118.2022, 33.7677], [-118.20227, 33.76758], [-118.20241, 33.76748], [-118.20257, 33.76745], [-118.20258, 33.76746], [-118.20293, 33.76745], [-118.20372, 33.76743]]], [[[-118.20277, 33.76928], [-118.20246, 33.7692], [-118.20256, 33.76906], [-118.20259, 33.76898], [-118.2026, 33.7689], [-118.20271, 33.76908], [-118.20277, 33.76928]]], [[[-118.20408, 33.76924], [-118.20405, 33.76929], [-118.20394, 33.7693], [-118.20379, 33.76928], [-118.20364, 33.76921], [-118.20355, 33.76914], [-118.20347, 33.76905], [-118.20341, 33.76887], [-118.20342, 33.76875], [-118.20346, 33.76863], [-118.20382, 33.76795], [-118.20391, 33.76765], [-118.20394, 33.76742], [-118.20402, 33.76742], [-118.20408, 33.76924]]], [[[-118.20355, 33.7681], [-118.2035, 33.76819], [-118.20307, 33.7688], [-118.20299, 33.76894], [-118.2029, 33.76919], [-118.20289, 33.76932], [-118.20289, 33.76963], [-118.20287, 33.7694], [-118.20285, 33.76928], [-118.20272, 33.76894], [-118.2026, 33.76872], [-118.20242, 33.76849], [-118.20216, 33.76823], [-118.20211, 33.76816], [-118.20231, 33.76828], [-118.20251, 33.76835], [-118.20267, 33.76838], [-118.20289, 33.76839], [-118.20309, 33.76835], [-118.20329, 33.76828], [-118.20342, 33.76821], [-118.20355, 33.7681]]], [[[-118.20406, 33.76999], [-118.20399, 33.7698], [-118.20394, 33.76973], [-118.20385, 33.76962], [-118.20371, 33.76952], [-118.20349, 33.76942], [-118.20305, 33.76934], [-118.20313, 33.76903], [-118.20328, 33.76879], [-118.2033, 33.7688], [-118.2033, 33.76894], [-118.20335, 33.76908], [-118.2034, 33.76916], [-118.2035, 33.76926], [-118.20363, 33.76934], [-118.20375, 33.76938], [-118.20388, 33.7694], [-118.20406, 33.76941], [-118.20408, 33.76943], [-118.20408, 33.76967], [-118.20406, 33.76999]]], [[[-118.20398, 33.77217], [-118.20393, 33.77217], [-118.20381, 33.77206], [-118.20348, 33.77228], [-118.20319, 33.77243], [-118.20319, 33.77247], [-118.2031, 33.77247], [-118.20306, 33.77249], [-118.20305, 33.77135], [-118.20306, 33.77073], [-118.20305, 33.76945], [-118.20334, 33.76948], [-118.2036, 33.76957], [-118.2038, 33.76972], [-118.20389, 33.76984], [-118.20394, 33.76994], [-118.20397, 33.77013], [-118.20394, 33.77077], [-118.20398, 33.77125], [-118.20398, 33.77217]]], [[[-118.20396, 33.77281], [-118.20389, 33.77304], [-118.20338, 33.77408], [-118.2033, 33.77437], [-118.20328, 33.77438], [-118.20327, 33.77471], [-118.20325, 33.77471], [-118.2031, 33.77343], [-118.20307, 33.77281], [-118.20396, 33.77281]]]]} | Open Access 1 | 46606 | Cesar E. Chavez Park Terminus | 29914 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 15.111 | Cesar E. Chavez Park Terminus | 0 | None 1359 |
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]);