units_with_maps

Table actions

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

15 rows where COUNTY = 10 and MNG_AGENCY = 782

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Beaumont, City of · 15 ✖

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
5265 5265 5264 {"type": "Polygon", "coordinates": [[[-116.9771, 33.95886], [-116.97696, 33.95887], [-116.97697, 33.9611], [-116.97696, 33.96113], [-116.9769, 33.96116], [-116.97646, 33.96116], [-116.97639, 33.96122], [-116.97638, 33.96126], [-116.97639, 33.96131], [-116.97635, 33.96135], [-116.97517, 33.96136], [-116.97526, 33.95636], [-116.97709, 33.95635], [-116.9771, 33.95886]]]} Open Access 1 24633 Beaumont Sports Park 15941 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 22.671 Beaumont Sports Park 0 Local Recreation Area 3 4
6467 6467 6466 {"type": "Polygon", "coordinates": [[[-116.98167, 33.93103], [-116.98167, 33.93103], [-116.98149, 33.93126], [-116.98149, 33.93103], [-116.98167, 33.93103]]]} Open Access 1 39054 Veterans Park 27054 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 0.051 Veterans Park 0 Local Park 2 4
11360 11360 11359 {"type": "Polygon", "coordinates": [[[-116.98538, 33.92709], [-116.98426, 33.92651], [-116.98426, 33.9264], [-116.98538, 33.9264], [-116.98538, 33.92709]]]} Open Access 1 22145 Rangel Park 24185 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 1.136 Rangel Park 0 Local Park 2 4
11361 11361 11360 {"type": "MultiPolygon", "coordinates": [[[[-116.97428, 33.93236], [-116.97302, 33.93236], [-116.97302, 33.93104], [-116.97315, 33.93104], [-116.97315, 33.93033], [-116.97373, 33.93032], [-116.97374, 33.93016], [-116.97427, 33.93016], [-116.97428, 33.93236]]], [[[-116.97427, 33.9339], [-116.97316, 33.9339], [-116.97315, 33.93258], [-116.97426, 33.93258], [-116.97427, 33.9339]]], [[[-116.97427, 33.93544], [-116.97316, 33.93544], [-116.97315, 33.93412], [-116.97426, 33.93412], [-116.97427, 33.93544]]], [[[-116.97428, 33.93698], [-116.97317, 33.93698], [-116.97316, 33.93566], [-116.97427, 33.93566], [-116.97428, 33.93698]]]]} Open Access 1 22146 Stewart Park 25846 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 17.611 Stewart Park 0 Local Park 2 4
11984 11984 11983 {"type": "Polygon", "coordinates": [[[-116.99295, 33.95209], [-116.99286, 33.95235], [-116.99275, 33.95256], [-116.9926, 33.9528], [-116.99243, 33.95301], [-116.99204, 33.95292], [-116.99197, 33.95289], [-116.99188, 33.95288], [-116.98856, 33.95209], [-116.98817, 33.95262], [-116.98816, 33.95281], [-116.98808, 33.95278], [-116.98809, 33.95221], [-116.99153, 33.94716], [-116.99191, 33.94715], [-116.99024, 33.94964], [-116.98923, 33.9511], [-116.99242, 33.95187], [-116.99247, 33.95194], [-116.99254, 33.95198], [-116.99262, 33.952], [-116.99291, 33.95201], [-116.99295, 33.95209]]]} Open Access 1 24635 Oak Valley Park 23015 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 16.402 Oak Valley Park 0 Local Park 2 4
11985 11985 11984 {"type": "Polygon", "coordinates": [[[-116.99002, 33.93689], [-116.98976, 33.93712], [-116.98957, 33.93735], [-116.98957, 33.93742], [-116.98948, 33.93746], [-116.98945, 33.9375], [-116.98944, 33.93755], [-116.98924, 33.93759], [-116.98896, 33.93807], [-116.98887, 33.93804], [-116.98867, 33.93792], [-116.98846, 33.93774], [-116.98828, 33.93752], [-116.98819, 33.93733], [-116.98814, 33.93718], [-116.98811, 33.93699], [-116.98811, 33.93607], [-116.98818, 33.93601], [-116.98847, 33.93606], [-116.9894, 33.93642], [-116.98969, 33.93659], [-116.98984, 33.93671], [-116.99002, 33.93689]]]} Open Access 1 24636 3 Rings Ranch Community Park 15191 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 6.021 3 Rings Ranch Community Park 0 Local Park 2 4
11986 11986 11985 {"type": "Polygon", "coordinates": [[[-116.95169, 33.93946], [-116.95186, 33.93947], [-116.95201, 33.93951], [-116.95217, 33.93958], [-116.9523, 33.93967], [-116.9524, 33.93977], [-116.95248, 33.93989], [-116.95253, 33.94004], [-116.95255, 33.94017], [-116.95253, 33.94032], [-116.95249, 33.94045], [-116.9524, 33.94059], [-116.95231, 33.94068], [-116.95218, 33.94078], [-116.95201, 33.94085], [-116.95183, 33.9409], [-116.95166, 33.94091], [-116.95151, 33.94089], [-116.9513, 33.94083], [-116.95115, 33.94076], [-116.95104, 33.94068], [-116.95094, 33.94057], [-116.95086, 33.94044], [-116.95082, 33.94032], [-116.95081, 33.94017], [-116.95083, 33.94002], [-116.95089, 33.93987], [-116.95099, 33.93974], [-116.95109, 33.93965], [-116.95123, 33.93956], [-116.95138, 33.9395], [-116.95153, 33.93947], [-116.95169, 33.93946]]]} Open Access 1 24634 Mountain View Community Park 22550 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 4.998 Mtn. View Community Park 0 Local Park 2 4
14031 14031 14030 {"type": "Polygon", "coordinates": [[[-117.04557, 33.96089], [-117.04552, 33.96222], [-117.04478, 33.96209], [-117.04461, 33.96203], [-117.04445, 33.96194], [-117.04396, 33.96151], [-117.04431, 33.96125], [-117.0447, 33.96106], [-117.04512, 33.96094], [-117.04557, 33.96089]]]} Open Access 1 39201 Palmer Community Park 23352 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 3.59 Palmer Community Park 0 Local Park 2 4
14113 14113 14112 {"type": "Polygon", "coordinates": [[[-116.96415, 33.9134], [-116.96413, 33.91345], [-116.96375, 33.91362], [-116.96344, 33.91381], [-116.96319, 33.91402], [-116.96297, 33.91428], [-116.96291, 33.91429], [-116.96267, 33.91417], [-116.96265, 33.91412], [-116.9628, 33.91396], [-116.96283, 33.9139], [-116.96283, 33.91381], [-116.96279, 33.91374], [-116.96309, 33.91356], [-116.96312, 33.91346], [-116.96334, 33.91348], [-116.96354, 33.91341], [-116.96367, 33.91331], [-116.96374, 33.91319], [-116.96376, 33.91311], [-116.96377, 33.91293], [-116.96383, 33.91272], [-116.96383, 33.91249], [-116.96389, 33.91217], [-116.96389, 33.91201], [-116.96384, 33.9117], [-116.9638, 33.91164], [-116.96372, 33.91161], [-116.96401, 33.91161], [-116.96394, 33.91165], [-116.96392, 33.91172], [-116.96395, 33.91191], [-116.96396, 33.9121], [-116.96402, 33.91214], [-116.96398, 33.91223], [-116.96402, 33.91242], [-116.96402, 33.91298], [-116.96405, 33.91314], [-116.96415, 33.9134]]]} Open Access 1 39202 Seneca Springs Community Park 25299 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 2.183 Seneca Springs Community Park 0 Local Park 2 4
14114 14114 14113 {"type": "Polygon", "coordinates": [[[-117.01351, 33.94457], [-117.01346, 33.94462], [-117.01344, 33.94467], [-117.01344, 33.94477], [-117.01341, 33.94484], [-117.01331, 33.94497], [-117.01328, 33.94503], [-117.0133, 33.94509], [-117.01334, 33.94513], [-117.01339, 33.94516], [-117.01346, 33.94516], [-117.01346, 33.94534], [-117.01326, 33.94535], [-117.01326, 33.94562], [-117.01235, 33.94562], [-117.01229, 33.94557], [-117.0123, 33.94472], [-117.01235, 33.94445], [-117.01236, 33.94423], [-117.01246, 33.94416], [-117.01291, 33.94418], [-117.01351, 33.94424], [-117.01347, 33.94452], [-117.01351, 33.94457]]]} Open Access 1 39203 Shadow Hill Community Park 25335 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 3.924 Shadow Hill Community Park 0 Local Park 2 4
14115 14115 14114 {"type": "Polygon", "coordinates": [[[-117.01602, 33.95768], [-117.01601, 33.95856], [-117.01599, 33.95868], [-117.01595, 33.9588], [-117.01273, 33.95801], [-117.01268, 33.95786], [-117.01267, 33.95771], [-117.01274, 33.95687], [-117.01602, 33.95768]]]} Open Access 1 39204 Stetson Community Park 25837 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 9.565 Stetson Community Park 0 Local Park 2 4
14116 14116 14115 {"type": "Polygon", "coordinates": [[[-117.03602, 33.96133], [-117.03434, 33.96104], [-117.03431, 33.95906], [-117.03504, 33.95906], [-117.03504, 33.95939], [-117.03508, 33.95968], [-117.03515, 33.95996], [-117.03527, 33.96028], [-117.03543, 33.9606], [-117.0356, 33.96085], [-117.03579, 33.96109], [-117.03602, 33.96133]]]} Open Access 1 39205 Trevino Community Park 26525 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 5.156 Trevino Community Park 0 Local Park 2 4
14119 14119 14118 {"type": "Polygon", "coordinates": [[[-116.96063, 33.94208], [-116.96062, 33.94293], [-116.96054, 33.943], [-116.95951, 33.943], [-116.95943, 33.94293], [-116.95943, 33.94207], [-116.95952, 33.942], [-116.96054, 33.94201], [-116.96063, 33.94208]]]} Open Access 1 39206 Wild Flower Community Park 27496 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 2.971 Wild Flower Community Park 0 Local Park 2 4
14120 14120 14119 {"type": "Polygon", "coordinates": [[[-116.9598, 33.91857], [-116.95978, 33.919], [-116.95973, 33.91918], [-116.95965, 33.91939], [-116.95951, 33.91964], [-116.95904, 33.92028], [-116.95893, 33.92047], [-116.95886, 33.92064], [-116.95877, 33.92099], [-116.95875, 33.92117], [-116.95875, 33.92153], [-116.95867, 33.9216], [-116.95761, 33.9216], [-116.95822, 33.92157], [-116.95821, 33.92129], [-116.95774, 33.9211], [-116.95773, 33.92107], [-116.95786, 33.92101], [-116.95787, 33.92089], [-116.95794, 33.92076], [-116.9579, 33.92064], [-116.95795, 33.92047], [-116.95785, 33.92025], [-116.95783, 33.9201], [-116.95784, 33.91987], [-116.95772, 33.91955], [-116.95741, 33.9197], [-116.95737, 33.91975], [-116.95725, 33.91973], [-116.957, 33.91976], [-116.9565, 33.91968], [-116.95652, 33.91915], [-116.95647, 33.91911], [-116.95653, 33.91903], [-116.9565, 33.91894], [-116.95654, 33.91892], [-116.95654, 33.91862], [-116.95793, 33.91864], [-116.95794, 33.91863], [-116.95793, 33.91853], [-116.9598, 33.91857]]]} Open Access 1 39207 DeForge Community Park 18016 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 13.894 DeForge Community Park 0 Local Park 2 4
14121 14121 14120 {"type": "Polygon", "coordinates": [[[-116.97409, 33.95412], [-116.97363, 33.95412], [-116.97363, 33.95406], [-116.97399, 33.95371], [-116.97409, 33.95372], [-116.97409, 33.95412]]]} Open Access 1 39208 Sunny Hills Community Park 26004 1415 Beaumont, City of 802 City 2 City Agency 2 http://www.ci.beaumont.ca.us/index.aspx?nid=33 City 2 1415 Beaumont, City of 782 City 2 City Agency 2   Riverside 10 0.319 Sunny Hills 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]);