units_with_maps

Table actions

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

8 rows where AGNCY_NAME = 527, DES_TP = 2 and MNG_AGENCY = 519

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Newman, City of · 8 ✖

DES_TP 1

  • Local Park · 8 ✖

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
2469 2469 2468 {"type": "Polygon", "coordinates": [[[-121.02666, 37.31484], [-121.0256, 37.31511], [-121.02521, 37.31406], [-121.02625, 37.31381], [-121.02666, 37.31484]]]} Open Access 1 18916 Pioneer Park 23726 1223 Newman, City of 527 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 1223 Newman, City of 519 City 2 City Agency 2   Stanislaus 2 2.919 Pioneer Park 0 Local Park 2 4
2883 2883 2882 {"type": "Polygon", "coordinates": [[[-121.01423, 37.32012], [-121.01422, 37.32074], [-121.01419, 37.32091], [-121.01419, 37.32123], [-121.01408, 37.32125], [-121.01408, 37.32153], [-121.01412, 37.3216], [-121.01413, 37.32195], [-121.01309, 37.32191], [-121.01304, 37.32011], [-121.01423, 37.32012]]]} Open Access 1 18902 Barrigton Park 15834 1223 Newman, City of 527 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 1223 Newman, City of 519 City 2 City Agency 2   Stanislaus 2 4.855 Barrigton Park 0 Local Park 2 4
3752 3752 3751 {"type": "Polygon", "coordinates": [[[-121.03023, 37.31264], [-121.02963, 37.31279], [-121.02953, 37.31255], [-121.02944, 37.31257], [-121.02919, 37.31193], [-121.02927, 37.3119], [-121.02919, 37.3117], [-121.0298, 37.31154], [-121.03023, 37.31264]]]} Open Access 1 34876 Howard B Hill Jr Park 20114 1223 Newman, City of 527 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 1223 Newman, City of 519 City 2 City Agency 2   Stanislaus 2 1.935 Howard B Hill Jr Park 0 Local Park 2 4
10617 10617 10616 {"type": "Polygon", "coordinates": [[[-121.03293, 37.31843], [-121.03291, 37.31976], [-121.03108, 37.31974], [-121.03104, 37.31842], [-121.03293, 37.31843]]]} Open Access 1 18910 Lions Park 21321 1223 Newman, City of 527 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 1223 Newman, City of 519 City 2 City Agency 2   Stanislaus 2 5.972 Lions Park 0 Local Park 2 4
13015 13015 13014 {"type": "Polygon", "coordinates": [[[-121.02647, 37.307], [-121.02645, 37.30777], [-121.02504, 37.30767], [-121.02505, 37.30685], [-121.02578, 37.30686], [-121.02639, 37.30693], [-121.02647, 37.307]]]} Open Access 1 34877 Janet Carlsen Park 20361 1223 Newman, City of 527 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 1223 Newman, City of 519 City 2 City Agency 2   Stanislaus 2 2.904 Janet Carlsen Park 0 Local Park 2 4
13039 13039 13038 {"type": "Polygon", "coordinates": [[[-121.03563, 37.30465], [-121.03559, 37.3065], [-121.03527, 37.3065], [-121.0351, 37.30646], [-121.03494, 37.30641], [-121.03479, 37.30634], [-121.03459, 37.3062], [-121.03448, 37.30609], [-121.0344, 37.30596], [-121.03433, 37.30583], [-121.03429, 37.30562], [-121.0343, 37.30547], [-121.03434, 37.30532], [-121.03445, 37.30511], [-121.03456, 37.30499], [-121.03469, 37.30488], [-121.03485, 37.30479], [-121.03502, 37.30472], [-121.0352, 37.30467], [-121.03539, 37.30465], [-121.03563, 37.30465]]]} Open Access 1 34878 Alfred A. "Bush" Rose, Jr. Park 30997 1223 Newman, City of 527 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 1223 Newman, City of 519 City 2 City Agency 2   Stanislaus 2 4.821 Alfred A. "Bush" Rose, Jr. Park 0 Local Park 2 4
13924 13924 13923 {"type": "Polygon", "coordinates": [[[-121.01284, 37.31283], [-121.01284, 37.31283], [-121.01186, 37.31375], [-121.01186, 37.31311], [-121.01183, 37.31294], [-121.01178, 37.3128], [-121.01165, 37.31266], [-121.01165, 37.31256], [-121.01189, 37.3125], [-121.01229, 37.31248], [-121.01272, 37.3125], [-121.01282, 37.31253], [-121.01284, 37.31283]]]} Open Access 1 48839 Joe M Barba Park 33559 1223 Newman, City of 527 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 1223 Newman, City of 519 City 2 City Agency 2   Stanislaus 2 2.032 Joe M Barba Park 0 Local Park 2 4
15007 15007 15006 {"type": "Polygon", "coordinates": [[[-121.00767, 37.32011], [-121.00763, 37.32015], [-121.0075, 37.3202], [-121.00728, 37.32031], [-121.00714, 37.3204], [-121.00611, 37.32119], [-121.0058, 37.32142], [-121.00573, 37.3214], [-121.00563, 37.32134], [-121.00471, 37.32071], [-121.00468, 37.32066], [-121.00639, 37.31905], [-121.00678, 37.31931], [-121.00761, 37.31931], [-121.00767, 37.32011]]]} Open Access 1 45657 Sherman Park 28473 1223 Newman, City of 527 City 2 City Agency 2 http://www.cityofnewman.com/ City 2 1223 Newman, City of 519 City 2 City Agency 2   Stanislaus 2 9.035 Sherman 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]);