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) | |
| 3630 | 3630 | 246504 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 255 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 01/05/1989 12:00:00 AM | 9 | Width 3ft | Permit Number 25818 | 6004850.160540001 | 2099861.56096 | 37.7460944007479 | -122.425944484052 | (37.7460944007479, -122.425944484052) | |
| 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) | |||
| 21776 | 21776 | 15063 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1X Minerva St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5995983.74533 | 2089004.6361 | 37.7157788310068 | -122.455818528899 | (37.7157788310068, -122.455818528899) | |||
| 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) | |||
| 24147 | 24147 | 210947 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 171 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992177.81487 | 2089015.3385599998 | 37.715589054271 | -122.468974238973 | (37.715589054271, -122.468974238973) | |||
| 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) | |||
| 24748 | 24748 | 210946 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 78 Lobos St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5996128.662169999 | 2088702.9665 | 37.714958832754 | -122.455295843853 | (37.714958832754, -122.455295843853) | ||||
| 24880 | 24880 | 178117 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988789.573419999 | 2089765.1297400002 | 37.717451446800204 | -122.480740256365 | (37.7174514468002, -122.480740256365) | ||||
| 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) | |||
| 25277 | 25277 | 210945 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 78 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5996140.80305 | 2088701.9398299998 | 37.7149567103495 | -122.455253805936 | (37.7149567103495, -122.455253805936) | ||||
| 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) | |||
| 26660 | 26660 | 178123 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 7 Still St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6003166.62203 | 2094649.98003 | 37.7316893083954 | -122.43139397276501 | (37.7316893083954, -122.431393972765) | |||
| 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) | |||
| 29203 | 29203 | 210954 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 462 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 5999009.76671 | 2094995.92761 | 37.732402733380795 | -122.44578987220301 | (37.7324027333808, -122.445789872203) | |||
| 30171 | 30171 | 194414 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2190 Revere Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6011991.11483 | 2096738.36261 | 37.737919746788705 | -122.401032427923 | (37.7379197467887, -122.401032427923) | ||||
| 30661 | 30661 | 218109 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 55 Lopez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5993991.90268 | 2100564.6875400003 | 37.747405374856896 | -122.46354166741699 | (37.7474053748569, -122.463541667417) | |||
| 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) | |||
| 32653 | 32653 | 194410 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1700x Quesada Ave | 42 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6014359.990180001 | 2095279.52622 | 37.7340459422739 | -122.39273997266899 | (37.7340459422739, -122.392739972669) | ||||
| 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) | |||
| 34452 | 34452 | 234432 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 200 Kingston St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6006208.4441 | 2098088.0907099997 | 37.741301521440796 | -122.421121802138 | (37.7413015214408, -122.421121802138) | ||||
| 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) | |||
| 35730 | 35730 | 132158 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2712 Steiner St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 4ft | 6002157.9755 | 2117472.75324 | 37.7942978654946 | -122.436513993051 | (37.7942978654946, -122.436513993051) | |||
| 36022 | 36022 | 178126 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 71 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6004930.0407300005 | 2092988.4225599999 | 37.7272268238432 | -122.425179289615 | (37.7272268238432, -122.425179289615) | ||||
| 36036 | 36036 | 194406 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1301 Minnesota St | 74 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6015366.03061 | 2102265.75372 | 37.753284502988 | -122.38974954880399 | (37.753284502988, -122.389749548804) | ||||
| 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) | |||
| 39990 | 39990 | 210966 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1693 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5993691.01781 | 2104009.81266 | 37.7568474649492 | -122.46483224853 | (37.7568474649492, -122.46483224853) | |||
| 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) | |||
| 41247 | 41247 | 210975 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 260 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5993308.24189 | 2099718.06264 | 37.745041343196704 | -122.465844195348 | (37.7450413431967, -122.465844195348) | |||
| 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) | |||
| 42906 | 42906 | 210968 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 11 Manor Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993371.33986 | 2093065.25444 | 37.726778028858796 | -122.465142895042 | (37.7267780288588, -122.465142895042) | |||
| 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) | |||
| 45496 | 45496 | 247037 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 550x Valley St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6002254.50848 | 2099154.508 | 37.744005964510606 | -122.434869346159 | (37.7440059645106, -122.434869346159) | ||||
| 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) | |||
| 48132 | 48132 | 234465 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 90 Divisadero St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6001962.28164 | 2108178.2640299997 | 37.7687664300461 | -122.43652554481301 | (37.7687664300461, -122.436525544813) | |||
| 48708 | 48708 | 210982 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1 Pizarro Way | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995118.54931 | 2093932.6722 | 37.7292603465805 | -122.459165665284 | (37.7292603465805, -122.459165665284) | |||
| 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) | |||
| 50192 | 50192 | 210981 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 332 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994142.27629 | 2099863.6831400003 | 37.7454892568299 | -122.462970838052 | (37.7454892568299, -122.462970838052) | |||
| 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) | |||
| 51105 | 51105 | 234464 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 90 Divisadero St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6001962.84457 | 2108154.72248 | 37.7687018227487 | -122.43652191247601 | (37.7687018227487, -122.436521912476) | |||
| 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) | |||
| 53508 | 53508 | 194413 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 98 Ceres St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 1ft | 6013801.433130001 | 2093700.7478 | 37.729679900994896 | -122.39456057640601 | (37.7296799009949, -122.394560576406) | |||
| 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) | |||
| 54708 | 54708 | 210955 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 222 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6000597.13244 | 2094707.9445200001 | 37.7317025050644 | -122.440281346627 | (37.7317025050644, -122.440281346627) | |||
| 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) | |||
| 55602 | 55602 | 218212 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 51 Taraval St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993554.23205 | 2099175.8099 | 37.7435666412016 | -122.464954237955 | (37.7435666412016, -122.464954237955) | |||
| 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) | |||
| 57157 | 57157 | 218107 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 71 Lopez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5993982.26369 | 2100522.02822 | 37.747287687783796 | -122.463571902628 | (37.7472876877838, -122.463571902628) | |||
| 57192 | 57192 | 194409 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 538 Mississippi St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6014067.65715 | 2104573.47269 | 37.7595489177536 | -122.394401194978 | (37.7595489177536, -122.394401194978) | |||
| 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) | |||
| 60239 | 60239 | 178116 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988774.083930001 | 2089765.9400900002 | 37.7174527715132 | -122.480793855056 | (37.7174527715132, -122.480793855056) | ||||
| 60618 | 60618 | 234457 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 6 Park Hill Ave | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6001153.426630001 | 2107602.71165 | 37.7671401095592 | -122.43928204874399 | (37.7671401095592, -122.439282048744) | |||
| 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) | |||
| 61361 | 61361 | 210952 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 82 Vernon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992474.658530001 | 2088476.64416 | 37.7141270758919 | -122.467909063055 | (37.7141270758919, -122.467909063055) |
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");