Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 185277 | 185277 | 249599 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 7ft | 5998912.4282 | 2111428.40333 | 37.7775167022821 | -122.447308674267 | (37.7775167022821, -122.447308674267) | |||
| 183600 | 183600 | 250188 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5997295.794369999 | 2110912.47939 | 37.7760076003172 | -122.45286387197201 | (37.7760076003172, -122.452863871972) | ||||
| 177444 | 177444 | 250578 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 5997460.213380001 | 2111222.95498 | 37.7768695060652 | -122.452317514945 | (37.7768695060652, -122.452317514945) | |||
| 176192 | 176192 | 250598 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 10ft | 5998612.86839 | 2111383.01591 | 37.7773749583343 | -122.448341677839 | (37.7773749583343, -122.448341677839) | |||
| 176048 | 176048 | 250571 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5997270.54496 | 2111084.7365 | 37.7764791265377 | -122.45296365267299 | (37.7764791265377, -122.452963652673) | ||||
| 174357 | 174357 | 47273 | Permitted Site 1 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 8 | Permit Number 45219 | 6002244.66037 | 2088892.0690000001 | 37.715827083242296 | -122.43416990473999 | (37.7158270832423, -122.43416990474) | |
| 173485 | 173485 | 176092 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Italy Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 6002233.31845 | 2088899.94109 | 37.715848054527 | -122.434209670065 | (37.715848054527, -122.434209670065) | |||
| 172532 | 172532 | 190962 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1 Jack Balestreri Way | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6012415.27524 | 2104795.5991 | 37.7600668346491 | -122.400131588717 | (37.7600668346491, -122.400131588717) | ||||
| 171210 | 171210 | 119448 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 895 32nd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5986011.64571 | 2109832.7311 | 37.7723898247803 | -122.49181865574499 | (37.7723898247803, -122.491818655745) | ||||
| 169789 | 169789 | 190964 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1 Jack Balestreri Way | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6012433.13326 | 2104783.13919 | 37.760033618186895 | -122.400068950945 | (37.7600336181869, -122.400068950945) | ||||
| 169298 | 169298 | 250577 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 8ft | 5997444.6396 | 2111219.7245400003 | 37.776859743909895 | -122.452371155927 | (37.7768597439099, -122.452371155927) | |||
| 168385 | 168385 | 186505 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1400 Lower Great Hwy | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980903.7154 | 2105004.5327 | 37.7588331246947 | -122.509128554095 | (37.7588331246947, -122.509128554095) | |||
| 167519 | 167519 | 118972 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4400 Cabrillo St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5981914.76561 | 2110344.52005 | 37.7735547445483 | -122.50602785926 | (37.7735547445483, -122.50602785926) | |||
| 162932 | 162932 | 250593 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 7ft | 5998409.0493 | 2111353.9501099996 | 37.7772834963756 | -122.44904465719499 | (37.7772834963756, -122.449044657195) | |||
| 162345 | 162345 | 176093 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Italy Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 6002215.73545 | 2088910.6695299998 | 37.7158765144653 | -122.43427121154801 | (37.7158765144653, -122.434271211548) | |||
| 161739 | 161739 | 223690 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 3287 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006386.04454 | 2103750.12413 | 37.756858184863404 | -122.420909618783 | (37.7568581848634, -122.420909618783) | |||
| 161181 | 161181 | 250574 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 5997258.88405 | 2111163.19525 | 37.77669388555061 | -122.453009655693 | (37.7766938855506, -122.453009655693) | ||||
| 155381 | 155381 | 187544 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1400 Somerset St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6011380.55027 | 2088229.60878 | 37.714522389959996 | -122.40254530072201 | (37.71452238996, -122.402545300722) | ||||
| 153836 | 153836 | 250190 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 10ft | 5997282.93833 | 2110956.0047400002 | 37.7761263728801 | -122.45291148657 | (37.7761263728801, -122.45291148657) | |||
| 152682 | 152682 | 64515 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 720 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 6 | 3x3 | Permit Number 25396 | 6000553.55593738 | 2111421.0223091 | 37.7775900754915 | -122.44163095230499 | (37.7775900754915, -122.441630952305) |
| 152556 | 152556 | 223686 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 San Jose Ave | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6003580.53373 | 2095739.5097599998 | 37.734704360212 | -122.430040690922 | (37.734704360212, -122.430040690922) | ||||
| 146510 | 146510 | 250568 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5997280.420030001 | 2111005.26169 | 37.7762614753232 | -122.452923754242 | (37.7762614753232, -122.452923754242) | ||||
| 146159 | 146159 | 120634 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004538.0 | 2114050.0 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | |||||
| 144803 | 144803 | 8402 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6004544.7148816 | 2114057.9755695 | 37.785057082792605 | -122.428012143853 | (37.7850570827926, -122.428012143853) | |||
| 144553 | 144553 | 2278 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 750X Brotherhood Way | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 14M | 5991074.042616099 | 2088106.2478104 | 37.71302907778821 | -122.47272309171998 | (37.7130290777882, -122.47272309172) | |||
| 138493 | 138493 | 102479 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 760 Victoria St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | |||||
| 137941 | 137941 | 250595 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | 5998510.6665900005 | 2111373.95167 | 37.777344226694495 | -122.44869457271099 | (37.7773442266945, -122.448694572711) | ||||
| 131820 | 131820 | 250590 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | 5998102.22715 | 2111312.63197 | 37.7771524948281 | -122.45010307019501 | (37.7771524948281, -122.450103070195) | ||||
| 129690 | 129690 | 223684 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1101 San Jose Ave | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004763.09066 | 2096356.87709 | 37.7364664154027 | -122.425996119524 | (37.7364664154027, -122.425996119524) | ||||
| 128815 | 128815 | 19488 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2100X Sloat Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 20M | 5984311.7495235 | 2095837.0474516002 | 37.7338620509701 | -122.496665634298 | (37.7338620509701, -122.496665634298) | |||
| 127868 | 127868 | 110833 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 533 PARNASSUS AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 5995513.0 | 2106277.0 | 37.7631774598891 | -122.458695326495 | (37.7631774598891, -122.458695326495) | ||
| 127853 | 127853 | 19402 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 400X Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5990261.3597061 | 2096050.1007313998 | 37.7347938328013 | -122.47611180943998 | (37.7347938328013, -122.47611180944) | |||
| 126778 | 126778 | 30069 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 410X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | |||
| 126734 | 126734 | 19483 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1900X Sloat Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5984946.1404685 | 2095883.2432036998 | 37.734026040705 | -122.49447578991699 | (37.734026040705, -122.494475789917) | |||
| 126424 | 126424 | 8350 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 Geary Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 124449 | 124449 | 120631 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004538.0 | 2114050.0 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | |||||
| 124304 | 124304 | 101467 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 301 Hazelwood Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996219.7 | 2095283.8 | 37.733033461480495 | -122.45545652663701 | (37.7330334614805, -122.455456526637) | |||||
| 121372 | 121372 | 8654 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2800 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | M6 | 5998424.6782121 | 2113209.2212936003 | 37.782378482790605 | -122.449124279941 | (37.7823784827906, -122.449124279941) | |||
| 119634 | 119634 | 19404 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 500X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5989983.811155001 | 2096024.6780472 | 37.7347079305354 | -122.47706952310101 | (37.7347079305354, -122.477069523101) | |||
| 118725 | 118725 | 101468 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 301 Hazelwood Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996219.7 | 2095283.8 | 37.733033461480495 | -122.45545652663701 | (37.7330334614805, -122.455456526637) | |||||
| 118111 | 118111 | 176094 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 623 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001683.03766 | 2089869.05665 | 37.7184777818954 | -122.436181004657 | (37.7184777818954, -122.436181004657) | |||
| 116709 | 116709 | 19448 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1400X Sloat Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5986974.910261401 | 2095954.0242956001 | 37.734338913390395 | -122.48746699486 | (37.7343389133904, -122.48746699486) | |||
| 115465 | 115465 | 8338 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 113817 | 113817 | 19450 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5986548.454435701 | 2095908.9031645001 | 37.7341901424899 | -122.48893805509199 | (37.7341901424899, -122.488938055092) | |||
| 111082 | 111082 | 120632 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004538.0 | 2114050.0 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | |||||
| 109405 | 109405 | 87565 | Permitted Site 1 | Cupressocyparis leylandii :: Leyland Cypress 34 | 10 Corwin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50392 | 6000837.0 | 2103986.0 | 37.757191497186604 | -122.44011714333901 | (37.7571914971866, -122.440117143339) | |||
| 109070 | 109070 | 21145 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2292X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
| 109002 | 109002 | 8656 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2800 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | M6 | 5998424.6782121 | 2113209.2212936003 | 37.782378482790605 | -122.449124279941 | (37.7823784827906, -122.449124279941) | |||
| 108861 | 108861 | 19405 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 500X Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5989983.811155001 | 2096024.6780472 | 37.7347079305354 | -122.47706952310101 | (37.7347079305354, -122.477069523101) | |||
| 108713 | 108713 | 19398 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 300X Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5990549.2944821995 | 2096013.3169503002 | 37.7347095261344 | -122.475113645462 | (37.7347095261344, -122.475113645462) | |||
| 108127 | 108127 | 8347 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 107932 | 107932 | 120635 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004538.0 | 2114050.0 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | |||||
| 107311 | 107311 | 8352 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 Geary Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 106208 | 106208 | 87566 | Permitted Site 1 | Cupressocyparis leylandii :: Leyland Cypress 34 | 10 Corwin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50392 | 6000837.0 | 2103986.0 | 37.757191497186604 | -122.44011714333901 | (37.7571914971866, -122.440117143339) | |||
| 104755 | 104755 | 120630 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004538.0 | 2114050.0 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | |||||
| 99987 | 99987 | 2279 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 750X Brotherhood Way | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 14M | 5991074.042616099 | 2088106.2478104 | 37.71302907778821 | -122.47272309171998 | (37.7130290777882, -122.47272309172) | |||
| 99788 | 99788 | 19438 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1302X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5987401.6755259 | 2095951.2124586997 | 37.73435607254571 | -122.485991341651 | (37.7343560725457, -122.485991341651) | |||
| 99133 | 99133 | 8403 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500 Geary Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6004544.7148816 | 2114057.9755695 | 37.785057082792605 | -122.428012143853 | (37.7850570827926, -122.428012143853) | |||
| 98767 | 98767 | 87567 | Permitted Site 1 | Cupressocyparis leylandii :: Leyland Cypress 34 | 10 Corwin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50392 | 6000837.0 | 2103986.0 | 37.757191497186604 | -122.44011714333901 | (37.7571914971866, -122.440117143339) | |||
| 98102 | 98102 | 8336 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 96041 | 96041 | 19397 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 300X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5990549.2944821995 | 2096013.3169503002 | 37.7347095261344 | -122.475113645462 | (37.7347095261344, -122.475113645462) | |||
| 94093 | 94093 | 8343 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 93100 | 93100 | 8335 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 89785 | 89785 | 19396 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 200X Sloat Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5990818.433168401 | 2096048.8602468998 | 37.7348227139519 | -122.47418574326099 | (37.7348227139519, -122.474185743261) | |||
| 89661 | 89661 | 8345 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 87703 | 87703 | 8538 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2100 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6001688.6684406 | 2113658.1430724 | 37.7837972495813 | -122.43786449651002 | (37.7837972495813, -122.43786449651) | |||
| 87151 | 87151 | 2280 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 750X Brotherhood Way | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 14M | 5991074.042616099 | 2088106.2478104 | 37.71302907778821 | -122.47272309171998 | (37.7130290777882, -122.47272309172) | |||
| 87021 | 87021 | 30067 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 410X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | |||
| 86660 | 86660 | 19484 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2100X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 20M | 5984311.7495235 | 2095837.0474516002 | 37.7338620509701 | -122.496665634298 | (37.7338620509701, -122.496665634298) | |||
| 85535 | 85535 | 8337 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 85381 | 85381 | 8346 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
| 81695 | 81695 | 19437 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300X Sloat Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5987408.732224501 | 2095946.646093 | 37.734343945736896 | -122.485966609595 | (37.7343439457369, -122.485966609595) | |||
| 81389 | 81389 | 120633 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6004538.0 | 2114050.0 | 37.7850348039721 | -122.428034806681 | (37.7850348039721, -122.428034806681) | |||||
| 81205 | 81205 | 2285 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 750X Brotherhood Way | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5991074.042616099 | 2088106.2478104 | 37.71302907778821 | -122.47272309171998 | (37.7130290777882, -122.47272309172) | |||
| 81172 | 81172 | 19449 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1400X Sloat Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5986974.910261401 | 2095954.0242956001 | 37.734338913390395 | -122.48746699486 | (37.7343389133904, -122.48746699486) | |||
| 80866 | 80866 | 30068 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 410X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | |||
| 78932 | 78932 | 19395 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 200X Sloat Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5990818.433168401 | 2096048.8602468998 | 37.7348227139519 | -122.47418574326099 | (37.7348227139519, -122.474185743261) | |||
| 78151 | 78151 | 8655 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2800 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | M6 | 5998424.6782121 | 2113209.2212936003 | 37.782378482790605 | -122.449124279941 | (37.7823784827906, -122.449124279941) | |||
| 77855 | 77855 | 8604 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2400 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 6000257.3380802 | 2113384.6945808 | 37.7829649350443 | -122.442796706973 | (37.7829649350443, -122.442796706973) | |||
| 73961 | 73961 | 201525 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 740 Earl St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6020363.02265 | 2093708.60357 | 37.730064074283106 | -122.371876721056 | (37.7300640742831, -122.371876721056) | ||||
| 72328 | 72328 | 250573 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5997263.272609999 | 2111141.17003 | 37.7766336615401 | -122.45299288421002 | (37.7766336615401, -122.45299288421) | ||||
| 71537 | 71537 | 250581 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5997509.5198800005 | 2111229.44513 | 37.776890150891795 | -122.45214741807699 | (37.7768901508918, -122.452147418077) | ||||
| 70868 | 70868 | 118536 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 7915 Geary Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5982451.538919999 | 2112333.71263 | 37.7790480679712 | -122.504318500947 | (37.7790480679712, -122.504318500947) | |||
| 70548 | 70548 | 250586 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 5997628.86615 | 2111246.4251 | 37.7769436093046 | -122.451735790285 | (37.7769436093046, -122.451735790285) | |||
| 69246 | 69246 | 250569 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 5997276.1967400005 | 2111033.33857 | 37.7763383251004 | -122.452940390794 | (37.7763383251004, -122.452940390794) | ||||
| 67845 | 67845 | 249598 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 7ft | 5998888.01684 | 2111424.33867 | 37.7775041468442 | -122.447392828322 | (37.7775041468442, -122.447392828322) | |||
| 65487 | 65487 | 190963 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1 Jack Balestreri Way | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6012430.01623 | 2104809.07988 | 37.7601046718029 | -122.400081553118 | (37.7601046718029, -122.400081553118) | ||||
| 65004 | 65004 | 250587 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5997646.23108 | 2111248.80698 | 37.776951143824 | -122.451675891826 | (37.776951143824, -122.451675891826) | |||
| 64057 | 64057 | 190961 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 151 Wisconsin St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6012606.72224 | 2106809.23912 | 37.7656065163403 | -122.399610842559 | (37.7656065163403, -122.399610842559) | ||||
| 63445 | 63445 | 223691 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1407 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005889.20889 | 2100701.5416599996 | 37.7484594630387 | -122.422411257281 | (37.7484594630387, -122.422411257281) | |||
| 62280 | 62280 | 250596 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 5998572.26922 | 2111378.3859099997 | 37.7773599243436 | -122.44848178950899 | (37.7773599243436, -122.448481789509) | |||
| 61223 | 61223 | 223687 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 San Jose Ave | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 6003595.322819999 | 2095749.76231 | 37.7347333489588 | -122.429990291123 | (37.7347333489588, -122.429990291123) | ||||
| 60845 | 60845 | 250576 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 8ft | 5997348.720930001 | 2111207.04633 | 37.7768194372103 | -122.452702050664 | (37.7768194372103, -122.452702050664) | |||
| 55672 | 55672 | 250580 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 8ft | 5997493.10232 | 2111228.13721 | 37.7768856192175 | -122.45220411672399 | (37.7768856192175, -122.452204116724) | |||
| 52831 | 52831 | 250589 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5997875.419290001 | 2111281.04875 | 37.7770527941865 | -122.450885388659 | (37.7770527941865, -122.450885388659) | ||||
| 52572 | 52572 | 250594 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 5998426.00628 | 2111357.0235599997 | 37.7772929050689 | -122.448986219244 | (37.7772929050689, -122.448986219244) | |||
| 51245 | 51245 | 8477 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1900 Geary Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 50865 | 50865 | 250599 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5998631.4294 | 2111385.5677400003 | 37.7773830261474 | -122.44827765331499 | (37.7773830261474, -122.448277653315) | |||
| 50298 | 50298 | 250575 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | 5997256.45682 | 2111186.28266 | 37.776757138456794 | -122.453019719107 | (37.7767571384568, -122.453019719107) | ||||
| 47001 | 47001 | 122962 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 98 09th Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5993057.14542 | 2114935.59748 | 37.786810183441204 | -122.46781902207898 | (37.7868101834412, -122.467819022079) |
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");