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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21970 | 21970 | 524 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2826 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6009890.4218 | 2102229.0519 | 37.752878568819796 | -122.408682823354 | (37.7528785688198, -122.408682823354) | |||
| 18224 | 18224 | 494 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6010448.7752 | 2102218.4922 | 37.752880830855496 | -122.40675117970801 | (37.7528808308555, -122.406751179708) | |||
| 20426 | 20426 | 496 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010495.2306 | 2102220.2128 | 37.7528881543902 | -122.406590648723 | (37.7528881543902, -122.406590648723) | |||
| 18580 | 18580 | 497 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6010516.451 | 2102220.2128 | 37.75288934158429 | -122.40651726425399 | (37.7528893415843, -122.406517264254) | |||
| 188438 | 188438 | 245412 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2802 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6009963.8161 | 2102233.787 | 37.7528956807716 | -122.408429345015 | (37.7528956807716, -122.408429345015) | |||
| 17455 | 17455 | 519 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2802 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6009998.1456 | 2102238.5221 | 37.7529106047271 | -122.408310960592 | (37.7529106047271, -122.408310960592) | |||
| 1775 | 1775 | 245411 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2794 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6010069.4683 | 2102240.5937 | 37.7529202865107 | -122.408064458251 | (37.7529202865107, -122.408064458251) | |||
| 18297 | 18297 | 513 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2792 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010090.1844 | 2102241.1856 | 37.752923071613495 | -122.40799285948499 | (37.7529230716135, -122.407992859485) | |||
| 17799 | 17799 | 514 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010107.5289 | 2102242.0067 | 37.752926297242205 | -122.407932936557 | (37.7529262972422, -122.407932936557) | |||
| 1904 | 1904 | 245410 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010125.3081 | 2102244.3008 | 37.752933591707794 | -122.40787161420401 | (37.7529335917078, -122.407871614204) | |||
| 39668 | 39668 | 245409 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2778 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010163.1606 | 2102247.1684 | 37.7529435845832 | -122.40774091468 | (37.7529435845832, -122.40774091468) | |||
| 20773 | 20773 | 501 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2754 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6010215.9248 | 2102247.7419 | 37.7529481129231 | -122.40755848565901 | (37.7529481129231, -122.407558485659) | |||
| 18753 | 18753 | 498 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2752 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010250.9097 | 2102250.6095 | 37.7529579449469 | -122.40743770281999 | (37.7529579449469, -122.40743770282) | |||
| 130123 | 130123 | 245414 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2736 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6010338.0852 | 2102254.0506 | 37.752972272430206 | -122.40713647446998 | (37.7529722724302, -122.40713647447) | |||
| 22172 | 22172 | 489 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2730 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010359.8791 | 2102254.6242 | 37.7529750670361 | -122.40706114707301 | (37.7529750670361, -122.407061147073) | |||
| 137830 | 137830 | 245413 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2726 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010382.82 | 2102257.4918 | 37.7529842245941 | -122.406982014782 | (37.7529842245941, -122.406982014782) | |||
| 18610 | 18610 | 487 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2718 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010403.4669 | 2102258.6388 | 37.7529885293488 | -122.406910694342 | (37.7529885293488, -122.406910694342) | |||
| 181828 | 181828 | 245472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010432.7166 | 2102259.7859 | 37.7529933156944 | -122.406809623625 | (37.7529933156944, -122.406809623625) | |||
| 130725 | 130725 | 245471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010463.1133 | 2102261.5065 | 37.7529997408326 | -122.406704626743 | (37.7529997408326, -122.406704626743) | |||
| 177119 | 177119 | 245470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6010486.0542 | 2102262.08 | 37.753002599060295 | -122.40662533272899 | (37.7530025990603, -122.406625332729) | |||
| 18907 | 18907 | 481 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010503.8335 | 2102264.9476 | 37.753011467555204 | -122.406564050249 | (37.7530114675552, -122.406564050249) | |||
| 134348 | 134348 | 97114 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1345 Noriega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 18860 | 5989801.9904 | 2103085.8445 | 37.7540855022306 | -122.47821424615101 | (37.7540855022306, -122.478214246151) | |||
| 44212 | 44212 | 184648 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1691 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983748.1287 | 2103659.9866 | 37.755308660398505 | -122.49919205978998 | (37.7553086603985, -122.49919205979) | |||
| 43401 | 43401 | 182246 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1455 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5985863.116 | 2105312.6885 | 37.759970370515106 | -122.491999577939 | (37.7599703705151, -122.491999577939) | |||
| 18161 | 18161 | 107661 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1312 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5999086.9 | 2105066.2 | 37.7600576690463 | -122.446247345124 | (37.7600576690463, -122.446247345124) | |||
| 21777 | 21777 | 15445 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2250 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006857.7723 | 2105245.8857 | 37.7609917781074 | -122.419384314212 | (37.7609917781074, -122.419384314212) | |||
| 17778 | 17778 | 15435 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2141 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006881.4762 | 2105834.0306 | 37.7626080219354 | -122.419344056803 | (37.7626080219354, -122.419344056803) | |||
| 894 | 894 | 15433 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2135 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006876.1683 | 2105910.6162 | 37.7628180091578 | -122.419367848279 | (37.7628180091578, -122.419367848279) | |||
| 879 | 879 | 246305 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2135 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6006876.9266 | 2105933.3644 | 37.762880513109295 | -122.41936683944401 | (37.7628805131093, -122.419366839444) | |||
| 72332 | 72332 | 182039 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1323 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5988935.747 | 2106319.8798 | 37.7629149697028 | -122.481446720354 | (37.7629149697028, -122.481446720354) | |||
| 55161 | 55161 | 246282 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6006871.6187 | 2105950.8046 | 37.762928100871896 | -122.41938643496401 | (37.7629281008719, -122.419386434964) | |||
| 228 | 228 | 246283 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2125 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 0ft | 6006872.377 | 2105970.5198 | 37.7629822769131 | -122.419385210964 | (37.7629822769131, -122.419385210964) | |||
| 157150 | 157150 | 43881 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1245 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 3 | Permit Number 43494 | 5981473.1113 | 2106617.2091 | 37.7632946239394 | -122.507278997702 | (37.7632946239394, -122.507278997702) | ||
| 187140 | 187140 | 183273 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1251 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5983646.3542 | 2106625.2038 | 37.7634443416971 | -122.49976317535801 | (37.7634443416971, -122.499763175358) | |||
| 58145 | 58145 | 183272 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1251 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5983645.262999999 | 2106639.9345 | 37.7634847239936 | -122.49976803825199 | (37.7634847239936, -122.499768038252) | |||
| 165135 | 165135 | 101264 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Permit Number 20727 | 5989453.6006 | 2106533.1127 | 37.7635305455459 | -122.479671267422 | (37.7635305455459, -122.479671267422) | |||
| 26993 | 26993 | 101263 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 20727 | 5989478.8752 | 2106534.6445 | 37.76353621964879 | -122.479583963683 | (37.7635362196488, -122.479583963683) | |||
| 171803 | 171803 | 60926 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1983 12:00:00 AM | 13 | Permit Number 20727 | 5989507.2134 | 2106536.1763 | 37.7635420716385 | -122.479486064031 | (37.7635420716385, -122.479486064031) | ||
| 42976 | 42976 | 113471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 80997 | 80997 | 113469 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 87131 | 87131 | 113474 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 89483 | 89483 | 113468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 06/21/2016 02:14:00 PM | 3 | 6x7 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||
| 92566 | 92566 | 113466 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 96050 | 96050 | 113472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 111779 | 111779 | 113467 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 112823 | 112823 | 113475 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 124165 | 124165 | 113473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 126562 | 126562 | 113465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 20 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | |||
| 144168 | 144168 | 113470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 40899 | 40899 | 181727 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2755 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5987094.0342 | 2107004.1542 | 37.76468654333279 | -122.487866760897 | (37.7646865433328, -122.487866760897) | |||
| 67589 | 67589 | 181728 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2755 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987089.3098 | 2107026.595 | 37.7647478839827 | -122.487884750055 | (37.7647478839827, -122.487884750055) | |||
| 163380 | 163380 | 245439 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2940 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6007210.058999999 | 2106771.9452 | 37.7652018171161 | -122.418274106734 | (37.7652018171161, -122.418274106734) | |||
| 146420 | 146420 | 245460 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2940 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6007306.1163 | 2106778.6027 | 37.7652255036159 | -122.41794233876101 | (37.7652255036159, -122.417942338761) | |||
| 157627 | 157627 | 245462 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2886 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6007544.8329 | 2106792.8686 | 37.7652781065022 | -122.41711768386001 | (37.7652781065022, -122.41711768386) | |||
| 63246 | 63246 | 245461 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2886 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6007563.8542 | 2106794.7707 | 37.7652843992631 | -122.417052028294 | (37.7652843992631, -122.417052028294) | |||
| 57912 | 57912 | 200832 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2000 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010535.924 | 2106957.4024 | 37.7658976908793 | -122.406783753376 | (37.7658976908793, -122.406783753376) | |||
| 167853 | 167853 | 32297 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011502.2034 | 2107015.4172 | 37.766111004805396 | -122.40344565674499 | (37.7661110048054, -122.403445656745) | ||
| 156483 | 156483 | 32296 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 8 | Permit Number 36875 | 6011540.2459 | 2107019.2214 | 37.7661235750542 | -122.403314342162 | (37.7661235750542, -122.403314342162) | ||
| 165399 | 165399 | 32294 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011626.7926 | 2107023.9767 | 37.7661414653506 | -122.403015326989 | (37.7661414653506, -122.403015326989) | ||
| 34183 | 34183 | 32298 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | 12 | Permit Number 36875 | 6011655.3244 | 2107023.9767 | 37.766143058580205 | -122.40291664053001 | (37.7661430585802, -122.40291664053) | |
| 38098 | 38098 | 98472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011885.4815 | 2107033.4874 | 37.766182021887005 | -122.402121236301 | (37.766182021887, -122.402121236301) | |||
| 46381 | 46381 | 98473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011870.2645 | 2107034.4384 | 37.7661837837598 | -122.402173936122 | (37.7661837837598, -122.402173936122) | |||
| 181203 | 181203 | 98471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011899.7475 | 2107035.3895 | 37.7661880408824 | -122.40207202642401 | (37.7661880408824, -122.402072026424) | |||
| 47183 | 47183 | 98470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011914.0134 | 2107036.3406 | 37.7661914486194 | -122.402022750022 | (37.7661914486194, -122.402022750022) | |||
| 28900 | 28900 | 98468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011948.2516 | 2107041.0959 | 37.7662064164751 | -122.40190466033701 | (37.7662064164751, -122.401904660337) | |||
| 48254 | 48254 | 248610 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 872 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997691.4278 | 2107516.4386 | 37.7667056091614 | -122.4512503025 | (37.7667056091614, -122.4512503025) | |||
| 60986 | 60986 | 248611 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 862 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997689.6108 | 2107534.9111 | 37.7667562259025 | -122.45125791953001 | (37.7667562259025, -122.45125791953) | |||
| 154058 | 154058 | 248533 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 174 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998320.7066 | 2107735.9897 | 37.7673444513971 | -122.449089561777 | (37.7673444513971, -122.449089561777) | |||
| 149998 | 149998 | 248465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997147.6982 | 2107925.2578 | 37.767796974534605 | -122.45316047633601 | (37.7677969745346, -122.453160476336) | |||
| 41329 | 41329 | 248473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 758 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5998609.6056 | 2107900.123 | 37.7678116388378 | -122.448102124294 | (37.7678116388378, -122.448102124294) | |||
| 24010 | 24010 | 248469 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 145 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998248.1791 | 2107933.2828 | 37.7678820197346 | -122.449354639507 | (37.7678820197346, -122.449354639507) | |||
| 183087 | 183087 | 248411 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1737 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997411.4623 | 2108107.5609 | 37.76831264578671 | -122.45226130839701 | (37.7683126457867, -122.452261308397) | |||
| 177880 | 177880 | 248404 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1713 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997468.9999 | 2108115.1317 | 37.768336729240296 | -122.452062838629 | (37.7683367292403, -122.452062838629) | |||
| 150865 | 150865 | 246100 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997118.778 | 2108135.4212 | 37.7683723717283 | -122.453275681682 | (37.7683723717283, -122.453275681682) | |||
| 43725 | 43725 | 246164 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1756 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997323.9447 | 2108138.6009 | 37.768392859677896 | -122.452566262235 | (37.7683928596779, -122.452566262235) | |||
| 155231 | 155231 | 246099 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997115.1441 | 2108154.4994 | 37.7684245472814 | -122.453289628456 | (37.7684245472814, -122.453289628456) | |||
| 73071 | 73071 | 248407 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 39 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999275.3753 | 2108109.8322 | 37.7684254834855 | -122.445814398115 | (37.7684254834855, -122.445814398115) | |||
| 52969 | 52969 | 248377 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 701 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997902.4997 | 2108143.1434 | 37.7684384639657 | -122.45056543049401 | (37.7684384639657, -122.450565430494) | |||
| 183850 | 183850 | 248348 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 706 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997944.2901 | 2108144.5061 | 37.7684445974615 | -122.45042098016701 | (37.7684445974615, -122.450420980167) | |||
| 153054 | 153054 | 246152 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1720 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997446.2877 | 2108155.2565 | 37.7684456006596 | -122.45214429305 | (37.7684456006596, -122.45214429305) | |||
| 39575 | 39575 | 246153 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1720 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997461.1263 | 2108156.7707 | 37.7684506082583 | -122.45209307718099 | (37.7684506082583, -122.452093077181) | |||
| 64636 | 64636 | 246098 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997112.7214 | 2108174.1833 | 37.7684784553517 | -122.45329942957198 | (37.7684784553517, -122.453299429572) | |||
| 77095 | 77095 | 248383 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1621 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997789.5444 | 2108160.7074 | 37.7684802243505 | -122.450957397559 | (37.7684802243505, -122.450957397559) | |||
| 131399 | 131399 | 248376 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 701 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997900.3799 | 2108160.4046 | 37.7684857374838 | -122.45057400725 | (37.7684857374838, -122.45057400725) | |||
| 74916 | 74916 | 248371 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997803.1717 | 2108162.5244 | 37.7684859935016 | -122.45091039318199 | (37.7684859935016, -122.450910393182) | |||
| 172810 | 172810 | 246165 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1700 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997526.8402 | 2108168.581 | 37.7684868003121 | -122.45186663191299 | (37.7684868003121, -122.451866631913) | |||
| 147110 | 147110 | 248373 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997837.6943 | 2108167.0669 | 37.768500442306106 | -122.45079131066002 | (37.7685004423061, -122.45079131066) | |||
| 180852 | 180852 | 246097 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997110.2988 | 2108193.2616 | 37.7685307006045 | -122.45330918662901 | (37.7685307006045, -122.453309186629) | |||
| 185767 | 185767 | 248349 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1589 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997958.0688 | 2108183.1168 | 37.7685514011761 | -122.450376104779 | (37.7685514011761, -122.450376104779) | |||
| 38886 | 38886 | 248350 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1587 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997973.5131 | 2108185.8423 | 37.7685597685915 | -122.45032288098899 | (37.7685597685915, -122.450322880989) | |||
| 35119 | 35119 | 248351 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1587 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997991.38 | 2108188.2649 | 37.7685674429378 | -122.450261255818 | (37.7685674429378, -122.450261255818) | |||
| 182156 | 182156 | 246388 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997718.8338 | 2108194.9271 | 37.768570134567206 | -122.45120444629801 | (37.7685701345672, -122.451204446298) | |||
| 161008 | 161008 | 248352 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1585 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998007.43 | 2108190.3847 | 37.7685741818657 | -122.450205893283 | (37.7685741818657, -122.450205893283) | |||
| 47229 | 47229 | 246151 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1622 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997783.0336 | 2108202.195 | 37.7685937659628 | -122.450982909765 | (37.7685937659628, -122.450982909765) | |||
| 167223 | 167223 | 246096 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997106.9677 | 2108216.5794 | 37.768594534360204 | -122.453322392223 | (37.7685945343602, -122.453322392223) | |||
| 165925 | 165925 | 248346 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1575 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998065.2703 | 2108198.2582 | 37.7685991103156 | -122.45000639696 | (37.7685991103156, -122.45000639696) | |||
| 167539 | 167539 | 248335 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1559 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998127.3503 | 2108207.3431 | 37.768627607196 | -122.449792323102 | (37.768627607196, -122.449792323102) | |||
| 129813 | 129813 | 248337 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1539 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998178.2256 | 2108213.3997 | 37.7686471477417 | -122.449616786829 | (37.7686471477417, -122.449616786829) | |||
| 46704 | 46704 | 246095 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997104.5451 | 2108242.017 | 37.768664240613205 | -122.45333260848801 | (37.7686642406132, -122.453332608488) | |||
| 183117 | 183117 | 246173 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997888.1153 | 2108243.3798 | 37.768712864196 | -122.45062241217899 | (37.768712864196, -122.450622412179) |
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");