Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 673 | 673 | 210967 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 375 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | 4 | Width 3ft | Permit Number 32251 | 5992728.19812 | 2094135.00675 | 37.7296781967805 | -122.467443955276 | (37.7296781967805, -122.467443955276) | |
| 2065 | 2065 | 141406 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 500 IVY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 6 | Width 0ft | Permit Number 34950 | 6004860.5862 | 2111087.89 | 37.77691982656621 | -122.42670774733699 | (37.7769198265662, -122.426707747337) | |
| 2074 | 2074 | 141405 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 500 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 3 | Width 0ft | Permit Number 34950 | 6004899.5578 | 2111091.1041 | 37.7769308549567 | -122.426573161514 | (37.7769308549567, -122.426573161514) | |
| 4485 | 4485 | 18883 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2323 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/2009 12:00:00 AM | 3 | 2X2 | 6003550.924930001 | 2115900.91625 | 37.7900610577251 | -122.431581959853 | (37.7900610577251, -122.431581959853) | ||
| 5327 | 5327 | 112348 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 50 Perine Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6002110.93793 | 2115571.4421599996 | 37.7890746830929 | -122.436540595874 | (37.7890746830929, -122.436540595874) | |||
| 10026 | 10026 | 66781 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 63 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2017 12:00:00 AM | 3 | Permit Number 30050 | 6005821.27951384 | 2106893.65445384 | 37.7654577301272 | -122.423086219508 | (37.7654577301272, -122.423086219508) | |
| 11839 | 11839 | 83664 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 75 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769750 | 6003631.23676 | 2092962.7354 | 37.727082834286705 | -122.429667413832 | (37.7270828342867, -122.429667413832) |
| 14473 | 14473 | 101307 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 250 Napoleon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6012205.824519999 | 2099880.6211200003 | 37.7465596955814 | -122.40051072938401 | (37.7465596955814, -122.400510729384) | |||
| 14963 | 14963 | 3779 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 7 Carpenter Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/1997 12:00:00 AM | 5 | 3X3 | 6016553.62516 | 2095504.9773400002 | 37.73478657804021 | -122.385171527445 | (37.7347865780402, -122.385171527445) | ||
| 15629 | 15629 | 101309 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 250 Napoleon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012087.5096 | 2099832.08135 | 37.7464198168313 | -122.40091644235399 | (37.7464198168313, -122.400916442354) | |||
| 15705 | 15705 | 101308 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 250 Napoleon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6012186.42356 | 2099869.9404599997 | 37.746529286798 | -122.400577066077 | (37.746529286798, -122.400577066077) | |||
| 16192 | 16192 | 101310 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 250 Napoleon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012064.796159999 | 2099822.57577 | 37.746392449557206 | -122.400994315548 | (37.7463924495572, -122.400994315548) | |||
| 16809 | 16809 | 73565 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1501 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770154 | 6015647.31227 | 2096389.49505 | 37.737165106784396 | -122.388366706276 | (37.7371651067844, -122.388366706276) | |
| 17822 | 17822 | 9388 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 413 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001286.51839 | 2097494.94671 | 37.739394192481896 | -122.43809757416 | (37.7393941924819, -122.43809757416) | |||
| 17825 | 17825 | 22806 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 12 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1997 12:00:00 AM | 6 | 2X2 | 5998870.766969999 | 2099815.86165 | 37.745629183238705 | -122.446617085705 | (37.7456291832387, -122.446617085705) | ||
| 19820 | 19820 | 31367 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 300 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 4 | 3x3 | Permit Number 34972 | 5992232.45976 | 2099147.6054 | 37.7434128975899 | -122.469522506162 | (37.7434128975899, -122.469522506162) |
| 20903 | 20903 | 17950 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2475 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6002060.7597199995 | 2114997.16684 | 37.787495018845206 | -122.436673082148 | (37.7874950188452, -122.436673082148) | |||
| 20921 | 20921 | 9399 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 443 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001572.96858 | 2097546.67982 | 37.7395525262153 | -122.437110860475 | (37.7395525262153, -122.437110860475) | |||
| 23805 | 23805 | 234442 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 4545 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000779.8567699995 | 2101100.46263 | 37.749265255608705 | -122.44010785660801 | (37.7492652556087, -122.440107856608) | |||
| 24392 | 24392 | 234428 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2644 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010244.9423 | 2104006.47473 | 37.7577788253492 | -122.40758212741801 | (37.7577788253492, -122.407582127418) | |||
| 24625 | 24625 | 181924 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2347 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5985449.2316 | 2099241.7124 | 37.7432769299175 | -122.49298378014 | (37.7432769299175, -122.49298378014) | |||
| 24648 | 24648 | 183459 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2530 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989571.117000001 | 2098107.4281 | 37.7404026737429 | -122.47864859712 | (37.7404026737429, -122.47864859712) | |||
| 25186 | 25186 | 194408 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 670 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014377.03674 | 2104046.7592599997 | 37.758119869848706 | -122.393294339956 | (37.7581198698487, -122.393294339956) | |||
| 26193 | 26193 | 210969 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1901 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991556.95578 | 2102433.12062 | 37.7523950096285 | -122.472097634809 | (37.7523950096285, -122.472097634809) | |||
| 28647 | 28647 | 65834 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2222 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1990 12:00:00 AM | 6 | Permit Number 28824 | 6000082.60671 | 2120602.00378 | 37.8027718048421 | -122.443919922685 | (37.8027718048421, -122.443919922685) | ||
| 28961 | 28961 | 132139 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 99 Moulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002898.54088 | 2119398.05033 | 37.7996262865921 | -122.434089249929 | (37.7996262865921, -122.434089249929) | |||
| 28991 | 28991 | 138961 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 659 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004210.501 | 2110971.7814 | 37.7765642456394 | -122.42894831076201 | (37.7765642456394, -122.428948310762) | |||
| 31880 | 31880 | 234456 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 148 Saturn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999835.14903 | 2106019.07755 | 37.762716739201394 | -122.44372797587 | (37.7627167392014, -122.44372797587) | |||
| 32197 | 32197 | 132145 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 540 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004877.00023 | 2111089.96239 | 37.776926444827396 | -122.426651113773 | (37.7769264448274, -122.426651113773) | |||
| 34061 | 34061 | 141408 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 530 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004791.8837 | 2111076.2387 | 37.776883950480794 | -122.426944580369 | (37.7768839504808, -122.426944580369) | |||
| 35572 | 35572 | 178120 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 450 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007489.47996 | 2091618.13072 | 37.7236085535687 | -122.416234291698 | (37.7236085535687, -122.416234291698) | |||
| 36228 | 36228 | 178111 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 200 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6000616.294969999 | 2087881.86398 | 37.712960731619 | -122.43972589293399 | (37.712960731619, -122.439725892934) | |||
| 36753 | 36753 | 183792 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2018 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986653.8717 | 2099631.7621 | 37.7444182780506 | -122.48884717015801 | (37.7444182780506, -122.488847170158) | |||
| 36886 | 36886 | 210939 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 73 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994126.41089 | 2090335.9107700002 | 37.719327422704 | -122.462334784419 | (37.719327422704, -122.462334784419) | |||
| 37121 | 37121 | 234449 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 322 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001539.15917 | 2096239.2167900002 | 37.7359606150995 | -122.437134171803 | (37.7359606150995, -122.437134171803) | |||
| 37906 | 37906 | 96615 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1224 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767286 | 6008996.31071 | 2117161.4041 | 37.7938291883275 | -122.412830459354 | (37.7938291883275, -122.412830459354) | |
| 39840 | 39840 | 234452 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 486 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001799.54683 | 2102978.51444 | 37.75447993581071 | -122.436716173237 | (37.7544799358107, -122.436716173237) | |||
| 40105 | 40105 | 210943 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 901 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995890.03888 | 2089972.39061 | 37.718430679008996 | -122.456212350133 | (37.718430679009, -122.456212350133) | |||
| 40631 | 40631 | 141415 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 530 IVY ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004662.5142 | 2111058.1591 | 37.7768269924265 | -122.42739082069099 | (37.7768269924265, -122.427390820691) | |||
| 40760 | 40760 | 132148 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 540 Ivy St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004787.54086 | 2111075.34441 | 37.7768812494174 | -122.426959539871 | (37.7768812494174, -122.426959539871) | |||
| 40916 | 40916 | 140013 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 840 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004880.8164 | 2111850.7611 | 37.7790156271835 | -122.42669210332899 | (37.7790156271835, -122.426692103329) | |||
| 40991 | 40991 | 178104 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 450 Holyoke St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009831.59561 | 2092324.84748 | 37.725680469262 | -122.40818779113899 | (37.725680469262, -122.408187791139) | |||
| 41044 | 41044 | 119909 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2x Lucy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6014143.19985 | 2094023.91332 | 37.7305862422565 | -122.393401649772 | (37.7305862422565, -122.393401649772) | |||
| 41745 | 41745 | 62425 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2190 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/1990 12:00:00 AM | 7 | Permit Number 28803 | 6000367.7692599995 | 2120295.99012 | 37.80194783518171 | -122.44291112974399 | (37.8019478351817, -122.442911129744) | |
| 42025 | 42025 | 37797 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 407 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 1 | Permit Number 40124 | 6010065.36404 | 2092583.8602200001 | 37.7264047508705 | -122.407397920192 | (37.7264047508705, -122.407397920192) | |
| 42704 | 42704 | 139021 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2557 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000404.6376 | 2114075.0402 | 37.7848688424651 | -122.442336688766 | (37.7848688424651, -122.442336688766) | |||
| 44022 | 44022 | 194404 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 400 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6011167.33115 | 2106202.8997400003 | 37.763861305473 | -122.404546718569 | (37.763861305473, -122.404546718569) | ||||
| 44887 | 44887 | 234454 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 281 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001786.69063 | 2104222.73922 | 37.7578955465505 | -122.43684969828001 | (37.7578955465505, -122.43684969828) | |||
| 46331 | 46331 | 140232 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2217 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997153.7791 | 2110495.4596 | 37.774854433410894 | -122.453325023475 | (37.7748544334109, -122.453325023475) | |||
| 46758 | 46758 | 141416 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 530 IVY ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004640.4169 | 2111056.1502 | 37.776820226698 | -122.427467118785 | (37.776820226698, -122.427467118785) | |||
| 48860 | 48860 | 183458 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2530 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989571.117000001 | 2098094.1306 | 37.740366162256606 | -122.47864762489401 | (37.7403661622566, -122.478647624894) | |||
| 49803 | 49803 | 194420 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 412 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6011221.81037 | 2112380.99989 | 37.780827996156795 | -122.40479327221901 | (37.7808279961568, -122.404793272219) | |||
| 50063 | 50063 | 194419 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1548 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015902.62004 | 2095929.8973700001 | 37.7359172884615 | -122.387451930266 | (37.7359172884615, -122.387451930266) | |||
| 50137 | 50137 | 123786 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1250 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5994756.19271 | 2112157.0597599996 | 37.7792790287593 | -122.46173921976101 | (37.7792790287593, -122.461739219761) | |||
| 50932 | 50932 | 178108 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 200 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000658.1626 | 2087895.7833900002 | 37.71300133420971 | -122.43958218218201 | (37.7130013342097, -122.439582182182) | |||
| 51247 | 51247 | 105348 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 651X Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6004248.77005 | 2110989.99433 | 37.7766164199227 | -122.428817225763 | (37.7766164199227, -122.428817225763) | |||
| 52050 | 52050 | 178106 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 450 Holyoke St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009819.25849 | 2092363.8819400002 | 37.7257869588856 | -122.40823319163201 | (37.7257869588856, -122.408233191632) | |||
| 52233 | 52233 | 234438 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 786 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998023.26528 | 2107589.70092 | 37.7669257633449 | -122.45010781952101 | (37.7669257633449, -122.450107819521) | |||
| 52257 | 52257 | 139016 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2569 SUTTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000276.5862 | 2114052.7703 | 37.7848003959002 | -122.442778104076 | (37.7848003959002, -122.442778104076) | |||
| 54207 | 54207 | 210959 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2470 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992377.133719999 | 2098485.46159 | 37.741603179253296 | -122.468974087904 | (37.7416031792533, -122.468974087904) | |||
| 54944 | 54944 | 234436 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 3734 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6004821.76707 | 2102536.50237 | 37.7534375658093 | -122.42623307379499 | (37.7534375658093, -122.426233073795) | |||
| 55466 | 55466 | 210958 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2470 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992377.13613 | 2098506.21795 | 37.741660171086295 | -122.468975589747 | (37.7416601710863, -122.468975589747) | |||
| 55677 | 55677 | 30932 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 507 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 4 | Permit Number 34745 | 5995284.50806 | 2091206.784 | 37.7217852518603 | -122.458394705264 | (37.7217852518603, -122.458394705264) | |
| 57092 | 57092 | 234447 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 55 Van Buren St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002027.69076 | 2096295.05115 | 37.7361416809875 | -122.435449118386 | (37.7361416809875, -122.435449118386) | |||
| 57916 | 57916 | 210961 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 88 Forest Side Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992499.55454 | 2098520.7139 | 37.7417070455482 | -122.46855336616501 | (37.7417070455482, -122.468553366165) | |||
| 57964 | 57964 | 178105 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 450 Holyoke St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009827.37216 | 2092339.8154799999 | 37.725721331760795 | -122.408203446535 | (37.7257213317608, -122.408203446535) | |||
| 58032 | 58032 | 234460 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 797 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001289.8745099995 | 2102005.0906700003 | 37.7517781700284 | -122.438409012985 | (37.7517781700284, -122.438409012985) | |||
| 60237 | 60237 | 234461 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 605 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002406.85283 | 2104666.34798 | 37.7591488165855 | -122.43473664128 | (37.7591488165855, -122.43473664128) | |||
| 60889 | 60889 | 178099 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 475 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009870.22482 | 2092198.24037 | 37.7253349956071 | -122.40804532773501 | (37.7253349956071, -122.408045327735) | |||
| 61470 | 61470 | 66146 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1870 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1990 12:00:00 AM | 7 | Permit Number 29213 | 6000296.96947 | 2121326.31343 | 37.8047727901033 | -122.443230173234 | (37.8047727901033, -122.443230173234) | ||
| 61945 | 61945 | 132151 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 540 Ivy St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004697.15203 | 2111064.23767 | 37.7768456416404 | -122.42727143105499 | (37.7768456416404, -122.427271431055) | |||
| 62021 | 62021 | 178112 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 557 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009785.47339 | 2092559.58187 | 37.7263224179212 | -122.408363782157 | (37.7263224179212, -122.408363782157) | |||
| 62418 | 62418 | 178121 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1186 Munich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001045.2474 | 2087209.5115 | 37.7111390073292 | -122.438195159605 | (37.7111390073292, -122.438195159605) | |||
| 62699 | 62699 | 234453 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 439 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003529.16507 | 2102129.83652 | 37.7522478103946 | -122.430674147321 | (37.7522478103946, -122.430674147321) | |||
| 63408 | 63408 | 234427 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 268 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008861.7546 | 2107017.31377 | 37.7659683774771 | -122.412578614117 | (37.7659683774771, -122.412578614117) | |||
| 63645 | 63645 | 139013 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2569 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000229.2629 | 2114047.2029 | 37.7847824113212 | -122.442941426751 | (37.7847824113212, -122.442941426751) | |||
| 63774 | 63774 | 132150 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 540 Ivy St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004720.2552 | 2111067.25332 | 37.7768552284141 | -122.427191725035 | (37.7768552284141, -122.427191725035) | |||
| 63886 | 63886 | 141417 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 530 IVY ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004625.1496 | 2111052.9361 | 37.776810538049 | -122.427519703953 | (37.776810538049, -122.427519703953) | |||
| 66169 | 66169 | 138963 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 645 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004237.2429 | 2110976.1269 | 37.7765776909409 | -122.428856112669 | (37.7765776909409, -122.428856112669) | |||
| 67639 | 67639 | 210963 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 88 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992505.491719999 | 2098536.0534599996 | 37.7417495070478 | -122.468533953373 | (37.7417495070478, -122.468533953373) | |||
| 69110 | 69110 | 210971 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1901 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991557.235669999 | 2102412.45554 | 37.752338284906 | -122.47209516077801 | (37.752338284906, -122.472095160778) | |||
| 69997 | 69997 | 132143 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 525 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004895.042769999 | 2111066.14782 | 37.7768620758709 | -122.42658700288099 | (37.7768620758709, -122.426587002881) | |||
| 70892 | 70892 | 234434 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1256 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010030.06778 | 2101895.5926599996 | 37.7519707841232 | -122.408176383232 | (37.7519707841232, -122.408176383232) | |||
| 72014 | 72014 | 183496 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2546 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5989574.0258 | 2098014.7611 | 37.740148403076795 | -122.478631764598 | (37.7401484030768, -122.478631764598) | |||
| 72041 | 72041 | 210973 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1252 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992165.38565 | 2098459.60758 | 37.7415199541938 | -122.46970435269199 | (37.7415199541938, -122.469704352692) | |||
| 72148 | 72148 | 132153 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 540 Ivy St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6004662.5128 | 2111060.462 | 37.776833315546 | -122.427390989626 | (37.776833315546, -122.427390989626) | |||
| 72939 | 72939 | 183793 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2020 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986629.5476 | 2099631.7621 | 37.74441685845579 | -122.48893127672399 | (37.7444168584558, -122.488931276724) | |||
| 73073 | 73073 | 234458 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 478 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998572.14145 | 2106426.12515 | 37.7637622712248 | -122.448125561761 | (37.7637622712248, -122.448125561761) | |||
| 73084 | 73084 | 194418 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1548 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015914.234209999 | 2095920.1543400001 | 37.7358911793201 | -122.38741109563999 | (37.7358911793201, -122.38741109564) | |||
| 73352 | 73352 | 96614 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1224 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767286 | 6008998.07345 | 2117142.60049 | 37.7937776571604 | -122.41282303006399 | (37.7937776571604, -122.412823030064) | |
| 73879 | 73879 | 178103 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 450 Holyoke St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009835.80068 | 2092308.97785 | 37.7256371300447 | -122.408172135737 | (37.7256371300447, -122.408172135737) | |||
| 74179 | 74179 | 210979 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1130 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992638.30475 | 2098474.89596 | 37.7415892550296 | -122.468070286321 | (37.7415892550296, -122.468070286321) | |||
| 74196 | 74196 | 132144 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 525 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004910.2643099995 | 2111067.91228 | 37.7768677811601 | -122.426534472605 | (37.7768677811601, -122.426534472605) | |||
| 75806 | 75806 | 210977 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1130 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992617.33297 | 2098474.42129 | 37.7415867405452 | -122.468142764474 | (37.7415867405452, -122.468142764474) | |||
| 76731 | 76731 | 31383 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1200 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 4 | Permit Number 34979 | 5992400.98606 | 2098463.3385900003 | 37.7415438132084 | -122.468890005775 | (37.7415438132084, -122.468890005775) | |
| 76972 | 76972 | 140011 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 820 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004901.0094 | 2111721.5902 | 37.7786620972536 | -122.42661304697901 | (37.7786620972536, -122.426613046979) | |||
| 78768 | 78768 | 40741 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 60 Alviso St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1999 12:00:00 AM | Permit Number 41718 | 5992200.51411552 | 2091694.39813825 | 37.7229464099622 | -122.46909064509899 | (37.7229464099622, -122.469090645099) | |||
| 78964 | 78964 | 9364 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 257 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/1999 12:00:00 AM | 6 | 2X2 | 6001120.2442093 | 2098330.9781253003 | 37.74168028071279 | -122.43873236712601 | (37.7416802807128, -122.438732367126) | ||
| 81708 | 81708 | 21369 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2592X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 81737 | 81737 | 105346 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 651X Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6004248.77005 | 2110989.99433 | 37.7766164199227 | -122.428817225763 | (37.7766164199227, -122.428817225763) |
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");