units_with_maps

Table actions

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

3 rows where DES_TP = 3 and MNG_AGENCY = 136

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Porterville, City of · 3 ✖

DES_TP 1

  • Local Recreation Area · 3 ✖
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
6158 6158 6157 {"type": "Polygon", "coordinates": [[[-119.03889, 36.08375], [-119.03865, 36.08375], [-119.03851, 36.08388], [-119.03732, 36.08389], [-119.03726, 36.0822], [-119.03872, 36.0822], [-119.03875, 36.08265], [-119.03886, 36.08328], [-119.03889, 36.08375]]]} Open Access 1 1171 Hayes Field 19755 1260 Porterville, City of 139 City 2 City Agency 2 http://www.ci.porterville.ca.us/ City 2 1260 Porterville, City of 136 City 2 City Agency 2   Tulare 29 6.219 Hayes Field 0 Local Recreation Area 3 4
6170 6170 6169 {"type": "MultiPolygon", "coordinates": [[[[-119.00412, 36.06444], [-119.00205, 36.06442], [-119.00204, 36.06457], [-119.00206, 36.06564], [-119.00082, 36.06562], [-119.00081, 36.06569], [-118.99981, 36.06569], [-118.99979, 36.0629], [-119.00339, 36.06294], [-119.00388, 36.06365], [-119.00412, 36.06444]]], [[[-119.00453, 36.06712], [-119.00453, 36.06755], [-119.00411, 36.06755], [-119.0041, 36.06711], [-119.00453, 36.06712]]], [[[-119.0045, 36.06776], [-119.0045, 36.06847], [-119.00412, 36.06847], [-119.00412, 36.06776], [-119.0045, 36.06776]]]]} Restricted Access 2 1184 Murry Park and Porterville Municipal Golf Course 32995 1260 Porterville, City of 139 City 2 City Agency 2 http://www.ci.porterville.ca.us/ City 2 1260 Porterville, City of 136 City 2 City Agency 2   Tulare 29 22.939 Murry Park and Porterville Municipal GC 0 Local Recreation Area 3 4
6184 6184 6183 {"type": "MultiPolygon", "coordinates": [[[[-119.02608, 36.0563], [-119.02593, 36.05628], [-119.02515, 36.05627], [-119.02459, 36.0563], [-119.02371, 36.0565], [-119.02346, 36.05645], [-119.0228, 36.0563], [-119.02236, 36.0563], [-119.02198, 36.05627], [-119.02167, 36.0563], [-119.02138, 36.05637], [-119.02124, 36.05637], [-119.02108, 36.05635], [-119.02033, 36.05636], [-119.0198, 36.05635], [-119.01867, 36.05627], [-119.01799, 36.05625], [-119.01758, 36.05618], [-119.0172, 36.05609], [-119.01712, 36.05605], [-119.01693, 36.05606], [-119.01676, 36.0561], [-119.01677, 36.05589], [-119.01782, 36.0558], [-119.0195, 36.05579], [-119.02035, 36.05581], [-119.02096, 36.05587], [-119.02169, 36.05601], [-119.02189, 36.05603], [-119.02237, 36.05602], [-119.02295, 36.0561], [-119.0233, 36.05607], [-119.02382, 36.05612], [-119.02407, 36.05612], [-119.02497, 36.0561], [-119.02608, 36.05611], [-119.02608, 36.0563]]], [[[-119.03915, 36.06018], [-119.03825, 36.06018], [-119.0372, 36.05999], [-119.03628, 36.0598], [-119.03537, 36.05955], [-119.03473, 36.05934], [-119.0337, 36.05905], [-119.03113, 36.05818], [-119.02997, 36.05784], [-119.02982, 36.05775], [-119.02934, 36.05752], [-119.02855, 36.05703], [-119.02854, 36.05691], [-119.02849, 36.0568], [-119.02828, 36.05675], [-119.02752, 36.05662], [-119.02711, 36.05649], [-119.02663, 36.05637], [-119.02625, 36.05634], [-119.02625, 36.05617], [-119.02864, 36.05615], [-119.02872, 36.05594], [-119.03105, 36.05597], [-119.03129, 36.05628], [-119.03145, 36.05653], [-119.0318, 36.05713], [-119.03199, 36.0575], [-119.03202, 36.05761], [-119.03204, 36.05776], [-119.03213, 36.05792], [-119.03228, 36.05806], [-119.03259, 36.05818], [-119.03278, 36.05823], [-119.03301, 36.05832], [-119.0333, 36.05833], [-119.03344, 36.05835], [-119.03368, 36.05846], [-119.03433, 36.05867], [-119.03466, 36.05875], [-119.03484, 36.05874], [-119.03509, 36.0587], [-119.03522, 36.05873], [-119.03533, 36.05885], [-119.03549, 36.05895], [-119.0358, 36.05908], [-119.03687, 36.05937], [-119.0371, 36.05948], [-119.03789, 36.05979], [-119.03803, 36.05981], [-119.03816, 36.05977], [-119.03841, 36.05973], [-119.03892, 36.05972], [-119.03899, 36.0574], [-119.03896, 36.05687], [-119.03886, 36.05624], [-119.03859, 36.05431], [-119.0385, 36.05415], [-119.0384, 36.0541], [-119.03829, 36.05399], [-119.03824, 36.05384], [-119.03795, 36.05389], [-119.03772, 36.0539], [-119.03757, 36.05389], [-119.03757, 36.05342], [-119.0376, 36.05324], [-119.03738, 36.05306], [-119.03737, 36.05304], [-119.03667, 36.0525], [-119.03546, 36.05204], [-119.03537, 36.05203], [-119.03537, 36.05188], [-119.03579, 36.0519], [-119.03654, 36.05197], [-119.0371, 36.0522], [-119.03767, 36.05273], [-119.03849, 36.05369], [-119.03891, 36.05472], [-119.03905, 36.05606], [-119.03918, 36.05806], [-119.03912, 36.05971], [-119.03915, 36.05972], [-119.03915, 36.06018]]]]} Open Access 1 1222 Tule River Parkway 26572 1260 Porterville, City of 139 City 2 City Agency 2 http://www.ci.porterville.ca.us/ City 2 1260 Porterville, City of 136 City 2 City Agency 2   Tulare 29 41.275 Tule River Parkway 0 Local Recreation Area 3 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]);