units_with_maps

Table actions

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

1 row where AGNCY_NAME = 352, DES_TP = 798 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 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
9567 9567 9566 {"type": "MultiPolygon", "coordinates": [[[[-122.54851, 38.01751], [-122.54807, 38.01783], [-122.54668, 38.01878], [-122.5461, 38.01881], [-122.54616, 38.01909], [-122.54534, 38.0194], [-122.5443, 38.01946], [-122.54386, 38.01956], [-122.54333, 38.01997], [-122.5432, 38.02059], [-122.54334, 38.02114], [-122.54273, 38.02102], [-122.54252, 38.01982], [-122.54384, 38.01894], [-122.54258, 38.01753], [-122.54261, 38.01707], [-122.54335, 38.01634], [-122.54396, 38.01636], [-122.54428, 38.01344], [-122.54761, 38.01477], [-122.54792, 38.01431], [-122.54832, 38.01447], [-122.54832, 38.01524], [-122.54812, 38.01595], [-122.54745, 38.01635], [-122.54789, 38.01735], [-122.54851, 38.01751]], [[-122.54646, 38.01768], [-122.54647, 38.01766], [-122.54612, 38.01729], [-122.54582, 38.01747], [-122.54617, 38.01784], [-122.54646, 38.01768]], [[-122.54732, 38.01475], [-122.54699, 38.01453], [-122.54649, 38.01497], [-122.54701, 38.01535], [-122.54753, 38.0149], [-122.54732, 38.01475]]], [[[-122.54844, 38.02215], [-122.54794, 38.02295], [-122.54801, 38.02299], [-122.54811, 38.02325], [-122.54828, 38.02336], [-122.54803, 38.02376], [-122.54773, 38.02364], [-122.54741, 38.02391], [-122.54734, 38.02398], [-122.5473, 38.02406], [-122.54728, 38.02412], [-122.54728, 38.02422], [-122.54719, 38.02423], [-122.54718, 38.02411], [-122.54722, 38.024], [-122.54729, 38.02389], [-122.54769, 38.02353], [-122.54777, 38.02341], [-122.54781, 38.02327], [-122.5478, 38.02314], [-122.54774, 38.02304], [-122.54762, 38.02293], [-122.54745, 38.02284], [-122.54704, 38.02324], [-122.54669, 38.02329], [-122.5474, 38.02367], [-122.54721, 38.02385], [-122.54714, 38.02392], [-122.54709, 38.02405], [-122.54707, 38.02419], [-122.547, 38.02416], [-122.54673, 38.02424], [-122.54674, 38.02381], [-122.54648, 38.02323], [-122.54605, 38.02322], [-122.5458, 38.0234], [-122.54575, 38.02263], [-122.5449, 38.02219], [-122.54295, 38.02283], [-122.54293, 38.02221], [-122.54412, 38.02152], [-122.54413, 38.02145], [-122.5445, 38.02153], [-122.54548, 38.0209], [-122.54549, 38.02063], [-122.54488, 38.0204], [-122.54488, 38.02019], [-122.54541, 38.02019], [-122.54641, 38.01981], [-122.54633, 38.02032], [-122.54667, 38.02032], [-122.54665, 38.02034], [-122.54632, 38.02036], [-122.54626, 38.021], [-122.54603, 38.02122], [-122.54709, 38.02155], [-122.54758, 38.02188], [-122.54795, 38.02165], [-122.54844, 38.02215]]]]} Open Access 1 16093 San Rafael Lands 013 24982 1312 San Rafael, City of 352 City 2 City Agency 2 http://www.cityofsanrafael.org/comsvcs-home/ City 2 1312 San Rafael, City of 349 City 2 City Agency 2   Marin 23 74.917 San Rafael Lands 013   None 798  

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