units_with_maps

Table actions

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

1 row where AGNCY_TYP = 7 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 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
15865 15865 15864 {"type": "MultiPolygon", "coordinates": [[[[-122.0804, 37.33059], [-122.07911, 37.33194], [-122.07887, 37.33225], [-122.07852, 37.33283], [-122.07839, 37.33296], [-122.07824, 37.33308], [-122.07806, 37.33317], [-122.0779, 37.33323], [-122.0777, 37.33327], [-122.07749, 37.33329], [-122.07719, 37.33326], [-122.07646, 37.33309], [-122.07616, 37.33298], [-122.0759, 37.33282], [-122.07512, 37.33223], [-122.07517, 37.33218], [-122.075, 37.33205], [-122.07457, 37.3319], [-122.07427, 37.33187], [-122.0741, 37.33188], [-122.07394, 37.33192], [-122.07381, 37.33196], [-122.07365, 37.33205], [-122.07206, 37.3311], [-122.07206, 37.33082], [-122.07203, 37.3306], [-122.07191, 37.3303], [-122.07159, 37.32924], [-122.07162, 37.32837], [-122.07169, 37.32817], [-122.07164, 37.32819], [-122.07199, 37.32751], [-122.07218, 37.32722], [-122.07236, 37.32698], [-122.0726, 37.32671], [-122.07293, 37.32637], [-122.07419, 37.328], [-122.07498, 37.32761], [-122.0754, 37.32786], [-122.07518, 37.32786], [-122.07498, 37.32791], [-122.07421, 37.32834], [-122.07364, 37.32859], [-122.0734, 37.32901], [-122.07399, 37.32932], [-122.0742, 37.32947], [-122.07441, 37.32968], [-122.07451, 37.32976], [-122.0749, 37.32995], [-122.07499, 37.33001], [-122.07505, 37.33011], [-122.07509, 37.33039], [-122.07516, 37.33057], [-122.07531, 37.33078], [-122.07548, 37.33094], [-122.07556, 37.33096], [-122.07568, 37.33097], [-122.07584, 37.33069], [-122.07581, 37.33049], [-122.07586, 37.33048], [-122.07591, 37.3308], [-122.07617, 37.33078], [-122.07631, 37.3307], [-122.07637, 37.33064], [-122.07641, 37.33057], [-122.0765, 37.33004], [-122.07654, 37.32995], [-122.07659, 37.32988], [-122.07717, 37.32944], [-122.07744, 37.32908], [-122.07777, 37.32876], [-122.07795, 37.32854], [-122.07806, 37.32847], [-122.07841, 37.32835], [-122.07862, 37.32865], [-122.07828, 37.32882], [-122.07805, 37.329], [-122.07792, 37.32916], [-122.07758, 37.3297], [-122.07726, 37.33003], [-122.07714, 37.33023], [-122.07707, 37.33044], [-122.07706, 37.33061], [-122.0771, 37.33083], [-122.07718, 37.33097], [-122.07727, 37.33104], [-122.07738, 37.33108], [-122.07752, 37.3311], [-122.07765, 37.33109], [-122.0788, 37.33073], [-122.07912, 37.33069], [-122.07945, 37.33069], [-122.07961, 37.33066], [-122.07971, 37.33062], [-122.0798, 37.33056], [-122.07995, 37.33039], [-122.08027, 37.33047], [-122.08037, 37.33053], [-122.0804, 37.33059]]], [[[-122.09473, 37.33238], [-122.09235, 37.33433], [-122.09064, 37.33625], [-122.09065, 37.33627], [-122.09121, 37.33637], [-122.09143, 37.33688], [-122.09264, 37.33738], [-122.09274, 37.33777], [-122.09261, 37.33784], [-122.09259, 37.33801], [-122.09264, 37.33813], [-122.09253, 37.33838], [-122.09261, 37.33856], [-122.09263, 37.33887], [-122.09236, 37.339], [-122.09235, 37.33918], [-122.09225, 37.33932], [-122.09212, 37.33941], [-122.09221, 37.33983], [-122.09233, 37.33997], [-122.09241, 37.34002], [-122.09238, 37.34017], [-122.09249, 37.34025], [-122.09218, 37.34026], [-122.09215, 37.34046], [-122.09211, 37.34046], [-122.09049, 37.34012], [-122.09059, 37.33993], [-122.09047, 37.33989], [-122.09042, 37.33999], [-122.09034, 37.34004], [-122.09024, 37.34006], [-122.09013, 37.34003], [-122.0901, 37.33986], [-122.09036, 37.33976], [-122.0905, 37.33961], [-122.09053, 37.33941], [-122.09044, 37.33903], [-122.09092, 37.33661], [-122.09047, 37.33629], [-122.09028, 37.33609], [-122.08985, 37.3355], [-122.08954, 37.33515], [-122.08932, 37.33505], [-122.08907, 37.33483], [-122.08904, 37.33463], [-122.08866, 37.33444], [-122.08801, 37.33377], [-122.08797, 37.3336], [-122.08465, 37.33407], [-122.08444, 37.33341], [-122.08436, 37.33305], [-122.0842, 37.33304], [-122.08372, 37.33307], [-122.08364, 37.333], [-122.08351, 37.33202], [-122.08345, 37.33183], [-122.08336, 37.33166], [-122.08329, 37.33156], [-122.08319, 37.33158], [-122.08283, 37.33112], [-122.08291, 37.33106], [-122.08277, 37.3309], [-122.08255, 37.33073], [-122.08228, 37.33062], [-122.08133, 37.33037], [-122.08113, 37.33035], [-122.08095, 37.33036], [-122.08089, 37.33033], [-122.08089, 37.3303], [-122.08095, 37.33011], [-122.08097, 37.32994], [-122.08133, 37.32995], [-122.08169, 37.33002], [-122.08163, 37.32923], [-122.08215, 37.32883], [-122.08309, 37.32961], [-122.08438, 37.32863], [-122.0822, 37.32546], [-122.0823, 37.32525], [-122.08187, 37.32442], [-122.08104, 37.32418], [-122.07777, 37.32433], [-122.0777, 37.32419], [-122.07865, 37.32325], [-122.08156, 37.32373], [-122.08156, 37.32393], [-122.08178, 37.32422], [-122.08245, 37.32423], [-122.08247, 37.32371], [-122.08256, 37.32371], [-122.08485, 37.32496], [-122.08863, 37.32607], [-122.09346, 37.33005], [-122.09473, 37.33238]], [[-122.08557, 37.3273], [-122.08518, 37.32711], [-122.08493, 37.32727], [-122.08497, 37.32799], [-122.08527, 37.32828], [-122.08562, 37.32905], [-122.08573, 37.32906], [-122.08596, 37.32807], [-122.08593, 37.32797], [-122.08576, 37.32776], [-122.08557, 37.3273]]]]} Open Access 1 27 Rancho San Antonio Open Space Preserve 31458 326 Santa Clara County Parks and Recreation Dept., County of 472 County 3 County Agency - Parks 7 http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx County 3 2079 Midpeninsula Regional Open Space District 631 Special District 4 Recreation/Parks District 4 https://www.sccgov.org/sites/parks/parkfinder/Pages/RanchoSanAntonio.aspx Santa Clara 19 282.56 Rancho San Antonio OSP 0 Local Conservation Area 4 2

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