units_with_maps

Table actions

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

4 rows where AGNCY_ID = 6042, MNG_AGENCY = 695 and MNG_AG_TYP = 15

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Home Owners Association · 4 ✖

MNG_AGENCY 1

  • Nellie Gail Ranch Owners Association · 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
4008 4008 4007 {"type": "Polygon", "coordinates": [[[-117.69963, 33.56992], [-117.69952, 33.57001], [-117.69881, 33.57008], [-117.69853, 33.57013], [-117.69811, 33.57027], [-117.69807, 33.57025], [-117.69787, 33.56999], [-117.69788, 33.56997], [-117.69802, 33.56982], [-117.69823, 33.56964], [-117.69834, 33.56949], [-117.6984, 33.56937], [-117.69959, 33.56969], [-117.69963, 33.56992]]]} Restricted Access 2 43065 Moulton Park 32220 6042 Nellie Gail Ranch Owners Association 710 Private 7 Home Owners Association 16 http://www.nelliegailranch.org/ Private 14 6042 Nellie Gail Ranch Owners Association 695 Private 7 Home Owners Association 15   Orange 3 2.271 Moulton Park 0 Private Recreation or Education 65 4
13720 13720 13719 {"type": "Polygon", "coordinates": [[[-117.68781, 33.56685], [-117.68754, 33.56707], [-117.68738, 33.56716], [-117.6872, 33.5672], [-117.68701, 33.5672], [-117.68688, 33.56718], [-117.68666, 33.56708], [-117.6865, 33.56695], [-117.68625, 33.56665], [-117.68745, 33.56622], [-117.68781, 33.56685]]]} Restricted Access 2 36135 Hidden Trail Park 32368 6042 Nellie Gail Ranch Owners Association 710 Private 7 Home Owners Association 16 http://www.nelliegailranch.org/ Private 14 6042 Nellie Gail Ranch Owners Association 695 Private 7 Home Owners Association 15   Orange 3 2.361 Hidden Trail Park 0 Private Recreation or Education 65 4
14149 14149 14148 {"type": "Polygon", "coordinates": [[[-117.68585, 33.58636], [-117.68536, 33.58738], [-117.68474, 33.58771], [-117.68467, 33.58757], [-117.68438, 33.58671], [-117.68425, 33.58649], [-117.6842, 33.58636], [-117.68418, 33.58624], [-117.6842, 33.58618], [-117.68423, 33.58616], [-117.68431, 33.58615], [-117.68449, 33.58609], [-117.68461, 33.58603], [-117.68472, 33.58595], [-117.68488, 33.58578], [-117.68585, 33.58636]]]} Restricted Access 2 43043 Gallup Park 32373 6042 Nellie Gail Ranch Owners Association 710 Private 7 Home Owners Association 16 http://www.nelliegailranch.org/ Private 14 6042 Nellie Gail Ranch Owners Association 695 Private 7 Home Owners Association 15   Orange 3 4.679 Gallup Park 0 Private Recreation or Education 65 4
14171 14171 14170 {"type": "Polygon", "coordinates": [[[-117.6905, 33.5747], [-117.6905, 33.57489], [-117.69044, 33.57512], [-117.69032, 33.57533], [-117.69021, 33.57545], [-117.69016, 33.57546], [-117.68992, 33.57536], [-117.68965, 33.57532], [-117.68938, 33.57534], [-117.68921, 33.57538], [-117.68898, 33.5755], [-117.68879, 33.57566], [-117.68867, 33.57586], [-117.68861, 33.57608], [-117.68767, 33.57626], [-117.68719, 33.57544], [-117.68757, 33.57526], [-117.688, 33.57509], [-117.68857, 33.5749], [-117.689, 33.5748], [-117.68945, 33.57472], [-117.69006, 33.57466], [-117.69041, 33.57464], [-117.6905, 33.5747]]]} Restricted Access 2 43068 Dapple Grey Park 32382 6042 Nellie Gail Ranch Owners Association 710 Private 7 Home Owners Association 16 http://www.nelliegailranch.org/ Private 14 6042 Nellie Gail Ranch Owners Association 695 Private 7 Home Owners Association 15   Orange 3 6.64 Dapple Grey Park 0 Private Recreation or Education 65 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]);