units_with_maps

Table actions

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

24 rows where AGNCY_LEV = 4, DES_TP = 2, MNG_AGENCY = 382 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 24 ✖

MNG_AGENCY 1

  • North of the River Recreation and Park District · 24 ✖

DES_TP 1

  • Local Park · 24 ✖

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
1569 1569 1568 {"type": "Polygon", "coordinates": [[[-119.03325, 35.4423], [-119.03318, 35.445], [-119.03099, 35.44499], [-119.031, 35.44318], [-119.03103, 35.44277], [-119.03106, 35.44272], [-119.03106, 35.44265], [-119.03103, 35.4426], [-119.03096, 35.44256], [-119.03092, 35.4423], [-119.03325, 35.4423]]]} Open Access 1 13234 North Highland Park 22822 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 14.884 North Highland Park 0 Local Park 2 4
1766 1766 1765 {"type": "Polygon", "coordinates": [[[-119.10684, 35.36219], [-119.1064, 35.36249], [-119.10628, 35.36247], [-119.1062, 35.36252], [-119.10617, 35.36259], [-119.10618, 35.36266], [-119.10622, 35.36272], [-119.10623, 35.36359], [-119.10405, 35.36358], [-119.10402, 35.36351], [-119.10397, 35.36345], [-119.10389, 35.36343], [-119.1038, 35.36345], [-119.10374, 35.36351], [-119.10352, 35.36355], [-119.10352, 35.36371], [-119.10311, 35.36371], [-119.10311, 35.36282], [-119.10313, 35.36265], [-119.10311, 35.36259], [-119.10302, 35.36248], [-119.10389, 35.36248], [-119.10389, 35.36255], [-119.10563, 35.36255], [-119.10564, 35.36218], [-119.10684, 35.36219]]]} Open Access 1 13184 Mondavi Park 22368 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 8.983 Mondavi Park 0 Local Park 2 4
1792 1792 1791 {"type": "Polygon", "coordinates": [[[-119.02987, 35.40131], [-119.02821, 35.40131], [-119.02822, 35.40213], [-119.02791, 35.4021], [-119.02791, 35.40263], [-119.0276, 35.40263], [-119.02758, 35.40338], [-119.02754, 35.40312], [-119.02753, 35.40284], [-119.02712, 35.40285], [-119.02711, 35.40337], [-119.02688, 35.40337], [-119.02688, 35.40299], [-119.02672, 35.40298], [-119.02672, 35.40131], [-119.02623, 35.4013], [-119.02651, 35.40111], [-119.02658, 35.40101], [-119.02666, 35.40086], [-119.02669, 35.40048], [-119.02662, 35.39998], [-119.0267, 35.39991], [-119.02983, 35.39908], [-119.02987, 35.40131]]]} Open Access 1 13492 Riverview Park 24467 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 19.963 Riverview Park 0 Local Park 2 4
3406 3406 3405 {"type": "Polygon", "coordinates": [[[-119.01684, 35.41888], [-119.01475, 35.41888], [-119.01468, 35.41594], [-119.01679, 35.41595], [-119.01684, 35.41888]]]} Open Access 1 24875 Standard Park 25782 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 15.335 Standard Park 0 Local Park 2 4
3407 3407 3406 {"type": "Polygon", "coordinates": [[[-119.02999, 35.42808], [-119.02794, 35.42807], [-119.02794, 35.42719], [-119.02991, 35.42721], [-119.02998, 35.42726], [-119.02999, 35.42808]]]} Open Access 1 24877 NOR Park 22786 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 4.468 NOR Park 0 Local Park 2 4
3460 3460 3459 {"type": "Polygon", "coordinates": [[[-119.08491, 35.40132], [-119.08461, 35.40134], [-119.08421, 35.40131], [-119.08354, 35.40131], [-119.08346, 35.40125], [-119.08344, 35.39843], [-119.08349, 35.39838], [-119.08459, 35.39842], [-119.08461, 35.39892], [-119.08458, 35.39901], [-119.08458, 35.39909], [-119.08463, 35.39919], [-119.08475, 35.39924], [-119.08485, 35.39927], [-119.0849, 35.39975], [-119.08491, 35.40132]]]} Open Access 1 25362 Emerald Cove Park 18613 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 9.921 Emerald Cove Park 0 Local Park 2 4
3473 3473 3472 {"type": "Polygon", "coordinates": [[[-119.03006, 35.43544], [-119.03004, 35.43691], [-119.02772, 35.4369], [-119.02772, 35.43538], [-119.02999, 35.43538], [-119.03006, 35.43544]]]} Open Access 1 25789 North Meadows Park 22830 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 8.835 North Meadows Park 0 Local Park 2 4
3702 3702 3701 {"type": "Polygon", "coordinates": [[[-119.13655, 35.40159], [-119.13653, 35.4041], [-119.1365, 35.40501], [-119.13643, 35.40507], [-119.13224, 35.40508], [-119.13226, 35.40158], [-119.13655, 35.40159]]]} Open Access 1 44485 Polo Community Park 23874 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 37.231 Polo Community Park 0 Local Park 2 4
5537 5537 5536 {"type": "Polygon", "coordinates": [[[-119.03334, 35.42147], [-119.03333, 35.4215], [-119.03271, 35.422], [-119.0325, 35.4221], [-119.03228, 35.42217], [-119.03222, 35.42214], [-119.03209, 35.42194], [-119.03198, 35.42173], [-119.03188, 35.42147], [-119.03188, 35.42144], [-119.03194, 35.4214], [-119.03328, 35.4214], [-119.03332, 35.42141], [-119.03334, 35.42144], [-119.03334, 35.42147]]]} Open Access 1 24876 McCray Park 22013 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 1.756 McCray Park 0 Local Park 2 4
5554 5554 5553 {"type": "MultiPolygon", "coordinates": [[[[-119.07261, 35.39748], [-119.07261, 35.3977], [-119.07254, 35.39775], [-119.06568, 35.39772], [-119.06561, 35.39766], [-119.06561, 35.39719], [-119.06564, 35.39694], [-119.06564, 35.39639], [-119.0657, 35.39634], [-119.06671, 35.39634], [-119.06671, 35.39745], [-119.07261, 35.39748]]], [[[-119.07323, 35.39748], [-119.07323, 35.39776], [-119.07288, 35.39775], [-119.07281, 35.3977], [-119.07282, 35.39748], [-119.07323, 35.39748]]]]} Open Access 1 25351 San Lauren Park 24922 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 8.032 San Lauren Park 0 Local Park 2 4
5555 5555 5554 {"type": "Polygon", "coordinates": [[[-119.09045, 35.40647], [-119.09044, 35.40738], [-119.08934, 35.40737], [-119.08934, 35.40647], [-119.08974, 35.40647], [-119.08981, 35.40644], [-119.0899, 35.40646], [-119.09002, 35.40645], [-119.09045, 35.40647]]]} Open Access 1 25353 Olive Park West 23129 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 2.515 Olive Park West 0 Local Park 2 4
5556 5556 5555 {"type": "Polygon", "coordinates": [[[-119.08621, 35.40729], [-119.0851, 35.40731], [-119.08511, 35.40685], [-119.0851, 35.40638], [-119.08555, 35.40636], [-119.08621, 35.40638], [-119.08621, 35.40729]]]} Open Access 1 25354 Olive Park East 23128 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 2.554 Olive Park East 0 Local Park 2 4
5557 5557 5556 {"type": "Polygon", "coordinates": [[[-119.04068, 35.41591], [-119.03921, 35.41592], [-119.0392, 35.4141], [-119.04065, 35.4141], [-119.04068, 35.41591]]]} Open Access 1 25356 North Beardsley Park 22808 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 6.595 North Beardsley Park 0 Local Park 2 4
5558 5558 5557 {"type": "Polygon", "coordinates": [[[-119.12778, 35.3653], [-119.12778, 35.36639], [-119.12774, 35.36742], [-119.12773, 35.36865], [-119.12763, 35.36873], [-119.12648, 35.36873], [-119.12549, 35.36876], [-119.12548, 35.36746], [-119.1255, 35.3653], [-119.12742, 35.36529], [-119.12778, 35.3653]]]} Open Access 1 25359 LibertyPark 21215 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 19.487 LibertyPark 0 Local Park 2 4
8397 8397 8396 {"type": "Polygon", "coordinates": [[[-119.15641, 35.40372], [-119.1562, 35.40376], [-119.15599, 35.40383], [-119.15575, 35.40394], [-119.15557, 35.40405], [-119.15225, 35.40133], [-119.15324, 35.40133], [-119.15325, 35.40155], [-119.1544, 35.40155], [-119.15447, 35.4017], [-119.15459, 35.40192], [-119.15485, 35.40226], [-119.15497, 35.40238], [-119.15505, 35.40233], [-119.1562, 35.40328], [-119.15628, 35.40338], [-119.15635, 35.40348], [-119.15641, 35.40372]]]} Open Access 1 12999 Austin Creek Park 15711 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4 https://norfun.org/construction/austin-creek-park/ Kern 36 9.344 Austin Creek Park 0 Local Park 2 4
8418 8418 8417 {"type": "Polygon", "coordinates": [[[-119.07434, 35.41834], [-119.07433, 35.41949], [-119.07294, 35.41949], [-119.07293, 35.41959], [-119.07009, 35.41957], [-119.07009, 35.4179], [-119.07384, 35.4179], [-119.07386, 35.41832], [-119.07434, 35.41834]]]} Open Access 1 13049 Fruitvale/Norris Park 19138 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 16.948 Fruitvale/Norris Park 0 Local Park 2 4
8448 8448 8447 {"type": "Polygon", "coordinates": [[[-119.1175, 35.42072], [-119.11635, 35.42116], [-119.11602, 35.42075], [-119.11588, 35.42062], [-119.11552, 35.42035], [-119.11513, 35.42011], [-119.11481, 35.41997], [-119.11442, 35.41983], [-119.11404, 35.41975], [-119.1135, 35.41968], [-119.11574, 35.41842], [-119.11708, 35.42015], [-119.1175, 35.42072]]]} Open Access 1 13129 Madison Grove Park 21656 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 10.96 Madison Grove Park 0 Local Park 2 4
8505 8505 8504 {"type": "Polygon", "coordinates": [[[-119.13082, 35.39222], [-119.1308, 35.39362], [-119.12798, 35.3936], [-119.12794, 35.39219], [-119.12797, 35.39106], [-119.12882, 35.39108], [-119.12879, 35.3922], [-119.13082, 35.39222]]]} Open Access 1 13325 North Rosedale Park 22857 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 12.349 North Rosedale Park 0 Local Park 2 4
8543 8543 8542 {"type": "MultiPolygon", "coordinates": [[[[-119.09761, 35.40048], [-119.09761, 35.40048], [-119.0976, 35.40055], [-119.09755, 35.40051], [-119.09761, 35.40048]]], [[[-119.09798, 35.40118], [-119.09789, 35.40109], [-119.09783, 35.40095], [-119.0979, 35.401], [-119.09794, 35.40106], [-119.09798, 35.40118]]], [[[-119.09823, 35.4015], [-119.0981, 35.40149], [-119.09804, 35.40138], [-119.09808, 35.40132], [-119.09823, 35.4015]]], [[[-119.09895, 35.39986], [-119.09895, 35.39986], [-119.09864, 35.39995], [-119.09889, 35.3998], [-119.09895, 35.39986]]], [[[-119.09949, 35.40115], [-119.09931, 35.40122], [-119.09921, 35.40121], [-119.09937, 35.40109], [-119.09947, 35.40107], [-119.09949, 35.40115]]]]} Open Access 1 13462 River Lakes Ranch Community Park 24410 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 0.141 River Lakes Ranch Community Park 0 Local Park 2 4
8563 8563 8562 {"type": "Polygon", "coordinates": [[[-119.02942, 35.42069], [-119.02795, 35.42068], [-119.02794, 35.42017], [-119.02802, 35.42025], [-119.0291, 35.42025], [-119.0291, 35.41966], [-119.02941, 35.41964], [-119.02942, 35.42069]]]} Open Access 1 13578 Sears Park 25245 2096 North of the River Recreation and Park District 386 Special District 4 Recreation/Parks District 4 http://norfun.org/ Special District 4 2096 North of the River Recreation and Park District 382 Special District 4 Recreation/Parks District 4   Kern 36 2.062 Sears Park 0 Local Park 2 4

Next page

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