units_with_maps

Table actions

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

14 rows where COUNTY = 10, DES_TP = 2 and MNG_AGENCY = 555

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Perris, City of · 14 ✖

DES_TP 1

  • Local Park · 14 ✖

ACCESS_TYP 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
2928 2928 2927 {"type": "Polygon", "coordinates": [[[-117.21419, 33.78669], [-117.21416, 33.78846], [-117.2131, 33.78845], [-117.21308, 33.78667], [-117.21419, 33.78669]]]} Open Access 1 19871 Bob Long Park 16210 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2   Riverside 10 4.867 Bob Long Park 0 Local Park 2 4
6235 6235 6234 {"type": "Polygon", "coordinates": [[[-117.22851, 33.7902], [-117.22628, 33.7902], [-117.22628, 33.78801], [-117.22746, 33.788], [-117.22746, 33.78956], [-117.22846, 33.78956], [-117.22851, 33.7902]]]} Open Access 1 1291 Banta Beatty Park 15802 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2   Riverside 10 8.216 Banta Beatty Park 0 Local Park 2 4
6801 6801 6800 {"type": "Polygon", "coordinates": [[[-117.23225, 33.7922], [-117.23211, 33.79221], [-117.23212, 33.7938], [-117.23068, 33.7938], [-117.22974, 33.79171], [-117.22954, 33.79115], [-117.2294, 33.7907], [-117.23224, 33.79069], [-117.23225, 33.7922]]]} Open Access 1 5316 Metz Park 22190 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2   Riverside 10 17.209 Metz Park 0 Local Park 2 4
10711 10711 10710 {"type": "Polygon", "coordinates": [[[-117.22146, 33.82254], [-117.22143, 33.82281], [-117.22083, 33.82283], [-117.22084, 33.82245], [-117.21981, 33.8224], [-117.21975, 33.82263], [-117.21946, 33.82262], [-117.21943, 33.82277], [-117.21756, 33.82281], [-117.21749, 33.82274], [-117.21749, 33.81948], [-117.21758, 33.8194], [-117.21784, 33.81938], [-117.21788, 33.81979], [-117.21803, 33.81998], [-117.22078, 33.82232], [-117.22109, 33.82246], [-117.22146, 33.82254]]]} Open Access 1 19869 Paragon Park 23409 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2   Riverside 10 15.394 Paragon Park 0 Local Park 2 4
10712 10712 10711 {"type": "Polygon", "coordinates": [[[-117.2226, 33.80668], [-117.2226, 33.80688], [-117.22237, 33.80757], [-117.22235, 33.80829], [-117.22118, 33.80829], [-117.22116, 33.80616], [-117.22126, 33.80614], [-117.22129, 33.80604], [-117.22131, 33.80534], [-117.22174, 33.80533], [-117.22166, 33.8049], [-117.22196, 33.80489], [-117.22201, 33.80552], [-117.22209, 33.80563], [-117.22225, 33.80566], [-117.22231, 33.80668], [-117.2226, 33.80668]]]} Open Access 1 19870 Copper Creek Park 17628 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2   Riverside 10 8.861 Copper Creek Park 0 Local Park 2 4
11995 11995 11994 {"type": "MultiPolygon", "coordinates": [[[[-117.22935, 33.73821], [-117.22866, 33.73876], [-117.22889, 33.73903], [-117.22865, 33.73916], [-117.22836, 33.73929], [-117.22809, 33.73937], [-117.22782, 33.73942], [-117.22778, 33.73931], [-117.22785, 33.73923], [-117.22788, 33.73912], [-117.22786, 33.739], [-117.22777, 33.73885], [-117.22769, 33.73834], [-117.22762, 33.73819], [-117.2276, 33.73807], [-117.22764, 33.73797], [-117.22773, 33.73786], [-117.22792, 33.73777], [-117.22805, 33.73767], [-117.22826, 33.73759], [-117.22875, 33.73753], [-117.22881, 33.73782], [-117.2292, 33.73766], [-117.22927, 33.73772], [-117.22909, 33.73802], [-117.22935, 33.73821]]], [[[-117.22935, 33.73999], [-117.22899, 33.7404], [-117.22885, 33.74048], [-117.22861, 33.74056], [-117.22832, 33.74058], [-117.22815, 33.74057], [-117.22794, 33.73959], [-117.22815, 33.73954], [-117.22854, 33.73942], [-117.22876, 33.73932], [-117.22902, 33.73918], [-117.22927, 33.73946], [-117.22922, 33.73973], [-117.22923, 33.73983], [-117.22935, 33.73999]]]]} Open Access 1 24653 Monument Ranch Park 22447 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2   Riverside 10 8.557 Monument Ranch Park 0 Local Park 2 4
14708 14708 14707 {"type": "MultiPolygon", "coordinates": [[[[-117.22872, 33.7773], [-117.22831, 33.77731], [-117.22788, 33.77723], [-117.22683, 33.7766], [-117.22871, 33.77659], [-117.22872, 33.7773]]], [[[-117.22872, 33.77766], [-117.22872, 33.77766], [-117.22856, 33.77755], [-117.22872, 33.77754], [-117.22872, 33.77766]]]]} Open Access 1 45055 Mercado Park 28049 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2 http://www.parks.ca.gov/?Page_id=26463 Riverside 10 2.35 Mercado Park 0 Local Park 2 4
14901 14901 14900 {"type": "Polygon", "coordinates": [[[-117.20331, 33.82801], [-117.20331, 33.82811], [-117.20305, 33.82823], [-117.2028, 33.82828], [-117.2009, 33.82829], [-117.20067, 33.82826], [-117.20056, 33.82829], [-117.20006, 33.82829], [-117.20006, 33.82684], [-117.20188, 33.82684], [-117.20231, 33.82709], [-117.20266, 33.82735], [-117.20304, 33.82769], [-117.20331, 33.82801]]]} Open Access 1 45453 Liberty Park 28258 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2 http://www.cityofperris.org/residents/parks/parks/liberty-park.html Riverside 10 9.984 Liberty Park 0 Local Park 2 4
14902 14902 14901 {"type": "Polygon", "coordinates": [[[-117.19176, 33.83854], [-117.19139, 33.83854], [-117.1914, 33.83929], [-117.19101, 33.83918], [-117.19081, 33.83909], [-117.19065, 33.83899], [-117.19043, 33.83883], [-117.19007, 33.83847], [-117.19007, 33.83839], [-117.19066, 33.83797], [-117.19092, 33.83773], [-117.1911, 33.83751], [-117.1912, 33.83748], [-117.19144, 33.83755], [-117.19169, 33.83758], [-117.1917, 33.83847], [-117.19176, 33.83854]]]} Open Access 1 45454 Frank Eaton Memorial Park 28257 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2 http://www.cityofperris.org/residents/parks/parks/frank-eaton-park.html Riverside 10 4.423 Frank Eaton Memorial Park 0 Local Park 2 4
14903 14903 14902 {"type": "Polygon", "coordinates": [[[-117.21216, 33.83907], [-117.20865, 33.83908], [-117.20865, 33.8374], [-117.21216, 33.83739], [-117.21216, 33.83907]]]} Open Access 1 45455 Morgan Park 28256 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2 http://www.cityofperris.org/residents/parks/parks/morgan-park.html Riverside 10 14.952 Morgan Park 0 Local Park 2 4
14904 14904 14903 {"type": "Polygon", "coordinates": [[[-117.1894, 33.82787], [-117.18909, 33.82788], [-117.18908, 33.8279], [-117.18702, 33.8279], [-117.18699, 33.8278], [-117.1869, 33.82772], [-117.1869, 33.8267], [-117.18897, 33.82669], [-117.18898, 33.82733], [-117.18935, 33.82734], [-117.1894, 33.82742], [-117.18942, 33.82749], [-117.18942, 33.82778], [-117.1894, 33.82787]]]} Open Access 1 45456 May Ranch Park 28255 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2 http://www.cityofperris.org/residents/parks/parks/may-ranch-park.html Riverside 10 6.905 May Ranch Park 0 Local Park 2 4
14905 14905 14904 {"type": "Polygon", "coordinates": [[[-117.20841, 33.79369], [-117.20708, 33.79371], [-117.20708, 33.79261], [-117.2084, 33.79258], [-117.20841, 33.79369]]]} Open Access 1 45458 Patriot Park 28261 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2 http://www.cityofperris.org/residents/parks/parks/patriot-park.html Riverside 10 3.698 Patriot Park 0 Local Park 2 4
14906 14906 14905 {"type": "Polygon", "coordinates": [[[-117.23464, 33.77386], [-117.23309, 33.77386], [-117.23308, 33.77214], [-117.23463, 33.77213], [-117.23464, 33.77386]]]} Open Access 1 45459 Rotary Park 28260 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2 http://www.cityofperris.org/residents/parks/parks/rotary-park.html Riverside 10 6.795 Rotary Park 0 Local Park 2 4
14907 14907 14906 {"type": "Polygon", "coordinates": [[[-117.21722, 33.79009], [-117.21716, 33.79014], [-117.21519, 33.79015], [-117.21519, 33.78843], [-117.21609, 33.78842], [-117.21662, 33.78887], [-117.21678, 33.78905], [-117.2169, 33.7892], [-117.21702, 33.78939], [-117.21712, 33.78963], [-117.21718, 33.78985], [-117.21722, 33.79009]]]} Open Access 1 45460 Skydive Baseball Park 28259 1388 Perris, City of 563 City 2 City Agency 2 http://cityofperris.org/residents/parks.html City 2 1388 Perris, City of 555 City 2 City Agency 2 http://www.cityofperris.org/residents/parks/parks/skydive-park.html Riverside 10 7.227 Skydive Baseball 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]);