Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33356 | 33356 | 248279 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 111 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006822.34586 | 2098891.67697 | 37.743542578041 | -122.419056125953 | (37.743542578041, -122.419056125953) | |||
| 183547 | 183547 | 248276 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.41927801298401 | (37.7431956465585, -122.419278012984) | |||
| 46452 | 46452 | 248275 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006752.53211 | 2098758.7700799997 | 37.743173713897 | -122.41928809889299 | (37.743173713897, -122.419288098893) | |||
| 135232 | 135232 | 248274 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006747.61558 | 2098750.1570099997 | 37.743149787441 | -122.419304488116 | (37.743149787441, -122.419304488116) | |||
| 167049 | 167049 | 248271 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 157 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006700.68835 | 2098666.52237 | 37.7429175024299 | -122.419460818167 | (37.7429175024299, -122.419460818167) | |||
| 60186 | 60186 | 248270 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 157 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006694.18006 | 2098651.40644 | 37.7428756308979 | -122.419482249905 | (37.7428756308979, -122.419482249905) | |||
| 50402 | 50402 | 248264 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006711.60121 | 2098736.3727599997 | 37.743109910586 | -122.419428038785 | (37.743109910586, -122.419428038785) | |||
| 68659 | 68659 | 248263 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006717.3063 | 2098747.87418 | 37.743141812234505 | -122.41940912783899 | (37.7431418122345, -122.419409127839) | |||
| 45389 | 45389 | 248262 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | |||
| 104259 | 104259 | 248261 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | |||
| 165360 | 165360 | 248260 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 132 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006738.11061 | 2098784.48151 | 37.7432434994904 | -122.419339788302 | (37.7432434994904, -122.419339788302) | |||
| 66722 | 66722 | 248258 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006769.1868199995 | 2098841.93634 | 37.7434030077589 | -122.41923640944201 | (37.7434030077589, -122.419236409442) | |||
| 179238 | 179238 | 248257 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006778.60351 | 2098856.6294 | 37.7434438819296 | -122.41920489088899 | (37.7434438819296, -122.419204890889) | |||
| 156357 | 156357 | 248255 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 116 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006791.47872 | 2098879.96545 | 37.7435086825726 | -122.41916202653 | (37.7435086825726, -122.41916202653) | |||
| 45296 | 45296 | 248254 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006798.65634 | 2098892.16282 | 37.7435425780247 | -122.419138073069 | (37.7435425780247, -122.419138073069) | |||
| 176531 | 176531 | 248253 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006804.331590001 | 2098902.21261 | 37.7435704920937 | -122.419119162122 | (37.7435704920937, -122.419119162122) | |||
| 43078 | 43078 | 248232 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 86 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6006910.04538 | 2099108.75258 | 37.744143557179896 | -122.41876827364901 | (37.7441435571799, -122.418768273649) | |||
| 184060 | 184060 | 248231 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 80 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006921.48329 | 2099128.86154 | 37.74419941586729 | -122.41873014957599 | (37.7441994158673, -122.418730149576) | |||
| 185308 | 185308 | 248230 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 74 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006935.57349 | 2099151.82262 | 37.7442632551522 | -122.418683056597 | (37.7442632551522, -122.418683056597) | |||
| 149673 | 149673 | 248229 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 72 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006943.33301 | 2099166.5172900003 | 37.7443040402894 | -122.41865726764401 | (37.7443040402894, -122.418657267644) | |||
| 40106 | 40106 | 248228 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006955.04848 | 2099184.3603 | 37.744353692775995 | -122.41861802300501 | (37.744353692776, -122.418618023005) | |||
| 150639 | 150639 | 248209 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 37 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007043.43628 | 2099296.21325 | 37.7446657917085 | -122.418320324941 | (37.7446657917085, -122.418320324941) | |||
| 64383 | 64383 | 248208 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 37 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007034.71089 | 2099281.8609599997 | 37.744625892375396 | -122.41834947827101 | (37.7446258923754, -122.418349478271) | |||
| 172679 | 172679 | 248207 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 39 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007026.812390001 | 2099268.29908 | 37.7445882098712 | -122.41837582837601 | (37.7445882098712, -122.418375828376) | |||
| 70040 | 70040 | 248206 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 39 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007021.99675 | 2099262.74695 | 37.744572693881395 | -122.41839208633999 | (37.7445726938814, -122.41839208634) | |||
| 149968 | 149968 | 248204 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 47 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006982.897919999 | 2099182.4975099997 | 37.744350145854796 | -122.418521593214 | (37.7443501458548, -122.418521593214) | |||
| 137669 | 137669 | 248203 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 47 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006976.18023 | 2099171.17204 | 37.7443186704674 | -122.418544018687 | (37.7443186704674, -122.418544018687) | |||
| 176629 | 176629 | 248202 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 51 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006954.7875 | 2099136.48348 | 37.7442222190818 | -122.418615530989 | (37.7442222190818, -122.418615530989) | |||
| 65155 | 65155 | 248201 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006949.2101 | 2099121.02775 | 37.7441794671077 | -122.41863372066601 | (37.7441794671077, -122.418633720666) | |||
| 55143 | 55143 | 248200 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006940.782319999 | 2099105.37762 | 37.744136020872205 | -122.418661752548 | (37.7441360208722, -122.418661752548) | |||
| 181222 | 181222 | 248199 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 55 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006933.20129 | 2099091.48631 | 37.7440974516285 | -122.41868698121999 | (37.7440974516285, -122.41868698122) | |||
| 152658 | 152658 | 248198 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006917.65895 | 2099068.8782900004 | 37.744034500003295 | -122.418739120308 | (37.7440345000033, -122.418739120308) | |||
| 32338 | 32338 | 248196 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006902.26536 | 2099037.70953 | 37.7439480508589 | -122.41879013796101 | (37.7439480508589, -122.418790137961) | |||
| 65181 | 65181 | 248195 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006895.3062 | 2099022.5140400003 | 37.7439059356157 | -122.418813123741 | (37.7439059356157, -122.418813123741) | |||
| 135516 | 135516 | 247504 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1398 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999483.6766 | 2108789.6708 | 37.7703040400286 | -122.44514278745399 | (37.7703040400286, -122.445142787454) | |||
| 37517 | 37517 | 246517 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 41 Waller St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005417.73549 | 2109222.5624700002 | 37.771829573112605 | -122.424647671566 | (37.7718295731126, -122.424647671566) | |||
| 73397 | 73397 | 246510 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 231 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | |||
| 60139 | 60139 | 246422 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6003829.35465 | 2099854.81871 | 37.746018144524605 | -122.429473817668 | (37.7460181445246, -122.429473817668) | |||
| 23898 | 23898 | 246421 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6003840.654080001 | 2099855.1968900003 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | |||
| 188742 | 188742 | 246420 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6003851.19686 | 2099854.61267 | 37.7460188154337 | -122.42939827552401 | (37.7460188154337, -122.429398275524) | |||
| 33594 | 33594 | 244469 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 665 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003415.8306 | 2109638.0930000003 | 37.7728572538387 | -122.43160206502701 | (37.7728572538387, -122.431602065027) | |||
| 46091 | 46091 | 244452 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 411 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003668.1352 | 2109738.0991 | 37.7731461435953 | -122.430736452264 | (37.7731461435953, -122.430736452264) | |||
| 1249 | 1249 | 237914 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 5997227.0 | 2107052.0 | 37.7654037766697 | -122.452823145368 | (37.7654037766697, -122.452823145368) | |||
| 167348 | 167348 | 225101 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 75 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6006050.3801 | 2109334.27291 | 37.7721720124675 | -122.42246724636601 | (37.7721720124675, -122.422467246366) | |||
| 180519 | 180519 | 225100 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 75 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6006056.75092 | 2109200.3154 | 37.7718045566698 | -122.422435689168 | (37.7718045566698, -122.422435689168) | |||
| 3024 | 3024 | 225099 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 14 | Width 3ft | Permit Number 37779 | 6003663.75485 | 2108815.27117 | 37.770612035853404 | -122.43068573955401 | (37.7706120358534, -122.430685739554) | |
| 43924 | 43924 | 225098 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6004313.032319999 | 2109116.83696 | 37.7714768248189 | -122.42846137891199 | (37.7714768248189, -122.428461378912) | |||
| 30270 | 30270 | 225097 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6004333.63591 | 2109116.4123400003 | 37.7714768248196 | -122.42839007973998 | (37.7714768248196, -122.42839007974) | |||
| 131148 | 131148 | 225096 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004357.77926 | 2109121.0465599997 | 37.7714909154158 | -122.428306896964 | (37.7714909154158, -122.428306896964) | |||
| 41360 | 41360 | 225095 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 231 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004583.37564 | 2109107.4182 | 37.7714662577942 | -122.427525575841 | (37.7714662577942, -122.427525575841) | |||
| 5182 | 5182 | 225094 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 621 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780775 | 6002723.2165 | 2108842.98565 | 37.7706348030957 | -122.433941050651 | (37.7706348030957, -122.433941050651) | |
| 74103 | 74103 | 225093 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 635 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002682.06353 | 2108837.51126 | 37.770617436283004 | -122.43408300774901 | (37.770617436283, -122.434083007749) | |||
| 134756 | 134756 | 225092 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002638.752309999 | 2108633.09345 | 37.770053697148796 | -122.434218205527 | (37.7700536971488, -122.434218205527) | |||
| 174977 | 174977 | 225091 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 169 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000007.70524 | 2106202.33536 | 37.7632297601708 | -122.443144329371 | (37.7632297601708, -122.443144329371) | |||
| 59003 | 59003 | 225090 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 188 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002851.63466 | 2107200.7798599997 | 37.7661329947706 | -122.433379482476 | (37.7661329947706, -122.433379482476) | |||
| 74525 | 74525 | 225089 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 838 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004316.16009 | 2104019.9015 | 37.757482039184204 | -122.428087274435 | (37.7574820391842, -122.428087274435) | |||
| 41526 | 41526 | 225088 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3899 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003725.04695 | 2104766.8360099997 | 37.7594994820291 | -122.43018486576099 | (37.7594994820291, -122.430184865761) | |||
| 28883 | 28883 | 225087 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3901 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003680.66693 | 2104762.3511799998 | 37.759484654009704 | -122.43033803379299 | (37.7594846540097, -122.430338033793) | |||
| 25477 | 25477 | 225086 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3689 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003831.7176 | 2103603.4271 | 37.756311078698296 | -122.429732966312 | (37.7563110786983, -122.429732966312) | |||
| 37108 | 37108 | 225085 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 406 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6004142.31119 | 2101495.14459 | 37.7505398125629 | -122.42850855554701 | (37.7505398125629, -122.428508555547) | |||
| 35568 | 35568 | 225084 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3784 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003185.26448 | 2103031.00379 | 37.7547027131682 | -122.43192775097401 | (37.7547027131682, -122.431927750974) | |||
| 37728 | 37728 | 225083 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3782 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003229.02977 | 2103031.88331 | 37.7547076090931 | -122.431776461616 | (37.7547076090931, -122.431776461616) | |||
| 35683 | 35683 | 225082 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 543 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002779.31526 | 2103257.0391599997 | 37.7553003306644 | -122.433347783174 | (37.7553003306644, -122.433347783174) | |||
| 154109 | 154109 | 225081 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004907.37106 | 2095955.144 | 37.7353714997996 | -122.42546869953199 | (37.7353714997996, -122.425468699532) | |||
| 152050 | 152050 | 225080 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2823 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009082.12028 | 2103902.9950900003 | 37.7574295349581 | -122.411596352099 | (37.7574295349581, -122.411596352099) | |||
| 27662 | 27662 | 225079 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2804 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009325.524119999 | 2103958.77383 | 37.7575963412133 | -122.410758500511 | (37.7575963412133, -122.410758500511) | |||
| 182826 | 182826 | 225078 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2844 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6009189.802619999 | 2103948.11037 | 37.7575594510339 | -122.41122712912599 | (37.7575594510339, -122.411227129126) | |||
| 177140 | 177140 | 225077 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2862 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6009020.65891 | 2103938.13075 | 37.7575225617285 | -122.411811393486 | (37.7575225617285, -122.411811393486) | |||
| 45627 | 45627 | 225076 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3328 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007533.56344 | 2101516.4180900003 | 37.7507895524966 | -122.41678281788602 | (37.7507895524966, -122.416782817886) | |||
| 178393 | 178393 | 225075 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3334 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007507.05129 | 2101513.0888099996 | 37.750778919809 | -122.416874263658 | (37.750778919809, -122.416874263658) | |||
| 51934 | 51934 | 225074 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3354 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007335.7626 | 2101504.20622 | 37.750744893976204 | -122.417465967185 | (37.7507448939762, -122.417465967185) | |||
| 69332 | 69332 | 225073 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 904 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009377.25257 | 2103854.7897900003 | 37.757313724754795 | -122.410572259011 | (37.7573137247548, -122.410572259011) | |||
| 28082 | 28082 | 225072 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 902 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009377.02442 | 2103868.3997 | 37.757351081704606 | -122.41057400910299 | (37.7573510817046, -122.410574009103) | |||
| 76853 | 76853 | 225071 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009374.803830001 | 2103883.5621599997 | 37.7573925899019 | -122.410582759505 | (37.7573925899019, -122.410582759505) | |||
| 38614 | 38614 | 225070 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 890 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009108.93583 | 2103990.9837700003 | 37.757672636103 | -122.411509829221 | (37.757672636103, -122.411509829221) | |||
| 24342 | 24342 | 225069 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 892 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009108.56559 | 2103972.85995 | 37.75762285142989 | -122.41150982923 | (37.7576228514299, -122.41150982923) | |||
| 130879 | 130879 | 225068 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009114.1902 | 2103856.87983 | 37.757304711760604 | -122.41148218316299 | (37.7573047117606, -122.411482183163) | |||
| 136895 | 136895 | 225067 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009115.2795 | 2103823.2478099996 | 37.7572124269416 | -122.41147603989401 | (37.7572124269416, -122.411476039894) | |||
| 161704 | 161704 | 225066 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 199 Franconia St | 13 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010116.17854 | 2099660.00965 | 37.745837186534295 | -122.407720980957 | (37.7458371865343, -122.407720980957) | |||
| 75887 | 75887 | 225065 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 219 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006960.17815 | 2097772.4528099997 | 37.740477199257704 | -122.418500188445 | (37.7404771992577, -122.418500188445) | |||
| 185355 | 185355 | 225064 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 253 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998981.0777900005 | 2106664.05961 | 37.7644389481338 | -122.446728303069 | (37.7644389481338, -122.446728303069) | |||
| 167323 | 167323 | 225063 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 247 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998979.478759999 | 2106681.18548 | 37.7644858801306 | -122.44673506598998 | (37.7644858801306, -122.44673506599) | |||
| 163059 | 163059 | 225062 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 139 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998883.5307 | 2107364.0663900003 | 37.76635541778779 | -122.44711607094601 | (37.7663554177878, -122.447116070946) | |||
| 129912 | 129912 | 225061 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1289 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 5997502.5049 | 2105021.0962900002 | 37.7598432128005 | -122.451723726786 | (37.7598432128005, -122.451723726786) | |||
| 162230 | 162230 | 225060 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 243 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997087.67897 | 2106671.87912 | 37.76435207719771 | -122.453277577199 | (37.7643520771977, -122.453277577199) | |||
| 55625 | 55625 | 225059 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 245 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5997024.32382 | 2107012.23049 | 37.7652829636624 | -122.453521279988 | (37.7652829636624, -122.453521279988) | |||
| 43510 | 43510 | 225058 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 283 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996870.764690001 | 2106986.93981 | 37.76520471814 | -122.454050575073 | (37.76520471814, -122.454050575073) | |||
| 37675 | 37675 | 225057 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 360 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6001062.01743 | 2096696.77883 | 37.7371898399477 | -122.438816616317 | (37.7371898399477, -122.438816616317) | |||
| 65489 | 65489 | 225056 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 354 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001081.74278 | 2096696.02818 | 37.737188901044995 | -122.43874836315399 | (37.737188901045, -122.438748363154) | |||
| 178420 | 178420 | 225055 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 348 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6001114.83392 | 2096694.1461 | 37.7371856158122 | -122.438633817409 | (37.7371856158122, -122.438633817409) | |||
| 184149 | 184149 | 225054 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 342 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6001139.36381 | 2096693.2959599998 | 37.7371846769336 | -122.438548945674 | (37.7371846769336, -122.438548945674) | |||
| 32281 | 32281 | 225053 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001218.80684 | 2096592.16387 | 37.736911510559295 | -122.438267032523 | (37.7369115105593, -122.438267032523) | |||
| 154480 | 154480 | 225052 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 375 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000953.83658 | 2096674.2134099999 | 37.737121725291296 | -122.439189029173 | (37.7371217252913, -122.439189029173) | |||
| 188391 | 188391 | 225051 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000881.81518 | 2102275.99981 | 37.752498802180796 | -122.439839555559 | (37.7524988021808, -122.439839555559) | |||
| 35881 | 35881 | 225050 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | |||
| 180608 | 180608 | 225049 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 4ft | 6002919.63953 | 2100068.3028700002 | 37.7465527734974 | -122.432634735922 | (37.7465527734974, -122.432634735922) | |||
| 71841 | 71841 | 225048 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2823 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009293.07164 | 2103911.54746 | 37.757464848636204 | -122.410867399417 | (37.7574648486362, -122.410867399417) | |||
| 170271 | 170271 | 225047 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 971 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6009431.366330001 | 2103539.27108 | 37.7564504151646 | -122.410362833886 | (37.7564504151646, -122.410362833886) | |||
| 67983 | 67983 | 225046 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 901 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009412.500080001 | 2103884.6672799997 | 37.757397737644204 | -122.41045246843001 | (37.7573977376442, -122.41045246843) | |||
| 74205 | 74205 | 225045 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 881 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6009145.122330001 | 2103987.25914 | 37.7576644387915 | -122.411384417877 | (37.7576644387915, -122.411384417877) |
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");