units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, COUNTY = 35, DES_TP = 14 and MNG_AGENCY = 206

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Placer, County of · 1 ✖

DES_TP 1

  • Local Other or Unknown · 1 ✖

ACCESS_TYP 1

  • Open 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
11201 11201 11200 {"type": "MultiPolygon", "coordinates": [[[[-121.09032, 38.92752], [-121.08899, 38.92751], [-121.08904, 38.92737], [-121.08902, 38.9272], [-121.0891, 38.92715], [-121.08911, 38.92713], [-121.08952, 38.92692], [-121.09032, 38.92752]]], [[[-121.09322, 38.9114], [-121.09322, 38.9114], [-121.0932, 38.91235], [-121.0925, 38.91175], [-121.0924, 38.91161], [-121.09248, 38.91126], [-121.09322, 38.9114]]], [[[-121.10842, 38.96386], [-121.10841, 38.96587], [-121.10722, 38.96588], [-121.10724, 38.96468], [-121.10758, 38.96467], [-121.10759, 38.96454], [-121.10799, 38.96452], [-121.10802, 38.96429], [-121.10802, 38.96387], [-121.10842, 38.96386]]], [[[-121.11189, 38.8014], [-121.11129, 38.80193], [-121.11155, 38.80292], [-121.11143, 38.80298], [-121.11116, 38.80195], [-121.10944, 38.8023], [-121.10946, 38.80121], [-121.11121, 38.80077], [-121.11189, 38.8014]]], [[[-121.16524, 38.84815], [-121.16497, 38.84816], [-121.16501, 38.84911], [-121.16461, 38.85055], [-121.16491, 38.85065], [-121.16489, 38.85075], [-121.16443, 38.85121], [-121.16384, 38.85088], [-121.16331, 38.851], [-121.16317, 38.85102], [-121.16297, 38.85101], [-121.16256, 38.85092], [-121.1622, 38.85081], [-121.16191, 38.85069], [-121.16137, 38.85044], [-121.16121, 38.84943], [-121.16162, 38.84848], [-121.16182, 38.84796], [-121.16182, 38.84763], [-121.16523, 38.84793], [-121.16524, 38.84815]]], [[[-121.17036, 38.75056], [-121.17013, 38.75052], [-121.17018, 38.75032], [-121.17036, 38.75056], [-121.17036, 38.75056]]], [[[-121.19966, 38.71425], [-121.19966, 38.7143], [-121.19913, 38.71429], [-121.19896, 38.71447], [-121.1989, 38.71496], [-121.19866, 38.71422], [-121.19966, 38.71425]]], [[[-121.2107, 38.71589], [-121.21067, 38.71612], [-121.21065, 38.71616], [-121.21032, 38.71625], [-121.21011, 38.71588], [-121.21011, 38.71584], [-121.2107, 38.71589]]], [[[-121.21429, 38.91194], [-121.21429, 38.91241], [-121.21387, 38.9124], [-121.21387, 38.91194], [-121.21429, 38.91194]]], [[[-121.26446, 38.90157], [-121.26445, 38.90515], [-121.26425, 38.90515], [-121.26416, 38.90157], [-121.26446, 38.90157]]], [[[-121.36418, 38.73603], [-121.36416, 38.73794], [-121.36413, 38.73794], [-121.36398, 38.73784], [-121.3637, 38.73776], [-121.36349, 38.7376], [-121.363, 38.73749], [-121.36225, 38.73719], [-121.36215, 38.73719], [-121.36209, 38.73718], [-121.36184, 38.73704], [-121.36178, 38.73697], [-121.36125, 38.73676], [-121.36104, 38.73669], [-121.36089, 38.73666], [-121.36055, 38.73658], [-121.36024, 38.73656], [-121.3601, 38.73652], [-121.35969, 38.73639], [-121.35915, 38.73615], [-121.35571, 38.73612], [-121.35551, 38.73628], [-121.35536, 38.73637], [-121.35499, 38.73649], [-121.35455, 38.7367], [-121.35413, 38.73684], [-121.35403, 38.737], [-121.35382, 38.73711], [-121.35357, 38.73717], [-121.35312, 38.73724], [-121.35291, 38.73726], [-121.35251, 38.73725], [-121.35219, 38.73737], [-121.35185, 38.73743], [-121.35167, 38.73742], [-121.35154, 38.7374], [-121.3514, 38.73742], [-121.35115, 38.7374], [-121.3509, 38.73741], [-121.35078, 38.73747], [-121.35058, 38.73753], [-121.35036, 38.73758], [-121.3501, 38.73762], [-121.34916, 38.73764], [-121.34881, 38.73769], [-121.34848, 38.73776], [-121.34825, 38.73778], [-121.34801, 38.73778], [-121.34764, 38.73782], [-121.34759, 38.73785], [-121.34757, 38.73791], [-121.34729, 38.73818], [-121.34712, 38.73829], [-121.34699, 38.73835], [-121.34685, 38.73837], [-121.34659, 38.73839], [-121.34644, 38.73843], [-121.34627, 38.73843], [-121.34611, 38.73838], [-121.34604, 38.73834], [-121.34594, 38.73822], [-121.34608, 38.73822], [-121.34603, 38.73724], [-121.34469, 38.73735], [-121.34441, 38.73735], [-121.34441, 38.73758], [-121.3443, 38.73756], [-121.34416, 38.73757], [-121.34418, 38.73812], [-121.34405, 38.73811], [-121.34374, 38.73807], [-121.34346, 38.738], [-121.34308, 38.73784], [-121.34284, 38.73777], [-121.34262, 38.73774], [-121.34259, 38.73729], [-121.34152, 38.73724], [-121.34068, 38.73673], [-121.33915, 38.73671], [-121.33913, 38.7363], [-121.33922, 38.73629], [-121.33916, 38.73506], [-121.33718, 38.73512], [-121.33715, 38.73424], [-121.33717, 38.7342], [-121.33721, 38.73418], [-121.3379, 38.73419], [-121.33892, 38.73429], [-121.33902, 38.73434], [-121.3391, 38.73436], [-121.33922, 38.73434], [-121.3393, 38.73427], [-121.3401, 38.73437], [-121.34013, 38.73434], [-121.3402, 38.73437], [-121.34027, 38.73437], [-121.34028, 38.7344], [-121.34037, 38.73443], [-121.34106, 38.73449], [-121.3411, 38.73448], [-121.34115, 38.73452], [-121.34121, 38.73454], [-121.34129, 38.73453], [-121.34134, 38.73449], [-121.34153, 38.73454], [-121.34176, 38.73456], [-121.34204, 38.73456], [-121.34209, 38.73453], [-121.34214, 38.73457], [-121.3422, 38.73458], [-121.34228, 38.73457], [-121.3423, 38.73458], [-121.34305, 38.73467], [-121.34309, 38.73464], [-121.34334, 38.73567], [-121.34433, 38.73573], [-121.34442, 38.73547], [-121.34429, 38.7351], [-121.34423, 38.73478], [-121.34455, 38.73481], [-121.34481, 38.73468], [-121.34471, 38.73398], [-121.3447, 38.73376], [-121.34481, 38.73374], [-121.34483, 38.73387], [-121.34489, 38.73414], [-121.345, 38.73435], [-121.34523, 38.7345], [-121.34536, 38.73444], [-121.34543, 38.73446], [-121.3455, 38.73445], [-121.34569, 38.7346], [-121.34596, 38.73463], [-121.34601, 38.73656], [-121.34642, 38.73654], [-121.34667, 38.73655], [-121.34686, 38.73649], [-121.347, 38.73648], [-121.34711, 38.73652], [-121.34717, 38.73652], [-121.34743, 38.73649], [-121.34765, 38.73642], [-121.34776, 38.73641], [-121.34815, 38.73641], [-121.34836, 38.73638], [-121.34879, 38.73637], [-121.34961, 38.73621], [-121.34979, 38.73614], [-121.35002, 38.73609], [-121.35105, 38.736], [-121.35131, 38.73601], [-121.35181, 38.73609], [-121.35205, 38.73611], [-121.35227, 38.73609], [-121.35249, 38.73604], [-121.35278, 38.73593], [-121.35288, 38.73588], [-121.35315, 38.73579], [-121.35347, 38.73573], [-121.35377, 38.73563], [-121.35424, 38.73538], [-121.35453, 38.73531], [-121.35525, 38.73526], [-121.35527, 38.73533], [-121.3563, 38.73519], [-121.35759, 38.73512], [-121.35842, 38.73485], [-121.35855, 38.73486], [-121.35859, 38.73347], [-121.35997, 38.73348], [-121.35996, 38.73507], [-121.36418, 38.73603]]], [[[-121.35534, 38.7287], [-121.35473, 38.72871], [-121.35474, 38.72597], [-121.35533, 38.72601], [-121.35534, 38.7287]]], [[[-121.35947, 38.74338], [-121.3557, 38.74339], [-121.35569, 38.74319], [-121.35683, 38.74281], [-121.3573, 38.74261], [-121.35753, 38.74248], [-121.35756, 38.74227], [-121.35775, 38.74204], [-121.35778, 38.74191], [-121.3581, 38.7422], [-121.35805, 38.74223], [-121.35803, 38.74229], [-121.35803, 38.74234], [-121.35809, 38.74239], [-121.35805, 38.74253], [-121.35808, 38.74259], [-121.35878, 38.74283], [-121.35927, 38.74289], [-121.35932, 38.74295], [-121.35943, 38.74297], [-121.35947, 38.74338]]], [[[-121.36024, 38.74782], [-121.36, 38.74792], [-121.35993, 38.74793], [-121.35977, 38.74778], [-121.35954, 38.74764], [-121.35948, 38.74758], [-121.3593, 38.74753], [-121.35921, 38.74755], [-121.35871, 38.74751], [-121.35877, 38.74736], [-121.35876, 38.74731], [-121.35869, 38.74725], [-121.35854, 38.74724], [-121.35855, 38.74713], [-121.35841, 38.74712], [-121.35812, 38.74728], [-121.35793, 38.74732], [-121.35774, 38.74731], [-121.35747, 38.74724], [-121.3572, 38.74749], [-121.35754, 38.74771], [-121.35749, 38.74778], [-121.35748, 38.74783], [-121.3575, 38.74788], [-121.35645, 38.74844], [-121.35611, 38.74844], [-121.35591, 38.74848], [-121.35587, 38.7469], [-121.35583, 38.74667], [-121.35575, 38.7464], [-121.35671, 38.74638], [-121.3568, 38.74641], [-121.35698, 38.74641], [-121.35707, 38.74638], [-121.35812, 38.74637], [-121.35833, 38.74635], [-121.35851, 38.7463], [-121.35867, 38.74625], [-121.3588, 38.74617], [-121.35893, 38.74608], [-121.35903, 38.74598], [-121.35912, 38.74585], [-121.35918, 38.74571], [-121.35921, 38.74559], [-121.3602, 38.74559], [-121.36024, 38.74782]]], [[[-121.35831, 38.72866], [-121.35777, 38.72867], [-121.35777, 38.72865], [-121.35812, 38.72841], [-121.35831, 38.72841], [-121.35831, 38.72866]]], [[[-121.37271, 38.97789], [-121.37246, 38.97789], [-121.37226, 38.97768], [-121.37258, 38.97773], [-121.37271, 38.97789]]], [[[-121.38384, 38.89801], [-121.38331, 38.89801], [-121.38331, 38.89764], [-121.38383, 38.89764], [-121.38384, 38.89801]]]]} Open Access 1 21471 Placer County Land 8673 314 Placer, County of 210 County 3 County Agency 3 http://www.placer.ca.gov/departments/facility/parks County 3 314 Placer, County of 206 County 3 County Agency 3   Placer 35 180.682 Placer County Land 0 Local Other or Unknown 14 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]);