176 rows where qSpecies_id = 204 sorted by XCoord

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord ▼ YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
17160 254708 Permitted Site 7 Cupressus sempervirens :: Italian Cypress 204 2500X Market St 2 Median : Yard Tree Private 2       3x3                      
57069 117819 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 3936 Balboa St 2 Sidewalk: Curb side : Pot Tree Private 2     1 Width 1ft   5983305.90457 2111075.09338 37.7756424773924 -122.501269829965 (37.7756424773924, -122.501269829965) 11 6 2 55 26
112856 185276 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2601 Sunset Blvd 1 Sidewalk: Property side : Yard Tree Private 2     75 Width 0ft   5984954.4921 2097458.3645 37.7383513915158 -122.494562994936 (37.7383513915158, -122.494562994936) 1 8 3 29491 35
153190 207417 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 850 Quintara St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5990746.38049 2101133.08021 37.7487784984387 -122.47480582713 (37.7487784984387, -122.47480582713) 1 8 4 29491 12
100471 207414 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2 Lurline St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5992083.39749 2104933.95265 37.7592920911847 -122.4704592472 (37.7592920911847, -122.4704592472) 1 8 4 56 12
131104 207416 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 70 Marcela Ave 4 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5994652.30218 2100663.02331 37.7477134088455 -122.461265194639 (37.7477134088455, -122.461265194639) 1 8 4 29491 40
111990 207415 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 70 Marcela Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5994671.90889 2100681.03345 37.7477639885213 -122.461198701481 (37.7477639885213, -122.461198701481) 1 8 4 29491 40
70419 207421 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 7 Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5995137.11013 2096198.58173 37.735483049008 -122.459265520615 (37.735483049008, -122.459265520615) 9 7 4 59 40
83974 109404 Undocumented 4 Cupressus sempervirens :: Italian Cypress 204 355 CHRISTOPHER DR 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5995347.2 2103110.3 37.7544729812167 -122.459039464903 (37.7544729812167, -122.459039464903) 1 5 4 63 12
85820 26415 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 34 Maple St 12 Sidewalk: Property side : Cutout Tree DPW 1     3 10   5996568.2197254 2116061.2858977 37.7901031363132 -122.455752999345 (37.7901031363132, -122.455752999345) 11 6 1 54 31
99496 26413 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 34 Maple St 10 Sidewalk: Property side : Cutout Tree DPW 1     3 10   5996568.2197254 2116061.2858977 37.7901031363132 -122.455752999345 (37.7901031363132, -122.455752999345) 11 6 1 54 31
131267 26414 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 34 Maple St 11 Sidewalk: Property side : Cutout Tree DPW 1     3 10   5996568.2197254 2116061.2858977 37.7901031363132 -122.455752999345 (37.7901031363132, -122.455752999345) 11 6 1 54 31
98152 124237 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 285 Stanyan St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 1ft   5996676.38035 2110910.45447 37.7759665258119 -122.455006429336 (37.7759665258119, -122.455006429336) 11 6 2 54 16
145380 124238 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 285 Stanyan St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 1ft   5996678.45691 2110896.56425 37.7759285060276 -122.454998242108 (37.7759285060276, -122.454998242108) 11 6 2 54 16
188701 26380 Permitted Site 7 Cupressus sempervirens :: Italian Cypress 204 2621 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   5997625.2697268 2089162.8567299 37.7163073414789 -122.45015608882 (37.7163073414789, -122.45015608882) 9 8 6 28861 24
66673 251126 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 120 Saint Germain Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998052 2104136 37.7574444146042 -122.449759516473 (37.7574444146042, -122.449759516473) 15 5 4 28862 38
180491 251124 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 120 Saint Germain Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998052 2104136 37.7574444146042 -122.449759516473 (37.7574444146042, -122.449759516473) 15 5 4 28862 38
187832 251125 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 120 Saint Germain Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998052 2104136 37.7574444146042 -122.449759516473 (37.7574444146042, -122.449759516473) 15 5 4 28862 38
99962 207420 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 746 Foerster St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5998157.11941 2096037.86642 37.7352149287304 -122.448812683383 (37.7352149287304, -122.448812683383) 9 7 4 59 40
95545 207419 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 746 Foerster St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5998157.8565 2096043.41975 37.7352302190006 -122.448810534879 (37.7352302190006, -122.448810534879) 9 7 4 59 40
116997 207418 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 746 Foerster St 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5998157.99819 2096050.22322 37.7352489078083 -122.448810534898 (37.7352489078083, -122.448810534898) 9 7 4 59 40
1750 207422 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 140 Bella Vista Way 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5998335.54163 2097096.40434 37.7381316225622 -122.448272015461 (37.7381316225622, -122.448272015461) 9 7 4 59 40
69477 126432 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2750 Geary Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 1ft   5998549.737 2113237.17296 37.7824623826667 -122.448693647316 (37.7824623826667, -122.448693647316) 15 6 1 54 31
27970 126431 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2750 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 1ft   5998558.23476 2113238.75223 37.782467204845 -122.448664362682 (37.782467204845, -122.448664362682) 15 6 1 54 31
57919 126430 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2750 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 1ft   5998566.60506 2113239.86578 37.7824707409821 -122.448635485446 (37.7824707409821, -122.448635485446) 15 6 1 54 31
24029 66561 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2750 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/10/1991 12:00:00 AM 2   Permit Number 29749 5998574.90625 2113241.231 37.7824749641808 -122.448606865428 (37.7824749641808, -122.448606865428) 15 6 1 54 31
37871 176177 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 190 Foote Ave 10 Sidewalk: Property side : Yard Tree Private 2     3 Width 8ft   5998654.0159 2088359.71471 37.7141609137615 -122.446542507623 (37.7141609137615, -122.446542507623) 9 7 6 28861 25
112404 176176 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 190 Foote Ave 9 Sidewalk: Property side : Yard Tree Private 2     2 Width 8ft   5998664.09337 2088350.74464 37.7141368596079 -122.446507031185 (37.7141368596079, -122.446507031185) 9 7 6 28861 25
45865 176172 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 89 Ottawa Ave 1 Sidewalk: Curb side : Pot Tree Private 2     1 Width 2ft   5998934.49429 2088660.58419 37.7150030497132 -122.445594692335 (37.7150030497132, -122.445594692335) 9 7 6 28861 25
62182 176173 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 89 Ottawa Ave 2 Sidewalk: Curb side : Pot Tree Private 2     1 Width 2ft   5998945.18552 2088649.14892 37.7149722614393 -122.44555691723 (37.7149722614393, -122.44555691723) 9 7 6 28861 25
13780 176174 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 89 Ottawa Ave 3 Sidewalk: Curb side : Pot Tree Private 2     1 Width 2ft   5998957.51819 2088637.0202 37.7149396628061 -122.445513418834 (37.7149396628061, -122.445513418834) 9 7 6 28861 25
181120 176175 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 89 Ottawa Ave 4 Sidewalk: Curb side : Pot Tree Private 2     1 Width 2ft   5998972.72752 2088619.88467 37.7148934808181 -122.445459617764 (37.7148934808181, -122.445459617764) 9 7 6 28861 25
86885 126433 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2601 Francisco St 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 6ft   5999055.06177 2119708.37443 37.8002594731587 -122.447411378646 (37.8002594731587, -122.447411378646) 13 9 1 57 17
185762 223860 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 20 Deming St 3 Side Yard : Yard Tree Private 2     4 Width 3ft   5999452.08936 2105235.56335 37.7605435481615 -122.4449965101 (37.7605435481615, -122.4449965101) 15 5 5 28862 3
101211 223859 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 20 Deming St 2 Side Yard : Yard Tree Private 2     4 Width 3ft   5999452.72733 2105240.37235 37.7605567888939 -122.444994649378 (37.7605567888939, -122.444994649378) 15 5 5 28862 3
161166 223861 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 20 Deming St 4 Side Yard : Yard Tree Private 2     4 Width 3ft   5999453.3613 2105232.05426 37.760533985665 -122.44499185879 (37.760533985665, -122.44499185879) 15 5 5 28862 3
108922 105968 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2878 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2016 12:00:00 AM 3 5x6 Permit Number 772750 5999819.97417 2117444.58508 37.7940873899718 -122.444601693316 (37.7940873899718, -122.444601693316) 13 9 1 57 27
73024 105967 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2878 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2016 12:00:00 AM 3 4x6 Permit Number 772750 5999833.56214 2117445.14774 37.7940897102319 -122.44455471813 (37.7940897102319, -122.44455471813) 13 9 1 57 27
33430 126429 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2965 Broderick St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   5999956.74721 2118771.72266 37.7977391617965 -122.444223858445 (37.7977391617965, -122.444223858445) 13 9 1 57 17
183639 92230 Permitted Site 7 Cupressus sempervirens :: Italian Cypress 204 565 Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2009 12:00:00 AM   3x3 Permit Number 52673 6000270.5 2121584.5 37.8054801915973 -122.443340329465 (37.8054801915973, -122.443340329465) 13 9 1 57 17
188954 92231 Permitted Site 7 Cupressus sempervirens :: Italian Cypress 204 565 Marina Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2009 12:00:00 AM   3x3 Permit Number 52673 6000270.5 2121584.5 37.8054801915973 -122.443340329465 (37.8054801915973, -122.443340329465) 13 9 1 57 17
125941 223845 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 163 Corwin St 1 Back Yard : Yard Tree Private 2     5 Width 3ft   6000588.98082 2104313.3574 37.7580762176596 -122.440998371578 (37.7580762176596, -122.440998371578) 2 4 5 28862 38
191473 223846 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 163 Corwin St 2 Back Yard : Yard Tree Private 2     5 Width 3ft   6000593.0444 2104306.73656 37.7580582698975 -122.440983843043 (37.7580582698975, -122.440983843043) 2 4 5 28862 38
57333 223847 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 163 Corwin St 3 Back Yard : Yard Tree Private 2     5 Width 3ft   6000596.08551 2104301.4441 37.7580439113049 -122.440972945939 (37.7580439113049, -122.440972945939) 2 4 5 28862 38
64961 223848 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 163 Corwin St 4 Back Yard : Yard Tree Private 2     5 Width 3ft   6000598.61266 2104296.68505 37.758030988052 -122.440963864593 (37.758030988052, -122.440963864593) 2 4 5 28862 38
18539 223849 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 163 Corwin St 5 Back Yard : Yard Tree Private 2     5 Width 3ft   6000601.16124 2104292.97169 37.7580209372281 -122.440954784152 (37.7580209372281, -122.440954784152) 2 4 5 28862 38
13945 223850 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 163 Corwin St 6 Back Yard : Yard Tree Private 2     5 Width 3ft   6000602.6654 2104289.54137 37.7580116040773 -122.440949336057 (37.7580116040773, -122.440949336057) 2 4 5 28862 38
66994 126435 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 33 Normandie Ter 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   6000895.13879 2117418.20364 37.7940762455819 -122.440879626906 (37.7940762455819, -122.440879626906) 13 9 1 57 27
83166 126436 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 33 Normandie Ter 4 Sidewalk: Property side : Yard Tree Private 2     6 Width 3ft   6000899.16667 2117400.62389 37.7940282055903 -122.440864428369 (37.7940282055903, -122.440864428369) 13 9 1 57 27
171586 223839 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 1201 Douglass St 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6001375.46533 2100241.14483 37.7469396636504 -122.437986691344 (37.7469396636504, -122.437986691344) 2 4 5 63 22
189201 223838 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 1201 Douglass St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6001376.54401 2100236.11585 37.7469259166077 -122.437982601211 (37.7469259166077, -122.437982601211) 2 4 5 63 22
148528 223837 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 1201 Douglass St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6001376.71765 2100230.22226 37.7469097440832 -122.437981578698 (37.7469097440832, -122.437981578698) 2 4 5 63 22
159722 223858 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 4136 17th St 4 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6001426.52353 2105858.79179 37.762367271646 -122.438212505711 (37.762367271646, -122.438212505711) 15 5 5 28862 3
28817 223857 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 4136 17th St 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6001443.19254 2105860.10776 37.7623718330075 -122.438154948197 (37.7623718330075, -122.438154948197) 15 5 5 28862 3
166395 223856 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 4132 17th St 6 Sidewalk: Curb side : Pot Tree Private 2     1 Width 3ft   6001453.75395 2105861.01375 37.7623749212873 -122.438118485182 (37.7623749212873, -122.438118485182) 15 5 5 28862 3
127889 223855 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 4132 17th St 4 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6001465.57141 2105861.06048 37.7623757216707 -122.438077616409 (37.7623757216707, -122.438077616409) 15 5 5 28862 3
189478 223854 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 4132 17th St 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   6001479.36221 2105861.23339 37.7623769807219 -122.438029931638 (37.7623769807219, -122.438029931638) 15 5 5 28862 3
24750 94468 Property Tree 8 Cupressus sempervirens :: Italian Cypress 204 4128 17th St   Sidewalk: Property side : Pot Tree Private 2         in landscaped area 6001502 2105859 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108) 15 5 5 28862 3
71699 94469 Property Tree 8 Cupressus sempervirens :: Italian Cypress 204 4128 17th St   Sidewalk: Property side : Pot Tree Private 2         in landscaped area 6001502 2105859 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108) 15 5 5 28862 3
104809 94487 Property Tree 8 Cupressus sempervirens :: Italian Cypress 204 4128 17th St   Sidewalk: Property side : Pot Tree Private 2         in landscaped area 6001502 2105859 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108) 15 5 5 28862 3
134148 223853 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 90 Divisadero St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6001961.63263 2108146.90448 37.7686802875817 -122.436525544828 (37.7686802875817, -122.436525544828) 15 5 5 29492 3
80656 240935 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2500 Market St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 3ft Permit Number 781180 6001976.89611 2105831.81092 37.7623244756286 -122.43630704373 (37.7623244756286, -122.43630704373) 15 5 5 28862 3
31485 223842 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 3922 22nd St 3 Sidewalk: Curb side : Pot Tree Private 2     7 Width 4ft   6002306.42247 2102988.7945 37.7545369555235 -122.434964002506 (37.7545369555235, -122.434964002506) 2 4 5 28862 22
166252 126434 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 1425 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6002370.67136 2121569.77606 37.8055593011865 -122.436071357532 (37.8055593011865, -122.436071357532) 13 9 1 57 17
48758 112741 Undocumented 4 Cupressus sempervirens :: Italian Cypress 204 2514 CLAY ST 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6002696 2116178 37.7907733646004 -122.43455974658 (37.7907733646004, -122.43455974658) 13 9 1 29490 27
114770 223840 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2145 Castro St 3 Sidewalk: Curb side : Pot Tree Private 2     5 Width 10ft   6002711.92837 2099262.74028 37.7443291052999 -122.433295425556 (37.7443291052999, -122.433295425556) 2 7 5 63 22
67136 223844 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 198 Hancock St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003058.19031 2105071.09534 37.7602971123288 -122.432512916434 (37.7602971123288, -122.432512916434) 2 4 5 28862 3
80618 247145 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 500 27th St 15 Front Yard : Yard Tree Private 2     5     6003145.29919 2100074.31823 37.7465820851075 -122.431854859126 (37.7465820851075, -122.431854859126) 2 7 5 63 22
127634 247140 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 500 27th St 10 Front Yard : Yard Tree Private 2     4     6003166.93075 2100089.40149 37.7466247264498 -122.431781136306 (37.7466247264498, -122.431781136306) 2 7 5 63 22
23484 247139 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 500 27th St 9 Front Yard : Yard Tree Private 2     4     6003171.19627 2100066.51011 37.7465621138595 -122.43176475244 (37.7465621138595, -122.43176475244) 2 7 5 63 22
175849 247135 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 500 27th St 5 Front Yard : Yard Tree Private 2     6     6003187.16887 2100075.22315 37.7465869432374 -122.431710142923 (37.7465869432374, -122.431710142923) 2 7 5 63 22
136939 247001 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 401 Valley St 1 Side Yard : Yard Tree Private 2     5 Width 8ft   6003204.32988 2099186.4435 37.7441475339778 -122.431587360294 (37.7441475339778, -122.431587360294) 2 7 5 63 22
88296 223841 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 1548 Noe St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 2ft   6003280.5948 2099265.14761 37.7443679596294 -122.43132927013 (37.7443679596294, -122.43132927013) 2 7 5 63 22
89762 176178 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 445 Naples St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6003345.09348 2090989.4763 37.7216484973556 -122.43051586932 (37.7216484973556, -122.43051586932) 9 7 6 28861 5
4168 176179 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 445 Naples St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6003347.6645 2090993.45154 37.7216595581304 -122.430507265493 (37.7216595581304, -122.430507265493) 9 7 6 28861 5
79729 223852 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 3710 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003652.42128 2103638.06127 37.7563960214646 -122.430355505816 (37.7563960214646, -122.430355505816) 2 4 5 28862 3
93149 223851 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 310 Liberty St 32 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003941.73153 2103931.65904 37.7572185549154 -122.429375905766 (37.7572185549154, -122.429375905766) 2 4 5 28862 3
89432 251464 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 3440 16th St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6003947 2106622 37.7646058870383 -122.429549548663 (37.7646058870383, -122.429549548663) 8 4 5 28862 3
102616 251462 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 3440 16th St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6003947 2106622 37.7646058870383 -122.429549548663 (37.7646058870383, -122.429549548663) 8 4 5 28862 3
107839 251463 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 3440 16th St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6003947 2106622 37.7646058870383 -122.429549548663 (37.7646058870383, -122.429549548663) 8 4 5 28862 3
36848 121579 Undocumented 4 Cupressus sempervirens :: Italian Cypress 204 742X Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 1x1   6004940 2104032 37.7575505344573 -122.425930645849 (37.7575505344573, -122.425930645849) 2 4 5 28862 3
186601 223817 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 742 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 1ft   6004960.84188 2104040.81027 37.7575759032313 -122.425859193273 (37.7575759032313, -122.425859193273) 2 4 5 28862 3
136735 5743 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 1760 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     1 3X3   6005273.48821 2098170.50351 37.7414750573209 -122.424360413724 (37.7414750573209, -122.424360413724) 2 7 5 63 7
58833 223818 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 1760 Dolores St 2 : Tree Private 2     1 Width 2ft   6005274.68264 2098157.05024 37.7414381851378 -122.424355327149 (37.7414381851378, -122.424355327149) 2 7 5 63 7
127620 98316 Undocumented 4 Cupressus sempervirens :: Italian Cypress 204 1800X Clay St 1 Sidewalk: Property side : Cutout Tree Private 2       2x2   6006008.9 2116666.9 37.7923032687502 -122.423132026439 (37.7923032687502, -122.423132026439) 13 9 1 28858 27
167110 223829 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 100 Santa Marina St 4 Front Yard : Yard Tree Private 2     4     6006166.57618 2097475.41226 37.739616883506 -122.421223071201 (37.739616883506, -122.421223071201) 2 7 7 28859 2
31981 223830 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 100 Santa Marina St 5 Front Yard : Yard Tree Private 2     4     6006171.8374 2097486.11107 37.7396465566502 -122.421205639651 (37.7396465566502, -122.421205639651) 2 7 7 28859 2
158129 223831 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 100 Santa Marina St 6 Front Yard : Yard Tree Private 2     4     6006175.86532 2097493.16654 37.7396661564679 -122.421192213677 (37.7396661564679, -122.421192213677) 2 7 7 28859 2
177725 223832 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 100 Santa Marina St 7 Front Yard : Yard Tree Private 2     3     6006182.73872 2097507.89721 37.7397069910787 -122.421169494081 (37.7397069910787, -122.421169494081) 2 7 7 28859 2
111661 223828 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 100 Santa Marina St 3 Front Yard : Yard Tree Private 2     4     6006183.12873 2097474.29354 37.7396147449106 -122.421165760098 (37.7396147449106, -122.421165760098) 2 7 7 28859 2
7401 223827 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 100 Santa Marina St 2 Front Yard : Yard Tree Private 2     4     6006190.11427 2097485.70732 37.7396464784009 -122.421142417311 (37.7396464784009, -122.421142417311) 2 7 7 28859 2
22810 70611 Permitted Site 7 Cupressus sempervirens :: Italian Cypress 204 1355 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2013 12:00:00 AM     Permit Number 770302 6007018.06454335 2115342.51032554 37.7887237195829 -122.419546283037 (37.7887237195829, -122.419546283037) 13 9 10 28858 21
117555 32714 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 1105 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM 14   Permit Number 37110 6007282.5299 2115198.67905 37.7883436871578 -122.418621065405 (37.7883436871578, -122.418621065405) 13 9 10 28858 21
4322 176167 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 240 Hahn St 1 Sidewalk: Property side : Yard Tree DPW 1     9 Width 10ft   6007417.45559 2087310.83088 37.7117775673588 -122.416178356572 (37.7117775673588, -122.416178356572) 9 7 8 309 39
36582 223823 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 3101 17th St 1 : Tree Private 2     2 Width 1ft   6008008.73592 2106169.28223 37.7635919693097 -122.415468996495 (37.7635919693097, -122.415468996495) 8 4 7 28859 19
43177 223824 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 3101 17th St 2 : Tree Private 2     5 Width 1ft   6008016.50496 2106169.76352 37.7635937274947 -122.415442159828 (37.7635937274947, -122.415442159828) 8 4 7 28859 19
181762 223825 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 3101 17th St 3 : Tree Private 2     2 Width 1ft   6008027.95935 2106170.28892 37.7635958139266 -122.41540257978 (37.7635958139266, -122.41540257978) 8 4 7 28859 19
185681 223826 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 3101 17th St 4 : Tree Private 2     2 Width 1ft   6008033.82154 2106170.92846 37.7635978994403 -122.415382349527 (37.7635978994403, -122.415382349527) 8 4 7 28859 19
112773 223836 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2100 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 1ft   6008066.44955 2106150.296 37.7635430812786 -122.415268038516 (37.7635430812786, -122.415268038516) 8 4 7 28859 19
62930 223835 DPW Maintained 1 Cupressus sempervirens :: Italian Cypress 204 2100 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 1ft   6008066.57958 2106159.15106 37.7635674025314 -122.415268215666 (37.7635674025314, -122.415268215666) 8 4 7 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);