units_with_maps

Table actions

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

7 rows where AGNCY_LEV = 2, DES_TP = 2 and MNG_AGENCY = 136

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Porterville, City of · 7 ✖

DES_TP 1

  • Local Park · 7 ✖

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
2294 2294 2293 {"type": "MultiPolygon", "coordinates": [[[[-119.00403, 36.06926], [-118.99973, 36.06922], [-118.99968, 36.06574], [-119.00178, 36.06578], [-119.00179, 36.06635], [-119.00161, 36.06635], [-119.00162, 36.06678], [-119.0023, 36.0668], [-119.00218, 36.06695], [-119.00202, 36.06711], [-119.00186, 36.06721], [-119.00167, 36.06724], [-119.00162, 36.0673], [-119.0016, 36.06737], [-119.0017, 36.06765], [-119.0017, 36.06779], [-119.00168, 36.06791], [-119.00164, 36.06802], [-119.00183, 36.06829], [-119.00191, 36.06829], [-119.00192, 36.06828], [-119.00175, 36.06801], [-119.00178, 36.06793], [-119.0018, 36.0678], [-119.0018, 36.06764], [-119.0017, 36.06737], [-119.00171, 36.06733], [-119.0019, 36.06728], [-119.00209, 36.06717], [-119.00226, 36.067], [-119.00238, 36.06685], [-119.00258, 36.06648], [-119.00291, 36.06609], [-119.00338, 36.06573], [-119.00397, 36.06574], [-119.00403, 36.06926]]], [[[-119.00314, 36.0658], [-119.00283, 36.06604], [-119.00279, 36.0661], [-119.00289, 36.0658], [-119.00314, 36.0658]]]]} Open Access 1 47919 Murray Park 32017 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 33.872 Murray Park 0 Local Park 2 4
3780 3780 3779 {"type": "Polygon", "coordinates": [[[-119.00968, 36.05491], [-119.00859, 36.0549], [-119.00862, 36.05417], [-119.00899, 36.05419], [-119.00901, 36.05393], [-119.00968, 36.05396], [-119.00968, 36.05491]]]} Open Access 1 45032 Fallen Heroes Park 31994 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 http://www.ci.porterville.ca.us/depts/ParksandLeisure/Namethepark.cfm Tulare 29 2.31 Fallen Heroes Park 0 Local Park 2 4
5511 5511 5510 {"type": "Polygon", "coordinates": [[[-119.02126, 36.06141], [-119.02126, 36.06169], [-119.02088, 36.06168], [-119.02089, 36.0614], [-119.02126, 36.06141]]]} Open Access 1 1174 Lions Mini Park 21315 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 0.26 Lions MP 0 Local Park 2 4
6142 6142 6141 {"type": "Polygon", "coordinates": [[[-119.05276, 36.07331], [-119.05268, 36.07539], [-119.05273, 36.08022], [-119.04966, 36.08022], [-119.04964, 36.07848], [-119.04994, 36.07838], [-119.05083, 36.07873], [-119.05213, 36.07902], [-119.05214, 36.07902], [-119.05212, 36.07442], [-119.0511, 36.07363], [-119.0506, 36.07361], [-119.05005, 36.07371], [-119.04814, 36.0737], [-119.04737, 36.07391], [-119.04723, 36.07391], [-119.04484, 36.07374], [-119.04433, 36.07501], [-119.04414, 36.07515], [-119.04407, 36.07393], [-119.04402, 36.07363], [-119.04411, 36.0734], [-119.05276, 36.07331]]]} Open Access 1 1226 Veteran's Memorial Park 27012 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 29.233 Veteran's Memorial Park 0 Local Park 2 4
6154 6154 6153 {"type": "Polygon", "coordinates": [[[-119.02223, 36.0768], [-119.02221, 36.07837], [-119.02222, 36.07915], [-119.02219, 36.07954], [-119.02219, 36.08023], [-119.02126, 36.08021], [-119.02101, 36.07981], [-119.02063, 36.07909], [-119.02029, 36.07837], [-119.01969, 36.07682], [-119.0201, 36.0768], [-119.02223, 36.0768]]]} Open Access 1 1229 Zalud Park 27851 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 15.304 Zalud Park 0 Local Park 2 4
6172 6172 6171 {"type": "Polygon", "coordinates": [[[-119.01837, 36.08107], [-119.01831, 36.08148], [-119.01806, 36.08153], [-119.01797, 36.08153], [-119.01791, 36.0815], [-119.01788, 36.08107], [-119.01837, 36.08107]]]} Open Access 1 1192 Olivewood Mini Park 23137 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 0.479 Olivewood MP 0 Local Park 2 4
6175 6175 6174 {"type": "Polygon", "coordinates": [[[-119.07983, 36.03277], [-119.07974, 36.03669], [-119.07376, 36.03671], [-119.07091, 36.03428], [-119.07092, 36.03038], [-119.07471, 36.03037], [-119.07472, 36.03281], [-119.07983, 36.03277]]]} Open Access 1 1206 Porterville Sports Complex and OHV Park 23904 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 99.975 Porterville Sports Complex and OHV 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]);