Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 259 | 259 | 141361 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 305 | 305 | 191509 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 905 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008110.0 | 2110227.0 | 37.774739203286295 | -122.415406037323 | (37.7747392032863, -122.415406037323) | |||
| 2219 | 2219 | 122754 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 6011277.363419999 | 2105334.1858 | 37.761482160689894 | -122.404105006665 | (37.7614821606899, -122.404105006665) | |||
| 2920 | 2920 | 140307 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997894.6936 | 2109955.1396 | 37.7734132939715 | -122.45072309212 | (37.7734132939715, -122.45072309212) | |||
| 3002 | 3002 | 141577 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1470 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000705.688999999 | 2110697.4418 | 37.7756119733478 | -122.44105274978997 | (37.7756119733478, -122.44105274979) | |||
| 3383 | 3383 | 17357 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2200 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005533.42048 | 2117633.73572 | 37.794931112339796 | -122.42484601254 | (37.7949311123398, -122.42484601254) | |||
| 4191 | 4191 | 244054 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Cole St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997907.6831 | 2109139.8095 | 37.771175350707296 | -122.450619366393 | (37.7711753507073, -122.450619366393) | |||
| 4616 | 4616 | 129648 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2005 12:00:00 AM | 3 | Width 3ft | 6009818.04009 | 2121706.12273 | 37.806353954733794 | -122.41030822344901 | (37.8063539547338, -122.410308223449) | ||
| 5775 | 5775 | 14804 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1140 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1994 12:00:00 AM | 3 | 4X4 | 6003547.1646 | 2111783.654 | 37.7787558775283 | -122.431300948764 | (37.7787558775283, -122.431300948764) | ||
| 7730 | 7730 | 7960 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1800 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005701.62625 | 2116374.60015 | 37.7914833418188 | -122.42417440425 | (37.7914833418188, -122.42417440425) | |||
| 10289 | 10289 | 77643 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006923.4408599995 | 2093174.3728599998 | 37.7278498138936 | -122.41830128179899 | (37.7278498138936, -122.418301281799) | |
| 24079 | 24079 | 207947 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992701.4282599995 | 2100499.03593 | 37.74715067337829 | -122.467999226394 | (37.7471506733783, -122.467999226394) | |||
| 24497 | 24497 | 227291 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 65 Zircon Pl | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 4ft | 6002354.98671 | 2098718.92039 | 37.7428156470274 | -122.43449077742399 | (37.7428156470274, -122.434490777424) | |||
| 24921 | 24921 | 185624 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985032.5384 | 2100289.574 | 37.74612969593421 | -122.49450180509399 | (37.7461296959342, -122.494501805094) | |||
| 26258 | 26258 | 200061 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1801 Lane St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6014890.6772 | 2094101.3916 | 37.7308404836446 | -122.39082290013799 | (37.7308404836446, -122.390822900138) | |||
| 29220 | 29220 | 138705 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2521 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001202.4589 | 2114528.6624 | 37.7861598123502 | -122.439609023251 | (37.7861598123502, -122.439609023251) | |||
| 32112 | 32112 | 191454 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6014422.1933 | 2115994.29604 | 37.790927639935205 | -122.39397451700701 | (37.7909276399352, -122.393974517007) | |||
| 32180 | 32180 | 227228 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3181 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007128.07099 | 2103203.65441 | 37.7553995025029 | -122.418304665024 | (37.7553995025029, -122.418304665024) | |||
| 32604 | 32604 | 248523 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 218 Downey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998865.9504 | 2107750.6769 | 37.7674159481781 | -122.447204704709 | (37.7674159481781, -122.447204704709) | |||
| 34507 | 34507 | 129677 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012069.97592 | 2116796.7218299997 | 37.792999901879604 | -122.402169577472 | (37.7929999018796, -122.402169577472) | |||
| 35118 | 35118 | 249626 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2450 Golden Gate Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 7ft | 5997629.20154 | 2111320.8976 | 37.7771481106256 | -122.45174000362199 | (37.7771481106256, -122.451740003622) | |||
| 35900 | 35900 | 177084 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 199 Blanken Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012033.75638 | 2087275.42031 | 37.71193882479629 | -122.400220567635 | (37.7119388247963, -122.400220567635) | |||
| 36312 | 36312 | 177137 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 567 Bowdoin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008885.05575 | 2093363.35639 | 37.728478948128 | -122.41153325655199 | (37.728478948128, -122.411533256552) | |||
| 37092 | 37092 | 129611 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1700 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6005874.36357 | 2117588.54131 | 37.794826271174294 | -122.42366308389799 | (37.7948262711743, -122.423663083898) | |||
| 37739 | 37739 | 227447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 240 Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004034.0348 | 2104541.75459 | 37.7588989579324 | -122.429100184426 | (37.7588989579324, -122.429100184426) | |||
| 40077 | 40077 | 191470 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6014270.7643099995 | 2112702.62209 | 37.7818810438134 | -122.39426789834499 | (37.7818810438134, -122.394267898345) | |||
| 40802 | 40802 | 182830 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1811 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985639.2314 | 2102838.2271 | 37.7531630922797 | -122.49259163632401 | (37.7531630922797, -122.492591636324) | |||
| 40980 | 40980 | 245071 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 8 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000404.0401 | 2108984.869 | 37.770892494718 | -122.44197327427901 | (37.770892494718, -122.441973274279) | |||
| 46096 | 46096 | 122133 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5991114.065719999 | 2115007.37065 | 37.7868948615896 | -122.474546795399 | (37.7868948615896, -122.474546795399) | ||||
| 46570 | 46570 | 226667 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Buchanan St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6004704.0947199995 | 2109267.38309 | 37.7719123098365 | -122.42711939795 | (37.7719123098365, -122.42711939795) | |||
| 46741 | 46741 | 129579 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2434 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000792.48835 | 2116759.0177599997 | 37.7922604469152 | -122.441187490011 | (37.7922604469152, -122.441187490011) | |||
| 46988 | 46988 | 116060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100x 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7 | 3x3 | 6011408.71891 | 2105130.5396 | 37.7609303321981 | -122.403636370817 | (37.7609303321981, -122.403636370817) | ||
| 48599 | 48599 | 227168 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 119 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5998108.05626 | 2106506.70041 | 37.76395696996121 | -122.44973648946001 | (37.7639569699612, -122.44973648946) | |||
| 48603 | 48603 | 177091 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993412.52644 | 2086599.2418 | 37.709026289400796 | -122.46453122115801 | (37.7090262894008, -122.464531221158) | |||
| 50894 | 50894 | 177115 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 34 Vienna St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 6005069.55264 | 2093328.8991099999 | 37.7281695777432 | -122.424721208244 | (37.7281695777432, -122.424721208244) | |||
| 53214 | 53214 | 227510 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 37 Brady St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6006532.91743 | 2109718.55388 | 37.773254365438596 | -122.420825392799 | (37.7732543654386, -122.420825392799) | |||
| 54144 | 54144 | 120481 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5988593.25091 | 2114641.37666 | 37.7857435664695 | -122.48324129171101 | (37.7857435664695, -122.483241291711) | |||
| 55596 | 55596 | 138671 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1720 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999595.6975 | 2114785.7218 | 37.7867740499686 | -122.44518646163601 | (37.7867740499686, -122.445186461636) | |||
| 58525 | 58525 | 207855 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 494 Victoria St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5993274.09777 | 2090428.4072099999 | 37.719532280163 | -122.46528760316099 | (37.719532280163, -122.465287603161) | |||
| 60586 | 60586 | 207937 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996773.96274 | 2094591.1270299999 | 37.7311633363083 | -122.45349031003201 | (37.7311633363083, -122.453490310032) | |||
| 60663 | 60663 | 114468 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009284.18017 | 2121746.40432 | 37.806434617621704 | -122.412158595669 | (37.8064346176217, -122.412158595669) | |||
| 62116 | 62116 | 227254 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 191 Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 2ft | 6006076.68891 | 2096382.83584 | 37.736611844768895 | -122.42145629056999 | (37.7366118447689, -122.42145629057) | |||
| 62185 | 62185 | 227290 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 685 29th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002218.42059 | 2098832.30166 | 37.7431192122842 | -122.434971090944 | (37.7431192122842, -122.434971090944) | ||||
| 64168 | 64168 | 250111 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006107.64961 | 2115425.94774 | 37.7889014952475 | -122.42270212321199 | (37.7889014952475, -122.422702123212) | |||
| 68366 | 68366 | 129656 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009761.436430001 | 2121807.95495 | 37.80663038745121 | -122.410511306563 | (37.8066303874512, -122.410511306563) | |||
| 68444 | 68444 | 184122 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3340 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983807.3681 | 2104294.0393 | 37.7570530669968 | -122.49903404016001 | (37.7570530669968, -122.49903404016) | |||
| 70070 | 70070 | 227378 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3440 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006846.58605 | 2101476.05301 | 37.7506400554955 | -122.419155589162 | (37.7506400554955, -122.419155589162) | |||
| 70355 | 70355 | 191497 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6016662.8976 | 2094787.97273 | 37.7328238706214 | -122.384743799985 | (37.7328238706214, -122.384743799985) | |||
| 73429 | 73429 | 34690 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) |
| 76026 | 76026 | 96009 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009716.9001400005 | 2116412.09513 | 37.7918121879409 | -122.41028421245701 | (37.7918121879409, -122.410284212457) |
| 76604 | 76604 | 207995 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999470.3608 | 2094946.2688099998 | 37.7322926698604 | -122.44419392902799 | (37.7322926698604, -122.444193929028) | |||
| 82923 | 82923 | 92842 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3440 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2009 12:00:00 AM | 3x3 | 6006883.0 | 2101475.0 | 37.7506392147773 | -122.419029591774 | (37.7506392147773, -122.419029591774) | |||
| 83821 | 83821 | 114799 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||||
| 86964 | 86964 | 113437 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198x HIGHLAND AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4x4 | 6006173.0 | 2096415.0 | 37.73670559026029 | -122.421125584355 | (37.7367055902603, -122.421125584355) | ||||
| 87823 | 87823 | 20263 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | ||
| 88992 | 88992 | 98678 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 93915 | 93915 | 34045 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37957 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | ||
| 96040 | 96040 | 37259 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 96430 | 96430 | 115659 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000749.0 | 2110266.0 | 37.7744298099173 | -122.440871970116 | (37.7744298099173, -122.440871970116) | |||
| 97647 | 97647 | 27658 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1698X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | |||
| 97712 | 97712 | 93119 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1555 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6000421.0 | 2110261.0 | 37.774397395284 | -122.44200622209299 | (37.774397395284, -122.442006222093) | |||
| 99391 | 99391 | 17145 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
| 100122 | 100122 | 26530 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2701x Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008955.0644 | 2102702.28881 | 37.7541255388196 | -122.41195091510001 | (37.7541255388196, -122.4119509151) | |||
| 103677 | 103677 | 25292 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000743.1124599995 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | |||
| 105778 | 105778 | 105876 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2X 27th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006029.156359999 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | ||||
| 107186 | 107186 | 103604 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | ||
| 108302 | 108302 | 107956 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2299X 25TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012136.0 | 2101880.0 | 37.752045663585896 | -122.400892625965 | (37.7520456635859, -122.400892625965) | ||||
| 110687 | 110687 | 12310 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 949 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004809.18722 | 2111991.6762900003 | 37.7793984956931 | -122.426949936516 | (37.7793984956931, -122.426949936516) | ||
| 111912 | 111912 | 246237 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 96 Delmar St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999342.4520000005 | 2107821.6903 | 37.7676381481281 | -122.445561664053 | (37.7676381481281, -122.445561664053) | |||
| 113858 | 113858 | 20273 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009846.48172 | 2121764.7141400003 | 37.8065164263834 | -122.41021393510599 | (37.8065164263834, -122.410213935106) | |||
| 114565 | 114565 | 92634 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | ||
| 117586 | 117586 | 11438 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2100X FRANKLIN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005630.0 | 2117242.0 | 37.79386095938629 | -122.424483955414 | (37.7938609593863, -122.424483955414) | |||
| 118133 | 118133 | 73874 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 120775 | 120775 | 89035 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 121210 | 121210 | 111020 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 90x DOWNEY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2015 12:00:00 AM | 3x3 | 5998894.0 | 2107683.0 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | |||
| 123443 | 123443 | 191504 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Baldwin Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6017862.18303 | 2093613.8535 | 37.7296662241092 | -122.38051594408 | (37.7296662241092, -122.38051594408) | |||
| 124552 | 124552 | 33770 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
| 125454 | 125454 | 12207 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
| 127620 | 127620 | 102189 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
| 130319 | 130319 | 227276 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 91 Gold Mine Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001604.247 | 2099100.29306 | 37.743820161875796 | -122.437113918188 | (37.7438201618758, -122.437113918188) | |||
| 131196 | 131196 | 207959 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995748.658340001 | 2100247.6965 | 37.7466360605992 | -122.45744403462 | (37.7466360605992, -122.45744403462) | |||
| 131957 | 131957 | 227491 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1893 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004617.88514 | 2097640.41879 | 37.7399825226668 | -122.42658952729099 | (37.7399825226668, -122.426589527291) | |||
| 132468 | 132468 | 191449 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1224 Fairfax Ave | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6017403.85827 | 2096904.38167 | 37.7386760604628 | -122.382329276794 | (37.7386760604628, -122.382329276794) | |||
| 137087 | 137087 | 227164 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997856.90065 | 2106470.54587 | 37.7638433262424 | -122.45060255097 | (37.7638433262424, -122.45060255097) | |||
| 143379 | 143379 | 20268 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | |||
| 144344 | 144344 | 99682 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 144635 | 144635 | 20278 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
| 145904 | 145904 | 17040 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.772983491104604 | -122.439151661694 | (37.7729834911046, -122.439151661694) | |||
| 148184 | 148184 | 123769 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 801 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993062.81388 | 2110680.4895599997 | 37.7751271410654 | -122.46748986588499 | (37.7751271410654, -122.467489865885) | |||
| 148880 | 148880 | 123766 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 773 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993235.861169999 | 2110685.0962099996 | 37.7751497787963 | -122.466891596882 | (37.7751497787963, -122.466891596882) | |||
| 149329 | 149329 | 207836 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 De Montfort Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5995005.14377 | 2091917.0493299998 | 37.7237194121086 | -122.459411800719 | (37.7237194121086, -122.459411800719) | |||
| 149576 | 149576 | 177053 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998955.229780001 | 2090176.99773 | 37.719167958508 | -122.445632005212 | (37.719167958508, -122.445632005212) | |||
| 151650 | 151650 | 226670 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008867.09497 | 2106908.52586 | 37.765669970714704 | -122.412552451952 | (37.7656699707147, -122.412552451952) | |||
| 153989 | 153989 | 207834 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 112 Marston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5998700.55085 | 2093216.8077 | 37.7275000279916 | -122.446730933593 | (37.7275000279916, -122.446730933593) | |||
| 155356 | 155356 | 101145 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 2x2 | 6013204.93498 | 2104939.92488 | 37.7605071193183 | -122.397410636789 | (37.7605071193183, -122.397410636789) | |||
| 155465 | 155465 | 227515 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1175 Stevenson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6006475.3834 | 2109601.81722 | 37.7729305914948 | -122.42101612099701 | (37.7729305914948, -122.421016120997) | |||
| 156713 | 156713 | 177062 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999011.63296 | 2090530.40369 | 37.720141550179896 | -122.44546243984199 | (37.7201415501799, -122.445462439842) | |||
| 157456 | 157456 | 129596 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1730 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6005755.363609999 | 2117239.26251 | 37.793860521606 | -122.42404999020901 | (37.793860521606, -122.424049990209) | |||
| 157800 | 157800 | 227365 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 176 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008045.892659999 | 2101114.02966 | 37.7497134875938 | -122.41498265482599 | (37.7497134875938, -122.414982654826) | |||
| 159520 | 159520 | 227235 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3591 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006415.25299 | 2104336.0172200003 | 37.7584685576864 | -122.42085019969801 | (37.7584685576864, -122.420850199698) |
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");