units_with_maps

Table actions

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

7 rows where AGNCY_TYP = 2, COUNTY = 37, DES_TP = 3 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_NAME

MNG_AG_TYP 1

  • City Agency · 7 ✖

DES_TP 1

  • Local Recreation Area · 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
2326 2326 2325 {"type": "Polygon", "coordinates": [[[-120.60546, 37.3466], [-120.60475, 37.34779], [-120.60365, 37.34736], [-120.60433, 37.34619], [-120.60546, 37.3466]]]} Open Access 1 17043 Atwater Memorial Ball Park 15680 1014 Atwater, City of 470 City 2 City Agency 2 http://www.atwater.org/index.cfm?page=940884 City 2 1014 Atwater, City of 463 City 2 City Agency 2   Merced 37 3.939 Atwater Memorial Ball Park 0 Local Recreation Area 3 4
2370 2370 2369 {"type": "Polygon", "coordinates": [[[-120.83479, 37.08983], [-120.83269, 37.08984], [-120.83279, 37.08797], [-120.83477, 37.08796], [-120.83479, 37.08983]]]} Open Access 1 17169 Ag Sports Complex 15283 1189 Los Banos, City of 519 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 1189 Los Banos, City of 512 City 2 City Agency 2   Merced 37 9.306 Ag Sports Complex 0 Local Recreation Area 3 4
4328 4328 4327 {"type": "Polygon", "coordinates": [[[-120.83477, 37.08028], [-120.83422, 37.08027], [-120.83417, 37.08005], [-120.83425, 37.08002], [-120.83433, 37.07998], [-120.8344, 37.07988], [-120.83477, 37.07997], [-120.83477, 37.08028]]]} Open Access 1 48327 Regency Tot Lot 32889 1189 Los Banos, City of 519 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 1189 Los Banos, City of 512 City 2 City Agency 2   Merced 37 0.458 Regency Tot Lot 0 Local Recreation Area 3 4
7454 7454 7453 {"type": "MultiPolygon", "coordinates": [[[[-120.83719, 37.05776], [-120.8411, 37.05961], [-120.84094, 37.05985], [-120.83719, 37.05808], [-120.8356, 37.05737], [-120.8356, 37.05723], [-120.83576, 37.05713], [-120.83719, 37.05776]]], [[[-120.84549, 37.06143], [-120.84515, 37.06193], [-120.84227, 37.06065], [-120.84113, 37.06003], [-120.84134, 37.05972], [-120.84254, 37.06023], [-120.84259, 37.06017], [-120.84549, 37.06143]]], [[[-120.84976, 37.06343], [-120.84948, 37.06384], [-120.8454, 37.06203], [-120.84585, 37.06137], [-120.84641, 37.06162], [-120.84634, 37.06169], [-120.84626, 37.06181], [-120.84624, 37.0619], [-120.84624, 37.06204], [-120.84626, 37.06214], [-120.84632, 37.06225], [-120.84645, 37.06237], [-120.84676, 37.06256], [-120.84715, 37.06267], [-120.84735, 37.06269], [-120.84752, 37.06266], [-120.84764, 37.06262], [-120.84776, 37.06256], [-120.84785, 37.06248], [-120.84796, 37.06232], [-120.84802, 37.06234], [-120.84793, 37.06249], [-120.84838, 37.06269], [-120.84849, 37.06255], [-120.84947, 37.06299], [-120.84932, 37.06323], [-120.84976, 37.06343]]], [[[-120.8528, 37.06447], [-120.85219, 37.06535], [-120.85197, 37.06526], [-120.85218, 37.06507], [-120.85217, 37.06491], [-120.85116, 37.06458], [-120.84972, 37.06395], [-120.85, 37.06354], [-120.85245, 37.06462], [-120.85267, 37.06441], [-120.8528, 37.06447]]]]} Open Access 1 48445 Rail Trail 33150 1189 Los Banos, City of 519 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 1189 Los Banos, City of 512 City 2 City Agency 2   Merced 37 19.027 Rail Trail 0 Local Recreation Area 3 4
9967 9967 9966 {"type": "Polygon", "coordinates": [[[-120.70787, 37.3895], [-120.70505, 37.38952], [-120.70508, 37.38762], [-120.70787, 37.38761], [-120.70787, 37.3895]]]} Open Access 1 17142 Livingston Sports Complex 21385 1179 Livingston, City of 219 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1179 Livingston, City of 215 City 2 City Agency 2   Merced 37 12.918 Livingston Sports Complex 0 Local Recreation Area 3 4
10008 10008 10007 {"type": "Polygon", "coordinates": [[[-120.50888, 37.29553], [-120.50884, 37.29726], [-120.50588, 37.29724], [-120.50594, 37.29553], [-120.50888, 37.29553]]]} Open Access 1 17205 Merced Youth Sports Complex 22167 1203 Merced, City of 474 City 2 City Agency 2 http://www.cityofmerced.org/depts/parks_n_community_services/default.asp City 2 1203 Merced, City of 467 City 2 City Agency 2   Merced 37 12.336 Merced Youth Sports Complex 0 Local Recreation Area 3 4
12316 12316 12315 {"type": "Polygon", "coordinates": [[[-120.8676, 37.06527], [-120.86648, 37.06525], [-120.86653, 37.06449], [-120.86575, 37.06447], [-120.8658, 37.06262], [-120.86597, 37.06263], [-120.86669, 37.0628], [-120.86684, 37.06288], [-120.86699, 37.06321], [-120.86707, 37.06356], [-120.86716, 37.06357], [-120.86716, 37.06451], [-120.86744, 37.06472], [-120.86757, 37.06493], [-120.8676, 37.06527]]]} Open Access 1 25977 Colorado Ball Park 17541 1189 Los Banos, City of 519 City 2 City Agency 2 http://www.losbanos.org/city-government/departments/public-works/ City 2 1189 Los Banos, City of 512 City 2 City Agency 2   Merced 37 7.357 Colorado Ball Park 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]);