units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, AGNCY_NAME = 541 and DES_TP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Recreation Area · 1 ✖

ACCESS_TYP 1

  • Restricted Access · 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
15715 15715 15714 {"type": "Polygon", "coordinates": [[[-121.41975, 38.62346], [-121.4198, 38.62372], [-121.41981, 38.62399], [-121.41977, 38.62426], [-121.41968, 38.62453], [-121.41958, 38.62472], [-121.41944, 38.62492], [-121.41881, 38.62563], [-121.40843, 38.63518], [-121.40815, 38.63532], [-121.40714, 38.63543], [-121.40592, 38.63611], [-121.40545, 38.6363], [-121.40506, 38.63644], [-121.40444, 38.63661], [-121.40337, 38.63678], [-121.40288, 38.6369], [-121.40098, 38.63755], [-121.4004, 38.63744], [-121.39986, 38.63736], [-121.39945, 38.63746], [-121.39897, 38.63771], [-121.39804, 38.6384], [-121.3975, 38.63872], [-121.39721, 38.63917], [-121.39689, 38.63946], [-121.39644, 38.63969], [-121.39606, 38.64003], [-121.39524, 38.64033], [-121.39482, 38.6405], [-121.39444, 38.64055], [-121.39308, 38.64054], [-121.39247, 38.64056], [-121.39199, 38.64066], [-121.39146, 38.6407], [-121.39082, 38.64075], [-121.39015, 38.64075], [-121.38974, 38.64072], [-121.38942, 38.64064], [-121.38838, 38.64059], [-121.38784, 38.64051], [-121.38759, 38.64039], [-121.38749, 38.64026], [-121.38746, 38.64011], [-121.3875, 38.63999], [-121.38775, 38.63982], [-121.388, 38.63972], [-121.38839, 38.63929], [-121.38849, 38.639], [-121.38852, 38.63878], [-121.38824, 38.63837], [-121.38811, 38.63825], [-121.38805, 38.63812], [-121.38821, 38.6379], [-121.38859, 38.63753], [-121.38866, 38.63728], [-121.38786, 38.63673], [-121.38864, 38.63583], [-121.38938, 38.63532], [-121.39025, 38.63492], [-121.39709, 38.6323], [-121.39865, 38.63406], [-121.39906, 38.63434], [-121.39973, 38.63413], [-121.40058, 38.63399], [-121.40101, 38.63387], [-121.40159, 38.6336], [-121.4014, 38.63335], [-121.4013, 38.63319], [-121.40123, 38.633], [-121.4012, 38.63276], [-121.40121, 38.63258], [-121.40125, 38.6324], [-121.4015, 38.63185], [-121.40152, 38.63171], [-121.40153, 38.63152], [-121.40182, 38.63153], [-121.40428, 38.62982], [-121.40454, 38.62967], [-121.40525, 38.6293], [-121.40598, 38.62895], [-121.4106, 38.62717], [-121.41287, 38.62613], [-121.41367, 38.6258], [-121.4179, 38.62414], [-121.41858, 38.62384], [-121.41921, 38.62353], [-121.41975, 38.62346]]]} Restricted Access 2 34932 Haggin Oaks Golf Course 33101 1287 Sacramento, City of 541 City 2 City Agency 2 http://portal.cityofsacramento.org/ParksandRec City 2 1287 Sacramento, City of 534 City 2 City Agency 2   Sacramento 41 407.841 Haggin Oaks GC 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]);