units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 3, DES_TP = 2 and MNG_AGENCY = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Diego, City of · 3 ✖

DES_TP 1

  • Local Park · 3 ✖

ACCESS_TYP 1

  • No Public Access · 3 ✖
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
3846 3846 3845 {"type": "Polygon", "coordinates": [[[-117.22388, 32.93759], [-117.22376, 32.93764], [-117.22348, 32.9376], [-117.22333, 32.93761], [-117.22215, 32.93794], [-117.22194, 32.93802], [-117.22151, 32.93822], [-117.22151, 32.93456], [-117.22388, 32.93457], [-117.22388, 32.93759]]]} No Public Access 3 46811 Neighborhood 8 Neighborhood Park 30272 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 19.773 Neighborhood 8 Neighborhood Park 0 Local Park 2 4
6608 6608 6607 {"type": "Polygon", "coordinates": [[[-117.03964, 32.5565], [-117.03952, 32.55674], [-117.03854, 32.5569], [-117.03824, 32.55697], [-117.03804, 32.55697], [-117.03763, 32.55706], [-117.03762, 32.55704], [-117.03717, 32.55717], [-117.03738, 32.55766], [-117.03743, 32.55783], [-117.03746, 32.55795], [-117.03747, 32.55822], [-117.03369, 32.55819], [-117.03357, 32.55452], [-117.03776, 32.55454], [-117.03928, 32.55638], [-117.03964, 32.5565]]]} No Public Access 3 4168 Beyer Community Park 30224 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 43.828 Beyer Community Park 0 Local Park 2 4
15451 15451 15450 {"type": "Polygon", "coordinates": [[[-117.10104, 32.96786], [-117.0991, 32.9694], [-117.09768, 32.96813], [-117.0991, 32.96695], [-117.0996, 32.96659], [-117.10104, 32.96786]]]} No Public Access 3 46721 Penasquitos Village Neighborhood Park 30267 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 12.044 Penasquitos Village Neighborhood 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]);