units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where DES_TP = 3, LABEL_NAME = "City of San Diego OS" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4261 | 4261 | 4260 | {"type": "MultiPolygon", "coordinates": [[[[-117.03242, 32.56189], [-117.03233, 32.56408], [-117.0318, 32.56433], [-117.03151, 32.56443], [-117.03117, 32.56452], [-117.03079, 32.56457], [-117.03012, 32.56456], [-117.02974, 32.56461], [-117.02961, 32.56458], [-117.02954, 32.56454], [-117.02825, 32.56345], [-117.0281, 32.5634], [-117.02721, 32.56331], [-117.02723, 32.56173], [-117.02555, 32.56167], [-117.02535, 32.56199], [-117.02528, 32.5623], [-117.02503, 32.5626], [-117.02496, 32.56276], [-117.025, 32.5629], [-117.02509, 32.56296], [-117.02532, 32.56297], [-117.02504, 32.5632], [-117.0247, 32.56351], [-117.02421, 32.56407], [-117.02411, 32.56425], [-117.02344, 32.56567], [-117.02339, 32.56575], [-117.02328, 32.56586], [-117.02317, 32.56591], [-117.02277, 32.56602], [-117.0228, 32.55797], [-117.02719, 32.55808], [-117.02724, 32.56172], [-117.03242, 32.56189]]], [[[-117.03233, 32.56424], [-117.03228, 32.5654], [-117.03159, 32.56538], [-117.03088, 32.56542], [-117.03051, 32.56541], [-117.03025, 32.56543], [-117.03003, 32.56548], [-117.02985, 32.56554], [-117.02902, 32.56593], [-117.0289, 32.56603], [-117.02863, 32.56645], [-117.0286, 32.56658], [-117.0285, 32.5667], [-117.02815, 32.56674], [-117.02785, 32.56695], [-117.0278, 32.56725], [-117.0279, 32.56768], [-117.0277, 32.56775], [-117.02549, 32.56781], [-117.02393, 32.56803], [-117.02386, 32.56803], [-117.02424, 32.56757], [-117.02436, 32.56737], [-117.0247, 32.56708], [-117.02489, 32.56704], [-117.0254, 32.56685], [-117.02553, 32.56698], [-117.02554, 32.56697], [-117.02556, 32.56687], [-117.0259, 32.56708], [-117.02608, 32.56705], [-117.02629, 32.56695], [-117.02647, 32.56678], [-117.02659, 32.56644], [-117.02666, 32.56614], [-117.02673, 32.56603], [-117.02684, 32.5657], [-117.0269, 32.56568], [-117.027, 32.56531], [-117.02692, 32.56507], [-117.02674, 32.56481], [-117.02677, 32.56466], [-117.02654, 32.56438], [-117.02639, 32.56425], [-117.02599, 32.564], [-117.02594, 32.56374], [-117.02573, 32.5635], [-117.02549, 32.56335], [-117.02545, 32.56309], [-117.02555, 32.56303], [-117.02573, 32.56299], [-117.0259, 32.563], [-117.026, 32.56303], [-117.02666, 32.56332], [-117.02696, 32.56342], [-117.0272, 32.56346], [-117.02721, 32.56345], [-117.02807, 32.56353], [-117.02814, 32.56355], [-117.02821, 32.56359], [-117.02943, 32.56464], [-117.02953, 32.5647], [-117.02965, 32.56474], [-117.02981, 32.56475], [-117.03017, 32.5647], [-117.03078, 32.56471], [-117.03117, 32.56466], [-117.03142, 32.5646], [-117.03179, 32.56449], [-117.03205, 32.56438], [-117.03233, 32.56424]]]]} | Open Access 1 | 45194 | City of San Diego Open Space | 10307 | 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 | 127.055 | City of San Diego OS | 0 | Local Recreation Area 3 | 4 | |
7814 | 7814 | 7813 | {"type": "Polygon", "coordinates": [[[-116.9793, 33.00015], [-116.97875, 33.00754], [-116.96993, 33.00757], [-116.96172, 33.00767], [-116.9618, 33.00385], [-116.96605, 33.00387], [-116.9661, 33.0001], [-116.97037, 33.00014], [-116.9793, 33.00015]], [[-116.96341, 33.00537], [-116.96341, 33.00535], [-116.96301, 33.00517], [-116.96282, 33.00519], [-116.96283, 33.00535], [-116.9626, 33.00539], [-116.96258, 33.00528], [-116.96208, 33.00531], [-116.96211, 33.00571], [-116.96243, 33.0057], [-116.96285, 33.00559], [-116.96301, 33.00552], [-116.96317, 33.00548], [-116.96341, 33.00537]]]} | Unknown Access 4 | 45215 | City of San Diego Open Space | 17331 | 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 | 287.249 | City of San Diego OS | 0 | Local Recreation Area 3 | 4 | |
10005 | 10005 | 10004 | {"type": "Polygon", "coordinates": [[[-117.13531, 32.80963], [-117.13296, 32.80967], [-117.13295, 32.80886], [-117.13279, 32.80885], [-117.13274, 32.80882], [-117.13263, 32.8087], [-117.13257, 32.80854], [-117.13257, 32.80843], [-117.13265, 32.80791], [-117.13264, 32.80786], [-117.1326, 32.8078], [-117.13254, 32.80778], [-117.13225, 32.80775], [-117.13215, 32.80763], [-117.13295, 32.80762], [-117.13296, 32.80837], [-117.13529, 32.80833], [-117.13531, 32.80963]]]} | No Public Access 3 | 47974 | City of San Diego Open Space | 32304 | 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 | 9.034 | City of San Diego OS | 0 | Local Recreation Area 3 | 4 | |
15507 | 15507 | 15506 | {"type": "Polygon", "coordinates": [[[-117.02242, 32.57628], [-117.02242, 32.57628], [-117.02083, 32.57624], [-117.02118, 32.57611], [-117.02174, 32.57594], [-117.02223, 32.57562], [-117.02233, 32.57589], [-117.02242, 32.57628]]]} | Open Access 1 | 45207 | City of San Diego Open Space | 10307 | 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 | 1.194 | City of San Diego OS | 0 | Local Recreation Area 3 | 4 | |
15535 | 15535 | 15534 | {"type": "Polygon", "coordinates": [[[-117.24445, 32.93036], [-117.24384, 32.93078], [-117.24315, 32.93101], [-117.24282, 32.93073], [-117.24213, 32.93039], [-117.24164, 32.93003], [-117.24135, 32.92922], [-117.24129, 32.92865], [-117.24119, 32.92824], [-117.24154, 32.92724], [-117.24182, 32.92724], [-117.24181, 32.92806], [-117.24342, 32.93077], [-117.24385, 32.93052], [-117.24414, 32.93039], [-117.2444, 32.93031], [-117.24445, 32.93036]]]} | Open Access 1 | 45198 | City of San Diego Open Space | 10307 | 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 | 8.662 | City of San Diego OS | 0 | Local Recreation Area 3 | 4 | |
16188 | 16188 | 16187 | {"type": "Polygon", "coordinates": [[[-117.22383, 32.91946], [-117.22379, 32.91988], [-117.22322, 32.91985], [-117.22259, 32.91987], [-117.22198, 32.91995], [-117.22137, 32.92008], [-117.22145, 32.91609], [-117.22178, 32.91613], [-117.22189, 32.91642], [-117.22192, 32.91664], [-117.22198, 32.91685], [-117.22199, 32.91698], [-117.22198, 32.91718], [-117.22193, 32.91735], [-117.22186, 32.9175], [-117.22168, 32.91777], [-117.22165, 32.91789], [-117.22168, 32.91805], [-117.22187, 32.91856], [-117.22193, 32.91891], [-117.22189, 32.91892], [-117.22186, 32.91916], [-117.22179, 32.91933], [-117.22168, 32.91949], [-117.2216, 32.91954], [-117.22163, 32.91956], [-117.22187, 32.9195], [-117.22223, 32.91945], [-117.22255, 32.91949], [-117.22315, 32.91946], [-117.22349, 32.91948], [-117.22383, 32.91946]]]} | Open Access 1 | 45208 | City of San Diego Open Space | 10307 | 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 | 6.406 | City of San Diego OS | 0 | Local Recreation Area 3 | 4 | |
16209 | 16209 | 16208 | {"type": "MultiPolygon", "coordinates": [[[[-117.01476, 32.57155], [-117.01474, 32.57158], [-117.01457, 32.57172], [-117.01445, 32.57185], [-117.01425, 32.57214], [-117.01422, 32.5706], [-117.01442, 32.57102], [-117.01476, 32.57155]]], [[[-117.01851, 32.57046], [-117.01854, 32.57228], [-117.01616, 32.57225], [-117.01588, 32.57208], [-117.01562, 32.57188], [-117.01543, 32.57171], [-117.0152, 32.57148], [-117.015, 32.57124], [-117.01483, 32.57098], [-117.01466, 32.57065], [-117.01456, 32.57038], [-117.01851, 32.57046]]]]} | Open Access 1 | 45206 | City of San Diego Open Space | 10307 | 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 | 16.791 | City of San Diego OS | 0 | Local Recreation Area 3 | 4 | |
16224 | 16224 | 16223 | {"type": "MultiPolygon", "coordinates": [[[[-117.17185, 32.94141], [-117.17172, 32.94153], [-117.17137, 32.94203], [-117.17127, 32.94204], [-117.17095, 32.94198], [-117.17079, 32.94201], [-117.17071, 32.94206], [-117.17051, 32.94228], [-117.17016, 32.94252], [-117.17011, 32.94258], [-117.17009, 32.94268], [-117.17011, 32.94274], [-117.17015, 32.9428], [-117.17047, 32.94295], [-117.17071, 32.94309], [-117.1708, 32.94319], [-117.17098, 32.9433], [-117.1709, 32.94337], [-117.17035, 32.94357], [-117.17028, 32.94362], [-117.17022, 32.94369], [-117.17018, 32.94381], [-117.17021, 32.94394], [-117.17025, 32.94401], [-117.17043, 32.94419], [-117.17034, 32.94427], [-117.17025, 32.94429], [-117.16989, 32.94427], [-117.16955, 32.94423], [-117.16938, 32.94144], [-117.17185, 32.94141]]], [[[-117.17414, 32.94858], [-117.16987, 32.94862], [-117.16965, 32.94508], [-117.17004, 32.94514], [-117.17037, 32.94525], [-117.17082, 32.94532], [-117.17098, 32.94522], [-117.17115, 32.94522], [-117.17126, 32.94526], [-117.17129, 32.9453], [-117.17129, 32.94541], [-117.17132, 32.94557], [-117.17138, 32.94564], [-117.17147, 32.94568], [-117.17166, 32.9457], [-117.17205, 32.94569], [-117.173, 32.94591], [-117.17321, 32.9459], [-117.17339, 32.94586], [-117.17349, 32.9458], [-117.17355, 32.94573], [-117.17359, 32.94556], [-117.17359, 32.9455], [-117.17357, 32.94541], [-117.17353, 32.94535], [-117.17345, 32.94528], [-117.1729, 32.94508], [-117.1727, 32.94505], [-117.17233, 32.94504], [-117.1722, 32.94501], [-117.17187, 32.9449], [-117.17184, 32.94487], [-117.17183, 32.94483], [-117.17186, 32.94479], [-117.17199, 32.94474], [-117.17213, 32.94466], [-117.17242, 32.94466], [-117.17312, 32.94449], [-117.17328, 32.94449], [-117.17345, 32.94445], [-117.17355, 32.9444], [-117.17368, 32.94426], [-117.17371, 32.94404], [-117.17361, 32.94381], [-117.17331, 32.9436], [-117.17295, 32.9436], [-117.17275, 32.94364], [-117.17262, 32.94358], [-117.17262, 32.94354], [-117.1727, 32.94328], [-117.173, 32.94317], [-117.17314, 32.94305], [-117.17332, 32.94313], [-117.17347, 32.94324], [-117.17357, 32.94326], [-117.17366, 32.94327], [-117.17392, 32.94339], [-117.17414, 32.94858]]], [[[-117.17389, 32.94275], [-117.17373, 32.94266], [-117.17361, 32.94261], [-117.1736, 32.94251], [-117.17368, 32.94231], [-117.17367, 32.94224], [-117.17361, 32.94217], [-117.17355, 32.94213], [-117.17339, 32.94209], [-117.1731, 32.94204], [-117.17318, 32.9419], [-117.17335, 32.9417], [-117.17337, 32.94164], [-117.17337, 32.94159], [-117.17333, 32.94152], [-117.17327, 32.94148], [-117.1731, 32.94145], [-117.17296, 32.9414], [-117.17383, 32.94139], [-117.17389, 32.94275]]], [[[-117.17597, 32.94676], [-117.1757, 32.94676], [-117.17568, 32.94618], [-117.17579, 32.94646], [-117.17585, 32.94654], [-117.17597, 32.94676]]], [[[-117.17981, 32.94029], [-117.17961, 32.94043], [-117.17925, 32.94048], [-117.1785, 32.94039], [-117.17848, 32.94036], [-117.17814, 32.9402], [-117.17788, 32.94012], [-117.17773, 32.94013], [-117.17762, 32.94019], [-117.17756, 32.94027], [-117.17753, 32.94035], [-117.17755, 32.94046], [-117.17835, 32.94133], [-117.17606, 32.94139], [-117.17602, 32.93953], [-117.17912, 32.93949], [-117.1789, 32.93958], [-117.1788, 32.93968], [-117.17876, 32.93975], [-117.17875, 32.93983], [-117.17878, 32.93991], [-117.17882, 32.93998], [-117.17899, 32.94015], [-117.17917, 32.94024], [-117.17938, 32.94027], [-117.17977, 32.94021], [-117.17981, 32.94029]]], [[[-117.23021, 32.98182], [-117.22152, 32.98177], [-117.22151, 32.98183], [-117.22094, 32.98183], [-117.22094, 32.98115], [-117.22027, 32.9809], [-117.21929, 32.98236], [-117.21746, 32.98188], [-117.21706, 32.98198], [-117.21692, 32.98225], [-117.2171, 32.98287], [-117.21745, 32.98314], [-117.21842, 32.98308], [-117.21826, 32.9835], [-117.21849, 32.98395], [-117.21827, 32.98405], [-117.21803, 32.98418], [-117.21777, 32.98436], [-117.21754, 32.98457], [-117.21737, 32.98477], [-117.2172, 32.98501], [-117.21707, 32.98528], [-117.21698, 32.98553], [-117.21193, 32.98539], [-117.21545, 32.98214], [-117.21597, 32.98171], [-117.21653, 32.98131], [-117.21697, 32.98104], [-117.21742, 32.98078], [-117.21789, 32.98055], [-117.21837, 32.98033], [-117.21904, 32.98008], [-117.21955, 32.97992], [-117.22007, 32.97977], [-117.2206, 32.97966], [-117.22479, 32.97889], [-117.22568, 32.97876], [-117.22619, 32.97872], [-117.2267, 32.9787], [-117.23019, 32.9787], [-117.23023, 32.98071], [-117.23021, 32.98182]]]]} | Open Access 1 | 45192 | City of San Diego Open Space | 10307 | 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 | 180.85 | City of San Diego OS | 0 | Local Recreation Area 3 | 4 | |
16225 | 16225 | 16224 | {"type": "Polygon", "coordinates": [[[-117.04225, 32.6863], [-117.04157, 32.68649], [-117.04108, 32.68527], [-117.04154, 32.68516], [-117.04187, 32.68509], [-117.04209, 32.68579], [-117.04221, 32.68619], [-117.04225, 32.6863]]]} | Open Access 1 | 45197 | City of San Diego Open Space | 10307 | 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 | 2.514 | City of San Diego OS | 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]);