units_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, DES_TP = 3 and MNG_AGENCY = 533

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Roseville, City of · 1 ✖

DES_TP 1

  • Local Recreation Area · 1 ✖

ACCESS_TYP 1

  • No Public Access · 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
16198 16198 16197 {"type": "MultiPolygon", "coordinates": [[[[-121.34941, 38.79537], [-121.34798, 38.79538], [-121.34717, 38.79574], [-121.34689, 38.7957], [-121.3466, 38.79572], [-121.34636, 38.79581], [-121.34598, 38.79589], [-121.34575, 38.79591], [-121.34553, 38.79633], [-121.34539, 38.79642], [-121.34546, 38.79651], [-121.34533, 38.79656], [-121.34503, 38.79653], [-121.34482, 38.79647], [-121.34463, 38.79639], [-121.3443, 38.79618], [-121.34403, 38.79595], [-121.34386, 38.79578], [-121.34362, 38.79541], [-121.34649, 38.79539], [-121.34649, 38.79424], [-121.34613, 38.79383], [-121.34831, 38.79267], [-121.34883, 38.79244], [-121.3494, 38.79224], [-121.34941, 38.79537]]], [[[-121.35801, 38.79652], [-121.35705, 38.79746], [-121.35665, 38.79764], [-121.35666, 38.79765], [-121.35697, 38.79762], [-121.35696, 38.79774], [-121.35703, 38.79776], [-121.35705, 38.7978], [-121.35693, 38.79835], [-121.35683, 38.79867], [-121.35669, 38.79897], [-121.35642, 38.79941], [-121.35463, 38.7994], [-121.35463, 38.79941], [-121.3554, 38.80031], [-121.35405, 38.80103], [-121.35391, 38.8008], [-121.35328, 38.79965], [-121.3533, 38.7996], [-121.35353, 38.79945], [-121.35364, 38.79932], [-121.35372, 38.79919], [-121.35377, 38.79905], [-121.35364, 38.79904], [-121.35357, 38.7992], [-121.35348, 38.79933], [-121.35336, 38.79943], [-121.35313, 38.79954], [-121.35287, 38.7996], [-121.35269, 38.7996], [-121.35251, 38.79957], [-121.35235, 38.79951], [-121.35213, 38.79937], [-121.35199, 38.79919], [-121.35172, 38.79852], [-121.35169, 38.79835], [-121.35168, 38.79824], [-121.35161, 38.79817], [-121.3515, 38.79816], [-121.35015, 38.79832], [-121.3494, 38.79846], [-121.34939, 38.7984], [-121.3487, 38.79854], [-121.34812, 38.79871], [-121.34791, 38.79878], [-121.34731, 38.79909], [-121.34697, 38.79912], [-121.34689, 38.79916], [-121.34667, 38.79889], [-121.34614, 38.79806], [-121.34599, 38.79788], [-121.34656, 38.79754], [-121.34683, 38.79753], [-121.34706, 38.79734], [-121.34744, 38.79725], [-121.34749, 38.79719], [-121.3479, 38.79713], [-121.34798, 38.79701], [-121.34794, 38.79683], [-121.348, 38.79653], [-121.34805, 38.79653], [-121.34824, 38.79633], [-121.34851, 38.79618], [-121.34862, 38.796], [-121.34879, 38.79586], [-121.34941, 38.79566], [-121.34942, 38.79647], [-121.35801, 38.79652]]], [[[-121.3539, 38.80109], [-121.35254, 38.80165], [-121.35206, 38.80044], [-121.35202, 38.80031], [-121.35203, 38.80017], [-121.35208, 38.80001], [-121.35231, 38.79968], [-121.35239, 38.79965], [-121.35266, 38.7997], [-121.35285, 38.7997], [-121.35306, 38.79968], [-121.35311, 38.7997], [-121.35375, 38.80085], [-121.3539, 38.80109]]]]} No Public Access 3 29577 Veterans Memorial Park Open Space 27036 1285 Roseville, City of 540 City 2 City Agency 2 http://www.roseville.ca.us/parks/default.asp City 2 1285 Roseville, City of 533 City 2 City Agency 2   Placer 35 95.757 Veterans Memorial Park OS 0 Local Recreation Area 3 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]);