Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76893 | 76893 | 130269 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 503 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007707.20145 | 2122317.4963 | 37.807914080648395 | -122.41765653263501 | (37.8079140806484, -122.417656532635) | |||
| 177446 | 177446 | 130268 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 503 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007672.5640199995 | 2122314.32327 | 37.80790341917061 | -122.417776179344 | (37.8079034191706, -122.417776179344) | |||
| 158197 | 158197 | 130267 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 503 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6007643.34611 | 2122309.22762 | 37.80788778354621 | -122.41787693399901 | (37.8078877835462, -122.417876933999) | |||
| 61757 | 61757 | 130266 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 503 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6007603.7031 | 2122302.7922099996 | 37.807867882461096 | -122.418013672301 | (37.8078678824611, -122.418013672301) | |||
| 74877 | 74877 | 130265 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 503 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007568.768759999 | 2122297.81349 | 37.807852245945504 | -122.418134218317 | (37.8078522459455, -122.418134218317) | |||
| 34775 | 34775 | 130264 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 503 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6007541.98485 | 2122297.32722 | 37.8078494032009 | -122.418226876366 | (37.8078494032009, -122.418226876366) | |||
| 75006 | 75006 | 130263 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007501.82202 | 2122290.9026099998 | 37.8078295021024 | -122.418365414238 | (37.8078295021024, -122.418365414238) | |||
| 182478 | 182478 | 130270 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2701 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007750.19369 | 2122282.10539 | 37.8078193253539 | -122.41750523699699 | (37.8078193253539, -122.417505236997) | |||
| 136805 | 136805 | 130262 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6007476.26817 | 2122287.02611 | 37.807817419716 | -122.418453574766 | (37.807817419716, -122.418453574766) | |||
| 153453 | 153453 | 130261 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007441.57257 | 2122281.00732 | 37.8077989404247 | -122.418573220586 | (37.8077989404247, -122.418573220586) | |||
| 60995 | 60995 | 130330 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2570 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6009264.58043 | 2122243.6632 | 37.8077988657989 | -122.412261592292 | (37.8077988657989, -122.412261592292) | |||
| 70525 | 70525 | 130260 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007403.7588599995 | 2122275.0522 | 37.8077804602788 | -122.418703661868 | (37.8077804602788, -122.418703661868) | |||
| 184284 | 184284 | 130259 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007382.90307 | 2122272.11478 | 37.8077712206334 | -122.41877563011101 | (37.8077712206334, -122.418775630111) | |||
| 151946 | 151946 | 130258 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6007346.420469999 | 2122267.68592 | 37.8077570059352 | -122.418901572974 | (37.8077570059352, -122.418901572974) | |||
| 188699 | 188699 | 130271 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2701 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007752.167090001 | 2122258.39153 | 37.8077543241725 | -122.417496725794 | (37.8077543241725, -122.417496725794) | |||
| 177558 | 177558 | 130288 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2800 Leavenworth St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007317.8229 | 2122229.78006 | 37.8076513158315 | -122.418997851683 | (37.8076513158315, -122.418997851683) | |||
| 131488 | 131488 | 130272 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2701 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007757.73013 | 2122209.84229 | 37.80762133333621 | -122.41747403050199 | (37.8076213333362, -122.417474030502) | |||
| 68814 | 68814 | 130287 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2800 Leavenworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007323.74687 | 2122200.41347 | 37.8075710162603 | -122.418975266098 | (37.8075710162603, -122.418975266098) | |||
| 51645 | 51645 | 130273 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2701 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007761.54871 | 2122182.8254299997 | 37.807547366773 | -122.417458899419 | (37.807547366773, -122.417458899419) | |||
| 34253 | 34253 | 130286 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2800 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007329.016419999 | 2122165.64422 | 37.8074758455098 | -122.41895456190001 | (37.8074758455098, -122.4189545619) | |||
| 30850 | 30850 | 130285 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2800 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007332.766 | 2122136.32222 | 37.8073955459235 | -122.41893950456301 | (37.8073955459235, -122.418939504563) | |||
| 58366 | 58366 | 130274 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2701 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007772.502309999 | 2122103.96163 | 37.807331443154396 | -122.41741539919799 | (37.8073314431544, -122.417415399198) | |||
| 50070 | 50070 | 130284 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2800 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007338.07417 | 2122103.44762 | 37.8073055795633 | -122.41891880127 | (37.8073055795633, -122.41891880127) | |||
| 150531 | 150531 | 130275 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 500 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007746.56526 | 2122025.03692 | 37.80711327662971 | -122.41749956316299 | (37.8071132766297, -122.417499563163) | |||
| 164736 | 164736 | 44354 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 4 | Permit Number 43731 | 6008055.5377 | 2122018.11955 | 37.8071116632331 | -122.41642980519899 | (37.8071116632331, -122.416429805199) | ||
| 48605 | 48605 | 44353 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 6 | Permit Number 43731 | 6008040.41682 | 2122016.3517 | 37.8071059588299 | -122.416482009051 | (37.8071059588299, -122.416482009051) | ||
| 55342 | 55342 | 130276 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 500 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007713.79297 | 2122020.79519 | 37.8070997858826 | -122.417612678081 | (37.8070997858826, -122.417612678081) | |||
| 186009 | 186009 | 44352 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 5 | Permit Number 43731 | 6008017.89414 | 2122013.61694 | 37.8070971832479 | -122.416559759923 | (37.8070971832479, -122.416559759923) | ||
| 119400 | 119400 | 107689 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2801 JONES ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2015 12:00:00 AM | 3 | Permit Number 774455 | 6007799.0 | 2122017.1 | 37.80709443404471 | -122.41731753833099 | (37.8070944340447, -122.417317538331) | ||
| 72221 | 72221 | 44358 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 80513 | 80513 | 44361 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 84339 | 84339 | 44355 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 101218 | 101218 | 44359 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 108916 | 108916 | 44356 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 117341 | 117341 | 44360 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 455 Beach St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | Permit Number 43731 | 6008034.11150007 | 2122012.08037307 | 37.8070938762584 | -122.416503527251 | (37.8070938762584, -122.416503527251) | |||
| 25747 | 25747 | 44351 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 6 | Permit Number 43731 | 6008003.5653099995 | 2122011.35371 | 37.8070901631447 | -122.41660918757601 | (37.8070901631447, -122.416609187576) | ||
| 112542 | 112542 | 43944 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2801 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43532 | 6007788.11286909 | 2122015.59896639 | 37.807089700059706 | -122.41735510920401 | (37.8070897000597, -122.417355109204) | ||||
| 37365 | 37365 | 44357 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 2 | Permit Number 43731 | 6007993.12258 | 2122010.7684299997 | 37.807087968806 | -122.416645285459 | (37.807087968806, -122.416645285459) | ||
| 183972 | 183972 | 130277 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 500 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007637.996780001 | 2122009.8332599998 | 37.807065421886 | -122.41787420993099 | (37.807065421886, -122.417874209931) | |||
| 23493 | 23493 | 130278 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 500 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007607.17064 | 2122005.0493400004 | 37.8070505515945 | -122.41798055117201 | (37.8070505515945, -122.417980551172) | |||
| 160299 | 160299 | 58305 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2800 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/15/1990 12:00:00 AM | 12 | Permit Number 29301 | 6007350.5652 | 2121996.5002 | 37.807012632588204 | -122.418867983279 | (37.8070126325882, -122.418867983279) | ||
| 135138 | 135138 | 130279 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 580 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007522.602469999 | 2121991.88932 | 37.8070096576235 | -122.418272284063 | (37.8070096576235, -122.418272284063) | |||
| 68639 | 68639 | 130280 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 580 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007496.72457 | 2121989.71213 | 37.8070022229356 | -122.418361685643 | (37.8070022229356, -122.418361685643) | |||
| 35091 | 35091 | 130281 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 580 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007471.37341 | 2121986.71155 | 37.806992557013395 | -122.418449205886 | (37.8069925570134, -122.418449205886) | |||
| 182323 | 182323 | 130282 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 580 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007436.13705 | 2121979.03934 | 37.8069695074103 | -122.418570604471 | (37.8069695074103, -122.418570604471) | |||
| 156581 | 156581 | 130283 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 580 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007414.38622 | 2121979.21478 | 37.806968764573604 | -122.418645890311 | (37.8069687645736, -122.418645890311) | |||
| 81210 | 81210 | 100114 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 86389 | 86389 | 100113 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 88125 | 88125 | 100109 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 89982 | 89982 | 100110 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 90019 | 90019 | 100119 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 93784 | 93784 | 100111 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 95264 | 95264 | 100117 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 100595 | 100595 | 100112 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 112445 | 112445 | 100115 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 113502 | 113502 | 100116 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 118771 | 118771 | 100120 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 139689 | 139689 | 100118 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007662.0 | 2121967.0 | 37.8069491634687 | -122.41778810344101 | (37.8069491634687, -122.417788103441) | |||||
| 108455 | 108455 | 110989 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 245x North Point St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 3x3 | Permit Number 776694 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | ||
| 79918 | 79918 | 115711 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 550 NORTH POINT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008089.0 | 2121871.0 | 37.806709591959 | -122.416303574578 | (37.806709591959, -122.416303574578) | ||||
| 95535 | 95535 | 115712 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 550 NORTH POINT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2016 12:00:00 AM | 3 | 3x3 | 6008089.0 | 2121871.0 | 37.806709591959 | -122.416303574578 | (37.806709591959, -122.416303574578) | ||
| 96292 | 96292 | 115709 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 550 NORTH POINT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008089.0 | 2121871.0 | 37.806709591959 | -122.416303574578 | (37.806709591959, -122.416303574578) | ||||
| 111993 | 111993 | 115710 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 550 NORTH POINT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008089.0 | 2121871.0 | 37.806709591959 | -122.416303574578 | (37.806709591959, -122.416303574578) | ||||
| 118865 | 118865 | 115713 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 550 NORTH POINT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008089.0 | 2121871.0 | 37.806709591959 | -122.416303574578 | (37.806709591959, -122.416303574578) | ||||
| 8071 | 8071 | 29750 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1333 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007187.30847 | 2121846.91915 | 37.806592727442606 | -122.419422349675 | (37.8065927274426, -122.419422349675) | ||
| 5509 | 5509 | 29751 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1331 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007205.020769999 | 2121826.2812 | 37.806537058492395 | -122.41935958779 | (37.8065370584924, -122.41935958779) | ||
| 1565 | 1565 | 29772 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1329 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2006 12:00:00 AM | 8 | 3x3 | 6007229.90871 | 2121805.15578 | 37.8064804551638 | -122.419271958731 | (37.8064804551638, -122.419271958731) | ||
| 3484 | 3484 | 29773 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1323 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007274.40422 | 2121764.0348900002 | 37.8063700535072 | -122.41911505491001 | (37.8063700535072, -122.41911505491) | ||
| 163985 | 163985 | 130325 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 542 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008159.70501 | 2121738.7701 | 37.806350497730605 | -122.416049515186 | (37.8063504977306, -122.416049515186) | |||
| 35983 | 35983 | 130326 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 542 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008148.25125 | 2121737.85271 | 37.806347334827706 | -122.416089088048 | (37.8063473348277, -122.416089088048) | |||
| 174188 | 174188 | 130327 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 542 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008134.16526 | 2121736.211 | 37.8063420351113 | -122.41613771889901 | (37.8063420351113, -122.416137718899) | |||
| 154258 | 154258 | 130328 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 542 North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008081.77545 | 2121727.51259 | 37.806315205644104 | -122.41631840709299 | (37.8063152056441, -122.416318407093) | |||
| 75043 | 75043 | 130329 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 542 North Point St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008067.9192 | 2121725.2629 | 37.806308249393204 | -122.416366199758 | (37.8063082493932, -122.416366199758) | |||
| 160123 | 160123 | 130312 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009237.336019999 | 2121537.59149 | 37.805858641438604 | -122.412305940572 | (37.8058586414386, -122.412305940572) | |||
| 184030 | 184030 | 130313 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009225.50566 | 2121536.68624 | 37.8058554919917 | -122.412346817477 | (37.8058554919917, -122.412346817477) | |||
| 34770 | 34770 | 130314 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009197.21329 | 2121532.85359 | 37.805843380819894 | -122.412444456844 | (37.8058433808199, -122.412444456844) | |||
| 154295 | 154295 | 130315 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009174.88124 | 2121532.51609 | 37.805841200870205 | -122.41252171672899 | (37.8058412008702, -122.412521716729) | |||
| 64932 | 64932 | 130316 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009160.79574 | 2121529.94561 | 37.8058333524822 | -122.41257028011101 | (37.8058333524822, -122.412570280111) | |||
| 49849 | 49849 | 130317 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009115.5531 | 2121524.3597 | 37.80581547576929 | -122.412726454583 | (37.8058154757693, -122.412726454583) | |||
| 55878 | 55878 | 130318 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009076.6698 | 2121517.84992 | 37.805795419088604 | -122.412860556086 | (37.8057954190886, -122.412860556086) | |||
| 41856 | 41856 | 130319 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009021.48907 | 2121509.76747 | 37.8057701292398 | -122.413050946145 | (37.8057701292398, -122.413050946145) | |||
| 146232 | 146232 | 29729 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 8 | 4x4 | 6007719.65165 | 2121534.5567900003 | 37.8057650284682 | -122.41755791876301 | (37.8057650284682, -122.417557918763) | ||
| 34100 | 34100 | 130320 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009003.41854 | 2121507.27888 | 37.8057622817731 | -122.41311330605801 | (37.8057622817731, -122.413113306058) | |||
| 107715 | 107715 | 103297 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011114.9 | 2121460.0 | 37.805750773231004 | -122.40580283963699 | (37.805750773231, -122.405802839637) | ||||
| 124983 | 124983 | 103295 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 50 Francisco St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2013 12:00:00 AM | 3x3 | Permit Number 769976 | 6011114.9 | 2121460.0 | 37.805750773231004 | -122.40580283963699 | (37.805750773231, -122.405802839637) | ||
| 151945 | 151945 | 130321 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008970.4885 | 2121503.34706 | 37.8057496373077 | -122.413226987563 | (37.8057496373077, -122.413226987563) | |||
| 155035 | 155035 | 130322 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Bay St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008954.4965699995 | 2121501.13304 | 37.8057426603468 | -122.41328217353998 | (37.8057426603468, -122.41328217354) | |||
| 125576 | 125576 | 27429 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1288 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6007634.94061 | 2121525.2653900003 | 37.8057347497405 | -122.417850415659 | (37.8057347497405, -122.417850415659) | |||
| 148676 | 148676 | 130324 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1198 Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6007631.15921 | 2121523.38759 | 37.80572938097279 | -122.417863368593 | (37.8057293809728, -122.417863368593) | |||
| 161441 | 161441 | 103294 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Francisco St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010967.251759999 | 2121426.28761 | 37.8056499492485 | -122.40631142405701 | (37.8056499492485, -122.406311424057) | |||
| 83711 | 83711 | 33972 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1250 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | |||
| 46310 | 46310 | 130354 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 52 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010940.055819999 | 2121419.5387 | 37.805629897078205 | -122.406405064151 | (37.8056298970782, -122.406405064151) | |||
| 51000 | 51000 | 130355 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 52 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6010894.644230001 | 2121412.4056599997 | 37.805607771039 | -122.406561715266 | (37.805607771039, -122.406561715266) | |||
| 181754 | 181754 | 130378 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 55 Francisco St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6011148.6457 | 2121397.6551200002 | 37.805581476679 | -122.405681662981 | (37.805581476679, -122.405681662981) | |||
| 150676 | 150676 | 130353 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1700 Montgomery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6011274.37795 | 2121365.3031099997 | 37.8054996761427 | -122.405244266923 | (37.8054996761427, -122.405244266923) | |||
| 87039 | 87039 | 103296 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 80 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010792.0 | 2121375.0 | 37.80549932132 | -122.406914293894 | (37.80549932132, -122.406914293894) | ||||
| 24489 | 24489 | 130352 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1700 Montgomery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6011277.60651 | 2121335.96977 | 37.80541931451221 | -122.40523102708299 | (37.8054193145122, -122.405231027083) | |||
| 58340 | 58340 | 130323 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1198 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6007760.71211 | 2121406.96666 | 37.8054170086409 | -122.417406774716 | (37.8054170086409, -122.417406774716) | |||
| 52988 | 52988 | 130351 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1700 Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6011282.98959 | 2121299.98363 | 37.8053208063785 | -122.40520986247 | (37.8053208063785, -122.40520986247) | |||
| 62550 | 62550 | 130379 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1701 Montgomery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6011240.532819999 | 2121290.2423099997 | 37.8052916854358 | -122.405356103906 | (37.8052916854358, -122.405356103906) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");