units_with_maps

Table actions

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

4 rows where AGNCY_LEV = 2, MNG_AGENCY = 516 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 4 ✖

MNG_AGENCY 1

  • Firebaugh, City of · 4 ✖

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
2394 2394 2393 {"type": "Polygon", "coordinates": [[[-120.45327, 36.85931], [-120.45288, 36.85957], [-120.45288, 36.85961], [-120.45117, 36.85982], [-120.45094, 36.85983], [-120.45032, 36.86], [-120.4499, 36.86022], [-120.44966, 36.86037], [-120.44952, 36.86052], [-120.44829, 36.85938], [-120.44841, 36.85912], [-120.44868, 36.85886], [-120.44889, 36.85862], [-120.44897, 36.85833], [-120.4498, 36.8584], [-120.45047, 36.85836], [-120.45209, 36.85818], [-120.45215, 36.85822], [-120.45327, 36.85931]]]} Open Access 1 18627 Andrew Firebaugh Historical Park 15484 1107 Firebaugh, City of 523 City 2 City Agency 2 http://www.ci.firebaugh.ca.us/ City 2 1107 Firebaugh, City of 516 City 2 City Agency 2   Fresno 9 16.635 Andrew Firebaugh Historical Park 0 Local Historic or Cultural Area 19 4
2844 2844 2843 {"type": "Polygon", "coordinates": [[[-120.45376, 36.85645], [-120.45339, 36.8567], [-120.45287, 36.85616], [-120.45324, 36.85591], [-120.45376, 36.85645]]]} Open Access 1 18764 Library Park 21218 1107 Firebaugh, City of 523 City 2 City Agency 2 http://www.ci.firebaugh.ca.us/ City 2 1107 Firebaugh, City of 516 City 2 City Agency 2   Fresno 9 0.808 Library Park 0 Local Park 2 4
5473 5473 5472 {"type": "Polygon", "coordinates": [[[-120.46319, 36.86907], [-120.46091, 36.8691], [-120.46087, 36.86806], [-120.46317, 36.86804], [-120.46319, 36.86907]]]} Open Access 1 18819 Maldonado Park 21697 1107 Firebaugh, City of 523 City 2 City Agency 2 http://www.ci.firebaugh.ca.us/ City 2 1107 Firebaugh, City of 516 City 2 City Agency 2   Fresno 9 5.833 Maldonado Park 0 Local Park 2 4
10520 10520 10519 {"type": "Polygon", "coordinates": [[[-120.44996, 36.85605], [-120.44877, 36.8569], [-120.44787, 36.85628], [-120.44726, 36.85606], [-120.44677, 36.85593], [-120.44562, 36.85571], [-120.44725, 36.85447], [-120.44739, 36.85461], [-120.44752, 36.85454], [-120.44806, 36.85455], [-120.4481, 36.85459], [-120.4483, 36.85445], [-120.44996, 36.85605]]]} Open Access 1 18700 Dunkle Park 18303 1107 Firebaugh, City of 523 City 2 City Agency 2 http://www.ci.firebaugh.ca.us/ City 2 1107 Firebaugh, City of 516 City 2 City Agency 2   Fresno 9 12.845 Dunkle 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]);