units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where DES_TP = 14 and MNG_AGENCY = 129 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 35
MNG_AGENCY 1
- Poway, City of · 35 ✖
DES_TP 1
- Local Other or Unknown · 35 ✖
ACCESS_TYP 1
- Open Access 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13572 | 13572 | 13571 | {"type": "Polygon", "coordinates": [[[-117.02405, 33.00214], [-117.02394, 33.00214], [-117.02394, 33.00177], [-117.02401, 33.00177], [-117.02405, 33.00214]]]} | Open Access 1 | 35891 | Poway holding 22 | 23946 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.091 | Poway holding 22 | 0 | Local Other or Unknown 14 | 4 | |
13527 | 13527 | 13526 | {"type": "Polygon", "coordinates": [[[-117.02371, 33.01452], [-117.0236, 33.01454], [-117.02354, 33.01365], [-117.02349, 33.01341], [-117.02363, 33.01341], [-117.02368, 33.01347], [-117.02367, 33.01393], [-117.02371, 33.01452]]]} | Open Access 1 | 35824 | Poway holding 31 | 23956 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.361 | Poway holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13992 | 13992 | 13991 | {"type": "Polygon", "coordinates": [[[-117.02354, 33.00205], [-117.02349, 33.0021], [-117.02338, 33.0021], [-117.02348, 33.00185], [-117.02347, 33.00124], [-117.02325, 33.00034], [-117.02352, 33.00034], [-117.02356, 33.00132], [-117.02356, 33.00176], [-117.02354, 33.00205]]]} | Open Access 1 | 36674 | Poway holding 33 | 23958 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.628 | Poway holding 33 | 0 | Local Other or Unknown 14 | 4 | |
13571 | 13571 | 13570 | {"type": "Polygon", "coordinates": [[[-117.03068, 33.02743], [-117.03049, 33.02762], [-117.03026, 33.02759], [-117.02995, 33.02739], [-117.02999, 33.0271], [-117.0306, 33.02717], [-117.03068, 33.02743]]]} | Open Access 1 | 35890 | Poway holding 16 | 23939 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.701 | Poway holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13409 | 13409 | 13408 | {"type": "Polygon", "coordinates": [[[-117.02379, 33.00511], [-117.02377, 33.00515], [-117.02368, 33.00518], [-117.02366, 33.00476], [-117.02327, 33.00289], [-117.02341, 33.00257], [-117.0234, 33.00228], [-117.02348, 33.00229], [-117.02352, 33.00233], [-117.02348, 33.00314], [-117.0235, 33.00363], [-117.02379, 33.00511]]]} | Open Access 1 | 35556 | Poway holding 1 | 23932 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.739 | Poway holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13433 | 13433 | 13432 | {"type": "Polygon", "coordinates": [[[-117.02384, 33.00745], [-117.02372, 33.00902], [-117.0237, 33.00904], [-117.02343, 33.00903], [-117.0236, 33.00877], [-117.02364, 33.0079], [-117.02322, 33.00746], [-117.02384, 33.00745]]]} | Open Access 1 | 35558 | Poway holding 7 | 23966 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.96 | Poway holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13526 | 13526 | 13525 | {"type": "Polygon", "coordinates": [[[-117.03112, 33.0179], [-117.03112, 33.01828], [-117.03018, 33.0182], [-117.02981, 33.01779], [-117.03112, 33.0179]]]} | Open Access 1 | 35823 | Poway holding 32 | 23957 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.1 | Poway holding 32 | 0 | Local Other or Unknown 14 | 4 | |
13573 | 13573 | 13572 | {"type": "Polygon", "coordinates": [[[-117.02693, 33.00207], [-117.02671, 33.00227], [-117.02652, 33.0025], [-117.02693, 33.00285], [-117.02677, 33.00296], [-117.0267, 33.00296], [-117.02655, 33.00283], [-117.02615, 33.00258], [-117.0265, 33.00173], [-117.02682, 33.00172], [-117.02693, 33.00207]]]} | Open Access 1 | 35892 | Poway holding 21 | 23945 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.303 | Poway holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13401 | 13401 | 13400 | {"type": "Polygon", "coordinates": [[[-117.06276, 32.93262], [-117.06259, 32.93285], [-117.06243, 32.93294], [-117.06232, 32.93308], [-117.06211, 32.93322], [-117.06207, 32.93368], [-117.06184, 32.93365], [-117.06165, 32.93359], [-117.06148, 32.93352], [-117.06123, 32.93336], [-117.06172, 32.93277], [-117.06228, 32.93288], [-117.06276, 32.93262]]]} | Open Access 1 | 35513 | Poway holding 27 | 23951 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.662 | Poway holding 27 | 0 | Local Other or Unknown 14 | 4 | |
13541 | 13541 | 13540 | {"type": "Polygon", "coordinates": [[[-117.02371, 33.00922], [-117.02368, 33.00986], [-117.02367, 33.01319], [-117.02363, 33.01325], [-117.02347, 33.01326], [-117.02353, 33.013], [-117.02353, 33.01255], [-117.02357, 33.01119], [-117.02337, 33.01058], [-117.02331, 33.01021], [-117.02355, 33.00952], [-117.02355, 33.00938], [-117.02348, 33.00917], [-117.02366, 33.00918], [-117.02369, 33.00919], [-117.02371, 33.00922]]]} | Open Access 1 | 35853 | Poway holding 12 | 23935 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.944 | Poway holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13523 | 13523 | 13522 | {"type": "Polygon", "coordinates": [[[-117.06423, 32.94261], [-117.06344, 32.94237], [-117.0629, 32.94227], [-117.06287, 32.94234], [-117.06251, 32.94227], [-117.06244, 32.94228], [-117.06202, 32.94219], [-117.06208, 32.94207], [-117.06213, 32.94202], [-117.06229, 32.94198], [-117.06305, 32.94195], [-117.06315, 32.94193], [-117.06323, 32.94189], [-117.0633, 32.94183], [-117.06335, 32.94176], [-117.06336, 32.94166], [-117.064, 32.94171], [-117.06418, 32.94234], [-117.06423, 32.94261]]]} | Open Access 1 | 35820 | Poway holding 35 | 23960 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 2.641 | Poway holding 35 | 0 | Local Other or Unknown 14 | 4 | |
13542 | 13542 | 13541 | {"type": "Polygon", "coordinates": [[[-117.02825, 33.0206], [-117.02825, 33.02204], [-117.02771, 33.02203], [-117.0277, 33.02191], [-117.02771, 33.02146], [-117.02758, 33.02145], [-117.02758, 33.02065], [-117.02643, 33.02023], [-117.02648, 33.01995], [-117.0274, 33.01995], [-117.02825, 33.0206]]]} | Open Access 1 | 35854 | Poway holding 14 | 23937 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 4.086 | Poway holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13543 | 13543 | 13542 | {"type": "Polygon", "coordinates": [[[-117.05278, 33.02232], [-117.05243, 33.02356], [-117.05042, 33.02282], [-117.05057, 33.02268], [-117.05073, 33.02259], [-117.05091, 33.02252], [-117.05125, 33.02246], [-117.05136, 33.02241], [-117.05151, 33.02232], [-117.05278, 33.02232]]]} | Open Access 1 | 35855 | Poway holding 13 | 23936 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 4.433 | Poway holding 13 | 0 | Local Other or Unknown 14 | 4 | |
3581 | 3581 | 3580 | {"type": "Polygon", "coordinates": [[[-117.06669, 32.93389], [-117.06669, 32.93424], [-117.06636, 32.93423], [-117.06575, 32.93426], [-117.06303, 32.93451], [-117.06295, 32.93426], [-117.06337, 32.93406], [-117.06374, 32.93381], [-117.06492, 32.93381], [-117.06669, 32.93389]]]} | Open Access 1 | 36687 | Poway holding 30 | 23955 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 4.51 | Poway holding 30 | 0 | Local Other or Unknown 14 | 4 | |
13540 | 13540 | 13539 | {"type": "Polygon", "coordinates": [[[-117.02815, 33.00388], [-117.02776, 33.00411], [-117.02767, 33.0045], [-117.02735, 33.00465], [-117.02745, 33.00503], [-117.02729, 33.00571], [-117.02741, 33.00617], [-117.02718, 33.00647], [-117.02748, 33.00684], [-117.02709, 33.00695], [-117.02685, 33.00632], [-117.02636, 33.00622], [-117.02635, 33.00607], [-117.02637, 33.00592], [-117.02701, 33.00604], [-117.02713, 33.00529], [-117.02715, 33.00465], [-117.02718, 33.0044], [-117.02746, 33.00417], [-117.02761, 33.00355], [-117.02726, 33.00317], [-117.02684, 33.00317], [-117.02684, 33.00313], [-117.02686, 33.00309], [-117.02727, 33.00279], [-117.02813, 33.00347], [-117.02815, 33.00388]]]} | Open Access 1 | 35849 | Poway holding 10 | 23933 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 4.566 | Poway holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13570 | 13570 | 13569 | {"type": "Polygon", "coordinates": [[[-117.02761, 33.01797], [-117.0268, 33.01789], [-117.02633, 33.01779], [-117.02581, 33.01761], [-117.02556, 33.0175], [-117.02533, 33.01736], [-117.02512, 33.01722], [-117.02493, 33.01706], [-117.02462, 33.01673], [-117.02435, 33.01626], [-117.0242, 33.01588], [-117.02413, 33.01561], [-117.02411, 33.01538], [-117.02404, 33.01406], [-117.02405, 33.00967], [-117.02421, 33.00752], [-117.02423, 33.00748], [-117.02427, 33.00746], [-117.02452, 33.00747], [-117.02444, 33.00763], [-117.02428, 33.00781], [-117.02427, 33.00824], [-117.02433, 33.00874], [-117.02453, 33.00876], [-117.02567, 33.00915], [-117.02558, 33.00927], [-117.02493, 33.00904], [-117.02432, 33.00886], [-117.02415, 33.00934], [-117.02414, 33.01027], [-117.02433, 33.01055], [-117.02416, 33.01078], [-117.02428, 33.01198], [-117.02412, 33.01289], [-117.02413, 33.0135], [-117.02423, 33.01492], [-117.02433, 33.01536], [-117.02454, 33.0158], [-117.02464, 33.01648], [-117.02518, 33.01699], [-117.02543, 33.01719], [-117.02575, 33.0174], [-117.0261, 33.01757], [-117.02641, 33.01769], [-117.02668, 33.01774], [-117.02694, 33.01776], [-117.02718, 33.01774], [-117.02748, 33.01768], [-117.02761, 33.01797]]]} | Open Access 1 | 35889 | Poway holding 19 | 23942 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 5.896 | Poway holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13432 | 13432 | 13431 | {"type": "Polygon", "coordinates": [[[-117.02617, 33.00623], [-117.02578, 33.00626], [-117.0255, 33.0061], [-117.02516, 33.00568], [-117.02487, 33.00565], [-117.02439, 33.00576], [-117.0243, 33.00716], [-117.02459, 33.0073], [-117.02428, 33.0073], [-117.02425, 33.00729], [-117.02423, 33.00725], [-117.02422, 33.00722], [-117.02427, 33.00658], [-117.02428, 33.00627], [-117.02427, 33.00577], [-117.02425, 33.00555], [-117.02388, 33.00376], [-117.02386, 33.00356], [-117.02384, 33.0031], [-117.02388, 33.00235], [-117.0239, 33.00232], [-117.02394, 33.0023], [-117.02404, 33.00229], [-117.02402, 33.00268], [-117.0247, 33.00289], [-117.02451, 33.00337], [-117.02431, 33.00428], [-117.02428, 33.00459], [-117.02444, 33.00473], [-117.02482, 33.00514], [-117.02562, 33.00557], [-117.02562, 33.00588], [-117.02572, 33.00598], [-117.02616, 33.00603], [-117.02617, 33.00623]]]} | Open Access 1 | 35555 | Poway holding 4 | 23964 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 5.991 | Poway holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13522 | 13522 | 13521 | {"type": "Polygon", "coordinates": [[[-117.0667, 32.93509], [-117.06608, 32.93509], [-117.06608, 32.93563], [-117.06586, 32.93563], [-117.06584, 32.93509], [-117.06421, 32.9351], [-117.06356, 32.93482], [-117.06295, 32.9351], [-117.06222, 32.93511], [-117.06222, 32.93513], [-117.06232, 32.93522], [-117.06227, 32.93524], [-117.06225, 32.93528], [-117.06224, 32.93532], [-117.06225, 32.93536], [-117.06196, 32.93565], [-117.06156, 32.9357], [-117.06157, 32.93563], [-117.06154, 32.93558], [-117.06149, 32.93553], [-117.06141, 32.93552], [-117.06141, 32.93511], [-117.06204, 32.93511], [-117.06205, 32.93509], [-117.06188, 32.93492], [-117.06198, 32.93491], [-117.06198, 32.9349], [-117.06196, 32.93488], [-117.06267, 32.93479], [-117.06298, 32.93478], [-117.06579, 32.93453], [-117.06636, 32.9345], [-117.06669, 32.93451], [-117.0667, 32.93509]]]} | Open Access 1 | 35819 | Poway holding 34 | 23959 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 6.144 | Poway holding 34 | 0 | Local Other or Unknown 14 | 4 | |
13524 | 13524 | 13523 | {"type": "Polygon", "coordinates": [[[-117.02155, 32.95986], [-117.02155, 32.95994], [-117.02103, 32.95994], [-117.02095, 32.96008], [-117.02096, 32.96039], [-117.02106, 32.96047], [-117.02091, 32.96064], [-117.02085, 32.96074], [-117.0208, 32.96091], [-117.0208, 32.96142], [-117.02082, 32.96161], [-117.0209, 32.96194], [-117.02088, 32.96203], [-117.02077, 32.96215], [-117.02066, 32.96219], [-117.02019, 32.96218], [-117.02019, 32.96179], [-117.02008, 32.96109], [-117.02, 32.96079], [-117.01987, 32.96057], [-117.01968, 32.96061], [-117.01969, 32.96053], [-117.01966, 32.96046], [-117.01972, 32.96042], [-117.01971, 32.95998], [-117.01905, 32.95999], [-117.01906, 32.96152], [-117.0189, 32.96152], [-117.01889, 32.95985], [-117.02155, 32.95986]]]} | Open Access 1 | 35821 | Poway holding 8 | 23967 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 6.389 | Poway holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13558 | 13558 | 13557 | {"type": "Polygon", "coordinates": [[[-117.02155, 32.96348], [-117.01891, 32.96349], [-117.01891, 32.96168], [-117.01906, 32.96168], [-117.01907, 32.9623], [-117.0192, 32.96265], [-117.0194, 32.96284], [-117.01979, 32.96292], [-117.01991, 32.9627], [-117.02, 32.96238], [-117.02, 32.96233], [-117.02056, 32.96236], [-117.02085, 32.96229], [-117.02135, 32.96256], [-117.02155, 32.96272], [-117.02155, 32.96348]]]} | Open Access 1 | 35873 | Poway holding 26 | 23950 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 6.785 | Poway holding 26 | 0 | Local Other or Unknown 14 | 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]);