Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
179027 | 179027 | 205907 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 30 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6000842.20104 | 2095534.19328 | 37.7339851426839 | -122.439493304878 | (37.7339851426839, -122.439493304878) | ||||
178921 | 178921 | 186554 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5984714.9821 | 2104746.2514 | 37.7583479137241 | -122.495928571528 | (37.7583479137241, -122.495928571528) | |||
178699 | 178699 | 176116 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Skyline Blvd | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5982365.02042 | 2092827.7229400002 | 37.725485007020296 | -122.503173222486 | (37.7254850070203, -122.503173222486) | |||
178626 | 178626 | 223814 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 47 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 10ft | 6003303.1448800005 | 2097708.7253900003 | 37.740095661872 | -122.43114022723499 | (37.740095661872, -122.431140227235) | |||
178194 | 178194 | 217837 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Cranleigh Dr | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5991408.51822 | 2095817.51986 | 37.7342216778764 | -122.472128777417 | (37.7342216778764, -122.472128777417) | ||||
178161 | 178161 | 186708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984718.4366 | 2105053.49 | 37.7591917076208 | -122.49593928954901 | (37.7591917076208, -122.495939289549) | |||
178149 | 178149 | 181354 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985076.1427 | 2099074.9211 | 37.742797140118796 | -122.494261514147 | (37.7427971401188, -122.494261514147) | |||
178107 | 178107 | 186569 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 40 | unknown : Yard 19 | Tree 1 | Private 1 | 26 | Width 0ft | 5984763.5541 | 2104672.9747 | 37.7581495609485 | -122.49575518551701 | (37.7581495609485, -122.495755185517) | |||
177404 | 177404 | 181475 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 0ft | 5984869.4504 | 2105277.3411 | 37.75981518382329 | -122.49543352861299 | (37.7598151838233, -122.495433528613) | |||
176904 | 176904 | 185257 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2570 33rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 71 | Width 0ft | 5986168.5104 | 2097746.1262 | 37.739212488149796 | -122.490386735185 | (37.7392124881498, -122.490386735185) | |||
176897 | 176897 | 186982 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 0ft | 5984958.5274 | 2098137.713 | 37.7402169360885 | -122.49459911154499 | (37.7402169360885, -122.494599111545) | |||
176884 | 176884 | 218149 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5994121.0220800005 | 2090034.4141 | 37.7184992747921 | -122.462331555861 | (37.7184992747921, -122.462331555861) | ||||
176669 | 176669 | 223743 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 65 Zircon Pl | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6002363.70914 | 2098682.85125 | 37.7427171047157 | -122.434458039421 | (37.7427171047157, -122.434458039421) | ||||
176606 | 176606 | 250697 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 877 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5985607.20317 | 2114948.81702 | 37.7864134812469 | -122.493594682746 | (37.7864134812469, -122.493594682746) | |||
176454 | 176454 | 184779 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 55 | Width 0ft | 5984701.0822 | 2105928.8672 | 37.7615942322964 | -122.496063889935 | (37.7615942322964, -122.496063889935) | |||
176394 | 176394 | 249925 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011155.36985 | 2120409.86411 | 37.802869621408796 | -122.40558877741002 | (37.8028696214088, -122.40558877741) | |||
176393 | 176393 | 249926 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011142.49576 | 2120408.96257 | 37.8028664261111 | -122.405633265077 | (37.8028664261111, -122.405633265077) | |||
176150 | 176150 | 138268 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800x GEARY BLVD | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | Width 0ft | 5998223.1317 | 2113127.3282 | 37.782142096338795 | -122.449815635357 | (37.7821420963388, -122.449815635357) | |||
176077 | 176077 | 176104 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6009423.2681599995 | 2090026.7428 | 37.7193474820922 | -122.409437239052 | (37.7193474820922, -122.409437239052) | |||
176055 | 176055 | 186244 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984769.2252 | 2103216.605 | 37.754151105704295 | -122.495628153173 | (37.7541511057043, -122.495628153173) | |||
176054 | 176054 | 223701 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 9ft | 6004786.9856 | 2096684.12369 | 37.7373663112035 | -122.425936792158 | (37.7373663112035, -122.425936792158) | |||
176049 | 176049 | 206870 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700 Junipero Serra Blvd | 153 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5991175.977080001 | 2091433.26758 | 37.7221701581122 | -122.47261319456699 | (37.7221701581122, -122.472613194567) | |||
175849 | 175849 | 218295 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Woodacre Dr | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | 5991182.782880001 | 2095348.63112 | 37.7329211619833 | -122.47287502947701 | (37.7329211619833, -122.472875029477) | ||||
175790 | 175790 | 176118 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3500 Great Hwy | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5982159.440219999 | 2092886.81947 | 37.7256351838922 | -122.50388825816201 | (37.7256351838922, -122.503888258162) | |||
175707 | 175707 | 206835 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Casitas Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 5995050.15142 | 2095828.17097 | 37.7344609919799 | -122.459539348883 | (37.7344609919799, -122.459539348883) | |||
175698 | 175698 | 205893 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1110 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 5998235.76076 | 2095666.83858 | 37.734200671531504 | -122.448514080556 | (37.7342006715315, -122.448514080556) | |||
175611 | 175611 | 206907 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5996091.97052 | 2094634.86515 | 37.731244313077895 | -122.455851223752 | (37.7312443130779, -122.455851223752) | |||
175601 | 175601 | 176161 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990361.86615 | 2090050.7376 | 37.718326916127204 | -122.475326462647 | (37.7183269161272, -122.475326462647) | ||||
175582 | 175582 | 187210 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 0ft | 5984940.3895 | 2098925.3948 | 37.742378636211 | -122.494719881886 | (37.742378636211, -122.494719881886) | |||
175546 | 175546 | 185684 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 0ft | 5984861.742000001 | 2100618.807 | 37.7470236824891 | -122.495116662039 | (37.7470236824891, -122.495116662039) | |||
175510 | 175510 | 190973 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | 6011275.27355 | 2104274.28266 | 37.7585717863791 | -122.404037642038 | (37.7585717863791, -122.404037642038) | ||||
175414 | 175414 | 223770 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 340 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007775.55004 | 2105926.88107 | 37.7629132824304 | -122.416258345863 | (37.7629132824304, -122.416258345863) | |||
175401 | 175401 | 185622 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5985035.4121 | 2100280.3783 | 37.7461046152286 | -122.494491190588 | (37.7461046152286, -122.494491190588) | |||
175203 | 175203 | 205904 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 172 Kensington Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994739.17505 | 2098652.52014 | 37.7421980699986 | -122.460819110215 | (37.7421980699986, -122.460819110215) | |||
175190 | 175190 | 186383 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | Width 0ft | 5984821.7301 | 2102416.5017 | 37.751957317115895 | -122.49538757696999 | (37.7519573171159, -122.49538757697) | |||
175132 | 175132 | 185488 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 41 | unknown : Yard 19 | Tree 1 | Private 1 | 27 | Width 0ft | 5985122.4012 | 2098536.3046 | 37.741320951397704 | -122.494061879541 | (37.7413209513977, -122.494061879541) | |||
175066 | 175066 | 186302 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1800 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984990.1286 | 2102749.3532 | 37.7528810944721 | -122.49482977812 | (37.7528810944721, -122.49482977812) | |||
174966 | 174966 | 185935 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2000 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985034.4441 | 2101527.1648 | 37.7495278943342 | -122.494586435864 | (37.7495278943342, -122.494586435864) | |||
174648 | 174648 | 223764 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 126 Bradford St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6009530.67949 | 2097860.55808 | 37.7408634922583 | -122.40961857835899 | (37.7408634922583, -122.409618578359) | |||
174595 | 174595 | 176128 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3500 Great Hwy | 15 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5982352.93882 | 2092754.66757 | 37.7252837063712 | -122.503209580278 | (37.7252837063712, -122.503209580278) | |||
174433 | 174433 | 223744 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 591 27th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6002700.253169999 | 2100030.0951900003 | 37.746435420069396 | -122.433390619685 | (37.7464354200694, -122.433390619685) | |||
174389 | 174389 | 186633 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980876.555 | 2105686.5399 | 37.760704119089 | -122.509273133786 | (37.760704119089, -122.509273133786) | |||
174210 | 174210 | 205916 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 506 Congo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6000130.425 | 2095272.3934400002 | 37.73322576685489 | -122.44193534195401 | (37.7332257668549, -122.441935341954) | |||
174207 | 174207 | 184747 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 54 | Width 0ft | 5984699.9431 | 2106151.5726 | 37.7622056521899 | -122.496084260471 | (37.7622056521899, -122.496084260471) | |||
174101 | 174101 | 176141 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 1 | : 4 | Tree 1 | Private 1 | 48 | Width 0ft | 5987562.65817 | 2089512.7313599999 | 37.7166870365437 | -122.484962576069 | (37.7166870365437, -122.484962576069) | |||
174021 | 174021 | 206805 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 68 Aerial Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 2ft | 5992337.85259 | 2102586.3377799997 | 37.752860862941205 | -122.469408341716 | (37.7528608629412, -122.469408341716) | |||
173594 | 173594 | 118511 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 8131 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 5981763.277969999 | 2112328.08269 | 37.7789921064061 | -122.506699014872 | (37.7789921064061, -122.506699014872) | |||
173530 | 173530 | 190974 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6011278.73233 | 2104250.4136900003 | 37.7585064407439 | -122.404024000205 | (37.7585064407439, -122.404024000205) | ||||
173128 | 173128 | 185117 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200x Sloat Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 5987506.2336 | 2095918.1597 | 37.7342714110431 | -122.485627430105 | (37.7342714110431, -122.485627430105) | |||
172875 | 172875 | 223813 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 80 Digby St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 46 | Width 10ft | 6002637.262130001 | 2097732.72749 | 37.740123809771 | -122.43344429032301 | (37.740123809771, -122.433444290323) | |||
172749 | 172749 | 186574 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 45 | unknown : Yard 19 | Tree 1 | Private 1 | 46 | Width 0ft | 5984720.0068 | 2104642.8266 | 37.7580642323025 | -122.495903564638 | (37.7580642323025, -122.495903564638) | |||
172674 | 172674 | 223806 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 177 Moffitt St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6002417.80157 | 2097060.2548599998 | 37.7382649020917 | -122.434155033533 | (37.7382649020917, -122.434155033533) | |||
172640 | 172640 | 185503 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 57 | unknown : Yard 19 | Tree 1 | Private 1 | 40 | Width 0ft | 5985131.0337 | 2098785.3193 | 37.7420051837622 | -122.49405038008001 | (37.7420051837622, -122.49405038008) | |||
172551 | 172551 | 176108 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 6005255.13814 | 2086372.0334299998 | 37.7090780076251 | -122.4235852251 | (37.7090780076251, -122.4235852251) | ||||
172549 | 172549 | 223727 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 295 Coso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6007771.677 | 2099478.1901599998 | 37.745206426340204 | -122.415815087109 | (37.7452064263402, -122.415815087109) | |||
172439 | 172439 | 206843 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Lobos St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5996870.71882 | 2088697.5203900002 | 37.7149864275584 | -122.45273060322901 | (37.7149864275584, -122.452730603229) | ||||
172394 | 172394 | 185209 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2500 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 0ft | 5985139.3342 | 2098053.216 | 37.73999551086 | -122.493967737883 | (37.73999551086, -122.493967737883) | |||
172365 | 172365 | 186543 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 21 | Width 0ft | 5984724.0894 | 2104873.2294 | 37.7586970933352 | -122.495906441969 | (37.7586970933352, -122.495906441969) | |||
172361 | 172361 | 186738 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5984873.2407 | 2106599.9288 | 37.7634468615844 | -122.495517968799 | (37.7634468615844, -122.495517968799) | |||
171960 | 171960 | 205890 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Stanford Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5997823.46765 | 2095740.1408099998 | 37.7343783595712 | -122.449944783251 | (37.7343783595712, -122.449944783251) | |||
171921 | 171921 | 184062 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1600 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 55 | Width 0ft | 5984941.4086 | 2103928.0299 | 37.7561145632567 | -122.49508516598499 | (37.7561145632567, -122.495085165985) | |||
171449 | 171449 | 249865 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1497 Montgomery St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 0ft | 6011350.601919999 | 2120707.91777 | 37.8036989186248 | -122.404934168095 | (37.8036989186248, -122.404934168095) | |||
171399 | 171399 | 184735 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984680.1977 | 2106291.6891 | 37.7625892162308 | -122.496162889393 | (37.7625892162308, -122.496162889393) | |||
171283 | 171283 | 206818 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5993615.2443699995 | 2100968.4802 | 37.748492377339204 | -122.46487343566601 | (37.7484923773392, -122.464873435666) | ||||
171157 | 171157 | 176146 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 7 | : 4 | Tree 1 | Private 1 | 40 | Width 0ft | 5987590.810219999 | 2090334.9259400002 | 37.7189462144818 | -122.48492555458999 | (37.7189462144818, -122.48492555459) | |||
171054 | 171054 | 206834 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Casitas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 5ft | 5995064.96816 | 2095832.8748700002 | 37.7344747596986 | -122.45948846344 | (37.7344747596986, -122.45948846344) | |||
170927 | 170927 | 181465 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984920.1337 | 2105218.8604 | 37.7596575796755 | -122.495253929823 | (37.7596575796755, -122.495253929823) | |||
170870 | 170870 | 249922 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011172.25119 | 2120397.10621 | 37.802835535282604 | -122.405529459923 | (37.8028355352826, -122.405529459923) | |||
170557 | 170557 | 223763 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 126 Bradford St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6009530.79254 | 2097866.09723 | 37.740878707894296 | -122.409618578334 | (37.7408787078943, -122.409618578334) | |||
170501 | 170501 | 205908 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6000855.4988 | 2095527.0411599998 | 37.733966261424 | -122.43944681802799 | (37.733966261424, -122.439446818028) | ||||
170407 | 170407 | 223738 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6002028.666809999 | 2098687.0013900003 | 37.742709475762894 | -122.43561681495899 | (37.7427094757629, -122.435616814959) | ||||
170223 | 170223 | 223772 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 310 Liberty St | 45 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 3ft | 6003858.111380001 | 2103926.6096799998 | 37.7571999560244 | -122.429664736557 | (37.7571999560244, -122.429664736557) | |||
170171 | 170171 | 223739 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6002032.6649400005 | 2098618.50085 | 37.7425216163939 | -122.43559809108 | (37.7425216163939, -122.43559809108) | ||||
169563 | 169563 | 223779 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 731 Noe St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6003094.682440001 | 2103994.83983 | 37.7573440418231 | -122.43230984055201 | (37.7573440418231, -122.432309840552) | |||
168711 | 168711 | 187185 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984955.2043 | 2099180.2099 | 37.7430791567104 | -122.49468743945299 | (37.7430791567104, -122.494687439453) | |||
168655 | 168655 | 223734 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4379 Cesar Chavez St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 6001460.85322 | 2100259.68732 | 37.7469954324125 | -122.43769275603901 | (37.7469954324125, -122.437692756039) | |||
168599 | 168599 | 176157 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 0ft | 5988327.5004199995 | 2088688.82584 | 37.714469318273004 | -122.482258598878 | (37.714469318273, -122.482258598878) | |||
168435 | 168435 | 176111 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 64 | 6005239.18473 | 2086329.3019599998 | 37.7089597755375 | -122.423637326411 | (37.7089597755375, -122.423637326411) | ||||
168306 | 168306 | 206810 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 66x Santa Monica Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993662.74276 | 2097416.4076799997 | 37.7387420203269 | -122.464451319071 | (37.7387420203269, -122.464451319071) | ||||
168086 | 168086 | 187007 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 0ft | 5984985.2617 | 2098061.8817 | 37.740010288446705 | -122.494501087771 | (37.7400102884467, -122.494501087771) | |||
168070 | 168070 | 250204 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 206 Union St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 6011843.5346800005 | 2119802.5611900003 | 37.8012405714539 | -122.403164615272 | (37.8012405714539, -122.403164615272) | |||
168039 | 168039 | 184986 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985020.5458 | 2096630.2336 | 37.7360814314996 | -122.494273593011 | (37.7360814314996, -122.494273593011) | |||
168002 | 168002 | 118630 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 349 Point Lobos Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5981637.79887 | 2112651.0038099997 | 37.7798713628306 | -122.507157052361 | (37.7798713628306, -122.507157052361) | ||||
167901 | 167901 | 185517 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 56 | Width 0ft | 5984884.6253 | 2100174.2165 | 37.745804297711395 | -122.495004757586 | (37.7458042977114, -122.495004757586) | |||
167760 | 167760 | 181426 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984929.045 | 2104818.9637 | 37.7585600964022 | -122.495193620608 | (37.7585600964022, -122.495193620608) | |||
167728 | 167728 | 201724 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6017165.24184 | 2095383.9343 | 37.7344880327856 | -122.383048514986 | (37.7344880327856, -122.383048514986) | ||||
167665 | 167665 | 186108 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984809.6117 | 2101640.7232 | 37.749826532853206 | -122.495372275422 | (37.7498265328532, -122.495372275422) | |||
167641 | 167641 | 190982 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6016087.28584 | 2100258.68622 | 37.7478134836207 | -122.387115296958 | (37.7478134836207, -122.387115296958) | ||||
167561 | 167561 | 186155 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1700 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984957.7478 | 2103324.5301 | 37.7544584761874 | -122.494984162752 | (37.7544584761874, -122.494984162752) | |||
167310 | 167310 | 186295 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1800 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 0ft | 5984980.8659 | 2102682.5007 | 37.752696993700106 | -122.49485688111099 | (37.7526969937001, -122.494856881111) | |||
167290 | 167290 | 185908 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2000 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985025.7545 | 2101367.4934 | 37.7490889717309 | -122.49460471461799 | (37.7490889717309, -122.494604714618) | |||
167137 | 167137 | 206811 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 66x Santa Monica Way | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 5993507.09013 | 2097468.08947 | 37.738874951811795 | -122.464993240656 | (37.7388749518118, -122.464993240656) | ||||
167101 | 167101 | 121995 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 598 15th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5991309.97219 | 2111418.90918 | 37.777053286089604 | -122.473607150419 | (37.7770532860896, -122.473607150419) | |||
167034 | 167034 | 176166 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 654 Peru Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 30 | 6005147.67241 | 2092530.2100099998 | 37.7259809651314 | -122.424394360408 | (37.7259809651314, -122.424394360408) | ||||
166986 | 166986 | 223780 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4071 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | Width 3ft | 6003254.362819999 | 2104156.16383 | 37.757796051860296 | -122.431769121362 | (37.7577960518603, -122.431769121362) | |||
166767 | 166767 | 223718 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 59 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005036.8773300005 | 2096676.581 | 37.7373597200698 | -122.42507226308999 | (37.7373597200698, -122.42507226309) | ||||
166696 | 166696 | 223775 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 615 Sanchez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 3ft | 6003692.3051 | 2104663.83541 | 37.7592148124283 | -122.43029075463998 | (37.7592148124283, -122.43029075464) | |||
166681 | 166681 | 185521 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984914.3316 | 2100160.6922 | 37.7457689026555 | -122.494901041959 | (37.7457689026555, -122.494901041959) | |||
166548 | 166548 | 206841 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 246 Thrift St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5994549.17298 | 2089660.24802 | 37.7174965486989 | -122.46082452325199 | (37.7174965486989, -122.460824523252) | ||||
166544 | 166544 | 176163 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 654 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6005125.75661 | 2092550.7271200002 | 37.726036063007705 | -122.42447158070601 | (37.7260360630077, -122.424471580706) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");