units_with_maps

Table actions

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

5 rows where AGNCY_NAME = 928, DES_TP = 2 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 5 ✖

DES_TP 1

  • Local Park · 5 ✖

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
9802 9802 9801 {"type": "Polygon", "coordinates": [[[-121.19792, 38.66885], [-121.19669, 38.66887], [-121.19669, 38.66908], [-121.19582, 38.66909], [-121.1958, 38.66856], [-121.19667, 38.66856], [-121.19668, 38.66847], [-121.19791, 38.66846], [-121.19792, 38.66885]]]} Open Access 1 47909 Norma Hamlin Park 32005 2248 Orangevale Recreation and Park District 928 Special District 4 Recreation/Parks District 4 http://www.orangevalecommunitycenter.com/ Special District 4 2248 Orangevale Recreation and Park District 901 Special District 4 Recreation/Parks District 4 https://www.ovparks.com/park/norma-hamlin-park/ Sacramento 41 2.262 Norma Hamlin Park 0 Local Park 2 4
11630 11630 11629 {"type": "Polygon", "coordinates": [[[-121.1973, 38.67486], [-121.19728, 38.6749], [-121.1966, 38.67543], [-121.19682, 38.67566], [-121.19587, 38.67651], [-121.19569, 38.67659], [-121.19469, 38.67548], [-121.19472, 38.67527], [-121.19431, 38.67517], [-121.19521, 38.67368], [-121.19527, 38.67365], [-121.19531, 38.67366], [-121.19614, 38.67396], [-121.19639, 38.674], [-121.19661, 38.67401], [-121.19679, 38.67434], [-121.19714, 38.67466], [-121.1973, 38.67486]]]} Open Access 1 23914 Palisades Park 23334 2248 Orangevale Recreation and Park District 928 Special District 4 Recreation/Parks District 4 http://www.orangevalecommunitycenter.com/ Special District 4 2248 Orangevale Recreation and Park District 901 Special District 4 Recreation/Parks District 4   Sacramento 41 11.697 Palisades Park 0 Local Park 2 4
11633 11633 11632 {"type": "Polygon", "coordinates": [[[-121.22338, 38.67296], [-121.22337, 38.6748], [-121.22113, 38.67476], [-121.22115, 38.67291], [-121.222, 38.67293], [-121.22209, 38.67295], [-121.22222, 38.67294], [-121.22338, 38.67296]]]} Open Access 1 23918 Pecan Park 23554 2248 Orangevale Recreation and Park District 928 Special District 4 Recreation/Parks District 4 http://www.orangevalecommunitycenter.com/ Special District 4 2248 Orangevale Recreation and Park District 901 Special District 4 Recreation/Parks District 4   Sacramento 41 9.861 Pecan Park 0 Local Park 2 4
11848 11848 11847 {"type": "Polygon", "coordinates": [[[-121.22504, 38.69618], [-121.22493, 38.70013], [-121.22491, 38.70017], [-121.22488, 38.70019], [-121.22411, 38.70023], [-121.22067, 38.70019], [-121.22073, 38.69821], [-121.2205, 38.69781], [-121.21967, 38.69806], [-121.21938, 38.69791], [-121.2192, 38.6983], [-121.21807, 38.69848], [-121.21802, 38.70012], [-121.21555, 38.70008], [-121.21573, 38.6973], [-121.21818, 38.69737], [-121.21826, 38.69582], [-121.2195, 38.69585], [-121.22, 38.69567], [-121.21989, 38.69527], [-121.21985, 38.69489], [-121.2199, 38.69299], [-121.22035, 38.69301], [-121.22058, 38.69304], [-121.22057, 38.6932], [-121.22075, 38.6933], [-121.22081, 38.69345], [-121.2208, 38.6936], [-121.22067, 38.69374], [-121.22061, 38.69503], [-121.22077, 38.69566], [-121.22089, 38.69595], [-121.22144, 38.69625], [-121.2232, 38.69624], [-121.22362, 38.69606], [-121.22384, 38.69619], [-121.22504, 38.69618]]]} Open Access 1 24281 Orangevale Community Park 23181 2248 Orangevale Recreation and Park District 928 Special District 4 Recreation/Parks District 4 http://www.orangevalecommunitycenter.com/ Special District 4 2248 Orangevale Recreation and Park District 901 Special District 4 Recreation/Parks District 4   Sacramento 41 76.518 Orangevale Community Park 0 Local Park 2 4
11850 11850 11849 {"type": "Polygon", "coordinates": [[[-121.24202, 38.67499], [-121.23976, 38.67498], [-121.23976, 38.67313], [-121.24201, 38.67315], [-121.24202, 38.67499]]]} Open Access 1 24284 Almond Park 15399 2248 Orangevale Recreation and Park District 928 Special District 4 Recreation/Parks District 4 http://www.orangevalecommunitycenter.com/ Special District 4 2248 Orangevale Recreation and Park District 901 Special District 4 Recreation/Parks District 4   Sacramento 41 9.905 Almond Park 0 Local Park 2 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]);