units_with_maps

Table actions

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

15 rows where COUNTY = 6, DES_TP = 2 and MNG_AGENCY = 300

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Carson, City of · 15 ✖

DES_TP 1

  • Local Park · 15 ✖

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
1008 1008 1007 {"type": "Polygon", "coordinates": [[[-118.24404, 33.83769], [-118.24404, 33.83815], [-118.24268, 33.83816], [-118.24268, 33.83844], [-118.24232, 33.83844], [-118.24231, 33.83816], [-118.24103, 33.83817], [-118.24103, 33.83635], [-118.2436, 33.83634], [-118.2436, 33.83723], [-118.24403, 33.83724], [-118.24361, 33.83726], [-118.24361, 33.83768], [-118.24404, 33.83769]]]} Open Access 1 6245 Dolphin Park 18192 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 12.671 Dolphin Park 0 Local Park 2 4
2201 2201 2200 {"type": "Polygon", "coordinates": [[[-118.26317, 33.8491], [-118.2621, 33.84957], [-118.26194, 33.84955], [-118.26186, 33.84959], [-118.26169, 33.84923], [-118.26131, 33.84865], [-118.26125, 33.84853], [-118.26111, 33.84745], [-118.26112, 33.84744], [-118.2611, 33.84742], [-118.26107, 33.84723], [-118.26207, 33.84748], [-118.26249, 33.84755], [-118.26298, 33.84762], [-118.26317, 33.8491]]]} Open Access 1 6240 Del Amo Park 18022 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 8.624 Del Amo Park 0 Local Park 2 4
3133 3133 3132 {"type": "Polygon", "coordinates": [[[-118.27833, 33.8369], [-118.27827, 33.8369], [-118.27808, 33.83715], [-118.27783, 33.83715], [-118.27782, 33.83677], [-118.27827, 33.83669], [-118.27833, 33.8369]]]} Open Access 1 48036 Reflections Mini Park 32529 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2 http://ci.carson.ca.us/communityservices/Parks_Rec_Parks.aspx#Reflections Los Angeles 6 0.436 Reflections MP 0 Local Park 2 4
7133 7133 7132 {"type": "Polygon", "coordinates": [[[-118.24836, 33.84879], [-118.24832, 33.84883], [-118.24633, 33.84884], [-118.24631, 33.84881], [-118.24631, 33.84826], [-118.24634, 33.84812], [-118.24633, 33.84802], [-118.24666, 33.84785], [-118.24675, 33.84787], [-118.24836, 33.84786], [-118.24836, 33.84879]]]} Open Access 1 6239 Dr. Thomas G. Mills Memorial Park 18268 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 4.97 Dr. Thomas G. Mills Memorial Park 0 Local Park 2 4
7142 7142 7141 {"type": "Polygon", "coordinates": [[[-118.25871, 33.87287], [-118.25868, 33.8729], [-118.25858, 33.87292], [-118.25806, 33.87298], [-118.25752, 33.87298], [-118.25714, 33.87295], [-118.25708, 33.87153], [-118.25716, 33.87152], [-118.25716, 33.8713], [-118.25647, 33.87131], [-118.25645, 33.87071], [-118.25686, 33.8707], [-118.25685, 33.87032], [-118.25857, 33.87027], [-118.25862, 33.87029], [-118.25863, 33.87031], [-118.25869, 33.87184], [-118.25871, 33.87287]]]} Open Access 1 6235 Stevenson Park 25844 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 11.809 Stevenson Park 0 Local Park 2 4
7144 7144 7143 {"type": "MultiPolygon", "coordinates": [[[[-118.26409, 33.88086], [-118.26278, 33.8809], [-118.26311, 33.88234], [-118.26181, 33.88237], [-118.26148, 33.88095], [-118.2614, 33.88072], [-118.26125, 33.88003], [-118.26387, 33.87995], [-118.26409, 33.88086]]], [[[-118.26463, 33.87993], [-118.2645, 33.88113], [-118.26446, 33.88116], [-118.26438, 33.88116], [-118.26434, 33.88112], [-118.26415, 33.88034], [-118.26418, 33.88007], [-118.26416, 33.88002], [-118.26406, 33.87995], [-118.26463, 33.87993]]]]} Open Access 1 6236 Vernon M. Hemingway Memorial Park 27003 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 11.928 Vernon M. Hemingway Memorial Park 0 Local Park 2 4
7145 7145 7144 {"type": "Polygon", "coordinates": [[[-118.2689, 33.87422], [-118.26878, 33.87562], [-118.26841, 33.87564], [-118.2685, 33.8756], [-118.26855, 33.87556], [-118.2686, 33.87545], [-118.26862, 33.87537], [-118.26869, 33.87443], [-118.26868, 33.87423], [-118.2689, 33.87422]]]} Open Access 1 6237 Walnut Street Park 27244 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 0.677 Walnut Street Park 0 Local Park 2 4
7146 7146 7145 {"type": "Polygon", "coordinates": [[[-118.23663, 33.85793], [-118.23508, 33.85798], [-118.23505, 33.85798], [-118.23501, 33.85795], [-118.23484, 33.85606], [-118.23486, 33.856], [-118.2349, 33.85599], [-118.23655, 33.85594], [-118.23663, 33.85793]]]} Open Access 1 6238 James Anderson, Jr. Memorial Park 20342 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 8.451 James Anderson, Jr. Memorial Park 0 Local Park 2 4
7149 7149 7148 {"type": "Polygon", "coordinates": [[[-118.21586, 33.83428], [-118.21542, 33.83545], [-118.21543, 33.83546], [-118.21549, 33.83546], [-118.21548, 33.83549], [-118.21407, 33.83549], [-118.21407, 33.83547], [-118.21282, 33.83546], [-118.21342, 33.83428], [-118.21586, 33.83428]]]} Open Access 1 6246 Dominguez Park 18195 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 7.645 Dominguez Park 0 Local Park 2 4
7151 7151 7150 {"type": "Polygon", "coordinates": [[[-118.25765, 33.82779], [-118.25509, 33.8278], [-118.25506, 33.82778], [-118.25505, 33.82696], [-118.2551, 33.82691], [-118.25713, 33.82691], [-118.25713, 33.82443], [-118.25715, 33.82439], [-118.2572, 33.82437], [-118.25765, 33.82437], [-118.25765, 33.82779]]]} Open Access 1 6248 John D. Calas, Sr. Park 20433 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 9.224 John D. Calas, Sr. Park 0 Local Park 2 4
7153 7153 7152 {"type": "Polygon", "coordinates": [[[-118.2786, 33.83441], [-118.27563, 33.83442], [-118.27564, 33.83526], [-118.27468, 33.83526], [-118.27464, 33.83522], [-118.27464, 33.83353], [-118.27836, 33.83352], [-118.2786, 33.83441]]]} Open Access 1 6250 Carson Park 16921 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 10.804 Carson Park 0 Local Park 2 4
7154 7154 7153 {"type": "Polygon", "coordinates": [[[-118.27119, 33.81246], [-118.27117, 33.81496], [-118.27118, 33.81506], [-118.27114, 33.8152], [-118.2711, 33.81522], [-118.27103, 33.81523], [-118.27069, 33.81501], [-118.27055, 33.81496], [-118.27043, 33.81493], [-118.26943, 33.81494], [-118.2694, 33.81493], [-118.2694, 33.81477], [-118.26951, 33.81241], [-118.27119, 33.81246]]]} Open Access 1 6251 Scott Park 25204 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 11.27 Scott Park 0 Local Park 2 4
7155 7155 7154 {"type": "Polygon", "coordinates": [[[-118.28502, 33.80964], [-118.28351, 33.80964], [-118.28353, 33.80794], [-118.28418, 33.80794], [-118.28423, 33.80795], [-118.28431, 33.808], [-118.28433, 33.80812], [-118.28442, 33.80834], [-118.28493, 33.8094], [-118.28502, 33.80964]]]} Open Access 1 6252 Carriage Crest Park 16908 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 4.845 Carriage Crest Park 0 Local Park 2 4
7952 7952 7951 {"type": "Polygon", "coordinates": [[[-118.24147, 33.82799], [-118.24141, 33.82854], [-118.24084, 33.82854], [-118.24088, 33.8284], [-118.2413, 33.82838], [-118.24146, 33.82798], [-118.24147, 33.82799]]]} Open Access 1 6247 Friendship Mini Park 19118 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 0.285 Friendship MP 0 Local Park 2 4
15244 15244 15243 {"type": "Polygon", "coordinates": [[[-118.2527, 33.8336], [-118.25218, 33.8336], [-118.25202, 33.83339], [-118.25212, 33.83333], [-118.25215, 33.83328], [-118.25216, 33.83322], [-118.25213, 33.83305], [-118.25213, 33.83285], [-118.25216, 33.83281], [-118.25265, 33.8328], [-118.25269, 33.83282], [-118.2527, 33.8336]]]} Open Access 1 46442 Perry Park 29716 1048 Carson, City of 304 City 2 City Agency 2 http://ci.carson.ca.us/content/department/pub_service/parks_rec_parks.asp City 2 1048 Carson, City of 300 City 2 City Agency 2   Los Angeles 6 1.149 Perry 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]);