units_with_maps

Table actions

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

5 rows where AGNCY_LEV = 2, MNG_AGENCY = 632 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 5 ✖

MNG_AGENCY 1

  • Rio Dell, City of · 5 ✖
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
3459 3459 3458 {"type": "Polygon", "coordinates": [[[-124.10794, 40.50115], [-124.10684, 40.50146], [-124.10667, 40.50143], [-124.10657, 40.50108], [-124.10649, 40.50061], [-124.10638, 40.4999], [-124.10749, 40.49987], [-124.10765, 40.50033], [-124.10794, 40.50115]]]} Open Access 1 25412 Firemans Park and Picnic Area 18912 1435 Rio Dell, City of 642 City 2 City Agency 2 http://www.riodellcity.com/ City 2 1435 Rio Dell, City of 632 City 2 City Agency 2   Humboldt 45 4.191 Firemans Park and Picnic Area 0 Local Recreation Area 3 4
4769 4769 4768 {"type": "Polygon", "coordinates": [[[-124.10344, 40.4928], [-124.10326, 40.49301], [-124.10325, 40.49313], [-124.10297, 40.49314], [-124.10296, 40.49296], [-124.103, 40.49297], [-124.10313, 40.4928], [-124.10344, 40.4928]]]} Unknown Access 4 46929 Unnamed site - Rio Dell, City of 30545 1435 Rio Dell, City of 642 City 2 City Agency 2 http://www.riodellcity.com/ City 2 1435 Rio Dell, City of 632 City 2 City Agency 2   Humboldt 45 0.236   0 Local Other or Unknown 14 4
4770 4770 4769 {"type": "MultiPolygon", "coordinates": [[[[-124.10601, 40.49914], [-124.10572, 40.49916], [-124.10573, 40.49867], [-124.10555, 40.49848], [-124.10587, 40.49829], [-124.10601, 40.49914]]], [[[-124.10652, 40.49814], [-124.10615, 40.49811], [-124.10585, 40.49742], [-124.10652, 40.49814], [-124.10652, 40.49814]]]]} Open Access 1 46930 Unknown park - Rio Dell, City of 30546 1435 Rio Dell, City of 642 City 2 City Agency 2 http://www.riodellcity.com/ City 2 1435 Rio Dell, City of 632 City 2 City Agency 2 http://www.riodellcity.com/planning-pdf/Rio%20Dell%20Zoning%20Map.pdf Humboldt 45 0.75   0 Local Other or Unknown 14 4
4774 4774 4773 {"type": "Polygon", "coordinates": [[[-124.10655, 40.50715], [-124.10654, 40.50718], [-124.10649, 40.5072], [-124.10591, 40.5071], [-124.10587, 40.50708], [-124.10587, 40.50705], [-124.10588, 40.50702], [-124.10605, 40.50694], [-124.10617, 40.50686], [-124.1063, 40.50671], [-124.10635, 40.50669], [-124.1064, 40.50673], [-124.10649, 40.50701], [-124.10655, 40.50715]]]} Open Access 1 46937 Unnamed site - Rio Dell, City of 30560 1435 Rio Dell, City of 642 City 2 City Agency 2 http://www.riodellcity.com/ City 2 1435 Rio Dell, City of 632 City 2 City Agency 2   Humboldt 45 0.418   0 Local Other or Unknown 14 4
5643 5643 5642 {"type": "Polygon", "coordinates": [[[-124.1067, 40.4986], [-124.10642, 40.49873], [-124.10646, 40.49915], [-124.10623, 40.49904], [-124.10611, 40.49827], [-124.10632, 40.49821], [-124.1067, 40.4986]]]} Open Access 1 46931 Rio Dell City Hall Grounds 30548 1435 Rio Dell, City of 642 City 2 City Agency 2 http://www.riodellcity.com/ City 2 1435 Rio Dell, City of 632 City 2 City Agency 2   Humboldt 45 0.64 Rio Dell City Hall Grounds   None 457  

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