units_with_maps

Table actions

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

4 rows where AGNCY_WEB = "http://www.ci.corte-madera.ca.us/199/Parks-Recreation" and DES_TP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Park · 4 ✖

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
1845 1845 1844 {"type": "Polygon", "coordinates": [[[-122.50067, 37.9218], [-122.49945, 37.92181], [-122.49936, 37.9201], [-122.50047, 37.91971], [-122.50066, 37.92009], [-122.50067, 37.9218]]]} Open Access 1 14087 San Clemente Park 24850 1070 Corte Madera, Town of 431 City 2 City Agency 2 http://www.ci.corte-madera.ca.us/199/Parks-Recreation City 2 1070 Corte Madera, Town of 425 City 2 City Agency 2   Marin 23 5.785 San Clemente Park 0 Local Park 2 4
8694 8694 8693 {"type": "Polygon", "coordinates": [[[-122.50561, 37.91608], [-122.50538, 37.91614], [-122.50525, 37.91622], [-122.50518, 37.91631], [-122.50514, 37.91647], [-122.50398, 37.9167], [-122.50342, 37.91679], [-122.50269, 37.91538], [-122.50211, 37.91461], [-122.50194, 37.91442], [-122.50148, 37.91379], [-122.50255, 37.91364], [-122.50502, 37.91498], [-122.50518, 37.91505], [-122.50547, 37.91583], [-122.50551, 37.91583], [-122.50561, 37.91608]]]} Open Access 1 14088 Granada Park 19419 1070 Corte Madera, Town of 431 City 2 City Agency 2 http://www.ci.corte-madera.ca.us/199/Parks-Recreation City 2 1070 Corte Madera, Town of 425 City 2 City Agency 2   Marin 23 15.652 Granada Park 0 Local Park 2 4
9101 9101 9100 {"type": "Polygon", "coordinates": [[[-122.52993, 37.9261], [-122.52956, 37.92625], [-122.52956, 37.92628], [-122.52931, 37.92637], [-122.52891, 37.92591], [-122.52876, 37.92566], [-122.52974, 37.92583], [-122.52993, 37.9261]]]} Open Access 1 15085 Menke Park 22156 1070 Corte Madera, Town of 431 City 2 City Agency 2 http://www.ci.corte-madera.ca.us/199/Parks-Recreation City 2 1070 Corte Madera, Town of 425 City 2 City Agency 2   Marin 23 1.03 Menke Park 0 Local Park 2 4
9633 9633 9632 {"type": "Polygon", "coordinates": [[[-122.50693, 37.91553], [-122.50672, 37.91559], [-122.50657, 37.91514], [-122.50657, 37.91506], [-122.5066, 37.91498], [-122.50693, 37.91553]]]} Open Access 1 16244 Skunk Hollow Park 25531 1070 Corte Madera, Town of 431 City 2 City Agency 2 http://www.ci.corte-madera.ca.us/199/Parks-Recreation City 2 1070 Corte Madera, Town of 425 City 2 City Agency 2   Marin 23 0.217 Skunk Hollow 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]);