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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102990 | 102990 | 110725 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3514 25TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006378.0 | 2101471.0 | 37.7505997812246 | -122.42077564246901 | (37.7505997812246, -122.420775642469) | ||||
| 104562 | 104562 | 110727 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3514 25TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006378.0 | 2101471.0 | 37.7505997812246 | -122.42077564246901 | (37.7505997812246, -122.420775642469) | ||||
| 108556 | 108556 | 110723 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3514 25TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6006378.0 | 2101471.0 | 37.7505997812246 | -122.42077564246901 | (37.7505997812246, -122.420775642469) | |||
| 83618 | 83618 | 693 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1299X Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 91816 | 91816 | 694 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1299X Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 79496 | 79496 | 96947 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 900X Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 6x6 | 6007389.0 | 2101516.0 | 37.750780272338 | -122.41728270280899 | (37.750780272338, -122.417282702809) | |||
| 92716 | 92716 | 109925 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 375 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005525.2 | 2101540.6 | 37.750742783376495 | -122.423729644924 | (37.7507427833765, -122.423729644924) | |||
| 83524 | 83524 | 24454 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1384 Valencia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.750802300176396 | -122.42083421458901 | (37.7508023001764, -122.420834214589) | |||
| 83805 | 83805 | 24453 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1384 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.750802300176396 | -122.42083421458901 | (37.7508023001764, -122.420834214589) | |||
| 89692 | 89692 | 24451 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1384 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.750802300176396 | -122.42083421458901 | (37.7508023001764, -122.420834214589) | |||
| 90591 | 90591 | 24452 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1384 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.750802300176396 | -122.42083421458901 | (37.7508023001764, -122.420834214589) | |||
| 90516 | 90516 | 20972 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 95236 | 95236 | 20974 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 97048 | 97048 | 20975 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 105725 | 105725 | 57735 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 364 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 16 | Permit Number 31982 | 6005454.9599493 | 2101588.78174199 | 37.7508711140338 | -122.423975967283 | (37.7508711140338, -122.423975967283) | ||
| 10207 | 10207 | 58902 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 15 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1980 12:00:00 AM | Permit Number 18176 | 6005036.25199829 | 2101622.63318287 | 37.7509404143338 | -122.425426308198 | (37.7509404143338, -122.425426308198) | |||
| 51254 | 51254 | 120965 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1145x Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003243.0 | 2101623.0 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | ||||
| 79876 | 79876 | 120964 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1145x Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003243.0 | 2101623.0 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | ||||
| 113545 | 113545 | 120966 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1145x Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003243.0 | 2101623.0 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | ||||
| 102537 | 102537 | 61449 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1330-1332 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1984 12:00:00 AM | Permit Number 21384 | 6002514.93546023 | 2101705.58374617 | 37.7510254010171 | -122.434151182595 | (37.7510254010171, -122.434151182595) | |||
| 83775 | 83775 | 55163 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1328 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1993 12:00:00 AM | Permit Number 31912 | 6002514.24849197 | 2101716.89965545 | 37.751056432832996 | -122.43415436705601 | (37.751056432833, -122.434154367056) | |||
| 112670 | 112670 | 26518 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2881 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6009034.88918 | 2101730.9691 | 37.751462990880796 | -122.411606237117 | (37.7514629908808, -122.411606237117) | |||
| 142651 | 142651 | 97110 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1095X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003193.9 | 2101874.0 | 37.751526344012 | -122.43181528051201 | (37.751526344012, -122.431815280512) | |||
| 142870 | 142870 | 5595 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1100 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 6005095.523502599 | 2101950.1341989 | 37.75184300486389 | -122.425244643333 | (37.7518430048639, -122.425244643333) | |||
| 79832 | 79832 | 665 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 80256 | 80256 | 668 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 107557 | 107557 | 669 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 94052 | 94052 | 631 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | |||
| 120426 | 120426 | 632 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3179 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | |||
| 17517 | 17517 | 653 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3255X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 3 | 4x4 | 6007260.4251 | 2102038.7621 | 37.752208423697205 | -122.41776437753201 | (37.7522084236972, -122.417764377532) | |||
| 139997 | 139997 | 97109 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1095X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003187.0 | 2102045.0 | 37.751995478526204 | -122.431851350128 | (37.7519954785262, -122.431851350128) | |||
| 78930 | 78930 | 57108 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 280 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 24 | 6x6 | Permit Number 14378 | 6004748.38429029 | 2102046.50032189 | 37.752087986316106 | -122.42645196024401 | (37.7520879863161, -122.426451960244) | |
| 109289 | 109289 | 5589 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1082 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6005080.54834 | 2102051.49498 | 37.7521204720239 | -122.425303641737 | (37.7521204720239, -122.425303641737) | |||
| 123525 | 123525 | 96948 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 900X Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 6x6 | 6007359.7 | 2102053.2 | 37.752253653062404 | -122.417422091759 | (37.7522536530624, -122.417422091759) | |||
| 109132 | 109132 | 624 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3157 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6007970.52254 | 2102065.21548 | 37.752320993709 | -122.415310615518 | (37.752320993709, -122.415310615518) | |||
| 113025 | 113025 | 662 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3290X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6007123.820387 | 2102082.126741 | 37.7523198047665 | -122.418239853186 | (37.7523198047665, -122.418239853186) | |||
| 124341 | 124341 | 661 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3290X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6007123.820387 | 2102082.126741 | 37.7523198047665 | -122.418239853186 | (37.7523198047665, -122.418239853186) | |||
| 103916 | 103916 | 618 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3141X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008071.59955 | 2102085.94599 | 37.7523835952977 | -122.41496254106501 | (37.7523835952977, -122.414962541065) | |||
| 120933 | 120933 | 617 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3141X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008071.59955 | 2102085.94599 | 37.7523835952977 | -122.41496254106501 | (37.7523835952977, -122.414962541065) | |||
| 78183 | 78183 | 575 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3007 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008864.65035 | 2102095.7164 | 37.752454954328606 | -122.41222072226999 | (37.7524549543286, -122.41222072227) | |||
| 91976 | 91976 | 645 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 94745 | 94745 | 649 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 108234 | 108234 | 648 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 124697 | 124697 | 647 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 129104 | 129104 | 646 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 20818 | 20818 | 603 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3085 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008454.62539 | 2102106.73452 | 37.752462191692295 | -122.413639440921 | (37.7524621916923, -122.413639440921) | |||
| 82184 | 82184 | 121122 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2701X 24th St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6010429.0 | 2102109.0 | 37.752579083030895 | -122.406811850318 | (37.7525790830309, -122.406811850318) | ||||
| 85158 | 85158 | 121118 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2701X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010429.0 | 2102109.0 | 37.752579083030895 | -122.406811850318 | (37.7525790830309, -122.406811850318) | ||||
| 95980 | 95980 | 121119 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2701X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010429.0 | 2102109.0 | 37.752579083030895 | -122.406811850318 | (37.7525790830309, -122.406811850318) | ||||
| 103379 | 103379 | 121117 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2701X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6010429.0 | 2102109.0 | 37.752579083030895 | -122.406811850318 | (37.7525790830309, -122.406811850318) | |||
| 109293 | 109293 | 121120 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2701X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010429.0 | 2102109.0 | 37.752579083030895 | -122.406811850318 | (37.7525790830309, -122.406811850318) | ||||
| 111952 | 111952 | 121123 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2701X 24th St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 24 | 3x3 | 6010429.0 | 2102109.0 | 37.752579083030895 | -122.406811850318 | (37.7525790830309, -122.406811850318) | |||
| 123995 | 123995 | 601 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3085 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6008510.860679401 | 2102109.8045166 | 37.7524737788751 | -122.413445186335 | (37.7524737788751, -122.413445186335) | ||||
| 111485 | 111485 | 635 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3198 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6007763.62302 | 2102126.97717 | 37.752478946803606 | -122.416030482711 | (37.7524789468036, -122.416030482711) | |||
| 20099 | 20099 | 615 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3134X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6008105.608030001 | 2102127.9045700002 | 37.752500715042295 | -122.414847903135 | (37.7525007150423, -122.414847903135) | |||
| 139691 | 139691 | 634 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3194 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 6007781.42285 | 2102140.57786 | 37.7525172919755 | -122.41596989079201 | (37.7525172919755, -122.415969890792) | |||
| 106647 | 106647 | 541 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009654.44601 | 2102141.49288 | 37.752624931831 | -122.409492696033 | (37.752624931831, -122.409492696033) | |||
| 106609 | 106609 | 506 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2773 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.75265268273179 | -122.407779587097 | (37.7526526827318, -122.407779587097) | |||
| 120595 | 120595 | 510 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2781 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.75265268273179 | -122.407779587097 | (37.7526526827318, -122.407779587097) | |||
| 95024 | 95024 | 628 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3166 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6007874.17365 | 2102144.23632 | 37.7525325514911 | -122.41564940087 | (37.7525325514911, -122.41564940087) | |||
| 113541 | 113541 | 585 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3035 24TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 122 | 3x3 | 6008718.0 | 2102146.0 | 37.752584791835105 | -122.412731419953 | (37.7525847918351, -122.412731419953) | |||
| 78051 | 78051 | 18469 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4X4 | 6010532.642999999 | 2102160.24981 | 37.752725602318705 | -122.406457044136 | (37.7527256023187, -122.406457044136) | |||
| 1579 | 1579 | 588 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3044 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008688.10488 | 2102161.42262 | 37.7526254609089 | -122.412835893087 | (37.7526254609089, -122.412835893087) | |||
| 78264 | 78264 | 525 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009855.900330001 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | |||
| 139910 | 139910 | 48952 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3046 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2002 12:00:00 AM | 28 | Permit Number 46137 | 6008657.12939462 | 2102169.92315078 | 37.7526470627455 | -122.412943613067 | (37.7526470627455, -122.412943613067) | |
| 106676 | 106676 | 550 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2899 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009498.42946 | 2102171.88233 | 37.75269963130629 | -122.410034375932 | (37.7526996313063, -122.410034375932) | |||
| 120746 | 120746 | 94550 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2851 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 6x5 | 6009753.55231 | 2102181.05227 | 37.7527391057434 | -122.40915275887 | (37.7527391057434, -122.40915275887) | |||
| 115579 | 115579 | 583 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3032 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008758.82346 | 2102183.2401799997 | 37.7526893362197 | -122.412592877178 | (37.7526893362197, -122.412592877178) | |||
| 141446 | 141446 | 18468 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6010533.61703 | 2102196.70237 | 37.7528257474783 | -122.40645624412201 | (37.7528257474783, -122.406456244122) | |||
| 85222 | 85222 | 504 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2763 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010225.39225 | 2102202.2647 | 37.7528237725585 | -122.407522539236 | (37.7528237725585, -122.407522539236) | |||
| 115822 | 115822 | 51485 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 253 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2005 12:00:00 AM | Permit Number 47796 | 6004792.25802571 | 2102204.70843345 | 37.7525248690267 | -122.426311501214 | (37.7525248690267, -122.426311501214) | |||
| 114567 | 114567 | 121561 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1044 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6003754.0 | 2102206.0 | 37.7524696725481 | -122.42990206526301 | (37.7524696725481, -122.429902065263) | |||
| 93429 | 93429 | 594 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3056 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008579.288380001 | 2102218.52685 | 37.7527761477761 | -122.413216238549 | (37.7527761477761, -122.413216238549) | |||
| 128642 | 128642 | 516 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2800 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010023.971 | 2102231.1332900003 | 37.7528917628192 | -122.408221130018 | (37.7528917628192, -122.408221130018) | |||
| 88349 | 88349 | 59060 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4437 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1992 12:00:00 AM | 14 | 2x2 | Permit Number 30882 | 6000423.21385776 | 2102243.23045707 | 37.75238271007429 | -122.441423120737 | (37.7523827100743, -122.441423120737) | |
| 80364 | 80364 | 573 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2990 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 776380 | 6009007.8652800005 | 2102243.7741799997 | 37.752869522851704 | -122.411735919997 | (37.7528695228517, -122.411735919997) | ||
| 123037 | 123037 | 570 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2972 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6009057.78841 | 2102246.54845 | 37.7528799408325 | -122.411563471864 | (37.7528799408325, -122.411563471864) | |||
| 146193 | 146193 | 505 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2766X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010189.63609 | 2102250.35484 | 37.7529538159215 | -122.40764958164499 | (37.7529538159215, -122.407649581645) | |||
| 128032 | 128032 | 578 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3024 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6008810.60715 | 2102251.6242299997 | 37.7528800095792 | -122.41241863259701 | (37.7528800095792, -122.412418632597) | |||
| 113086 | 113086 | 486 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2708 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010515.41751 | 2102258.44338 | 37.7529942564805 | -122.40652353202299 | (37.7529942564805, -122.406523532023) | |||
| 115050 | 115050 | 511 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010123.24297 | 2102258.68458 | 37.7529729707581 | -122.407879770058 | (37.7529729707581, -122.407879770058) | |||
| 109865 | 109865 | 96913 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 65X Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005919.1 | 2102263.8 | 37.752750751809394 | -122.422418882903 | (37.7527507518094, -122.422418882903) | ||||
| 128389 | 128389 | 512 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010086.59475 | 2102267.66488 | 37.7529955768562 | -122.40800714042601 | (37.7529955768562, -122.408007140426) | |||
| 86273 | 86273 | 4418 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1128 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004420.057130001 | 2102283.99445 | 37.752721523998 | -122.427604283815 | (37.752721523998, -122.427604283815) | |||
| 87388 | 87388 | 488 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2728 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | |||
| 94730 | 94730 | 490 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2734 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | |||
| 96939 | 96939 | 113833 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 932 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 6007966.0 | 2102301.0 | 37.752968150444204 | -122.415342945464 | (37.7529681504442, -122.415342945464) | ||||
| 66021 | 66021 | 485 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010468.2249 | 2102315.4128099997 | 37.7531480416193 | -122.40669074837099 | (37.7531480416193, -122.406690748371) | |||
| 114145 | 114145 | 482 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1182X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6010538.0981 | 2102333.37734 | 37.75320127739371 | -122.406450377502 | (37.7532012773937, -122.406450377502) | |||
| 85412 | 85412 | 18467 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1185X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010590.614238201 | 2102338.4990144 | 37.7532182781408 | -122.40626912604701 | (37.7532182781408, -122.406269126047) | |||
| 124730 | 124730 | 18463 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1185X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6010590.614238201 | 2102338.4990144 | 37.7532182781408 | -122.40626912604701 | (37.7532182781408, -122.406269126047) | |||
| 77711 | 77711 | 484 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.40670053704201 | (37.7532507356841, -122.406700537042) | |||
| 18014 | 18014 | 113224 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 4244 23RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001623.0 | 2102374.0 | 37.752810049427794 | -122.437283434624 | (37.7528100494278, -122.437283434624) | ||||
| 92883 | 92883 | 18465 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1176 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2015 12:00:00 AM | 45 | 3X4 | 6010529.14326 | 2102401.59944 | 37.7533880992141 | -122.40648615219 | (37.7533880992141, -122.40648615219) | ||
| 114377 | 114377 | 18462 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1170 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6010530.25012 | 2102443.0228 | 37.7535019005095 | -122.406485243092 | (37.7535019005095, -122.406485243092) | |||
| 88258 | 88258 | 109000 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 circle | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | |||
| 108764 | 108764 | 109005 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | ||||
| 111519 | 111519 | 109004 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | ||||
| 112794 | 112794 | 109003 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | ||||
| 126595 | 126595 | 109001 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) |
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");