Street_Tree_List

Data source: data.sfgov.org

1,397 rows where qSpecies = 19 sorted by SiteOrder descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▲ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
132494 132494 185500 Undocumented 2 Juniperus chinensis :: Juniper 19 2400 Sunset Blvd 54 unknown : Yard 19 Tree 1 Private 1     6 Width 0ft   5985111.7766 2098706.9627 37.7417889108579 -122.49411119019399 (37.7417889108579, -122.494111190194)
175803 175803 129354 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 52 Median : Yard 3 Tree 1 DPW 2     14 Width 8ft   6011388.89614 2120338.61388 37.8026870410416 -122.40477563290199 (37.8026870410416, -122.404775632902)
75147 75147 129353 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 51 Median : Yard 3 Tree 1 DPW 2     6 Width 8ft   6011391.406830001 2120329.06369 37.8026609588854 -122.404766271855 (37.8026609588854, -122.404766271855)
184505 184505 249764 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 48 : 4 Tree 1 Private 1     23 Width 1ft   6000246.04856 2117175.67215 37.7933733291772 -122.44310811365101 (37.7933733291772, -122.443108113651)
174994 174994 249763 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 47 : 4 Tree 1 Private 1     21 Width 1ft   6000244.96871 2117178.7308099996 37.7933816658824 -122.443112069768 (37.7933816658824, -122.443112069768)
70038 70038 249762 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 46 : 4 Tree 1 Private 1     20 Width 1ft   6000243.900669999 2117182.35848 37.7933915656126 -122.443116025908 (37.7933915656126, -122.443116025908)
138184 138184 249761 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 45 : 4 Tree 1 Private 1     8 Width 1ft   6000243.02333 2117185.9818700003 37.793401464464395 -122.443119321906 (37.7934014644644, -122.443119321906)
163136 163136 129352 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 45 Median : Yard 3 Tree 1 DPW 2     3 Width 8ft   6011406.69978 2120255.02893 37.8024585322873 -122.404708135188 (37.8024585322873, -122.404708135188)
153878 153878 249760 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 44 : 4 Tree 1 Private 1     12 Width 1ft   6000241.7862599995 2117189.5298599997 37.7934111357761 -122.44312385717699 (37.7934111357761, -122.443123857177)
65018 65018 249759 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 43 : 4 Tree 1 Private 1     11 Width 1ft   6000241.634269999 2117194.01368 37.7934234385005 -122.443124705245 (37.7934234385005, -122.443124705245)
67332 67332 249758 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 42 : 4 Tree 1 Private 1     11 Width 1ft   6000240.94884 2117198.36774 37.793435354521996 -122.44312738972602 (37.793435354522, -122.443127389726)
182870 182870 249757 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 41 : 4 Tree 1 Private 1     11 Width 1ft   6000240.78319 2117204.07092 37.7934510045092 -122.443128372672 (37.7934510045092, -122.443128372672)
32459 32459 249756 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 40 : 4 Tree 1 Private 1     6 Width 1ft   6000240.43697 2117209.2145 37.7934651076862 -122.443129940195 (37.7934651076862, -122.443129940195)
52094 52094 249755 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 39 : 4 Tree 1 Private 1     9 Width 1ft   6000239.615259999 2117214.478 37.79347951302 -122.443133161562 (37.79347951302, -122.443133161562)
154652 154652 129351 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 39 Median : Yard 3 Tree 1 DPW 2     1 Width 8ft   6011425.67929 2120161.57643 37.8022029953207 -122.404635873741 (37.8022029953207, -122.404635873741)
26942 26942 129350 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 38 Median : Yard 3 Tree 1 DPW 2     1 Width 8ft   6011425.50986 2120159.17711 37.8021963979046 -122.404636291051 (37.8021963979046, -122.404636291051)
173393 173393 249754 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 38 : 4 Tree 1 Private 1     10 Width 1ft   6000238.64594 2117219.3423599997 37.7934928140037 -122.443136864991 (37.7934928140037, -122.443136864991)
37997 37997 249753 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 37 : 4 Tree 1 Private 1     7 Width 1ft   6000238.5689199995 2117223.4057 37.793503966475 -122.44313742344801 (37.793503966475, -122.443137423448)
62997 62997 249752 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 36 : 4 Tree 1 Private 1     8 Width 1ft   6000236.97181 2117227.13869 37.7935141252181 -122.44314321778299 (37.7935141252181, -122.443143217783)
49386 49386 249751 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 35 : 4 Tree 1 Private 1     9 Width 1ft   6000236.78022 2117230.8297200003 37.793524248891295 -122.443144145909 (37.7935242488913, -122.443144145909)
188999 188999 129349 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 35 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6011426.64663 2120143.89656 37.8021545047788 -122.40463128093398 (37.8021545047788, -122.404631280934)
148834 148834 249750 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 34 : 4 Tree 1 Private 1     11 Width 1ft   6000235.93718 2117235.57911 37.7935372413976 -122.443147404144 (37.7935372413976, -122.443147404144)
27490 27490 129348 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 33 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6011427.80927 2120135.82348 37.802132403051 -122.404626688974 (37.802132403051, -122.404626688974)
39030 39030 249749 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 33 : 4 Tree 1 Private 1     12 Width 1ft   6000235.88036 2117238.71283 37.7935458425285 -122.44314782591299 (37.7935458425285, -122.443147825913)
136197 136197 249748 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 32 : 4 Tree 1 Private 1     2 Width 1ft   6000234.88856 2117241.71857 37.7935540389482 -122.443151473582 (37.7935540389482, -122.443151473582)
40469 40469 249747 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 31 : 4 Tree 1 Private 1     10 Width 1ft   6000233.56128 2117245.74106 37.793565007967 -122.44315635509399 (37.793565007967, -122.443156355094)
46543 46543 249746 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 30 : 4 Tree 1 Private 1     4 Width 1ft   6000233.18821 2117249.22853 37.7935745623699 -122.44315789653 (37.7935745623699, -122.44315789653)
186808 186808 249745 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 29 : 4 Tree 1 Private 1     10 Width 1ft   6000232.829030001 2117254.6491400003 37.793589425458606 -122.44315952880899 (37.7935894254586, -122.443159528809)
27573 27573 249744 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 28 : 4 Tree 1 Private 1     10 Width 1ft   6000231.5353 2117259.0230400003 37.793601361269396 -122.44316431948799 (37.7936013612694, -122.443164319488)
130192 130192 249743 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 27 : 4 Tree 1 Private 1     8 Width 1ft   6000230.51867 2117262.97292 37.793612148632704 -122.443168120916 (37.7936121486327, -122.443168120916)
66358 66358 249740 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Broderick St 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 1ft   6000185.11039 2117163.8687299998 37.7933374453318 -122.443318115254 (37.7933374453318, -122.443318115254)
24248 24248 219332 Undocumented 2 Juniperus chinensis :: Juniper 19 1025 Junipero Serra Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5991262.77441 2090479.13965 37.719555381949206 -122.47224364333 (37.7195553819492, -122.47224364333)
169759 169759 129359 Undocumented 2 Juniperus chinensis :: Juniper 19 2431 Jones St 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   6007962.685269999 2120698.0317700002 37.8034818141966 -122.41665756481702 (37.8034818141966, -122.416657564817)
188529 188529 219331 Undocumented 2 Juniperus chinensis :: Juniper 19 1025 Junipero Serra Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5991262.34027 2090458.54246 37.7194988020073 -122.472243643342 (37.7194988020073, -122.472243643342)
6044 6044 107491 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 20 Median : Cutout 11 Tree 1 DPW 2     8     6011446.048280001 2119975.7461599996 37.8016938891322 -122.40455229795 (37.8016938891322, -122.40455229795)
46533 46533 129358 Undocumented 2 Juniperus chinensis :: Juniper 19 2431 Jones St 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   6007962.785209999 2120702.9106099997 37.8034952158822 -122.41665756479799 (37.8034952158822, -122.416657564798)
173591 173591 219330 Undocumented 2 Juniperus chinensis :: Juniper 19 1025 Junipero Serra Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   5991259.76279 2090425.50198 37.7194079318084 -122.472250145444 (37.7194079318084, -122.472250145444)
46959 46959 129177 Undocumented 2 Juniperus chinensis :: Juniper 19 2901 Steiner St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 2ft   6002004.54365 2118129.86788 37.796093411439706 -122.43709195313801 (37.7960934114397, -122.437091953138)
71131 71131 176782 Undocumented 2 Juniperus chinensis :: Juniper 19 101 Dartmouth St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 5ft   6008503.6919 2093600.7846099997 37.7291094763057 -122.412868435047 (37.7291094763057, -122.412868435047)
177114 177114 206923 Undocumented 2 Juniperus chinensis :: Juniper 19 370 Monterey Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 8ft   5999650.953509999 2094728.03216 37.731703744317 -122.443553909399 (37.731703744317, -122.443553909399)
181025 181025 190794 Undocumented 2 Juniperus chinensis :: Juniper 19 1701 19th St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 7ft   6012616.86212 2105145.29416 37.76103825803379 -122.399458942574 (37.7610382580338, -122.399458942574)
183528 183528 219372 DPW Maintained 3 Juniperus chinensis :: Juniper 19 400x Marietta Dr 17 Median : Cutout 11 Tree 1 DPW 2     9 Width 3ft   5999397.86314 2097051.08053 37.7380678498474 -122.444595794674 (37.7380678498474, -122.444595794674)
33950 33950 176781 Undocumented 2 Juniperus chinensis :: Juniper 19 101 Dartmouth St 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   6008506.492819999 2093591.6358299998 37.7290845129336 -122.41285810544399 (37.7290845129336, -122.412858105444)
71907 71907 190793 Undocumented 2 Juniperus chinensis :: Juniper 19 1701 19th St 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 7ft   6012612.20742 2105147.56278 37.761044227720106 -122.39947520054 (37.7610442277201, -122.39947520054)
75311 75311 129260 Undocumented 2 Juniperus chinensis :: Juniper 19 1230 Clay St 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   6008685.62861 2116995.27312 37.7933555900526 -122.413893694545 (37.7933555900526, -122.413893694545)
112118 112118 878 DPW Maintained 3 Juniperus chinensis :: Juniper 19 600X Alemany Blvd 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 1X1   6007241.9784 2095034.8696299999 37.7329762592527 -122.41733187808398 (37.7329762592527, -122.417331878084)
131673 131673 201354 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Bitting Ave 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   6012921.134769999 2092559.31371 37.726496777601795 -122.39752386145099 (37.7264967776018, -122.397523861451)
155003 155003 250175 Undocumented 2 Juniperus chinensis :: Juniper 19 721 Parker Ave 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 7ft   5997242.30788 2110631.32988 37.7752325717698 -122.453028595406 (37.7752325717698, -122.453028595406)
28078 28078 129229 Undocumented 2 Juniperus chinensis :: Juniper 19 2711 Vallejo St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   6000617.83995 2117501.7173200003 37.794289755430796 -122.44184510397 (37.7942897554308, -122.44184510397)
32661 32661 176624 Undocumented 2 Juniperus chinensis :: Juniper 19 190 Foote Ave 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   5998633.901980001 2088379.60151 37.714214369464 -122.446613458762 (37.714214369464, -122.446613458762)
55652 55652 250174 Undocumented 2 Juniperus chinensis :: Juniper 19 721 Parker Ave 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 7ft   5997242.00203 2110645.63605 37.7752718352644 -122.45303068632299 (37.7752718352644, -122.453030686323)
70285 70285 190830 Undocumented 2 Juniperus chinensis :: Juniper 19 256 Terry A Francois Blvd 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 6ft   6016394.93406 2108680.04428 37.770953776427895 -122.38663860051001 (37.7709537764279, -122.38663860051)
144668 144668 110414 Undocumented 2 Juniperus chinensis :: Juniper 19 419X 18TH AVE 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 MTA 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
148301 148301 129259 Undocumented 2 Juniperus chinensis :: Juniper 19 1230 Clay St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 3ft   6008689.11536 2116996.18865 37.7933582996916 -122.413881694895 (37.7933582996916, -122.413881694895)
154484 154484 201353 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Bitting Ave 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6012904.00238 2092563.8073 37.7265081621175 -122.39758340285101 (37.7265081621175, -122.397583402851)
160575 160575 129176 Undocumented 2 Juniperus chinensis :: Juniper 19 2901 Steiner St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   6002003.1477 2118142.56087 37.7961281837336 -122.437097692619 (37.7961281837336, -122.437097692619)
166224 166224 190792 Undocumented 2 Juniperus chinensis :: Juniper 19 1701 19th St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 7ft   6012608.36477 2105144.14311 37.7610346238788 -122.399488250597 (37.7610346238788, -122.399488250597)
42535 42535 250173 Undocumented 2 Juniperus chinensis :: Juniper 19 721 Parker Ave 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 7ft   5997239.18442 2110648.2538799997 37.7752788616692 -122.453040622039 (37.7752788616692, -122.453040622039)
68725 68725 129258 Undocumented 2 Juniperus chinensis :: Juniper 19 1230 Clay St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6008692.2550800005 2116996.28885 37.7933587511439 -122.413870838295 (37.7933587511439, -122.413870838295)
131660 131660 247557 Undocumented 2 Juniperus chinensis :: Juniper 19 815 Buena Vista Ave West 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32 Width 2ft   6000027.54626 2108348.5362299997 37.769123823324 -122.443229861189 (37.769123823324, -122.443229861189)
147527 147527 176780 Undocumented 2 Juniperus chinensis :: Juniper 19 101 Dartmouth St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6008510.60068 2093581.4689 37.729056827298 -122.412843185683 (37.729056827298, -122.412843185683)
165303 165303 190791 Undocumented 2 Juniperus chinensis :: Juniper 19 1701 19th St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 7ft   6012603.88401 2105144.39947 37.761035078034894 -122.3995037657 (37.7610350780349, -122.3995037657)
165941 165941 129228 Undocumented 2 Juniperus chinensis :: Juniper 19 2711 Vallejo St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   6000612.55755 2117501.2436 37.794288153722796 -122.441863347611 (37.7942881537228, -122.441863347611)
168356 168356 201352 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Bitting Ave 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6012884.58431 2092567.5936099999 37.7265174772786 -122.397650796243 (37.7265174772786, -122.397650796243)
170147 170147 190829 Undocumented 2 Juniperus chinensis :: Juniper 19 256 Terry A Francois Blvd 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 6ft   6016399.44084 2108687.19343 37.770973655936 -122.386623509886 (37.770973655936, -122.386623509886)
24188 24188 247556 Undocumented 2 Juniperus chinensis :: Juniper 19 815 Buena Vista Ave West 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 2ft   6000035.32206 2108353.94379 37.7691391145131 -122.443203353661 (37.7691391145131, -122.443203353661)
24753 24753 129266 Undocumented 2 Juniperus chinensis :: Juniper 19 24 Priest St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   6008334.4403800005 2117141.01825 37.7937360410291 -122.41511915572399 (37.7937360410291, -122.415119155724)
36594 36594 129227 Undocumented 2 Juniperus chinensis :: Juniper 19 2711 Vallejo St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 4ft   6000607.86653 2117501.04945 37.794287353335704 -122.441879565091 (37.7942873533357, -122.441879565091)
36832 36832 250172 Undocumented 2 Juniperus chinensis :: Juniper 19 721 Parker Ave 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 7ft   5997240.90305 2110650.9273599996 37.775286300843796 -122.45303486996401 (37.7752863008438, -122.453034869964)
135014 135014 129324 Undocumented 2 Juniperus chinensis :: Juniper 19 1830 Jones St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 10ft   6008276.93118 2118915.06501 37.7986039022051 -122.41544379748699 (37.7986039022051, -122.415443797487)
135032 135032 201351 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Bitting Ave 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   6012866.15074 2092573.2448900002 37.7265319680523 -122.397714917004 (37.7265319680523, -122.397714917004)
149482 149482 129320 Undocumented 2 Juniperus chinensis :: Juniper 19 900 Chestnut St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6007405.89372 2120592.57904 37.8031609369869 -122.41857688803002 (37.8031609369869, -122.41857688803)
149982 149982 190828 Undocumented 2 Juniperus chinensis :: Juniper 19 256 Terry A Francois Blvd 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 6ft   6016393.1041 2108697.45755 37.7710014881618 -122.386646144905 (37.7710014881618, -122.386646144905)
152742 152742 206922 Undocumented 2 Juniperus chinensis :: Juniper 19 370 Monterey Blvd 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   5999677.20212 2094726.1329599998 37.7317000265246 -122.44346302659201 (37.7317000265246, -122.443463026592)
173163 173163 129257 Undocumented 2 Juniperus chinensis :: Juniper 19 1230 Clay St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   6008696.73194 2116997.18381 37.793361459904794 -122.413855411325 (37.7933614599048, -122.413855411325)
56417 56417 190827 Undocumented 2 Juniperus chinensis :: Juniper 19 256 Terry A Francois Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 6ft   6016391.891340001 2108709.42861 37.771034290942204 -122.386651174818 (37.7710342909422, -122.386651174818)
58047 58047 206927 Undocumented 2 Juniperus chinensis :: Juniper 19 300 Monterey Blvd 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 2ft   5999958.08638 2094720.0748400001 37.7316994068848 -122.442491521362 (37.7316994068848, -122.442491521362)
68885 68885 250171 Undocumented 2 Juniperus chinensis :: Juniper 19 721 Parker Ave 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   5997238.11076 2110659.10553 37.7753085959468 -122.45304511956002 (37.7753085959468, -122.45304511956)
74501 74501 129333 Undocumented 2 Juniperus chinensis :: Juniper 19 1101 Greenwich St 12 Front Yard : Yard 7 Tree 1 Private 1     1     6007566.1830400005 2119864.34532 37.8011704135381 -122.417970546228 (37.8011704135381, -122.417970546228)
129996 129996 176779 Undocumented 2 Juniperus chinensis :: Juniper 19 101 Dartmouth St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6008512.5516 2093571.34607 37.729029141679895 -122.412835725785 (37.7290291416799, -122.412835725785)
149516 149516 201350 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Bitting Ave 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6012847.3383 2092578.90387 37.726546458834896 -122.397780348078 (37.7265464588349, -122.397780348078)
154626 154626 247555 Undocumented 2 Juniperus chinensis :: Juniper 19 815 Buena Vista Ave West 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 2ft   6000042.91239 2108360.38627 37.769157236751 -122.443177561991 (37.769157236751, -122.443177561991)
157724 157724 190784 Undocumented 2 Juniperus chinensis :: Juniper 19 1250 20th St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 3ft   6014129.55308 2104823.7661099997 37.760239609683104 -122.39420464993 (37.7602396096831, -122.39420464993)
169609 169609 190818 Undocumented 2 Juniperus chinensis :: Juniper 19 151 Helena St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 8ft   6011192.32656 2096261.9333400002 37.7365669811865 -122.403760731784 (37.7365669811865, -122.403760731784)
175954 175954 129256 Undocumented 2 Juniperus chinensis :: Juniper 19 1230 Clay St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   6008702.68791 2116997.72001 37.793363266662205 -122.413834841121 (37.7933632666622, -122.413834841121)
185950 185950 129226 Undocumented 2 Juniperus chinensis :: Juniper 19 2711 Vallejo St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   6000603.16366 2117500.27188 37.7942849503531 -122.44189578167801 (37.7942849503531, -122.441895781678)
186852 186852 129319 Undocumented 2 Juniperus chinensis :: Juniper 19 900 Chestnut St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6007409.37859 2120592.7001799997 37.8031614657978 -122.41856483710698 (37.8031614657978, -122.418564837107)
187969 187969 129213 Undocumented 2 Juniperus chinensis :: Juniper 19 11 Normandie Ter 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6000915.059280001 2117274.38469 37.793682490900295 -122.440800378652 (37.7936824909003, -122.440800378652)
28070 28070 190826 Undocumented 2 Juniperus chinensis :: Juniper 19 256 Terry A Francois Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 6ft   6016386.63874 2108737.40916 37.771110828636296 -122.38667129537 (37.7711108286363, -122.38667129537)
36391 36391 190790 Undocumented 2 Juniperus chinensis :: Juniper 19 1701 19th St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 7ft   6012585.92688 2105143.77126 37.7610323521809 -122.39956582791099 (37.7610323521809, -122.399565827911)
36896 36896 129318 Undocumented 2 Juniperus chinensis :: Juniper 19 900 Chestnut St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6007412.87531 2120593.39917 37.8031635819044 -122.418552786177 (37.8031635819044, -122.418552786177)
38919 38919 201349 Undocumented 2 Juniperus chinensis :: Juniper 19 1 Bitting Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6012827.9931 2092586.2696 37.7265656062986 -122.39784774058998 (37.7265656062986, -122.39784774059)
42195 42195 129225 Undocumented 2 Juniperus chinensis :: Juniper 19 2711 Vallejo St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   6000598.01874 2117499.1088 37.794281463669705 -122.441913500121 (37.7942814636697, -122.441913500121)
56530 56530 129361 Undocumented 2 Juniperus chinensis :: Juniper 19 555 California St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6011684.8742 2116686.03693 37.7926744848808 -122.403494267154 (37.7926744848808, -122.403494267154)
59135 59135 129138 Undocumented 2 Juniperus chinensis :: Juniper 19 2500 Chestnut St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 2ft   5999775.77706 2119527.96815 37.7998052840549 -122.444904453696 (37.7998052840549, -122.444904453696)
75728 75728 129145 Undocumented 2 Juniperus chinensis :: Juniper 19 2399 North Point St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   5999381.832219999 2120449.61925 37.8023133997084 -122.446333981843 (37.8023133997084, -122.446333981843)
133508 133508 129212 Undocumented 2 Juniperus chinensis :: Juniper 19 11 Normandie Ter 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 3ft   6000913.33947 2117282.2310599997 37.793703937035104 -122.440806892437 (37.7937039370351, -122.440806892437)
134794 134794 219325 Undocumented 2 Juniperus chinensis :: Juniper 19 1090 Capitol Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 1ft   5995080.6810800005 2091195.9220900002 37.721743712182395 -122.459098491296 (37.7217437121824, -122.459098491296)
160504 160504 129242 Undocumented 2 Juniperus chinensis :: Juniper 19 2792 Fillmore St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 4ft   6002602.84311 2117758.5745599996 37.7951079262315 -122.434995153204 (37.7951079262315, -122.434995153204)
167952 167952 129302 Undocumented 2 Juniperus chinensis :: Juniper 19 1287 Filbert St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   6006805.0052 2119409.93751 37.7998798558394 -122.42057228308201 (37.7998798558394, -122.420572283082)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 558.822ms · Data source: data.sfgov.org