units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1 and LABEL_NAME = "Marian Bear OS Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY
MNG_AG_TYP 1
DES_TP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16056 | 16056 | 16055 | {"type": "MultiPolygon", "coordinates": [[[[-117.18363, 32.84034], [-117.18361, 32.84277], [-117.18354, 32.84642], [-117.18339, 32.84644], [-117.18252, 32.8464], [-117.17975, 32.84613], [-117.17963, 32.84623], [-117.17802, 32.84571], [-117.17754, 32.84483], [-117.17635, 32.84315], [-117.1777, 32.84224], [-117.17857, 32.842], [-117.17874, 32.84284], [-117.17858, 32.84343], [-117.1782, 32.84402], [-117.17821, 32.84404], [-117.18032, 32.84354], [-117.18033, 32.84352], [-117.17999, 32.84317], [-117.18005, 32.84307], [-117.18045, 32.84312], [-117.18085, 32.84295], [-117.18091, 32.84257], [-117.1807, 32.84232], [-117.18045, 32.84226], [-117.18008, 32.84157], [-117.17939, 32.84161], [-117.17893, 32.84111], [-117.17842, 32.84034], [-117.18073, 32.84035], [-117.18363, 32.84034]]], [[[-117.19932, 32.84483], [-117.19841, 32.84529], [-117.1964, 32.84514], [-117.19437, 32.84512], [-117.1941, 32.84513], [-117.19254, 32.84532], [-117.19223, 32.84539], [-117.18633, 32.84623], [-117.18405, 32.84638], [-117.1841, 32.8432], [-117.18433, 32.844], [-117.18494, 32.84387], [-117.18489, 32.84404], [-117.18481, 32.84445], [-117.18482, 32.84446], [-117.18636, 32.84439], [-117.18614, 32.84362], [-117.18693, 32.84346], [-117.18707, 32.8437], [-117.18728, 32.84414], [-117.18924, 32.84417], [-117.18925, 32.84416], [-117.18849, 32.84311], [-117.18913, 32.84297], [-117.18945, 32.84336], [-117.19005, 32.84317], [-117.19052, 32.84426], [-117.19089, 32.8443], [-117.19118, 32.84421], [-117.19133, 32.84388], [-117.19105, 32.84379], [-117.19101, 32.84368], [-117.1909, 32.8436], [-117.19082, 32.84322], [-117.1912, 32.84312], [-117.1911, 32.84276], [-117.19087, 32.84271], [-117.19084, 32.84262], [-117.19158, 32.84245], [-117.19151, 32.84224], [-117.19154, 32.84221], [-117.19151, 32.84209], [-117.19152, 32.842], [-117.19167, 32.84244], [-117.1927, 32.84223], [-117.19307, 32.84346], [-117.19545, 32.84294], [-117.19577, 32.84335], [-117.19585, 32.84344], [-117.19586, 32.84351], [-117.19599, 32.84359], [-117.19609, 32.84353], [-117.19612, 32.84353], [-117.19696, 32.84367], [-117.19698, 32.8437], [-117.19702, 32.84372], [-117.19707, 32.84372], [-117.19711, 32.84369], [-117.19739, 32.84374], [-117.19759, 32.84369], [-117.19769, 32.84352], [-117.19748, 32.84305], [-117.19652, 32.84271], [-117.19728, 32.84254], [-117.19628, 32.84041], [-117.19606, 32.83996], [-117.19657, 32.83985], [-117.19714, 32.84143], [-117.19727, 32.84187], [-117.19737, 32.84201], [-117.19744, 32.84222], [-117.19785, 32.84289], [-117.19819, 32.8433], [-117.1984, 32.84354], [-117.19862, 32.84376], [-117.19922, 32.8443], [-117.19915, 32.84436], [-117.19932, 32.84483]]], [[[-117.18633, 32.84098], [-117.18576, 32.84149], [-117.18546, 32.84183], [-117.18524, 32.84181], [-117.18505, 32.84174], [-117.18475, 32.84175], [-117.1841, 32.84229], [-117.18413, 32.83945], [-117.18565, 32.83946], [-117.18537, 32.83964], [-117.18532, 32.83995], [-117.18543, 32.8401], [-117.18497, 32.84049], [-117.18488, 32.84077], [-117.185, 32.84102], [-117.18521, 32.84106], [-117.1854, 32.84111], [-117.18589, 32.84096], [-117.18633, 32.84098]]], [[[-117.21678, 32.84147], [-117.21364, 32.84319], [-117.21263, 32.84366], [-117.21197, 32.84384], [-117.21121, 32.84441], [-117.21076, 32.84457], [-117.2106, 32.8446], [-117.21047, 32.84471], [-117.2095, 32.8452], [-117.20869, 32.84547], [-117.20725, 32.84605], [-117.20636, 32.84638], [-117.20576, 32.84654], [-117.2049, 32.84665], [-117.20473, 32.84653], [-117.20425, 32.84668], [-117.20347, 32.84663], [-117.2027, 32.8464], [-117.20181, 32.84621], [-117.19973, 32.8444], [-117.19882, 32.84358], [-117.19848, 32.84322], [-117.19827, 32.84296], [-117.19804, 32.84265], [-117.1977, 32.84208], [-117.19758, 32.84182], [-117.19744, 32.84142], [-117.19742, 32.84134], [-117.19745, 32.84132], [-117.19688, 32.8398], [-117.19733, 32.8397], [-117.19796, 32.84045], [-117.1991, 32.84213], [-117.19999, 32.84191], [-117.20011, 32.84222], [-117.20006, 32.84229], [-117.19958, 32.84262], [-117.19979, 32.84313], [-117.2004, 32.84318], [-117.20072, 32.84362], [-117.20103, 32.84443], [-117.20196, 32.84464], [-117.20289, 32.8444], [-117.20294, 32.84451], [-117.2048, 32.84409], [-117.20625, 32.84442], [-117.20642, 32.84447], [-117.20664, 32.8445], [-117.20752, 32.84469], [-117.2078, 32.84401], [-117.20795, 32.84358], [-117.20675, 32.84301], [-117.20598, 32.84229], [-117.20558, 32.84242], [-117.20391, 32.84301], [-117.2038, 32.84307], [-117.2034, 32.84321], [-117.20312, 32.84306], [-117.20315, 32.8426], [-117.20296, 32.8424], [-117.20441, 32.84208], [-117.20421, 32.84079], [-117.20304, 32.84041], [-117.20193, 32.84042], [-117.20213, 32.83982], [-117.20219, 32.83969], [-117.20219, 32.83963], [-117.20281, 32.83941], [-117.20301, 32.83931], [-117.20348, 32.83967], [-117.20411, 32.8393], [-117.20411, 32.83866], [-117.20427, 32.83867], [-117.20475, 32.83928], [-117.20516, 32.84048], [-117.20539, 32.84059], [-117.20547, 32.84057], [-117.20553, 32.84064], [-117.20558, 32.84066], [-117.20568, 32.84067], [-117.2058, 32.84062], [-117.20636, 32.84093], [-117.20644, 32.83952], [-117.20644, 32.83866], [-117.20692, 32.83866], [-117.20691, 32.84059], [-117.20729, 32.84085], [-117.20805, 32.84085], [-117.20803, 32.84165], [-117.20823, 32.84228], [-117.20834, 32.84236], [-117.20865, 32.84245], [-117.20887, 32.84243], [-117.20899, 32.84244], [-117.20909, 32.84224], [-117.2091, 32.84174], [-117.20977, 32.84171], [-117.21013, 32.84225], [-117.21031, 32.84235], [-117.21052, 32.84225], [-117.211, 32.8418], [-117.21138, 32.84178], [-117.21137, 32.84148], [-117.21117, 32.84126], [-117.21081, 32.84108], [-117.20982, 32.84081], [-117.20988, 32.84045], [-117.20996, 32.84011], [-117.20999, 32.84015], [-117.21009, 32.84023], [-117.21025, 32.8403], [-117.21041, 32.84032], [-117.21055, 32.84032], [-117.21241, 32.84057], [-117.21319, 32.84058], [-117.21356, 32.84041], [-117.21342, 32.83993], [-117.21446, 32.83982], [-117.21468, 32.83823], [-117.21464, 32.83586], [-117.2138, 32.83511], [-117.21372, 32.83508], [-117.21606, 32.83506], [-117.21605, 32.83533], [-117.21587, 32.83646], [-117.21578, 32.83685], [-117.21538, 32.83809], [-117.21534, 32.83828], [-117.2153, 32.83864], [-117.21531, 32.83906], [-117.21533, 32.83924], [-117.21545, 32.83968], [-117.21554, 32.83989], [-117.21565, 32.84008], [-117.21576, 32.84027], [-117.21616, 32.8407], [-117.21678, 32.84121], [-117.21678, 32.84147]]], [[[-117.20114, 32.84598], [-117.19907, 32.84546], [-117.19908, 32.84538], [-117.19914, 32.84531], [-117.1995, 32.84512], [-117.19975, 32.8452], [-117.20015, 32.84513], [-117.20114, 32.84598]]], [[[-117.23276, 32.83743], [-117.2326, 32.83748], [-117.23145, 32.83793], [-117.23118, 32.838], [-117.23056, 32.83819], [-117.22955, 32.83842], [-117.22403, 32.83951], [-117.22075, 32.84008], [-117.21974, 32.84031], [-117.21817, 32.84085], [-117.21754, 32.84101], [-117.21705, 32.84101], [-117.21704, 32.84102], [-117.21647, 32.84058], [-117.2163, 32.84041], [-117.21613, 32.8402], [-117.216, 32.84003], [-117.21592, 32.83989], [-117.21583, 32.83967], [-117.21572, 32.83938], [-117.21567, 32.83914], [-117.21564, 32.83897], [-117.21563, 32.8386], [-117.21567, 32.83831], [-117.21571, 32.83816], [-117.21609, 32.83693], [-117.2162, 32.83649], [-117.21638, 32.83537], [-117.21639, 32.83508], [-117.21667, 32.83508], [-117.21625, 32.83917], [-117.21718, 32.83926], [-117.2176, 32.83865], [-117.21996, 32.83814], [-117.22057, 32.83814], [-117.22127, 32.83799], [-117.22142, 32.83755], [-117.22259, 32.83732], [-117.22237, 32.83659], [-117.22361, 32.83632], [-117.22372, 32.83672], [-117.22401, 32.83688], [-117.22438, 32.83647], [-117.22481, 32.83644], [-117.22491, 32.8365], [-117.22498, 32.83651], [-117.22518, 32.83661], [-117.22556, 32.83667], [-117.22589, 32.83693], [-117.22658, 32.8369], [-117.22717, 32.83678], [-117.22763, 32.83676], [-117.22806, 32.83663], [-117.22864, 32.83636], [-117.22887, 32.8363], [-117.22922, 32.83619], [-117.22939, 32.8363], [-117.22966, 32.83728], [-117.22995, 32.83727], [-117.23034, 32.83703], [-117.23051, 32.83686], [-117.23031, 32.83619], [-117.23011, 32.83585], [-117.22999, 32.83551], [-117.22964, 32.83492], [-117.22941, 32.83462], [-117.22913, 32.83435], [-117.22892, 32.83408], [-117.22888, 32.83392], [-117.23139, 32.83336], [-117.23166, 32.83382], [-117.23185, 32.83429], [-117.23276, 32.83743]]]]} | Open Access 1 | 47584 | Marian Bear Open Space Park | 31311 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 451.224 | Marian Bear OS Park | 0 | Local Recreation Area 3 | 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]);