superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 2 and MNG_AGENCY = 313

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Rohnert Park, City of · 1 ✖

ACCESS_TYP 1

  • Restricted Access · 1 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
14606 14606 14605 {"type": "MultiPolygon", "coordinates": [[[[-122.6975, 38.36612], [-122.69734, 38.36619], [-122.69709, 38.36634], [-122.69536, 38.36726], [-122.69449, 38.36933], [-122.69517, 38.37036], [-122.69584, 38.37134], [-122.69411, 38.37136], [-122.69245, 38.37031], [-122.6907, 38.36986], [-122.69038, 38.36872], [-122.69177, 38.36859], [-122.69286, 38.36873], [-122.69358, 38.36666], [-122.69634, 38.36528], [-122.69642, 38.36534], [-122.69653, 38.36539], [-122.69676, 38.36547], [-122.69697, 38.36557], [-122.69712, 38.3657], [-122.6975, 38.36612]]], [[[-122.70898, 38.36012], [-122.70778, 38.36135], [-122.70767, 38.36152], [-122.7071, 38.36209], [-122.70702, 38.36205], [-122.70748, 38.36157], [-122.70686, 38.36117], [-122.70628, 38.36175], [-122.70462, 38.36108], [-122.70419, 38.36097], [-122.70374, 38.36092], [-122.70328, 38.36091], [-122.6964, 38.36125], [-122.69604, 38.36128], [-122.69564, 38.35972], [-122.69545, 38.35657], [-122.69691, 38.35647], [-122.69729, 38.35804], [-122.69749, 38.36003], [-122.69883, 38.3598], [-122.69954, 38.35961], [-122.6992, 38.35623], [-122.70064, 38.35614], [-122.70132, 38.35946], [-122.70166, 38.35957], [-122.70361, 38.35947], [-122.70569, 38.358], [-122.70517, 38.35712], [-122.70522, 38.35674], [-122.70433, 38.35571], [-122.70408, 38.35529], [-122.70251, 38.35278], [-122.70262, 38.35201], [-122.70138, 38.35104], [-122.70123, 38.3508], [-122.70313, 38.35077], [-122.70898, 38.36012]]], [[[-122.70001, 38.36778], [-122.69854, 38.36776], [-122.69753, 38.36894], [-122.69828, 38.37051], [-122.69833, 38.37064], [-122.69784, 38.37126], [-122.69777, 38.3713], [-122.69774, 38.37131], [-122.69684, 38.37131], [-122.69615, 38.37029], [-122.6968, 38.37004], [-122.69645, 38.36954], [-122.69607, 38.36922], [-122.69604, 38.36805], [-122.69607, 38.36797], [-122.69626, 38.36772], [-122.69639, 38.36758], [-122.6976, 38.36693], [-122.69759, 38.36669], [-122.69761, 38.36658], [-122.69764, 38.36655], [-122.69857, 38.36607], [-122.70001, 38.36778]]], [[[-122.70675, 38.36236], [-122.70468, 38.36506], [-122.70424, 38.36526], [-122.70084, 38.36524], [-122.70082, 38.36531], [-122.69994, 38.36531], [-122.69971, 38.36554], [-122.69938, 38.36555], [-122.6991, 38.36561], [-122.69892, 38.36568], [-122.69853, 38.36588], [-122.69755, 38.36467], [-122.7001, 38.36388], [-122.70223, 38.36407], [-122.70278, 38.36381], [-122.70414, 38.363], [-122.70537, 38.36235], [-122.70572, 38.36194], [-122.70675, 38.36236]]], [[[-122.705, 38.36688], [-122.70205, 38.36782], [-122.70047, 38.36783], [-122.69937, 38.36659], [-122.70192, 38.36629], [-122.7025, 38.36599], [-122.70447, 38.366], [-122.705, 38.36688]]], [[[-122.70295, 38.35048], [-122.70097, 38.35045], [-122.6998, 38.34855], [-122.70177, 38.34858], [-122.70295, 38.35048]]], [[[-122.71201, 38.36935], [-122.71009, 38.36937], [-122.70842, 38.36762], [-122.70643, 38.36764], [-122.70528, 38.36571], [-122.70759, 38.3627], [-122.70855, 38.36309], [-122.70858, 38.36313], [-122.70859, 38.36317], [-122.70813, 38.36387], [-122.70798, 38.36383], [-122.70739, 38.3645], [-122.70635, 38.36559], [-122.70696, 38.36676], [-122.70714, 38.36692], [-122.70862, 38.36683], [-122.70863, 38.36672], [-122.70856, 38.36671], [-122.70864, 38.36569], [-122.70869, 38.36568], [-122.7087, 38.36543], [-122.70875, 38.36542], [-122.70875, 38.3653], [-122.70871, 38.36529], [-122.70872, 38.36513], [-122.70868, 38.36512], [-122.70873, 38.36441], [-122.70877, 38.36415], [-122.70945, 38.3639], [-122.70951, 38.36446], [-122.70955, 38.36528], [-122.71015, 38.36529], [-122.71024, 38.36524], [-122.71043, 38.3652], [-122.71044, 38.36511], [-122.71048, 38.36504], [-122.71064, 38.36488], [-122.71069, 38.36478], [-122.71067, 38.36468], [-122.71071, 38.36464], [-122.71056, 38.36444], [-122.71052, 38.36438], [-122.7105, 38.3643], [-122.71047, 38.36415], [-122.7105, 38.36411], [-122.71044, 38.36393], [-122.71041, 38.36364], [-122.71078, 38.36365], [-122.71095, 38.36393], [-122.71102, 38.36391], [-122.71146, 38.36462], [-122.71163, 38.36782], [-122.71174, 38.36845], [-122.71201, 38.36935]]]]} Restricted Access 2 Rohnert Park Municipal Golf Course   33089 1281 Rohnert Park, City of 313 City 2 City Agency 2 http://www.ci.rohnert-park.ca.us/index.aspx?page=74 City 2 282.899 Rohnert Park Municipal GC  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);