units_with_maps

Table actions

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

11 rows where AGNCY_TYP = 16 and DES_TP = 16

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, MNG_AG_ID, COUNTY, YR_EST

MNG_AG_TYP 1

DES_TP 1

  • Private Conservation · 11 ✖

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
8283 8283 8282 {"type": "Polygon", "coordinates": [[[-117.78053, 33.65114], [-117.78053, 33.65118], [-117.78037, 33.6515], [-117.78018, 33.65183], [-117.78015, 33.65185], [-117.77904, 33.65142], [-117.77904, 33.65138], [-117.77909, 33.6513], [-117.77941, 33.65074], [-117.77943, 33.65072], [-117.78053, 33.65114]]]} Restricted Access 2 12675 The Commons 26279 6019 Quail Hill Community Association 408 Private 7 Home Owners Association 16 http://www.quailhillhoa.org/ Private 14 6019 Quail Hill Community Association 402 Private 7 Home Owners Association 15   Orange 3 2.466 The Commons 0 Private Conservation 16 2
8497 8497 8496 {"type": "Polygon", "coordinates": [[[-122.22153, 37.36198], [-122.22095, 37.36343], [-122.22116, 37.36353], [-122.22107, 37.36357], [-122.22091, 37.36383], [-122.22031, 37.36425], [-122.21982, 37.36432], [-122.21905, 37.36479], [-122.21859, 37.36468], [-122.21792, 37.36468], [-122.21681, 37.36444], [-122.21663, 37.36458], [-122.21652, 37.36457], [-122.21625, 37.36444], [-122.21573, 37.36435], [-122.21511, 37.36387], [-122.21468, 37.36376], [-122.21411, 37.36345], [-122.21396, 37.36339], [-122.21379, 37.36335], [-122.21362, 37.36334], [-122.21345, 37.36335], [-122.21329, 37.36339], [-122.21312, 37.36346], [-122.21298, 37.36354], [-122.21287, 37.36365], [-122.21278, 37.36376], [-122.21271, 37.36391], [-122.21252, 37.36381], [-122.21233, 37.36377], [-122.21212, 37.36376], [-122.21185, 37.3638], [-122.21156, 37.36357], [-122.21116, 37.36334], [-122.21102, 37.36323], [-122.21199, 37.3621], [-122.21094, 37.36096], [-122.20955, 37.35979], [-122.20929, 37.35959], [-122.20817, 37.3594], [-122.20651, 37.35691], [-122.21042, 37.352], [-122.21243, 37.35403], [-122.21338, 37.35413], [-122.21598, 37.35557], [-122.21904, 37.35912], [-122.22061, 37.36021], [-122.22153, 37.36198]]]} Restricted Access 2 13289 Coal Mine Ridge 33341 6127 Portola Valley Ranch Home Owners Association 895 Private 7 Home Owners Association 16   Private 14 6127 Portola Valley Ranch Home Owners Association 869 Private 7 Home Owners Association 15   San Mateo 15 244.051 Coal Mine Ridge 1964 Private Conservation 16 2
9407 9407 9406 {"type": "Polygon", "coordinates": [[[-118.16539, 33.79771], [-118.1653, 33.79772], [-118.16505, 33.79788], [-118.16487, 33.79797], [-118.16459, 33.798], [-118.16457, 33.79798], [-118.16441, 33.79797], [-118.16422, 33.7979], [-118.16416, 33.79788], [-118.16391, 33.79769], [-118.16355, 33.79759], [-118.16322, 33.79759], [-118.16321, 33.79783], [-118.16279, 33.79783], [-118.16261, 33.79778], [-118.16232, 33.79779], [-118.16225, 33.79773], [-118.16219, 33.79756], [-118.1622, 33.79711], [-118.16329, 33.79711], [-118.16329, 33.79644], [-118.16342, 33.7965], [-118.16357, 33.7966], [-118.16389, 33.7969], [-118.1642, 33.79714], [-118.16423, 33.79718], [-118.16426, 33.79728], [-118.16431, 33.79732], [-118.1644, 33.79733], [-118.16449, 33.79729], [-118.16457, 33.79731], [-118.1647, 33.79731], [-118.16493, 33.79707], [-118.16499, 33.79711], [-118.16539, 33.79771]]]} Restricted Access 2 47821 Comstock South LLC HOA 31763 6120 Comstock South LLC 910 Private 7 Home Owners Association 16   Private 14 6120 Comstock South LLC 883 Private 7 Home Owners Association 15   Los Angeles 6 5.79 Comstock South LLC HOA 0 Private Conservation 16 2
9411 9411 9410 {"type": "Polygon", "coordinates": [[[-118.16745, 33.79841], [-118.16748, 33.79966], [-118.16742, 33.8003], [-118.16741, 33.80064], [-118.16736, 33.80067], [-118.16679, 33.80067], [-118.16673, 33.80063], [-118.16673, 33.80057], [-118.16695, 33.80057], [-118.16704, 33.80055], [-118.16711, 33.80046], [-118.1671, 33.80042], [-118.16718, 33.80035], [-118.16723, 33.80024], [-118.16723, 33.80016], [-118.16733, 33.79982], [-118.16737, 33.79925], [-118.16735, 33.79924], [-118.16733, 33.79912], [-118.1673, 33.79905], [-118.16718, 33.79893], [-118.16714, 33.7987], [-118.16712, 33.79868], [-118.16709, 33.79851], [-118.16704, 33.79848], [-118.1668, 33.79846], [-118.16701, 33.79867], [-118.16704, 33.79875], [-118.16705, 33.79882], [-118.167, 33.799], [-118.16691, 33.79902], [-118.16686, 33.79908], [-118.16691, 33.79933], [-118.16688, 33.79966], [-118.16666, 33.7996], [-118.16659, 33.79955], [-118.16656, 33.79946], [-118.16654, 33.79945], [-118.16657, 33.79932], [-118.16658, 33.79922], [-118.16655, 33.79911], [-118.16649, 33.79901], [-118.1667, 33.79881], [-118.16669, 33.79878], [-118.16652, 33.79864], [-118.16648, 33.79864], [-118.1663, 33.79847], [-118.16627, 33.79847], [-118.16603, 33.7983], [-118.16602, 33.79825], [-118.16593, 33.79816], [-118.16577, 33.79795], [-118.16548, 33.79774], [-118.16539, 33.79771], [-118.165, 33.79711], [-118.16494, 33.79707], [-118.1651, 33.79693], [-118.16509, 33.79689], [-118.16519, 33.79674], [-118.16548, 33.79688], [-118.16549, 33.79687], [-118.16597, 33.79717], [-118.1664, 33.79749], [-118.16649, 33.7975], [-118.16656, 33.79781], [-118.16672, 33.79795], [-118.16673, 33.79805], [-118.16686, 33.79805], [-118.16685, 33.79812], [-118.16689, 33.79819], [-118.1672, 33.79828], [-118.16745, 33.79841]]]} Restricted Access 2 47822 Hilltop LLC HOA 31764 6119 Hilltop LLC 911 Private 7 Home Owners Association 16   Private 14 6119 Hilltop LLC 884 Private 7 Home Owners Association 15   Los Angeles 6 6.573 Hilltop LLC HOA 0 Private Conservation 16 2
9413 9413 9412 {"type": "MultiPolygon", "coordinates": [[[[-118.15724, 33.79865], [-118.15735, 33.79866], [-118.15738, 33.79868], [-118.15739, 33.79872], [-118.15737, 33.79875], [-118.1572, 33.79889], [-118.15711, 33.79894], [-118.15658, 33.79909], [-118.15638, 33.7992], [-118.15631, 33.79919], [-118.15629, 33.79916], [-118.1564, 33.79915], [-118.15648, 33.79906], [-118.15653, 33.79896], [-118.15652, 33.79884], [-118.15649, 33.79877], [-118.15635, 33.79858], [-118.15611, 33.79832], [-118.15608, 33.79826], [-118.15607, 33.79818], [-118.15607, 33.79814], [-118.15612, 33.79806], [-118.15601, 33.79791], [-118.15601, 33.79786], [-118.15599, 33.79782], [-118.15594, 33.79778], [-118.15587, 33.79776], [-118.15602, 33.7973], [-118.15576, 33.79724], [-118.15574, 33.79726], [-118.15563, 33.79759], [-118.15553, 33.79771], [-118.1555, 33.79782], [-118.1555, 33.79789], [-118.15554, 33.79798], [-118.15552, 33.79809], [-118.15572, 33.79811], [-118.15572, 33.79814], [-118.15552, 33.79813], [-118.15551, 33.79827], [-118.15556, 33.79851], [-118.15559, 33.79858], [-118.15564, 33.79865], [-118.15582, 33.79878], [-118.15601, 33.79901], [-118.15599, 33.79903], [-118.15588, 33.7989], [-118.15556, 33.79866], [-118.15549, 33.79856], [-118.15541, 33.79835], [-118.15541, 33.79811], [-118.1552, 33.7981], [-118.1552, 33.79807], [-118.15541, 33.79807], [-118.15543, 33.79796], [-118.15543, 33.79771], [-118.15554, 33.79754], [-118.15555, 33.79747], [-118.15556, 33.79734], [-118.1555, 33.79733], [-118.1555, 33.79719], [-118.15646, 33.7972], [-118.15658, 33.79735], [-118.1566, 33.79741], [-118.1566, 33.79748], [-118.1565, 33.79736], [-118.15636, 33.79743], [-118.15628, 33.79748], [-118.15622, 33.79755], [-118.15619, 33.79763], [-118.15618, 33.79771], [-118.15622, 33.79787], [-118.15624, 33.79802], [-118.1563, 33.7982], [-118.15651, 33.79866], [-118.15673, 33.79859], [-118.15675, 33.79862], [-118.15655, 33.79871], [-118.15654, 33.79872], [-118.15671, 33.79892], [-118.15676, 33.79895], [-118.15681, 33.79895], [-118.15695, 33.79889], [-118.15713, 33.79888], [-118.15725, 33.79884], [-118.15727, 33.79879], [-118.15724, 33.79865]]], [[[-118.15759, 33.79826], [-118.15756, 33.79831], [-118.15739, 33.7983], [-118.15724, 33.79832], [-118.1572, 33.79827], [-118.15697, 33.79783], [-118.15686, 33.79786], [-118.15664, 33.79786], [-118.15672, 33.79769], [-118.1567, 33.79763], [-118.15665, 33.79759], [-118.15667, 33.79747], [-118.15666, 33.79738], [-118.1567, 33.79738], [-118.15689, 33.79765], [-118.15697, 33.79771], [-118.15719, 33.79806], [-118.15727, 33.79812], [-118.15759, 33.79826]]], [[[-118.1581, 33.80028], [-118.15797, 33.8005], [-118.15798, 33.80071], [-118.15784, 33.80071], [-118.15786, 33.80049], [-118.15794, 33.80023], [-118.15793, 33.80019], [-118.1579, 33.80017], [-118.15768, 33.80011], [-118.15732, 33.79992], [-118.15718, 33.7998], [-118.15704, 33.79967], [-118.15687, 33.79976], [-118.15685, 33.79973], [-118.15703, 33.79963], [-118.1569, 33.79936], [-118.15693, 33.79934], [-118.15687, 33.79914], [-118.15716, 33.79906], [-118.15722, 33.79908], [-118.15703, 33.79913], [-118.15699, 33.79919], [-118.15709, 33.79938], [-118.15712, 33.79951], [-118.15723, 33.79966], [-118.15733, 33.79977], [-118.1575, 33.79964], [-118.15754, 33.79967], [-118.15737, 33.7998], [-118.15737, 33.79981], [-118.15744, 33.79987], [-118.15769, 33.8], [-118.15802, 33.80006], [-118.1581, 33.80028]]]]} Restricted Access 2 47823 Bixby Village HOA 31766 6118 Bixby Village Home Owner Association 913 Private 7 Home Owners Association 16 http://www.bixbyvillagehoa.com/page/28905~504318/Management-Contacts Private 14 6118 Bixby Village Home Owner Association 886 Private 7 Home Owners Association 15   Los Angeles 6 3.135 Bixby Village HOA 0 Private Conservation 16 2
12834 12834 12833 {"type": "Polygon", "coordinates": [[[-117.57006, 33.63818], [-117.56954, 33.63885], [-117.56851, 33.63819], [-117.56793, 33.63796], [-117.56772, 33.63797], [-117.56754, 33.638], [-117.56734, 33.63809], [-117.56714, 33.63821], [-117.56675, 33.6382], [-117.56672, 33.63751], [-117.56682, 33.63751], [-117.56741, 33.63745], [-117.56825, 33.63745], [-117.56912, 33.63771], [-117.57006, 33.63818]]]} Restricted Access 2 30293 Swim & Racquet Complex 31709 6061 Rancho Santa Margarita Landscape and Recreation Corporation 622 Private 7 Home Owners Association 16 http://www.samlarc.org/ Private 14 6061 Rancho Santa Margarita Landscape and Recreation Corporation 611 Private 7 Home Owners Association 15   Orange 3 5.564 Swim & Racquet Complex 0 Private Conservation 16 2
13445 13445 13444 {"type": "Polygon", "coordinates": [[[-117.76081, 33.71748], [-117.7606, 33.71768], [-117.76047, 33.71785], [-117.76035, 33.71811], [-117.76026, 33.71821], [-117.76014, 33.71826], [-117.76006, 33.71834], [-117.76005, 33.71839], [-117.76007, 33.71842], [-117.76016, 33.71849], [-117.76013, 33.71857], [-117.76036, 33.71873], [-117.76026, 33.7188], [-117.76022, 33.71885], [-117.75996, 33.71872], [-117.75988, 33.71874], [-117.75984, 33.7187], [-117.75976, 33.71867], [-117.75892, 33.71777], [-117.75913, 33.71768], [-117.75975, 33.71737], [-117.76028, 33.71704], [-117.76057, 33.71725], [-117.76055, 33.71728], [-117.76081, 33.71748]]]} Restricted Access 2 35619 Park Paseo Recreation Center 32332 6016 Park Paseo Homeowners Association 1056 Private 7 Home Owners Association 16 http://parkpaseoirvine.com/ Private 14 6016 Park Paseo Homeowners Association 1015 Private 7 Home Owners Association 15   Orange 3 4.013 Park Paseo Rec. Ctr. 0 Private Conservation 16 2
13959 13959 13958 {"type": "Polygon", "coordinates": [[[-117.79032, 33.68059], [-117.78996, 33.68096], [-117.78968, 33.68077], [-117.78973, 33.68055], [-117.78979, 33.68042], [-117.7899, 33.68029], [-117.79032, 33.68059]]]} Restricted Access 2 36667 Woodspring Pool 32225 6034 Woodbridge Village Association 244 Private 7 Home Owners Association 16 http://www.wva.org/ Private 14 6034 Woodbridge Village Association 240 Private 7 Home Owners Association 15   Orange 3 0.596 Woodspring Pool 0 Private Conservation 16 2
14157 14157 14156 {"type": "Polygon", "coordinates": [[[-117.67909, 33.649], [-117.67893, 33.64913], [-117.67899, 33.64929], [-117.67864, 33.64938], [-117.67843, 33.64889], [-117.67844, 33.64887], [-117.67849, 33.64885], [-117.67865, 33.6488], [-117.67888, 33.64875], [-117.67905, 33.64874], [-117.67909, 33.64874], [-117.67911, 33.64877], [-117.67904, 33.64889], [-117.67905, 33.64895], [-117.67909, 33.649]]]} Restricted Access 2 43052 Sterling Heights park 32391 6044 Lake Forest Drive Association 1088 Private 7 Home Owners Association 16 http://lakeforestdrivehoa.org/ Private 14 6044 Lake Forest Drive Association 1044 Private 7 Home Owners Association 15   Orange 3 0.718 Sterling Heights park 0 Private Conservation 16 2
14781 14781 14780 {"type": "Polygon", "coordinates": [[[-116.94846, 32.64539], [-116.94839, 32.64551], [-116.94804, 32.64538], [-116.94761, 32.64525], [-116.94727, 32.64516], [-116.94683, 32.64507], [-116.94696, 32.64451], [-116.9465, 32.64443], [-116.94654, 32.64432], [-116.94654, 32.64418], [-116.94627, 32.64341], [-116.94628, 32.6433], [-116.94633, 32.64314], [-116.94659, 32.64328], [-116.94692, 32.6434], [-116.94793, 32.64356], [-116.9478, 32.64414], [-116.9478, 32.64431], [-116.94783, 32.64446], [-116.94788, 32.64461], [-116.94795, 32.64473], [-116.94839, 32.64535], [-116.94846, 32.64539]]]} Restricted Access 2 45168 Little League Ballfields 33364 6074 Home Owners Association - Unknown Name 640 Private 7 Home Owners Association 16   Private 14 6074 Home Owners Association - Unknown Name 629 Private 7 Home Owners Association 15   San Diego 4 6.308 Little League Ballfields 0 Private Conservation 16 2
14783 14783 14782 {"type": "Polygon", "coordinates": [[[-116.98285, 32.63543], [-116.98278, 32.63553], [-116.98274, 32.63564], [-116.98277, 32.63571], [-116.98272, 32.63579], [-116.98265, 32.63578], [-116.98257, 32.63579], [-116.9824, 32.63586], [-116.98222, 32.63538], [-116.98267, 32.63521], [-116.98278, 32.63525], [-116.98285, 32.63543]]]} Restricted Access 2 45170 The Breezeway 33355 6074 Home Owners Association - Unknown Name 640 Private 7 Home Owners Association 16   Private 14 6074 Home Owners Association - Unknown Name 629 Private 7 Home Owners Association 15   San Diego 4 0.674 The Breezeway 0 Private Conservation 16 2

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