superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Mission Beach Park" and MNG_AGENCY = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7051 | 7051 | 7050 | {"type": "MultiPolygon", "coordinates": [[[[-117.25354, 32.75924], [-117.25341, 32.75969], [-117.25331, 32.76027], [-117.25308, 32.76335], [-117.25237, 32.76339], [-117.25236, 32.76242], [-117.25231, 32.76241], [-117.25231, 32.7622], [-117.25229, 32.76201], [-117.25226, 32.76188], [-117.25218, 32.76169], [-117.252, 32.7614], [-117.25184, 32.76123], [-117.25154, 32.76094], [-117.25105, 32.76052], [-117.25084, 32.76037], [-117.25081, 32.76037], [-117.25062, 32.76025], [-117.25031, 32.76009], [-117.24996, 32.75995], [-117.24959, 32.75984], [-117.24945, 32.75973], [-117.25354, 32.75924]]], [[[-117.25096, 32.76933], [-117.25092, 32.76935], [-117.25094, 32.76987], [-117.25086, 32.76987], [-117.25086, 32.76934], [-117.25091, 32.76905], [-117.25095, 32.76905], [-117.25096, 32.76933]]], [[[-117.25102, 32.77074], [-117.2509, 32.77074], [-117.25086, 32.77018], [-117.25098, 32.77018], [-117.25102, 32.77074]]], [[[-117.25528, 32.78963], [-117.25499, 32.78972], [-117.25491, 32.78942], [-117.25486, 32.78913], [-117.25487, 32.78911], [-117.25487, 32.78905], [-117.25482, 32.78903], [-117.25452, 32.78768], [-117.25441, 32.78707], [-117.25444, 32.78705], [-117.25442, 32.78698], [-117.25439, 32.78697], [-117.25418, 32.78585], [-117.25421, 32.78583], [-117.25419, 32.78576], [-117.25416, 32.78575], [-117.25408, 32.78528], [-117.25397, 32.78463], [-117.25399, 32.78462], [-117.25398, 32.78455], [-117.25394, 32.78453], [-117.25377, 32.78358], [-117.25381, 32.78357], [-117.25379, 32.78349], [-117.25376, 32.78348], [-117.25366, 32.78285], [-117.25362, 32.78248], [-117.25365, 32.78246], [-117.25364, 32.78239], [-117.25361, 32.78238], [-117.25351, 32.78183], [-117.25348, 32.78154], [-117.25348, 32.78147], [-117.25351, 32.78145], [-117.25351, 32.78138], [-117.25347, 32.78137], [-117.25346, 32.78131], [-117.25341, 32.78056], [-117.25341, 32.78041], [-117.25344, 32.7804], [-117.25344, 32.78033], [-117.25341, 32.78031], [-117.25337, 32.77951], [-117.25334, 32.77936], [-117.25338, 32.77933], [-117.25338, 32.77927], [-117.25334, 32.77925], [-117.25333, 32.77919], [-117.25333, 32.77903], [-117.25328, 32.7784], [-117.25328, 32.77833], [-117.25331, 32.7783], [-117.2533, 32.77823], [-117.25326, 32.77822], [-117.25324, 32.77729], [-117.25327, 32.77727], [-117.25326, 32.7772], [-117.25323, 32.77719], [-117.25322, 32.77671], [-117.25322, 32.77625], [-117.25326, 32.77624], [-117.25326, 32.77617], [-117.25323, 32.77615], [-117.25317, 32.77555], [-117.25315, 32.77519], [-117.25319, 32.77517], [-117.25318, 32.7751], [-117.25315, 32.77509], [-117.25309, 32.77414], [-117.25312, 32.77413], [-117.25312, 32.77406], [-117.25309, 32.77404], [-117.25304, 32.77311], [-117.25307, 32.77309], [-117.25307, 32.77302], [-117.25303, 32.773], [-117.25298, 32.77206], [-117.25293, 32.77204], [-117.25291, 32.77199], [-117.25167, 32.77203], [-117.25155, 32.77199], [-117.25148, 32.77192], [-117.25131, 32.77192], [-117.25114, 32.77093], [-117.25103, 32.76889], [-117.25108, 32.76772], [-117.25169, 32.76764], [-117.25261, 32.76765], [-117.25255, 32.76665], [-117.25258, 32.76664], [-117.25258, 32.76656], [-117.25255, 32.76655], [-117.25252, 32.76608], [-117.25248, 32.76559], [-117.25251, 32.76557], [-117.2525, 32.76549], [-117.25248, 32.76548], [-117.25245, 32.76502], [-117.25242, 32.76453], [-117.25243, 32.76451], [-117.25244, 32.76448], [-117.2524, 32.76446], [-117.25237, 32.76352], [-117.25307, 32.76349], [-117.25284, 32.76679], [-117.25284, 32.76712], [-117.25285, 32.76714], [-117.25287, 32.76811], [-117.25288, 32.76813], [-117.25294, 32.76964], [-117.2531, 32.77209], [-117.25311, 32.77299], [-117.25312, 32.773], [-117.25315, 32.77381], [-117.25327, 32.77545], [-117.25329, 32.77656], [-117.25337, 32.77766], [-117.25337, 32.77831], [-117.25344, 32.77943], [-117.25347, 32.77968], [-117.25351, 32.78014], [-117.25355, 32.78037], [-117.25361, 32.78137], [-117.25368, 32.7819], [-117.25376, 32.78223], [-117.25403, 32.78388], [-117.25444, 32.78601], [-117.25486, 32.78794], [-117.2551, 32.78895], [-117.25528, 32.78963]]]]} | Open Access 1 | Mission Beach Park | 22292 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 49.86 | Mission Beach 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]);