units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

10 rows where DES_TP = 2, MNG_AGENCY = 33 and MNG_AG_LEV = 2

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

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

CSV options: 

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]);