trees
394 rows where qCaretaker_id = 2 and qSpecies_id = 123 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
55570 | 100314 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1683 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015409.74359 | 2097962.08476 | 37.7414699491892 | -122.389297877816 | (37.7414699491892, -122.389297877816) | 10 | 3 | 8 | 58 | 1 | |||
186419 | 100315 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1683 Galvez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6015443.91077 | 2097940.33755 | 37.7414121299803 | -122.389178220304 | (37.7414121299803, -122.389178220304) | 10 | 3 | 8 | 58 | 1 | |||
40738 | 100424 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
60226 | 100425 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
77304 | 101627 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
104346 | 101628 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
193442 | 101629 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
93279 | 101630 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | |
46025 | 101631 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
23399 | 101632 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
132977 | 101633 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
86262 | 101634 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
142722 | 111741 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 498x 11th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5992530.71883 | 2112167.74428 | 37.7791800053719 | -122.469438767189 | (37.7791800053719, -122.469438767189) | 11 | 6 | 2 | 54 | 11 | |||
104412 | 119966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 524 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5987215.94672 | 2112352.18936 | 37.7793778617147 | -122.487838060827 | (37.7793778617147, -122.487838060827) | 11 | 6 | 2 | 55 | 26 | |||
110974 | 120834 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2033 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989271.19606 | 2110543.25177 | 37.7745306911578 | -122.480595714565 | (37.7745306911578, -122.480595714565) | 11 | 6 | 2 | 55 | 26 | |||
157100 | 122016 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1633 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5990486.56458 | 2110588.66917 | 37.7747259547528 | -122.476394881461 | (37.7747259547528, -122.476394881461) | 11 | 6 | 2 | 55 | 26 | |||
191980 | 123105 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 498 11th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992529.16869 | 2112181.64232 | 37.7792180760249 | -122.469445141648 | (37.7792180760249, -122.469445141648) | 11 | 6 | 2 | 54 | 11 | |||
130878 | 123179 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 771 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992862.96444 | 2110216.56004 | 37.7738417753505 | -122.468147428182 | (37.7738417753505, -122.468147428182) | 11 | 6 | 2 | 54 | 11 | |||
64123 | 123208 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993131.19371 | 2112699.04699 | 37.7806735020779 | -122.467400140372 | (37.7806735020779, -122.467400140372) | 11 | 6 | 2 | 54 | 11 | |||
76553 | 123210 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993133.98431 | 2112655.94122 | 37.7805553064396 | -122.467387351051 | (37.7805553064396, -122.467387351051) | 11 | 6 | 2 | 54 | 11 | |||
116652 | 123211 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993134.492 | 2112639.50466 | 37.7805102054167 | -122.467384399185 | (37.7805102054167, -122.467384399185) | 11 | 6 | 2 | 54 | 11 | |||
116896 | 124090 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 601 Funston Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5991893.39709 | 2111137.10441 | 37.7763132974782 | -122.471568380763 | (37.7763132974782, -122.471568380763) | 11 | 6 | 2 | 54 | 11 | ||||
180939 | 136175 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3103 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001391.85411 | 2119087.81282 | 37.7986888314695 | -122.439280672761 | (37.7986888314695, -122.439280672761) | 13 | 9 | 1 | 57 | 17 | |||
20202 | 136176 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2134 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002833.9768 | 2118210.69092 | 37.7963624418193 | -122.434227733841 | (37.7963624418193, -122.434227733841) | 13 | 9 | 1 | 57 | 17 | |||
94223 | 136177 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2028 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003216.31619 | 2118958.46656 | 37.7984373333682 | -122.432958210354 | (37.7984373333682, -122.432958210354) | 13 | 9 | 1 | 57 | 17 | |||
106021 | 136178 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2400 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6001367.93231 | 2119047.53981 | 37.798576891075 | -122.439360561339 | (37.798576891075, -122.439360561339) | 13 | 9 | 1 | 57 | 17 | |||
148213 | 136179 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2400 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001333.81043 | 2119043.17386 | 37.7985629614603 | -122.439478320365 | (37.7985629614603, -122.439478320365) | 13 | 9 | 1 | 57 | 17 | |||
55713 | 136180 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3134 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999407.16472 | 2119635.33058 | 37.8000790286731 | -122.446187711617 | (37.8000790286731, -122.446187711617) | 13 | 9 | 1 | 57 | 17 | |||
146439 | 136181 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3140 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999405.90686 | 2119644.67772 | 37.8001046215781 | -122.446192737013 | (37.8001046215781, -122.446192737013) | 13 | 9 | 1 | 57 | 17 | |||
56230 | 136182 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3140 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999403.04173 | 2119664.02877 | 37.8001575907471 | -122.446204044176 | (37.8001575907471, -122.446204044176) | 13 | 9 | 1 | 57 | 17 | |||
46530 | 136183 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006523.02231 | 2120459.93681 | 37.8027469916359 | -122.421622667864 | (37.8027469916359, -122.421622667864) | 5 | 9 | 1 | 28858 | 32 | |||
71899 | 136184 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006503.30451 | 2120455.88239 | 37.8027347473741 | -122.421690613452 | (37.8027347473741, -122.421690613452) | 5 | 9 | 1 | 28858 | 32 | |||
92775 | 136185 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010045.72464 | 2116634.21167 | 37.7924404929984 | -122.409162155311 | (37.7924404929984, -122.409162155311) | 3 | 1 | 10 | 28857 | 4 | |||
39352 | 136186 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010043.14101 | 2116645.97985 | 37.7924726608324 | -122.40917192557 | (37.7924726608324, -122.40917192557) | 3 | 1 | 10 | 28857 | 4 | |||
26140 | 136187 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 840 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010038.55828 | 2116686.60963 | 37.7925839636381 | -122.409190650353 | (37.7925839636381, -122.409190650353) | 3 | 1 | 10 | 28857 | 4 | |||
118233 | 179275 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 716 Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005245.16074 | 2092477.21394 | 37.7258409541933 | -122.424053582122 | (37.7258409541933, -122.424053582122) | 9 | 7 | 6 | 309 | 5 | |||
178993 | 179276 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 716 Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6005258.78381 | 2092467.95462 | 37.7258162992748 | -122.424005829932 | (37.7258162992748, -122.424005829932) | 9 | 7 | 6 | 309 | 5 | |||
193441 | 179277 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 716 Peru Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005276.23831 | 2092458.42558 | 37.7257911200544 | -122.423944813618 | (37.7257911200544, -122.423944813618) | 9 | 7 | 6 | 309 | 5 | |||
86529 | 179278 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 223 Pioche St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006228.66725 | 2093396.90262 | 37.7284216981869 | -122.420718924746 | (37.7284216981869, -122.420718924746) | 9 | 7 | 7 | 309 | 5 | |||
170652 | 179279 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 223 Pioche St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006275.12702 | 2093408.77207 | 37.7284569075468 | -122.420559152977 | (37.7284569075468, -122.420559152977) | 9 | 7 | 7 | 309 | 5 | |||
16220 | 179280 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 16 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010456.33755 | 2094955.50587 | 37.7329386663832 | -122.406213356571 | (37.7329386663832, -122.406213356571) | 10 | 3 | 7 | 309 | 28 | |||
193922 | 179281 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 16 Hale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010435.48171 | 2094947.68687 | 37.7329160304499 | -122.406284910247 | (37.7329160304499, -122.406284910247) | 10 | 3 | 7 | 309 | 28 | |||
9715 | 196963 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015947.26389 | 2105849.11258 | 37.7631558583726 | -122.387989539601 | (37.7631558583726, -122.387989539601) | 14 | 3 | 8 | 28856 | 29 | |||
58715 | 196964 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015932.05228 | 2105848.00164 | 37.7631519652185 | -122.3880420744 | (37.7631519652185, -122.3880420744) | 14 | 3 | 8 | 28856 | 29 | |||
147564 | 196965 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015917.99613 | 2105847.416 | 37.763149578419 | -122.38809064947 | (37.763149578419, -122.38809064947) | 14 | 3 | 8 | 28856 | 29 | |||
117320 | 196966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015902.35048 | 2105846.23751 | 37.7631454756938 | -122.388144680757 | (37.7631454756938, -122.388144680757) | 14 | 3 | 8 | 28856 | 29 | |||
139206 | 196967 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015888.58147 | 2105846.04273 | 37.7631441779792 | -122.388192289968 | (37.7631441779792, -122.388192289968) | 14 | 3 | 8 | 28856 | 29 | |||
106594 | 196968 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015876.45874 | 2105845.10564 | 37.7631409332394 | -122.388234153389 | (37.7631409332394, -122.388234153389) | 14 | 3 | 8 | 28856 | 29 | |||
7828 | 196969 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015866.24342 | 2105844.60301 | 37.763138987107 | -122.388269449981 | (37.763138987107, -122.388269449981) | 14 | 3 | 8 | 28856 | 29 | |||
55110 | 196970 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015850.66313 | 2105843.80284 | 37.7631359267068 | -122.388323281596 | (37.7631359267068, -122.388323281596) | 14 | 3 | 8 | 28856 | 29 | |||
113139 | 196971 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015840.83077 | 2105843.69764 | 37.7631350930254 | -122.388357281382 | (37.7631350930254, -122.388357281382) | 14 | 3 | 8 | 28856 | 29 | |||
53461 | 196972 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6014458.90845 | 2102627.41024 | 37.7542271903342 | -122.392911888877 | (37.7542271903342, -122.392911888877) | 10 | 3 | 8 | 28856 | 29 | |||
4053 | 196973 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2019 12:00:00 AM | 3 | Width 4ft | 6014457.83967 | 2102608.37301 | 37.7541748588033 | -122.392914253189 | (37.7541748588033, -122.392914253189) | 10 | 3 | 8 | 28856 | 29 | ||
108931 | 196974 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 223 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6014047.89224 | 2106015.09524 | 37.7635062000657 | -122.394570502234 | (37.7635062000657, -122.394570502234) | 14 | 3 | 8 | 28856 | 29 | |||
112009 | 196975 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 209 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014043.29115 | 2106063.32562 | 37.7636383743244 | -122.394589793611 | (37.7636383743244, -122.394589793611) | 14 | 3 | 8 | 28856 | 29 | |||
170905 | 196976 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 209 Mississippi St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014043.63491 | 2106091.78418 | 37.7637165344031 | -122.39459059759 | (37.7637165344031, -122.39459059759) | 14 | 3 | 8 | 28856 | 29 | |||
20176 | 196977 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 209 Mississippi St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014040.95878 | 2106120.30389 | 37.7637946944947 | -122.394601850808 | (37.7637946944947, -122.394601850808) | 14 | 3 | 8 | 28856 | 29 | |||
160886 | 196978 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1551 20th St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6013296.03231 | 2104723.49575 | 37.7599179239891 | -122.397080394946 | (37.7599179239891, -122.397080394946) | 10 | 3 | 8 | 28856 | 29 | |||
125452 | 196979 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1551 20th St | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.397014079838 | (37.7599198521353, -122.397014079838) | 10 | 3 | 8 | 28856 | 29 | |||
149240 | 196980 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 320 Missouri St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6013452.78538 | 2105563.26016 | 37.7622324578928 | -122.396597126255 | (37.7622324578928, -122.396597126255) | 10 | 3 | 8 | 28856 | 29 | |||
83333 | 196981 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2460 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009761.09751 | 2107855.1809 | 37.7683194004524 | -122.409527097504 | (37.7683194004524, -122.409527097504) | 8 | 4 | 8 | 28853 | 19 | |||
176314 | 196982 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
4592 | 196983 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
146245 | 196984 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
170158 | 196985 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
168607 | 196986 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
111720 | 196987 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
62748 | 196988 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6011818.89895 | 2100809.64818 | 37.7490890172439 | -122.401913980245 | (37.7490890172439, -122.401913980245) | 10 | 3 | 8 | 58 | 1 | |||
141990 | 196989 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6011818.89895 | 2100809.64818 | 37.7490890172439 | -122.401913980245 | (37.7490890172439, -122.401913980245) | 10 | 3 | 8 | 58 | 1 | |||
88076 | 196990 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6014143.12746 | 2100151.41021 | 37.7474110756645 | -122.393830644379 | (37.7474110756645, -122.393830644379) | 10 | 3 | 8 | 58 | 1 | |||
92182 | 196991 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6014086.84637 | 2100149.18925 | 37.7474018495283 | -122.394025106589 | (37.7474018495283, -122.394025106589) | 10 | 3 | 8 | 58 | 1 | |||
193907 | 196992 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 5 | : | Tree | Private 2 | 7 | Width 4ft | 6013942.24849 | 2100140.56785 | 37.7473701394162 | -122.394524516312 | (37.7473701394162, -122.394524516312) | 10 | 3 | 8 | 58 | 1 | |||
70671 | 196993 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 6 | : | Tree | Private 2 | 7 | Width 4ft | 6013912.09606 | 2100139.02388 | 37.7473642236913 | -122.394628673985 | (37.7473642236913, -122.394628673985) | 10 | 3 | 8 | 58 | 1 | |||
11064 | 196994 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 7 | : | Tree | Private 2 | 7 | Width 4ft | 6013884.28274 | 2100137.93009 | 37.7473596740254 | -122.394724774624 | (37.7473596740254, -122.394724774624) | 10 | 3 | 8 | 58 | 1 | |||
124135 | 196995 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 8 | : | Tree | Private 2 | 8 | Width 4ft | 6013853.97089 | 2100136.72086 | 37.7473546683845 | -122.394829506973 | (37.7473546683845, -122.394829506973) | 10 | 3 | 8 | 58 | 1 | |||
184445 | 196996 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 10 | : | Tree | Private 2 | 8 | Width 4ft | 6013793.66265 | 2100133.46781 | 37.7473423827584 | -122.395037822335 | (37.7473423827584, -122.395037822335) | 10 | 3 | 8 | 58 | 1 | |||
20599 | 196997 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 11 | : | Tree | Private 2 | 7 | Width 4ft | 6013762.67186 | 2100131.60985 | 37.7473355578075 | -122.395144856947 | (37.7473355578075, -122.395144856947) | 10 | 3 | 8 | 58 | 1 | |||
148421 | 196998 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 13 | : | Tree | Private 2 | 5 | Width 4ft | 6013702.50003 | 2100126.86267 | 37.7473191766464 | -122.395352595851 | (37.7473191766464, -122.395352595851) | 10 | 3 | 8 | 58 | 1 | |||
97589 | 196999 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 14 | : | Tree | Private 2 | 4 | Width 4ft | 6013629.21679 | 2100123.8728 | 37.7473068910098 | -122.395605796394 | (37.7473068910098, -122.395605796394) | 10 | 3 | 8 | 58 | 1 | |||
121622 | 197000 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 15 | : | Tree | Private 2 | 6 | Width 4ft | 6013614.06576 | 2100123.51682 | 37.7473050707808 | -122.395658162994 | (37.7473050707808, -122.395658162994) | 10 | 3 | 8 | 58 | 1 | |||
5120 | 197001 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 16 | : | Tree | Private 2 | 9 | Width 4ft | 6013598.90827 | 2100122.82985 | 37.7473023413409 | -122.395710528743 | (37.7473023413409, -122.395710528743) | 10 | 3 | 8 | 58 | 1 | |||
22157 | 197002 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2251 Silver Ave | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6012830.37736 | 2096288.90355 | 37.7367324078692 | -122.398099143384 | (37.7367324078692, -122.398099143384) | 10 | 3 | 8 | 58 | 1 | |||
184093 | 197003 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6015964.6605 | 2113962.87673 | 37.7854354289412 | -122.38849574371 | (37.7854354289412, -122.38849574371) | 6 | 2 | 9 | 28856 | 6 | |||
135225 | 197004 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6015943.64363 | 2113959.00175 | 37.7854236244348 | -122.388568185881 | (37.7854236244348, -122.388568185881) | 6 | 2 | 9 | 28856 | 6 | |||
58857 | 197005 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6015945.83282 | 2113971.21012 | 37.7854572671771 | -122.388561464349 | (37.7854572671771, -122.388561464349) | 6 | 2 | 9 | 28856 | 6 | |||
149145 | 197006 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6015876.10983 | 2114035.38454 | 37.7856296114719 | -122.388807169036 | (37.7856296114719, -122.388807169036) | 6 | 2 | 9 | 28856 | 6 | |||
87499 | 197007 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6015822.85417 | 2114091.9182 | 37.7857818882589 | -122.388995368366 | (37.7857818882589, -122.388995368366) | 6 | 2 | 9 | 28856 | 6 | |||
74677 | 197008 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015819.96471 | 2114109.17282 | 37.7858291053701 | -122.389006570307 | (37.7858291053701, -122.389006570307) | 6 | 2 | 9 | 28856 | 6 | |||
9813 | 201661 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 149 Dore St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6009207.44548 | 2109499.94346 | 37.7728044975557 | -122.411558355748 | (37.7728044975557, -122.411558355748) | 8 | 2 | 9 | 28853 | 34 | |||
152731 | 213852 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1386 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991160.08427 | 2105986.1579 | 37.7621277372307 | -122.473729238831 | (37.7621277372307, -122.473729238831) | 1 | 8 | 11 | 56 | 12 | |||
48378 | 213853 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 339 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996569.29854 | 2106950.59972 | 37.7650876471008 | -122.455090641935 | (37.7650876471008, -122.455090641935) | 15 | 5 | 11 | 29492 | 12 | |||
121788 | 213854 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 494 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5998170.4747 | 2095280.37565 | 37.7331358031646 | -122.448711968308 | (37.7331358031646, -122.448711968308) | 9 | 7 | 4 | 59 | 40 | ||||
10563 | 220139 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
13557 | 220140 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 7ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
90252 | 22222 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4301 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768640 | 6015412.92695 | 2096851.83844 | 37.7384216168093 | -122.389209364399 | (37.7384216168093, -122.389209364399) | 10 | 3 | 8 | 58 | 1 | |
136365 | 22239 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4445 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1995 12:00:00 AM | 3 | 3X3 | 6015309.22014 | 2096468.43632 | 37.7373631231169 | -122.389541166269 | (37.7373631231169, -122.389541166269) | 10 | 3 | 8 | 58 | 1 | ||
111608 | 22240 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4445 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2010 12:00:00 AM | 3 | 3X3 | 6015309.22014 | 2096468.43632 | 37.7373631231169 | -122.389541166269 | (37.7373631231169, -122.389541166269) | 10 | 3 | 8 | 58 | 1 | ||
148723 | 22242 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4430 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1995 12:00:00 AM | 6 | 3x3 | 6015163.3661 | 2096572.43152 | 37.7376405844607 | -122.390052718455 | (37.7376405844607, -122.390052718455) | 10 | 3 | 8 | 58 | 1 | ||
191217 | 22252 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4544 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1993 12:00:00 AM | 6 | 3x3 | 6015060.7997 | 2096239.5516 | 37.7367208751663 | -122.390384090827 | (37.7367208751663, -122.390384090827) | 10 | 3 | 8 | 58 | 1 | ||
64306 | 22261 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 |
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) );