units_with_maps

Table actions

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

4 rows where DES_TP = 3, MNG_AGENCY = 512 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 4 ✖

MNG_AGENCY 1

  • Los Banos, City of · 4 ✖

DES_TP 1

  • Local Recreation Area · 4 ✖

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
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
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]);