units_with_maps

Table actions

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

13 rows where DES_TP = 2, LAYER = 2 and MNG_AGENCY = 507

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Ceres, City of · 13 ✖

DES_TP 1

  • Local Park · 13 ✖

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
2721 2721 2720 {"type": "Polygon", "coordinates": [[[-120.95224, 37.6058], [-120.95224, 37.60697], [-120.95222, 37.60699], [-120.95151, 37.60702], [-120.95099, 37.60708], [-120.95093, 37.60708], [-120.95091, 37.60706], [-120.95089, 37.60612], [-120.9509, 37.60586], [-120.95094, 37.60585], [-120.95177, 37.60584], [-120.95218, 37.60577], [-120.95222, 37.60578], [-120.95224, 37.6058]]]} Open Access 1 18358 Barry Grove Park 15836 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 3.887 Barry Grove Park 0 Local Park 2 4
2722 2722 2721 {"type": "Polygon", "coordinates": [[[-120.96627, 37.599], [-120.96527, 37.59814], [-120.96148, 37.59482], [-120.96379, 37.59484], [-120.96612, 37.59486], [-120.96627, 37.599]]]} Open Access 1 18361 Ceres Memorial Park 17081 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 23.33 Ceres Memorial Park 0 Local Park 2 4
2730 2730 2729 {"type": "Polygon", "coordinates": [[[-120.96592, 37.58393], [-120.96591, 37.58527], [-120.9659, 37.5853], [-120.96586, 37.58531], [-120.96435, 37.5853], [-120.9643, 37.58527], [-120.9643, 37.58448], [-120.96437, 37.58432], [-120.96433, 37.58423], [-120.9646, 37.58392], [-120.96592, 37.58393]]]} Open Access 1 18368 Don Pedro Park 18208 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 5.24 Don Pedro Park 0 Local Park 2 4
2738 2738 2737 {"type": "Polygon", "coordinates": [[[-120.93564, 37.59838], [-120.93399, 37.59838], [-120.93373, 37.59838], [-120.93376, 37.59827], [-120.9338, 37.59819], [-120.93397, 37.59797], [-120.93404, 37.59783], [-120.93407, 37.59769], [-120.93407, 37.59738], [-120.93524, 37.59738], [-120.93525, 37.59821], [-120.93563, 37.59822], [-120.93564, 37.59838]]]} Open Access 1 18393 Persephone Park 23616 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 3.269 Persephone Park 0 Local Park 2 4
3190 3190 3189 {"type": "Polygon", "coordinates": [[[-120.94781, 37.60194], [-120.94356, 37.60194], [-120.94345, 37.60167], [-120.94342, 37.60149], [-120.94339, 37.5984], [-120.94548, 37.5984], [-120.94549, 37.60016], [-120.94778, 37.60016], [-120.94781, 37.60194]]]} Open Access 1 22106 Smyrna Park 25579 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 27.695 Smyrna Park 0 Local Park 2 4
10391 10391 10390 {"type": "Polygon", "coordinates": [[[-120.93019, 37.61576], [-120.9297, 37.61597], [-120.92932, 37.61605], [-120.92867, 37.61599], [-120.928, 37.61589], [-120.92722, 37.61566], [-120.92709, 37.61558], [-120.9268, 37.61546], [-120.92651, 37.6153], [-120.92628, 37.61524], [-120.92582, 37.61503], [-120.92529, 37.61484], [-120.92526, 37.60941], [-120.93014, 37.6094], [-120.93019, 37.61576]]]} Open Access 1 18364 Ceres River Bluff Regional Park 17082 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 73.839 Ceres River Bluff RP 0 Local Park 2 4
10393 10393 10392 {"type": "Polygon", "coordinates": [[[-120.96996, 37.6059], [-120.9699, 37.60591], [-120.96985, 37.60594], [-120.96982, 37.60599], [-120.96983, 37.60604], [-120.96949, 37.60604], [-120.96948, 37.60525], [-120.96927, 37.60507], [-120.96885, 37.60507], [-120.96864, 37.60521], [-120.96865, 37.60569], [-120.96836, 37.60569], [-120.96821, 37.60565], [-120.96819, 37.6052], [-120.96837, 37.60514], [-120.96811, 37.60455], [-120.96836, 37.60448], [-120.96992, 37.6044], [-120.96996, 37.6059]]]} Open Access 1 18372 Independence Park 20188 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 4.347 Independence Park 0 Local Park 2 4
10397 10397 10396 {"type": "Polygon", "coordinates": [[[-120.93129, 37.60201], [-120.92682, 37.60202], [-120.92682, 37.60191], [-120.92921, 37.6019], [-120.92923, 37.60028], [-120.93127, 37.60027], [-120.93127, 37.60084], [-120.93129, 37.60085], [-120.93129, 37.60201]]]} Open Access 1 18376 Neel Park 22683 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 9.374 Neel Park 0 Local Park 2 4
10408 10408 10407 {"type": "Polygon", "coordinates": [[[-120.9455, 37.5854], [-120.9455, 37.58566], [-120.94365, 37.58566], [-120.9437, 37.58551], [-120.94381, 37.58542], [-120.94386, 37.58541], [-120.9451, 37.5854], [-120.94545, 37.58537], [-120.94548, 37.58538], [-120.9455, 37.5854]]]} Open Access 1 18403 Redwood Park 24247 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 1.161 Redwood Park 0 Local Park 2 4
10410 10410 10409 {"type": "Polygon", "coordinates": [[[-120.94561, 37.61224], [-120.94561, 37.61288], [-120.94559, 37.61289], [-120.94559, 37.61327], [-120.94522, 37.61345], [-120.94506, 37.61349], [-120.94487, 37.61351], [-120.94454, 37.61351], [-120.94438, 37.61349], [-120.9442, 37.61344], [-120.94391, 37.61331], [-120.94391, 37.61259], [-120.94396, 37.61253], [-120.94398, 37.61246], [-120.94395, 37.6124], [-120.94386, 37.61234], [-120.94382, 37.61229], [-120.94381, 37.61223], [-120.94383, 37.61218], [-120.94403, 37.61218], [-120.94434, 37.61223], [-120.94457, 37.61225], [-120.94561, 37.61224]]]} Open Access 1 18413 Riverview Park 24464 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 4.98 Riverview Park 0 Local Park 2 4
10414 10414 10413 {"type": "Polygon", "coordinates": [[[-120.94271, 37.58977], [-120.9427, 37.59037], [-120.94262, 37.59076], [-120.9426, 37.59099], [-120.94258, 37.59102], [-120.94069, 37.59103], [-120.94068, 37.58974], [-120.94267, 37.58974], [-120.94271, 37.58977]]]} Open Access 1 18418 Roeding Heights Park 24556 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 6.195 Roeding Heights Park 0 Local Park 2 4
10421 10421 10420 {"type": "Polygon", "coordinates": [[[-120.95558, 37.59127], [-120.95558, 37.59156], [-120.95465, 37.59156], [-120.95465, 37.59046], [-120.95558, 37.59127]]]} Open Access 1 18435 Whitmore Park 27472 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 1.573 Whitmore Park 0 Local Park 2 4
12328 12328 12327 {"type": "Polygon", "coordinates": [[[-120.98211, 37.58466], [-120.98089, 37.58466], [-120.98088, 37.58295], [-120.98094, 37.5829], [-120.98211, 37.5829], [-120.98211, 37.58466]]]} Open Access 1 25995 Sam Ryno Park 24818 1050 Ceres, City of 514 City 2 City Agency 2 http://www.ci.ceres.ca.us/ City 2 1050 Ceres, City of 507 City 2 City Agency 2   Stanislaus 2 5.229 Sam Ryno 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]);