Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137783 | 137783 | 247787 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 0 30th St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004405.04711 | 2098420.28659 | 37.74211182679821 | -122.42738097477199 | (37.7421118267982, -122.427380974772) | |||
154157 | 154157 | 247786 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 0 30th St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004434.4666 | 2098422.1705099996 | 37.7421186634473 | -122.42727938556101 | (37.7421186634473, -122.427279385561) | |||
33541 | 33541 | 242192 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Castro St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002211.39696 | 2108163.69762 | 37.7687405871237 | -122.43566283237499 | (37.7687405871237, -122.435662832375) | |||
99159 | 99159 | 242191 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002232.110859999 | 2107759.61358 | 37.76763224826921 | -122.435562272887 | (37.7676322482692, -122.435562272887) | |||
30078 | 30078 | 241966 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006454.12488 | 2096966.7090099999 | 37.7382363045723 | -122.420192755695 | (37.7382363045723, -122.420192755695) | |||
70391 | 70391 | 241968 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Holly Park Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006548.82894 | 2096926.6354599998 | 37.7381316072746 | -122.41986247247499 | (37.7381316072746, -122.419862472475) | |||
76854 | 76854 | 241967 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006413.05624 | 2096945.1311299999 | 37.73817474237261 | -122.420333219896 | (37.7381747423726, -122.420333219896) | |||
115951 | 115951 | 200596 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016417.1805 | 2094923.5303 | 37.7331824919173 | -122.38560275837798 | (37.7331824919173, -122.385602758378) | |||
37301 | 37301 | 180009 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997247.3865 | 2086752.55268 | 37.7096675698642 | -122.45128849717399 | (37.7096675698642, -122.451288497174) | |||
74913 | 74913 | 180008 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997232.2014 | 2086767.6701 | 37.7097082093476 | -122.451342068885 | (37.7097082093476, -122.451342068885) | |||
151119 | 151119 | 180011 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997275.602999999 | 2086720.88269 | 37.7095822269181 | -122.451188694021 | (37.7095822269181, -122.451188694021) | |||
174890 | 174890 | 180010 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Lawrence Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997262.56254 | 2086737.01263 | 37.7096257693921 | -122.45123492637501 | (37.7096257693921, -122.451234926375) | |||
46052 | 46052 | 242860 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006601.51384 | 2109123.7876 | 37.77162514551679 | -122.420545880782 | (37.7716251455168, -122.420545880782) | |||
132534 | 132534 | 242859 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006473.643180001 | 2109116.62874 | 37.7715982818596 | -122.420987685352 | (37.7715982818596, -122.420987685352) | |||
49912 | 49912 | 246603 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005584.08918 | 2109245.7263700003 | 37.7719025692852 | -122.42407388970899 | (37.7719025692852, -122.424073889709) | |||
76509 | 76509 | 246605 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6005631.61729 | 2109252.77035 | 37.7719245936684 | -122.42390998734899 | (37.7719245936684, -122.423909987349) | |||
132570 | 132570 | 246600 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005541.07514 | 2109239.2971099997 | 37.771882487431 | -122.424222221193 | (37.771882487431, -122.424222221193) | |||
149193 | 149193 | 246604 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005614.489030001 | 2109249.34773 | 37.7719142289884 | -122.423968991887 | (37.7719142289884, -122.423968991887) | |||
156968 | 156968 | 246602 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005566.51625 | 2109243.72851 | 37.77189609146429 | -122.424134533696 | (37.7718960914643, -122.424134533696) | |||
165531 | 165531 | 246601 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005553.210969999 | 2109241.87873 | 37.77189026116871 | -122.424180426085 | (37.7718902611687, -122.424180426085) | |||
131719 | 131719 | 198129 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Apollo St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6013057.33243 | 2094752.72387 | 37.7325270152047 | -122.39720676767901 | (37.7325270152047, -122.397206767679) | |||
173422 | 173422 | 218543 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Elmhurst Dr | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991239.17772 | 2094375.63397 | 37.7302528212926 | -122.472609144905 | (37.7302528212926, -122.472609144905) | |||
69581 | 69581 | 200585 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016408.3895 | 2094976.9039 | 37.7333285587394 | -122.38563687008002 | (37.7333285587394, -122.38563687008) | |||
54166 | 54166 | 242236 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Loma Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999958.34407 | 2106938.77843 | 37.7652490349443 | -122.443367952968 | (37.7652490349443, -122.443367952968) | |||
153763 | 153763 | 242239 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Loma Vista Ter | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999972.43901 | 2106916.37432 | 37.765188322609 | -122.443317592742 | (37.765188322609, -122.443317592742) | |||
159937 | 159937 | 242238 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Loma Vista Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999968.62465 | 2106925.5157 | 37.765213205047495 | -122.443331442302 | (37.7652132050475, -122.443331442302) | |||
185581 | 185581 | 242237 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Loma Vista Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999962.961130001 | 2106933.24517 | 37.7652341052825 | -122.443351586234 | (37.7652341052825, -122.443351586234) | |||
155589 | 155589 | 180161 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Rolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000203.12908 | 2088838.03405 | 37.715562633976205 | -122.441222488037 | (37.7155626339762, -122.441222488037) | |||
187322 | 187322 | 180160 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000171.58523 | 2088857.19454 | 37.7156134474691 | -122.44133289151199 | (37.7156134474691, -122.441332891512) | |||
41151 | 41151 | 214936 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993805.7734 | 2095746.0567400001 | 37.7341638955498 | -122.463835582055 | (37.7341638955498, -122.463835582055) | |||
67261 | 67261 | 214931 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993780.73912 | 2095831.5977 | 37.734397327182705 | -122.46392833994499 | (37.7343973271827, -122.463928339945) | |||
69575 | 69575 | 214932 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993788.65441 | 2095818.8700599999 | 37.7343628363837 | -122.463900050863 | (37.7343628363837, -122.463900050863) | |||
155414 | 155414 | 214934 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993802.59672 | 2095785.6905900002 | 37.7342725372347 | -122.463849440612 | (37.7342725372347, -122.463849440612) | |||
168514 | 168514 | 214935 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993803.057030001 | 2095767.7757400002 | 37.7342233740152 | -122.463846549273 | (37.7342233740152, -122.463846549273) | |||
182128 | 182128 | 214933 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 San Andreas Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993794.553230001 | 2095807.5426900003 | 37.7343320741677 | -122.463878834949 | (37.7343320741677, -122.463878834949) | |||
834 | 834 | 140247 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Ashbury St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998760.3863 | 2110325.7376 | 37.77448037673879 | -122.447755234881 | (37.7744803767388, -122.447755234881) | |||
38216 | 38216 | 218684 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996159.93427 | 2093814.55265 | 37.72899583258479 | -122.455556993472 | (37.7289958325848, -122.455556993472) | |||
130664 | 130664 | 218683 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996159.6314199995 | 2093800.0617900002 | 37.7289560267814 | -122.455556993487 | (37.7289560267814, -122.455556993487) | |||
166038 | 166038 | 75713 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Goettingen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009899.57579 | 2093995.19407 | 37.7302706953269 | -122.408070533924 | (37.7302706953269, -122.408070533924) | ||
26332 | 26332 | 218682 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Greenwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996235.990669999 | 2093774.3040900002 | 37.728889683804795 | -122.45529115477699 | (37.7288896838048, -122.455291154777) | |||
157139 | 157139 | 218681 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996249.01925 | 2093772.54485 | 37.7288856008733 | -122.455245987239 | (37.7288856008733, -122.455245987239) | |||
151356 | 151356 | 138200 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 MASONIC AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998935.002 | 2112526.6295 | 37.780533437474396 | -122.44730964733401 | (37.7805334374744, -122.447309647334) | |||
178724 | 178724 | 138203 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 MASONIC AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998926.8799 | 2112606.4971 | 37.780752269091 | -122.44734349554199 | (37.780752269091, -122.447343495542) | |||
184909 | 184909 | 138202 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 MASONIC AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998931.6178 | 2112562.5022 | 37.7806317412334 | -122.44732393749399 | (37.7806317412334, -122.447323937494) | |||
27867 | 27867 | 241239 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6005928.367769999 | 2109150.09439 | 37.7716594186857 | -122.42287620587601 | (37.7716594186857, -122.422876205876) | |||
150338 | 150338 | 241238 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 McCoppin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005908.08699 | 2109147.66491 | 37.771651603561104 | -122.422946185717 | (37.7716516035611, -122.422946185717) | |||
23837 | 23837 | 242256 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006379.216440001 | 2110444.9043099997 | 37.77524008469361 | -122.421408658888 | (37.7752400846936, -122.421408658888) | |||
24065 | 24065 | 242257 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006301.70753 | 2110434.24272 | 37.7752064401631 | -122.42167602284401 | (37.7752064401631, -122.421676022844) | |||
36493 | 36493 | 242259 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006155.99242 | 2110416.55826 | 37.7751496650453 | -122.42217882840299 | (37.7751496650453, -122.422178828403) | |||
49845 | 49845 | 242255 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006442.072269999 | 2110453.56934 | 37.7752674204858 | -122.421191841332 | (37.7752674204858, -122.421191841332) | |||
157428 | 157428 | 242260 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6006119.6892099995 | 2110408.87993 | 37.77512653448729 | -122.422303863832 | (37.7751265344873, -122.422303863832) | |||
187925 | 187925 | 242258 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006281.32025 | 2110433.89565 | 37.7752043375461 | -122.42174652250401 | (37.7752043375461, -122.421746522504) | |||
135364 | 135364 | 198121 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Venus St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012854.74593 | 2094309.4604599997 | 37.731298624935 | -122.397876080041 | (37.731298624935, -122.397876080041) | |||
67628 | 67628 | 242297 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004276.66198 | 2097448.18955 | 37.739435408412795 | -122.42775564310301 | (37.7394354084128, -122.427755643103) | |||
125555 | 125555 | 198253 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Oakdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6018226.96048 | 2093133.1999700002 | 37.728366565251605 | -122.3792214842 | (37.7283665652516, -122.3792214842) | ||||
27046 | 27046 | 136881 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009094.10364 | 2115978.2019 | 37.7905858921869 | -122.41240841293998 | (37.7905858921869, -122.41240841294) | |||
3769 | 3769 | 136887 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
3772 | 3772 | 136889 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
3785 | 3785 | 136888 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
4211 | 4211 | 136890 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 01:59:00 PM | 3 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | ||
1458 | 1458 | 246242 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999462.0 | 2107723.0 | 37.7673739936786 | -122.445141068115 | (37.7673739936786, -122.445141068115) | |||
1467 | 1467 | 246243 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100X Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999462.0 | 2107723.0 | 37.7673739936786 | -122.445141068115 | (37.7673739936786, -122.445141068115) | |||
159947 | 159947 | 120380 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5987993.342019999 | 2115259.54167 | 37.78740594078629 | -122.485362157504 | (37.7874059407863, -122.485362157504) | |||
184371 | 184371 | 140268 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998235.1003 | 2110285.9342 | 37.7743410503874 | -122.44956942301201 | (37.7743410503874, -122.449569423012) | |||
182724 | 182724 | 241579 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999507.07027 | 2107703.03573 | 37.7673217492226 | -122.444983741515 | (37.7673217492226, -122.444983741515) | |||
2022 | 2022 | 198027 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010199.0 | 2110711.0 | 37.7761853461059 | -122.40821387035 | (37.7761853461059, -122.40821387035) | |||
166389 | 166389 | 214920 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Northgate Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994398.89243 | 2094048.76996 | 37.7295377235746 | -122.461661978232 | (37.7295377235746, -122.461661978232) | |||
173318 | 173318 | 137755 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Pinar Ln | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000699.5333 | 2112350.481 | 37.780150448397706 | -122.44119267191799 | (37.7801504483977, -122.441192671918) | |||
25113 | 25113 | 137738 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000674.4901 | 2112530.5214 | 37.780643366815504 | -122.44129222933901 | (37.7806433668155, -122.441292229339) | |||
33175 | 33175 | 137742 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000683.6274 | 2112456.0686 | 37.7804394589456 | -122.44125527558901 | (37.7804394589456, -122.441255275589) | |||
59349 | 59349 | 137735 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000666.7064 | 2112585.6841 | 37.780794386091706 | -122.441323116023 | (37.7807943860917, -122.441323116023) | |||
71266 | 71266 | 137748 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000691.4111 | 2112421.5495 | 37.7803451216971 | -122.441225870769 | (37.7803451216971, -122.441225870769) | |||
72096 | 72096 | 137736 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000670.0906 | 2112567.0709 | 37.780743471784604 | -122.44131007253701 | (37.7807434717846, -122.441310072537) | |||
135795 | 135795 | 137741 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000681.9353 | 2112475.6969999997 | 37.780493257130296 | -122.441262538089 | (37.7804932571303, -122.441262538089) | |||
154612 | 154612 | 137737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000673.1364 | 2112546.4272 | 37.7806869629645 | -122.44129805402099 | (37.7806869629645, -122.441298054021) | |||
155700 | 155700 | 137757 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000706.9785 | 2112308.1782 | 37.7800347197931 | -122.44116387970101 | (37.7800347197931, -122.441163879701) | |||
160999 | 160999 | 137756 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000702.2406 | 2112329.8372 | 37.7800939200036 | -122.441181824601 | (37.7800939200036, -122.441181824601) | |||
162930 | 162930 | 137747 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000687.3501 | 2112439.4859 | 37.7803941391444 | -122.441241206915 | (37.7803941391444, -122.441241206915) | |||
174007 | 174007 | 137732 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000660.4455 | 2112640.6777 | 37.780945027799 | -122.441348722594 | (37.780945027799, -122.441348722594) | |||
25579 | 25579 | 242205 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003186.42364 | 2107753.3281099997 | 37.7676691456397 | -122.43226097948799 | (37.7676691456397, -122.432260979488) | |||
174517 | 174517 | 218485 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1010 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995061.27255 | 2090658.8523400002 | 37.7202679310146 | -122.45912671113001 | (37.7202679310146, -122.45912671113) | |||
147683 | 147683 | 180398 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1011 Munich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002492.33471 | 2087599.91152 | 37.712293156769206 | -122.433221553446 | (37.7122931567692, -122.433221553446) | |||
184315 | 184315 | 180397 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1011 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002469.75801 | 2087564.3183799998 | 37.7121941450283 | -122.433297043449 | (37.7121941450283, -122.433297043449) | |||
166616 | 166616 | 241695 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1018 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005690.09574 | 2103002.00673 | 37.754764775380295 | -122.423263292966 | (37.7547647753803, -122.423263292966) | |||
171519 | 171519 | 242114 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 102 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004092.370680001 | 2102414.1734 | 37.753060424318704 | -122.428746761659 | (37.7530604243187, -122.428746761659) | |||
171523 | 171523 | 74199 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1020 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1988 12:00:00 AM | 5 | 6007263.22393 | 2114733.09636 | 37.787064224370205 | -122.418654831377 | (37.7870642243702, -122.418654831377) | ||
165676 | 165676 | 182097 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1020 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5990001.597 | 2099070.5556 | 37.7430721571395 | -122.477230550126 | (37.7430721571395, -122.477230550126) | |||
175334 | 175334 | 242105 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1026 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003766.99419 | 2102287.31977 | 37.7526936933823 | -122.42986292912902 | (37.7526936933823, -122.429862929129) | |||
41240 | 41240 | 241912 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1027 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009191.98331 | 2103167.16216 | 37.7554152658072 | -122.411164423924 | (37.7554152658072, -122.411164423924) | |||
39491 | 39491 | 242040 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 103 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005654.86586 | 2099026.99842 | 37.743848326850205 | -122.42310260391001 | (37.7438483268502, -122.42310260391) | |||
173268 | 173268 | 218609 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1030 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990759.53808 | 2102496.2873400003 | 37.7525222708937 | -122.474859817922 | (37.7525222708937, -122.474859817922) | |||
176118 | 176118 | 249541 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1031 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006016.726419999 | 2113765.1480900003 | 37.7843362199808 | -122.42289862237699 | (37.7843362199808, -122.422898622377) | |||
46576 | 46576 | 123777 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1033 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992375.070730001 | 2110654.80372 | 37.7750168848669 | -122.469867030032 | (37.7750168848669, -122.469867030032) | |||
31342 | 31342 | 214854 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1049 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992461.71045 | 2106577.38517 | 37.7638263910912 | -122.46927048734501 | (37.7638263910912, -122.469270487345) | |||
171154 | 171154 | 241955 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006363.59253 | 2098203.7151099998 | 37.7416277451281 | -122.42059355834299 | (37.7416277451281, -122.420593558343) | |||
55091 | 55091 | 241541 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004710.348619999 | 2097237.45909 | 37.738881313620794 | -122.42624114523998 | (37.7388813136208, -122.42624114524) | |||
179576 | 179576 | 241543 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Fairmount St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004772.01507 | 2097243.72781 | 37.7389020115256 | -122.42602837732099 | (37.7389020115256, -122.426028377321) | |||
187962 | 187962 | 241542 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 105 Fairmount St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004746.05114 | 2097239.88547 | 37.738889993882395 | -122.426117875136 | (37.7388899938824, -122.426117875136) | |||
110642 | 110642 | 102285 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6000567.8 | 2102477.2 | 37.7530333697051 | -122.44093990264099 | (37.7530333697051, -122.440939902641) | |||
151008 | 151008 | 241463 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000582.9390199995 | 2102474.82919 | 37.7530277222622 | -122.440887379058 | (37.7530277222622, -122.440887379058) |
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");