trees
203 rows where Supervisor Districts = 10 and qSpecies_id = 53 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108315 | 251688 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 925 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008132 | 2115128 | 37.788197407905 | -122.415677021756 | (37.788197407905, -122.415677021756) | 13 | 1 | 10 | 28858 | 21 | ||||
39669 | 95554 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1333@ Larkin Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007121 | 2115358 | 37.7887720478953 | -122.419191239667 | (37.7887720478953, -122.419191239667) | 13 | 9 | 10 | 28858 | 21 | |||||
147353 | 52716 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1330on LARKIN Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2006 12:00:00 AM | Permit Number 48769 | 6007121.03491046 | 2115409.40396286 | 37.7889131924877 | -122.419194766666 | (37.7889131924877, -122.419194766666) | 13 | 9 | 10 | 28858 | 21 | |||
190125 | 52718 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1330on LARKIN Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2006 12:00:00 AM | Permit Number 48769 | 6007121.03491046 | 2115409.40396286 | 37.7889131924877 | -122.419194766666 | (37.7889131924877, -122.419194766666) | 13 | 9 | 10 | 28858 | 21 | |||
159895 | 113553 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3x3 | 6009263 | 2115423 | 37.7890709188275 | -122.411784791395 | (37.7890709188275, -122.411784791395) | 5 | 1 | 10 | 28857 | 21 | |||
146277 | 18498 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 501 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6010152.17541 | 2115498.44033 | 37.7893279015823 | -122.408713669265 | (37.7893279015823, -122.408713669265) | 5 | 1 | 10 | 28857 | 21 | |||
52775 | 18497 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 501 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6010150.58942 | 2115513.37022 | 37.7893688066449 | -122.408720210327 | (37.7893688066449, -122.408720210327) | 5 | 1 | 10 | 28857 | 21 | |||
48551 | 18500 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 519X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6010154.14929 | 2115557.66128 | 37.7894906186413 | -122.408711019419 | (37.7894906186413, -122.408711019419) | 5 | 1 | 10 | 28857 | 21 | |||
178040 | 120998 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 370 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010792 | 2115565 | 37.789546473623 | -122.406504631878 | (37.789546473623, -122.406504631878) | 5 | 1 | 10 | 28857 | 6 | ||||
83480 | 120997 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 360 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010836 | 2115566 | 37.7895516808253 | -122.406352466288 | (37.7895516808253, -122.406352466288) | 5 | 1 | 10 | 28857 | 6 | ||||
105476 | 120996 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 352 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x5 | 6010871.2 | 2115571.1 | 37.789567653219 | -122.406231036885 | (37.789567653219, -122.406231036885) | 5 | 1 | 10 | 28857 | 6 | ||||
95573 | 106226 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 350 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 22 | 3x5 | 6010879 | 2115572 | 37.7895705607022 | -122.406204113006 | (37.7895705607022, -122.406204113006) | 5 | 1 | 10 | 28857 | 6 | |||
143936 | 106224 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 340 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 24 | 3x5 | 6010923.2 | 2115578.3 | 37.7895903312377 | -122.406051628897 | (37.7895903312377, -122.406051628897) | 5 | 1 | 10 | 28857 | 6 | |||
159297 | 106225 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 340 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 22 | 3x5 | 6010923.2 | 2115578.3 | 37.7895903312377 | -122.406051628897 | (37.7895903312377, -122.406051628897) | 5 | 1 | 10 | 28857 | 6 | |||
35016 | 120999 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 390 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010815 | 2115725 | 37.7899870820688 | -122.406436332672 | (37.7899870820688, -122.406436332672) | 5 | 1 | 10 | 28857 | 6 | ||||
188867 | 121000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 390 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010815 | 2115725 | 37.7899870820688 | -122.406436332672 | (37.7899870820688, -122.406436332672) | 5 | 1 | 10 | 28857 | 6 | ||||
159917 | 122820 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 776 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009771.51732552 | 2115777.23613944 | 37.7900720800575 | -122.410050397484 | (37.7900720800575, -122.410050397484) | 5 | 1 | 10 | 28857 | 21 | ||||
142924 | 18508 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
151930 | 18509 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
166051 | 18510 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
47816 | 107839 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1000x LEAVENWORTH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008256 | 2115925 | 37.790392745036 | -122.415304443955 | (37.790392745036, -122.415304443955) | 5 | 1 | 10 | 28858 | 21 | ||||
143675 | 107836 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1000x LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008256 | 2115925 | 37.790392745036 | -122.415304443955 | (37.790392745036, -122.415304443955) | 5 | 1 | 10 | 28858 | 21 | |||
54854 | 18511 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 626 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6010143.9604039 | 2115933.8512359 | 37.7905229751065 | -122.408772822924 | (37.7905229751065, -122.408772822924) | 5 | 1 | 10 | 28857 | 21 | |||
13581 | 113413 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 16X LEROY PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 1x1 | 6008359 | 2116497 | 37.7919691052865 | -122.414988572568 | (37.7919691052865, -122.414988572568) | 5 | 1 | 10 | 28858 | 21 | |||
20147 | 103506 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1348 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
9205 | 96542 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767720 | 6013094 | 2116579 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | 4 | 1 | 10 | 28860 | 6 | ||||
118656 | 96541 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767720 | 6013094 | 2116579 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | 4 | 1 | 10 | 28860 | 6 | ||||
102458 | 99269 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1327 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008010 | 2116967 | 37.7932399920042 | -122.416229420814 | (37.7932399920042, -122.416229420814) | 5 | 1 | 10 | 28858 | 32 | ||||
28662 | 99265 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | |||||
41004 | 99266 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | ||||
131827 | 99267 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | ||||
176501 | 104744 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 15 WAVERLY PL | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010745.5 | 2116998.1 | 37.7934788206973 | -122.406766557506 | (37.7934788206973, -122.406766557506) | 3 | 1 | 10 | 28857 | 4 | ||||
175319 | 11028 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1449 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007474.68946 | 2117365.61582 | 37.7943043774737 | -122.418109907661 | (37.7943043774737, -122.418109907661) | 5 | 1 | 10 | 28858 | 32 | |||
109285 | 11031 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1469 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6007466.43149 | 2117407.25122 | 37.7944182331434 | -122.418141434433 | (37.7944182331434, -122.418141434433) | 5 | 1 | 10 | 28858 | 32 | |||
21080 | 11033 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1503 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007448.9758793 | 2117473.8836265 | 37.7946002066648 | -122.418206559463 | (37.7946002066648, -122.418206559463) | 5 | 1 | 10 | 28858 | 32 | |||
157130 | 11034 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1509 HYDE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6007406.1 | 2117518.3 | 37.7947197495209 | -122.418358066687 | (37.7947197495209, -122.418358066687) | 5 | 1 | 10 | 28858 | 32 | |||
27435 | 11036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1521 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007446.95336 | 2117561.22726 | 37.79483991673 | -122.41821975317 | (37.79483991673, -122.41821975317) | 5 | 1 | 10 | 28858 | 32 | |||
2280 | 116028 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1500 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006937 | 2117734 | 37.7952855901943 | -122.419996533467 | (37.7952855901943, -122.419996533467) | 13 | 9 | 10 | 28858 | 32 | ||||
186252 | 116029 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1500 PACIFIC AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006937 | 2117734 | 37.7952855901943 | -122.419996533467 | (37.7952855901943, -122.419996533467) | 13 | 9 | 10 | 28858 | 32 | ||||
52589 | 11046 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1560 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007462.42749 | 2117742.73439 | 37.7953391611566 | -122.418179084924 | (37.7953391611566, -122.418179084924) | 5 | 1 | 10 | 28858 | 32 | |||
96257 | 4573 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 75 | 4 | 6011767.886 | 2117749.45401 | 37.7955990100454 | -122.403281883117 | (37.7955990100454, -122.403281883117) | 3 | 1 | 10 | 28860 | 4 | |||
132857 | 11053 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1603 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007388.39144 | 2117874.05515 | 37.795695567741 | -122.418444578472 | (37.795695567741, -122.418444578472) | 5 | 1 | 10 | 28858 | 32 | |||
28305 | 121625 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 101x Trenton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010049 | 2117862 | 37.7958118850813 | -122.409237502382 | (37.7958118850813, -122.409237502382) | 3 | 1 | 10 | 308 | 4 | ||||
154699 | 121624 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 101x Trenton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010049 | 2117862 | 37.7958118850813 | -122.409237502382 | (37.7958118850813, -122.409237502382) | 3 | 1 | 10 | 308 | 4 | ||||
57914 | 106105 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 744x MONTGOMERY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011751.6 | 2117873.5 | 37.7959387009634 | -122.403346966666 | (37.7959387009634, -122.403346966666) | 3 | 1 | 10 | 28860 | 4 | |||||
25882 | 40606 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 744 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48110 | 6011762.49765618 | 2117875.03517526 | 37.7959435248288 | -122.403309366526 | (37.7959435248288, -122.403309366526) | 3 | 1 | 10 | 28860 | 4 | |||
46917 | 122714 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 855x Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011188 | 2117923 | 37.7960431220576 | -122.40530062832 | (37.7960431220576, -122.40530062832) | 3 | 1 | 10 | 28857 | 4 | ||||
80346 | 122712 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 855x Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011188 | 2117923 | 37.7960431220576 | -122.40530062832 | (37.7960431220576, -122.40530062832) | 3 | 1 | 10 | 28857 | 4 | ||||
186331 | 122713 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 855x Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011188 | 2117923 | 37.7960431220576 | -122.40530062832 | (37.7960431220576, -122.40530062832) | 3 | 1 | 10 | 28857 | 4 | ||||
82985 | 51836 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
107778 | 51837 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
131150 | 51835 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
72817 | 121043 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2125 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118096 | 37.7962471953974 | -122.422008397548 | (37.7962471953974, -122.422008397548) | 13 | 9 | 10 | 28858 | 32 | ||||
46032 | 121039 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2101 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
25834 | 93215 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 499 Jackson St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53209 | 6011715 | 2118034 | 37.7963773511427 | -122.403484907832 | (37.7963773511427, -122.403484907832) | 3 | 1 | 10 | 28860 | 4 | |||
55005 | 112827 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
139551 | 112828 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
148636 | 112826 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
186524 | 112825 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
43430 | 112751 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
99464 | 112750 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
55775 | 44125 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 431 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43629 | 6012046.82946857 | 2118068.4414971 | 37.796490448112 | -122.402339123693 | (37.796490448112, -122.402339123693) | 3 | 1 | 10 | 28860 | 4 | ||||
191709 | 52838 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 795on Trenton Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48857 | 6010309.20673902 | 2118158.51574656 | 37.7966406195852 | -122.408358059553 | (37.7966406195852, -122.408358059553) | 3 | 1 | 10 | 308 | 4 | ||||
79809 | 4593 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6011460.12974 | 2118136.30046 | 37.7966440043551 | -122.404374021953 | (37.7966440043551, -122.404374021953) | 3 | 1 | 10 | 308 | 4 | |||
44901 | 4596 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
47614 | 4599 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
150611 | 4595 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
160977 | 4597 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 170 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6011285.22621 | 2118219.63855 | 37.7968630551885 | -122.404985101368 | (37.7968630551885, -122.404985101368) | 3 | 1 | 10 | 308 | 4 | |||
78831 | 99639 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2201 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006359 | 2118331 | 37.7968922206311 | -122.422038941111 | (37.7968922206311, -122.422038941111) | 13 | 9 | 10 | 28858 | 32 | ||||
153320 | 99638 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2201 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6006359 | 2118331 | 37.7968922206311 | -122.422038941111 | (37.7968922206311, -122.422038941111) | 13 | 9 | 10 | 28858 | 32 | |||
110473 | 49870 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 607@ JACKSON Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2003 12:00:00 AM | Permit Number 46636 | 6012838.36008757 | 2118235.08187981 | 37.7969921557212 | -122.399611944085 | (37.7969921557212, -122.399611944085) | 3 | 1 | 10 | 28860 | 6 | |||
191099 | 100527 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1728 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4.5x6 | 6008341 | 2118363 | 37.7970916696404 | -122.415182998934 | (37.7970916696404, -122.415182998934) | 5 | 1 | 10 | 308 | 21 | ||||
31247 | 106090 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 615 Front St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012797.6 | 2118350.4 | 37.7973065196251 | -122.399761086072 | (37.7973065196251, -122.399761086072) | 3 | 1 | 10 | 28860 | 6 | |||||
99484 | 116156 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 755 SANSOME ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012110 | 2118369 | 37.7973192357085 | -122.402141679915 | (37.7973192357085, -122.402141679915) | 3 | 1 | 10 | 308 | 4 | ||||
28626 | 100399 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 4x4 | 6011664 | 2118384 | 37.7973355180624 | -122.403686018548 | (37.7973355180624, -122.403686018548) | 3 | 1 | 10 | 308 | 23 | ||
138724 | 19491 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10X Saroyan Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010944.42859 | 2118456.69114 | 37.7974948878134 | -122.406181056735 | (37.7974948878134, -122.406181056735) | 3 | 1 | 10 | 308 | 4 | |||
162852 | 19490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10X Saroyan Pl | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010944.42859 | 2118456.69114 | 37.7974948878134 | -122.406181056735 | (37.7974948878134, -122.406181056735) | 3 | 1 | 10 | 308 | 4 | |||
101743 | 98254 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 571 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010764.4 | 2118536 | 37.797702579203 | -122.406809598565 | (37.797702579203, -122.406809598565) | 3 | 1 | 10 | 308 | 4 | ||||
23258 | 4604 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 270 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6010907.72336 | 2118541.73775 | 37.7977263519913 | -122.406314062528 | (37.7977263519913, -122.406314062528) | 3 | 1 | 10 | 308 | 23 | |||
18087 | 4603 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 270 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6010933.33158 | 2118545.7793 | 37.7977388815556 | -122.406225735505 | (37.7977388815556, -122.406225735505) | 3 | 1 | 10 | 308 | 23 | |||
173250 | 11082 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1849 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007286.9943087 | 2118635.1241552 | 37.7977795644032 | -122.418849434729 | (37.7977795644032, -122.418849434729) | 5 | 1 | 10 | 28858 | 32 | |||
141238 | 11085 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1865 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6007279.7286506 | 2118687.2113849 | 37.7979221737821 | -122.418878272086 | (37.7979221737821, -122.418878272086) | 5 | 1 | 10 | 28858 | 32 | |||
13161 | 4609 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 316 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774670 | 6010771.0363 | 2118706.95943 | 37.7981723635161 | -122.406798689949 | (37.7981723635161, -122.406798689949) | 3 | 1 | 10 | 308 | 23 | |
119461 | 11088 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
166466 | 11087 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
182166 | 11086 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
157239 | 44224 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 150 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43669 | 6012974 | 2118691 | 37.7982515579635 | -122.399174613744 | (37.7982515579635, -122.399174613744) | 3 | 1 | 10 | 28860 | 6 | ||||
138743 | 11090 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1903 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 6x6 | 6007250.95739 | 2118862.55474 | 37.7984020026002 | -122.418990272151 | (37.7984020026002, -122.418990272151) | 5 | 1 | 10 | 28858 | 32 | |||
49389 | 11091 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1906 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6007294.23278 | 2118880.01642 | 37.7984523847496 | -122.418841764779 | (37.7984523847496, -122.418841764779) | 5 | 1 | 10 | 28858 | 32 | |||
71188 | 4619 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 358 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6010602.31813 | 2118839.00805 | 37.7985254951528 | -122.407391821594 | (37.7985254951528, -122.407391821594) | 3 | 1 | 10 | 308 | 23 | |||
151939 | 257912 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
193319 | 257913 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
4699 | 23132 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 610X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010603.58879 | 2118945.35218 | 37.798817561298 | -122.407394925794 | (37.798817561298, -122.407394925794) | 3 | 1 | 10 | 308 | 23 | ||
94426 | 23139 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 406X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6x3 | 6010454.05392 | 2118948.49862 | 37.798817830036 | -122.407912589535 | (37.798817830036, -122.407912589535) | 3 | 1 | 10 | 308 | 23 | |||
21287 | 23131 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 610X Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010622.64357 | 2118948.98987 | 37.7988286159864 | -122.407329246317 | (37.7988286159864, -122.407329246317) | 3 | 1 | 10 | 308 | 23 | ||
35445 | 253642 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010361.39347 | 2118971.94152 | 37.7988770104459 | -122.408234880635 | (37.7988770104459, -122.408234880635) | 3 | 1 | 10 | 308 | 4 | ||||
177573 | 4627 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 420 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010403.3977 | 2118996.04309 | 37.7989455393885 | -122.408091232197 | (37.7989455393885, -122.408091232197) | 3 | 1 | 10 | 308 | 23 | |||
52658 | 4626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 419 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010254.83162 | 2118999.33253 | 37.7989462519709 | -122.408605554576 | (37.7989462519709, -122.408605554576) | 3 | 1 | 10 | 308 | 4 | |||
74524 | 95408 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1257 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | No record of tree being permitted for planting. | 6006989.2 | 2119073.6 | 37.7989667366731 | -122.419911018667 | (37.7989667366731, -122.419911018667) | 5 | 1 | 10 | 28858 | 32 | ||
20324 | 4630 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6010279.42625 | 2119026.32466 | 37.7990217431564 | -122.408522353672 | (37.7990217431564, -122.408522353672) | 3 | 1 | 10 | 308 | 4 |
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) );