trees
176 rows where qSpecies_id = 204 sorted by Supervisor Districts
This data as json, CSV (advanced)
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 | ||||||||||||||
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 | |
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | ||||
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 | |||
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 | |||
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 | ||
20051 | 142994 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 39 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008184.8344 | 2120832.3766 | 37.8038631828496 | -122.415898325017 | (37.8038631828496, -122.415898325017) | 5 | 1 | 10 | 308 | 32 | |||
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 | |||
56387 | 142995 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 29 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008216.7367 | 2120837.5372 | 37.8038791460389 | -122.415788290484 | (37.8038791460389, -122.415788290484) | 5 | 1 | 10 | 308 | 32 | |||
99486 | 142996 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 19 Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008239.0804 | 2120841.4658 | 37.8038911890406 | -122.415711246845 | (37.8038911890406, -122.415711246845) | 5 | 1 | 10 | 308 | 32 | |||
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 | |
145805 | 142997 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 9 Houston St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008266.826 | 2120846.8676 | 37.8039075806775 | -122.415615613882 | (37.8039075806775, -122.415615613882) | 5 | 1 | 10 | 308 | 32 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||||
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 | |||
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 | ||||
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 | |
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
102449 | 223834 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 2100 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 6008066.72851 | 2106165.04225 | 37.7635835867453 | -122.415268117623 | (37.7635835867453, -122.415268117623) | 8 | 4 | 7 | 28859 | 19 | |||
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 | ||||
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 | |||
123824 | 223843 | DPW Maintained 1 | Cupressus sempervirens :: Italian Cypress 204 | 1336 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009254.1321 | 2101336.70744 | 37.7503927320375 | -122.410820223693 | (37.7503927320375, -122.410820223693) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );