units_with_maps

Table actions

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

14 rows where ACCESS_TYP = 3, GAP_STS = 4 and MNG_AGENCY = 4

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA

MNG_AG_TYP 1

MNG_AGENCY 1

  • San Diego, City of · 14 ✖

ACCESS_TYP 1

  • No Public Access · 14 ✖
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
1339 1339 1338 {"type": "Polygon", "coordinates": [[[-116.73714, 32.58342], [-116.74114, 32.58362], [-116.74116, 32.57636], [-116.73709, 32.57624], [-116.73707, 32.57262], [-116.74115, 32.5727], [-116.74116, 32.5691], [-116.73703, 32.56906], [-116.73696, 32.56738], [-116.75384, 32.56596], [-116.75385, 32.56579], [-116.80114, 32.56182], [-116.80119, 32.56352], [-116.79687, 32.56361], [-116.79696, 32.56738], [-116.78817, 32.56748], [-116.78397, 32.56787], [-116.78402, 32.57978], [-116.77099, 32.58015], [-116.76217, 32.58046], [-116.76212, 32.58426], [-116.75374, 32.58427], [-116.75371, 32.58796], [-116.75367, 32.59538], [-116.74509, 32.59534], [-116.74513, 32.59151], [-116.72846, 32.59121], [-116.72857, 32.58727], [-116.73278, 32.58732], [-116.7329, 32.5834], [-116.73714, 32.58342]]]} No Public Access 3 7398 Marron Valley Mitigation Bank 21885 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 2644.0 Marron Valley Mitigation Bank 0 Local Other or Unknown 14 4
3846 3846 3845 {"type": "Polygon", "coordinates": [[[-117.22388, 32.93759], [-117.22376, 32.93764], [-117.22348, 32.9376], [-117.22333, 32.93761], [-117.22215, 32.93794], [-117.22194, 32.93802], [-117.22151, 32.93822], [-117.22151, 32.93456], [-117.22388, 32.93457], [-117.22388, 32.93759]]]} No Public Access 3 46811 Neighborhood 8 Neighborhood Park 30272 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 19.773 Neighborhood 8 Neighborhood Park 0 Local Park 2 4
4532 4532 4531 {"type": "MultiPolygon", "coordinates": [[[[-117.21241, 32.80723], [-117.21239, 32.80731], [-117.21232, 32.80734], [-117.2111, 32.80742], [-117.21111, 32.80697], [-117.21157, 32.80696], [-117.21172, 32.80698], [-117.21219, 32.80709], [-117.21237, 32.80716], [-117.21241, 32.80723]]], [[[-117.21219, 32.80689], [-117.21219, 32.80695], [-117.21195, 32.80689], [-117.21219, 32.80689], [-117.21219, 32.80689]]]]} No Public Access 3 18410 Unnamed site - San Diego, City of 31719 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 1.217   0 Local Other or Unknown 14 4
4535 4535 4534 {"type": "Polygon", "coordinates": [[[-117.23982, 32.87111], [-117.23981, 32.87152], [-117.23927, 32.87152], [-117.23951, 32.87136], [-117.23982, 32.87111]]]} No Public Access 3 19896 Unnamed site - San Diego, City of 31719 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 0.273   0 Local Other or Unknown 14 4
4536 4536 4535 {"type": "Polygon", "coordinates": [[[-117.1276, 32.76738], [-117.12717, 32.76784], [-117.12705, 32.76778], [-117.12742, 32.76738], [-117.1276, 32.76738]]]} No Public Access 3 19905 Unnamed site - San Diego, City of 31719 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 0.196   0 Local Other or Unknown 14 4
4537 4537 4536 {"type": "Polygon", "coordinates": [[[-117.10461, 32.76969], [-117.10445, 32.76969], [-117.10461, 32.76951], [-117.10461, 32.76969], [-117.10461, 32.76969]]]} No Public Access 3 19907 Unnamed site - San Diego, City of 31719 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 0.035   0 Local Other or Unknown 14 4
4785 4785 4784 {"type": "Polygon", "coordinates": [[[-117.23137, 32.88833], [-117.22878, 32.89057], [-117.22879, 32.89385], [-117.22675, 32.89645], [-117.22675, 32.89619], [-117.22726, 32.89551], [-117.22708, 32.8954], [-117.22721, 32.89514], [-117.22753, 32.89435], [-117.22772, 32.89381], [-117.22795, 32.89294], [-117.22797, 32.89271], [-117.22797, 32.89157], [-117.22795, 32.89107], [-117.22798, 32.89083], [-117.22816, 32.89009], [-117.22833, 32.89009], [-117.22872, 32.88902], [-117.22917, 32.88808], [-117.22989, 32.8883], [-117.23011, 32.88786], [-117.23073, 32.88808], [-117.23137, 32.88833]]]} No Public Access 3 47655 Unnamed site - San Diego, City of 31719 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 20.801   0 Local Other or Unknown 14 4
4786 4786 4785 {"type": "MultiPolygon", "coordinates": [[[[-116.87263, 32.64332], [-116.87061, 32.64522], [-116.87029, 32.64505], [-116.87093, 32.64366], [-116.87252, 32.64297], [-116.87263, 32.64332]]], [[[-116.87285, 32.64414], [-116.87285, 32.64414], [-116.87206, 32.64428], [-116.87271, 32.64366], [-116.87285, 32.64414]]]]} No Public Access 3 47661 Unnamed site - San Diego, City of 31719 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 5.302   0 Local Other or Unknown 14 4
6608 6608 6607 {"type": "Polygon", "coordinates": [[[-117.03964, 32.5565], [-117.03952, 32.55674], [-117.03854, 32.5569], [-117.03824, 32.55697], [-117.03804, 32.55697], [-117.03763, 32.55706], [-117.03762, 32.55704], [-117.03717, 32.55717], [-117.03738, 32.55766], [-117.03743, 32.55783], [-117.03746, 32.55795], [-117.03747, 32.55822], [-117.03369, 32.55819], [-117.03357, 32.55452], [-117.03776, 32.55454], [-117.03928, 32.55638], [-117.03964, 32.5565]]]} No Public Access 3 4168 Beyer Community Park 30224 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 43.828 Beyer Community Park 0 Local Park 2 4
9993 9993 9992 {"type": "Polygon", "coordinates": [[[-117.00987, 32.55768], [-117.00557, 32.5576], [-117.00555, 32.56025], [-117.00128, 32.56018], [-117.00126, 32.55751], [-116.99834, 32.55745], [-116.99769, 32.55743], [-116.99699, 32.55743], [-116.99699, 32.55385], [-116.99614, 32.55382], [-116.99588, 32.55353], [-116.99536, 32.55264], [-116.99513, 32.55248], [-116.99481, 32.55243], [-116.99449, 32.55257], [-116.99356, 32.55323], [-116.993, 32.55322], [-116.99287, 32.55313], [-116.99284, 32.55268], [-116.99337, 32.55212], [-116.99346, 32.55187], [-116.99337, 32.55162], [-116.99317, 32.55135], [-116.9927, 32.55115], [-116.99269, 32.55005], [-116.99912, 32.55022], [-116.99914, 32.55328], [-116.99985, 32.5533], [-116.99986, 32.55391], [-117.00986, 32.55413], [-117.00985, 32.55619], [-117.00987, 32.55768]]]} No Public Access 3 47971 Otay Mitigation Site 32285 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 200.028 Otay Mitigation Site 0 Local Other or Unknown 14 4
10000 10000 9999 {"type": "Polygon", "coordinates": [[[-117.00123, 32.56466], [-117.00121, 32.56728], [-117.00107, 32.56728], [-117.00106, 32.56732], [-117.00068, 32.56736], [-117.00055, 32.56745], [-117.00053, 32.56778], [-117.00042, 32.56807], [-116.99905, 32.56804], [-116.99908, 32.56463], [-117.00123, 32.56466]]]} No Public Access 3 47970 Otay Mesa Open Space 32281 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 17.649 Otay Mesa OS 0 Local Recreation Area 3 4
10005 10005 10004 {"type": "Polygon", "coordinates": [[[-117.13531, 32.80963], [-117.13296, 32.80967], [-117.13295, 32.80886], [-117.13279, 32.80885], [-117.13274, 32.80882], [-117.13263, 32.8087], [-117.13257, 32.80854], [-117.13257, 32.80843], [-117.13265, 32.80791], [-117.13264, 32.80786], [-117.1326, 32.8078], [-117.13254, 32.80778], [-117.13225, 32.80775], [-117.13215, 32.80763], [-117.13295, 32.80762], [-117.13296, 32.80837], [-117.13529, 32.80833], [-117.13531, 32.80963]]]} No Public Access 3 47974 City of San Diego Open Space 32304 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 9.034 City of San Diego OS 0 Local Recreation Area 3 4
15451 15451 15450 {"type": "Polygon", "coordinates": [[[-117.10104, 32.96786], [-117.0991, 32.9694], [-117.09768, 32.96813], [-117.0991, 32.96695], [-117.0996, 32.96659], [-117.10104, 32.96786]]]} No Public Access 3 46721 Penasquitos Village Neighborhood Park 30267 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 12.044 Penasquitos Village Neighborhood Park 0 Local Park 2 4
16087 16087 16086 {"type": "MultiPolygon", "coordinates": [[[[-116.90152, 33.10587], [-116.89724, 33.10587], [-116.89719, 33.10206], [-116.89513, 33.10205], [-116.89508, 33.10392], [-116.89076, 33.10399], [-116.89074, 33.10215], [-116.89295, 33.10209], [-116.89298, 33.09483], [-116.89275, 33.08392], [-116.90146, 33.08384], [-116.90148, 33.08369], [-116.90146, 33.08771], [-116.89987, 33.08735], [-116.8997, 33.08734], [-116.89919, 33.08738], [-116.89898, 33.08738], [-116.89802, 33.08726], [-116.89789, 33.08727], [-116.89777, 33.0873], [-116.89716, 33.08761], [-116.89689, 33.08767], [-116.89679, 33.08771], [-116.8967, 33.08775], [-116.89665, 33.08781], [-116.89661, 33.08793], [-116.89663, 33.08808], [-116.89657, 33.08829], [-116.89633, 33.08876], [-116.89605, 33.08912], [-116.89595, 33.08934], [-116.89596, 33.08943], [-116.89612, 33.08973], [-116.89632, 33.08999], [-116.89646, 33.09033], [-116.89664, 33.09052], [-116.8967, 33.09062], [-116.89672, 33.09068], [-116.89672, 33.09073], [-116.89656, 33.09103], [-116.89643, 33.09145], [-116.89626, 33.09176], [-116.896, 33.09212], [-116.89594, 33.09225], [-116.89588, 33.09244], [-116.89584, 33.09273], [-116.89577, 33.09306], [-116.89575, 33.09322], [-116.89565, 33.0938], [-116.89555, 33.09451], [-116.8955, 33.09464], [-116.89534, 33.09481], [-116.8955, 33.09482], [-116.8956, 33.09471], [-116.89567, 33.0946], [-116.89578, 33.09376], [-116.89588, 33.09326], [-116.89589, 33.09313], [-116.89607, 33.09227], [-116.89614, 33.09212], [-116.89637, 33.09182], [-116.89654, 33.09153], [-116.89666, 33.09113], [-116.89684, 33.09077], [-116.89685, 33.09067], [-116.89684, 33.09059], [-116.89674, 33.09046], [-116.89664, 33.09036], [-116.89658, 33.09028], [-116.89643, 33.08994], [-116.89626, 33.08971], [-116.89609, 33.0894], [-116.89609, 33.08935], [-116.89617, 33.08916], [-116.89644, 33.08879], [-116.89669, 33.08833], [-116.89675, 33.08817], [-116.89675, 33.0879], [-116.89678, 33.08784], [-116.89693, 33.08777], [-116.89718, 33.08773], [-116.89783, 33.0874], [-116.89791, 33.08737], [-116.89801, 33.08737], [-116.89902, 33.08748], [-116.89923, 33.08748], [-116.89969, 33.08745], [-116.89986, 33.08746], [-116.90146, 33.08783], [-116.90149, 33.09135], [-116.90152, 33.10587]]], [[[-116.91016, 33.11349], [-116.90585, 33.11346], [-116.90585, 33.12475], [-116.89299, 33.12481], [-116.89298, 33.12095], [-116.90158, 33.12097], [-116.90154, 33.11025], [-116.91014, 33.11012], [-116.91016, 33.11349]]]]} No Public Access 3 47726 San Pasqual Trails Open Space 31514 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2 https://www.sandiego.gov/park-and-recreation/parks/osp/sanpasqual San Diego 4 738.003 San Pasqual Trails 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]);