units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where DES_TP = 2, MNG_AGENCY = 33, MNG_AG_TYP = 2 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 10 ✖
MNG_AGENCY 1
- Santee, City of · 10 ✖
DES_TP 1
- Local Park · 10 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80 | 80 | 79 | {"type": "Polygon", "coordinates": [[[-117.02291, 32.84594], [-117.02264, 32.84628], [-117.02204, 32.84691], [-117.02175, 32.84719], [-117.02112, 32.84769], [-117.02078, 32.84792], [-117.02051, 32.84808], [-117.0205, 32.84593], [-117.02291, 32.84594]]]} | Open Access 1 | 194 | West Hills Park | 27359 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=70 | San Diego 4 | 7.496 | West Hills Park | 0 | Local Park 2 | 4 |
359 | 359 | 358 | {"type": "Polygon", "coordinates": [[[-116.95561, 32.84108], [-116.95554, 32.84117], [-116.95549, 32.84219], [-116.95407, 32.84216], [-116.95412, 32.8405], [-116.95521, 32.84053], [-116.95561, 32.84108]]]} | Open Access 1 | 1012 | Shadow Hill Park | 25336 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=68 | San Diego 4 | 5.907 | Shadow Hill Park | 0 | Local Park 2 | 4 |
363 | 363 | 362 | {"type": "Polygon", "coordinates": [[[-116.97538, 32.86603], [-116.97536, 32.86778], [-116.97321, 32.86781], [-116.97319, 32.86606], [-116.97332, 32.86606], [-116.9737, 32.86601], [-116.97538, 32.86603]]]} | Open Access 1 | 1026 | Woodglen Vista Park | 27711 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=69 | San Diego 4 | 9.882 | Woodglen Vista Park | 0 | Local Park 2 | 4 |
1715 | 1715 | 1714 | {"type": "Polygon", "coordinates": [[[-117.01936, 32.8301], [-117.01924, 32.83103], [-117.01924, 32.83116], [-117.01713, 32.83102], [-117.01761, 32.83048], [-117.01773, 32.83003], [-117.01936, 32.8301]]]} | Open Access 1 | 12872 | Big Rock Park | 16087 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=65 | San Diego 4 | 4.829 | Big Rock Park | 0 | Local Park 2 | 4 |
2241 | 2241 | 2240 | {"type": "Polygon", "coordinates": [[[-117.00327, 32.84388], [-117.00321, 32.84396], [-117.00231, 32.84396], [-117.00229, 32.84395], [-117.00136, 32.84412], [-117.00137, 32.8442], [-117.00036, 32.84439], [-117.00032, 32.84432], [-116.99873, 32.84483], [-116.99875, 32.8449], [-116.99829, 32.845], [-116.99814, 32.84466], [-116.99705, 32.84193], [-116.9988, 32.84171], [-116.99935, 32.84157], [-116.99968, 32.84165], [-117.00072, 32.84155], [-117.0017, 32.84133], [-117.00257, 32.84084], [-117.00262, 32.84057], [-117.0026, 32.8399], [-117.00308, 32.83962], [-117.00312, 32.83966], [-117.00312, 32.84055], [-117.00316, 32.84248], [-117.00327, 32.84388]]]} | Open Access 1 | 47897 | Mast Park West | 31858 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | San Diego 4 | 43.439 | Mast Park West | 0 | Local Park 2 | 4 | |
3421 | 3421 | 3420 | {"type": "Polygon", "coordinates": [[[-116.96658, 32.84974], [-116.96647, 32.85215], [-116.96564, 32.85215], [-116.965, 32.85221], [-116.96414, 32.85224], [-116.96351, 32.8521], [-116.96347, 32.85208], [-116.96345, 32.85204], [-116.96339, 32.85204], [-116.9634, 32.85153], [-116.96338, 32.85152], [-116.9634, 32.85046], [-116.96343, 32.85045], [-116.96343, 32.84995], [-116.96658, 32.84974]]]} | No Public Access 3 | 25131 | Radio Towers Park | 24070 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | San Diego 4 | 18.699 | Radio Towers Park | 0 | Local Park 2 | 4 | |
6361 | 6361 | 6360 | {"type": "Polygon", "coordinates": [[[-116.99763, 32.84422], [-116.9965, 32.84438], [-116.99673, 32.84518], [-116.99419, 32.84574], [-116.99421, 32.84588], [-116.99365, 32.84607], [-116.99326, 32.84626], [-116.99273, 32.84663], [-116.99124, 32.84807], [-116.99122, 32.84518], [-116.99089, 32.84515], [-116.99072, 32.84511], [-116.99024, 32.84509], [-116.98961, 32.84514], [-116.98945, 32.84516], [-116.98899, 32.84527], [-116.98838, 32.84546], [-116.98618, 32.84627], [-116.98604, 32.84634], [-116.98538, 32.84655], [-116.98511, 32.84667], [-116.98488, 32.84675], [-116.98447, 32.84685], [-116.98368, 32.8469], [-116.98384, 32.84526], [-116.98405, 32.84527], [-116.98439, 32.84513], [-116.98461, 32.84498], [-116.98493, 32.84472], [-116.98545, 32.84439], [-116.98565, 32.84423], [-116.98611, 32.84405], [-116.98869, 32.84325], [-116.98918, 32.84315], [-116.98955, 32.84305], [-116.98978, 32.84301], [-116.98998, 32.84299], [-116.99091, 32.84299], [-116.99121, 32.84297], [-116.99122, 32.84252], [-116.99218, 32.8422], [-116.99294, 32.84202], [-116.99304, 32.84195], [-116.99357, 32.84185], [-116.99438, 32.84175], [-116.99466, 32.84163], [-116.9954, 32.84182], [-116.99667, 32.84183], [-116.99763, 32.84422]]]} | Open Access 1 | 1724 | Mast Park | 21946 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=66 | San Diego 4 | 102.175 | Mast Park | 0 | Local Park 2 | 4 |
13646 | 13646 | 13645 | {"type": "Polygon", "coordinates": [[[-116.97354, 32.83713], [-116.97353, 32.83828], [-116.97352, 32.83831], [-116.97349, 32.83833], [-116.96945, 32.83826], [-116.96948, 32.83738], [-116.97011, 32.83739], [-116.97013, 32.83657], [-116.97133, 32.8366], [-116.97132, 32.83709], [-116.97354, 32.83713]]]} | Open Access 1 | 45974 | Santee Mini Park | 29124 | 2384 | Port of Los Angeles 289 | Special District 4 | Port/Harbor District 15 | http://www.portoflosangeles.org/ | Special District 4 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=67 | San Diego 4 | 13.58 | Santee MP | 0 | Local Park 2 | 4 |
15146 | 15146 | 15145 | {"type": "Polygon", "coordinates": [[[-116.95407, 32.83359], [-116.95418, 32.83395], [-116.95427, 32.83414], [-116.95427, 32.83418], [-116.95425, 32.83422], [-116.95402, 32.83431], [-116.95386, 32.83434], [-116.9537, 32.83435], [-116.95347, 32.83431], [-116.95319, 32.8342], [-116.95369, 32.83363], [-116.95383, 32.83365], [-116.95407, 32.83359]]]} | Open Access 1 | 45976 | Sky Ranch Park | 29130 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=384 | San Diego 4 | 1.35 | Sky Ranch Park | 0 | Local Park 2 | 4 |
17046 | 17046 | 17045 | {"type": "Polygon", "coordinates": [[[-116.98325, 32.84955], [-116.98119, 32.84949], [-116.98023, 32.84953], [-116.97857, 32.8501], [-116.97773, 32.85014], [-116.97767, 32.85017], [-116.97709, 32.85032], [-116.97637, 32.85047], [-116.97628, 32.8506], [-116.97625, 32.85068], [-116.97623, 32.85157], [-116.97585, 32.85156], [-116.97579, 32.85151], [-116.97578, 32.8514], [-116.9757, 32.8514], [-116.97573, 32.85042], [-116.97586, 32.85043], [-116.97598, 32.85036], [-116.97605, 32.85025], [-116.9761, 32.85025], [-116.97612, 32.85003], [-116.97621, 32.85], [-116.97672, 32.84995], [-116.97693, 32.84991], [-116.9771, 32.84977], [-116.97717, 32.84964], [-116.97719, 32.84952], [-116.97714, 32.8494], [-116.97705, 32.84933], [-116.97693, 32.84934], [-116.97673, 32.84939], [-116.97602, 32.84946], [-116.97575, 32.84945], [-116.97576, 32.84927], [-116.97623, 32.84927], [-116.97646, 32.84925], [-116.97669, 32.84921], [-116.97701, 32.84909], [-116.9772, 32.84899], [-116.97738, 32.84886], [-116.97816, 32.84818], [-116.97844, 32.84802], [-116.97876, 32.84791], [-116.97914, 32.84784], [-116.98231, 32.84759], [-116.98263, 32.84759], [-116.9832, 32.84764], [-116.98324, 32.84766], [-116.98326, 32.84771], [-116.98325, 32.84955]]]} | Open Access 1 | 45977 | Town Center Community Park | 29131 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=229 | San Diego 4 | 32.677 | Town Ctr. Community Park | 0 | Local Park 2 | 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]);