units_with_maps

Table actions

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

1 row where AGNCY_LEV = 2, DES_TP = 908 and MNG_AGENCY = 13

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Watsonville, City of · 1 ✖

DES_TP 1

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
10385 10385 10384 {"type": "MultiPolygon", "coordinates": [[[[-121.75798, 36.90047], [-121.75609, 36.90223], [-121.75611, 36.90226], [-121.75499, 36.90323], [-121.75435, 36.90281], [-121.75745, 36.9], [-121.75798, 36.90047]]], [[[-121.7549, 36.90335], [-121.75398, 36.90403], [-121.75397, 36.90404], [-121.75404, 36.9041], [-121.75393, 36.90419], [-121.75385, 36.90412], [-121.75302, 36.90471], [-121.75302, 36.90473], [-121.75318, 36.90486], [-121.75303, 36.90498], [-121.75285, 36.90484], [-121.75274, 36.90492], [-121.75192, 36.90572], [-121.75129, 36.90516], [-121.75418, 36.90287], [-121.7549, 36.90335]]], [[[-121.7517, 36.90586], [-121.75102, 36.90635], [-121.75031, 36.90574], [-121.75107, 36.9053], [-121.7517, 36.90586]]], [[[-121.75087, 36.90647], [-121.74933, 36.90761], [-121.7488, 36.90796], [-121.74787, 36.90716], [-121.75014, 36.90584], [-121.75087, 36.90647]]], [[[-121.74869, 36.90807], [-121.74724, 36.90915], [-121.74657, 36.90856], [-121.74774, 36.90725], [-121.74869, 36.90807]]], [[[-121.74709, 36.90922], [-121.7468, 36.90943], [-121.74689, 36.90952], [-121.74659, 36.90974], [-121.74637, 36.90955], [-121.74681, 36.90897], [-121.74709, 36.90922]]], [[[-121.74659, 36.90991], [-121.7464, 36.91005], [-121.74623, 36.90976], [-121.7463, 36.90965], [-121.74659, 36.90991]]], [[[-121.74673, 36.9089], [-121.7461, 36.90975], [-121.74647, 36.91034], [-121.74647, 36.91042], [-121.74633, 36.91063], [-121.74615, 36.91048], [-121.74624, 36.91032], [-121.74568, 36.90954], [-121.74647, 36.90867], [-121.74673, 36.9089]]], [[[-121.74633, 36.9108], [-121.74559, 36.9118], [-121.74559, 36.91223], [-121.74523, 36.91234], [-121.74523, 36.91163], [-121.74575, 36.91113], [-121.74609, 36.91058], [-121.74633, 36.9108]]], [[[-121.7435, 36.91546], [-121.74276, 36.91643], [-121.74016, 36.91708], [-121.74036, 36.91663], [-121.74123, 36.91631], [-121.74227, 36.91632], [-121.74311, 36.91554], [-121.7433, 36.91528], [-121.7435, 36.91546]]]]} Open Access 1 18349 Pajaro River 28155 1373 Watsonville, City of 13 City 2 City Agency 2 http://cityofwatsonville.org/parks-community-services City 2 1373 Watsonville, City of 13 City 2 City Agency 2   Santa Cruz 5 34.942 Pajaro River 0 None 908  

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]);