Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 864 | 864 | 37366 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
| 5259 | 5259 | 42922 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42829 | |||||||||
| 5550 | 5550 | 37365 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
| 12187 | 12187 | 50191 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 347 Richard Av | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | Permit Number 46897 | ||||||||
| 90821 | 90821 | 44385 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 185 Baltimore Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43746 | 6002329.42862952 | 2086131.81061029 | 37.708252829485296 | -122.433679745726 | (37.7082528294853, -122.433679745726) | ||
| 112948 | 112948 | 44386 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 185 Baltimore Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43746 | 6002329.42862952 | 2086131.81061029 | 37.708252829485296 | -122.433679745726 | (37.7082528294853, -122.433679745726) | ||
| 58862 | 58862 | 37345 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 724 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 10 | Permit Number 39853 | 5998100.18965 | 2086460.63765 | 37.7089148310191 | -122.448320064445 | (37.7089148310191, -122.448320064445) | |
| 106047 | 106047 | 44443 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 287 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43774 | 6003431.81812286 | 2086404.88677332 | 37.7090651281705 | -122.429889231519 | (37.7090651281705, -122.429889231519) | ||
| 152208 | 152208 | 57958 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 332 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 13 | Permit Number 16918 | 5999508.527290001 | 2086501.1248400002 | 37.7091064162873 | -122.443455572131 | (37.7091064162873, -122.443455572131) | ||
| 160291 | 160291 | 44444 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 287 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 9 | Permit Number 43774 | 6003411.70926 | 2086434.98288 | 37.7091466267865 | -122.429960876109 | (37.7091466267865, -122.429960876109) | |
| 162722 | 162722 | 44442 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 287 South Hill Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 14 | Permit Number 43774 | 6003408.0203599995 | 2086444.2343400002 | 37.7091718203864 | -122.429974284999 | (37.7091718203864, -122.429974284999) | |
| 155230 | 155230 | 57965 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 211 Lowell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 20 | Permit Number 16925 | 5998963.22576 | 2086714.9374 | 37.7096623843901 | -122.445355572527 | (37.7096623843901, -122.445355572527) | ||
| 11621 | 11621 | 76445 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998808.0264099995 | 2086988.0844400001 | 37.710403523785 | -122.445911599067 | (37.710403523785, -122.445911599067) | |
| 12985 | 12985 | 76427 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 3 | 3x3 | 5998792.69271 | 2087037.2667900003 | 37.710537691825294 | -122.445968130449 | (37.7105376918253, -122.445968130449) | |
| 84417 | 84417 | 37376 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 91068 | 91068 | 37374 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 93477 | 93477 | 37378 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 95427 | 95427 | 37372 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 106497 | 106497 | 37368 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 109826 | 109826 | 37384 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 110425 | 110425 | 37367 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 112545 | 112545 | 37370 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 4 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 115975 | 115975 | 37380 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 129265 | 129265 | 37382 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 143392 | 143392 | 37369 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 12983 | 12983 | 73822 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998761.76944 | 2087100.1867 | 37.7107086898252 | -122.44607953033999 | (37.7107086898252, -122.44607953034) | |
| 167720 | 167720 | 78779 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 50 Farragut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 14 | 5997572.003219999 | 2087132.1924700001 | 37.7107285558476 | -122.45019391613701 | (37.7107285558476, -122.450193916137) | ||
| 28515 | 28515 | 177540 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118 Lowell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998750.27555 | 2087125.8155099999 | 37.7107784043659 | -122.446121097934 | (37.7107784043659, -122.446121097934) | |||
| 51706 | 51706 | 177541 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 763 Morse St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998622.731430001 | 2087153.99485 | 37.7108484939443 | -122.446563943873 | (37.7108484939443, -122.446563943873) | |||
| 146503 | 146503 | 177542 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 763 Morse St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998634.17055 | 2087157.9364900002 | 37.710859970193 | -122.446524691177 | (37.710859970193, -122.446524691177) | |||
| 76610 | 76610 | 177543 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 763 Morse St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998648.38585 | 2087164.77044 | 37.7108795466262 | -122.446476051329 | (37.7108795466262, -122.446476051329) | |||
| 59779 | 59779 | 177544 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 763 Morse St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998663.80946 | 2087170.3503700001 | 37.7108957487982 | -122.44642314511299 | (37.7108957487982, -122.446423145113) | |||
| 12245 | 12245 | 72809 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998733.92072 | 2087172.14442 | 37.710904679081395 | -122.446180954109 | (37.7109046790814, -122.446180954109) | |
| 179208 | 179208 | 177545 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 763 Morse St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998675.35081 | 2087179.2071099998 | 37.71092072659079 | -122.446383892402 | (37.7109207265908, -122.446383892402) | |||
| 131371 | 131371 | 177546 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1200 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6008407.5541199995 | 2087041.9081400002 | 37.711094783172 | -122.4127372923 | (37.711094783172, -122.4127372923) | |||
| 172708 | 172708 | 177547 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1202 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6008380.574519999 | 2087049.08192 | 37.7111129665536 | -122.412831047535 | (37.7111129665536, -122.412831047535) | |||
| 30262 | 30262 | 177548 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1212 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6008309.89956 | 2087076.14497 | 37.7111833088358 | -122.413077230629 | (37.7111833088358, -122.413077230629) | |||
| 23613 | 23613 | 177549 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1212 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008302.63413 | 2087080.3017900002 | 37.7111943147388 | -122.41310263557502 | (37.7111943147388, -122.413102635575) | |||
| 19640 | 19640 | 41394 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 78392 | 78392 | 41405 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 83061 | 83061 | 41397 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 90897 | 90897 | 41408 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 91647 | 91647 | 41393 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 95096 | 95096 | 41399 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 95366 | 95366 | 41392 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 97480 | 97480 | 41398 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 98726 | 98726 | 41388 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 101105 | 101105 | 41406 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 102191 | 102191 | 41403 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 104466 | 104466 | 41386 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 105218 | 105218 | 41402 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 107035 | 107035 | 41391 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 109577 | 109577 | 41400 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 109989 | 109989 | 41387 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 111241 | 111241 | 41395 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 111491 | 111491 | 41396 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 113046 | 113046 | 41389 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 113269 | 113269 | 41401 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 120697 | 120697 | 41407 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 145483 | 145483 | 41390 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 28957 | 28957 | 177550 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1232 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008203.75149 | 2087114.38987 | 37.7112823619554 | -122.41344680884899 | (37.7112823619554, -122.413446808849) | |||
| 47744 | 47744 | 177551 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1232 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6008194.37646 | 2087118.0668 | 37.711291931647104 | -122.4134794713 | (37.7112919316471, -122.4134794713) | |||
| 163639 | 163639 | 177552 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1252 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6008179.27118 | 2087123.9525 | 37.7113072443981 | -122.413532095133 | (37.7113072443981, -122.413532095133) | |||
| 26699 | 26699 | 177553 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1252 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008169.89589 | 2087127.62977 | 37.7113168149851 | -122.413564758528 | (37.7113168149851, -122.413564758528) | |||
| 39906 | 39906 | 41404 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1252 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | 7 | Permit Number 42021 | 6008157.91792 | 2087132.40574 | 37.7113292562177 | -122.413606495143 | (37.7113292562177, -122.413606495143) | |
| 68587 | 68587 | 177554 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008137.76094 | 2087139.4402400001 | 37.711347439601 | -122.41367666025101 | (37.711347439601, -122.413676660251) | |||
| 62663 | 62663 | 177555 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1262 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6008091.22398 | 2087157.2966900002 | 37.7113938563146 | -122.41383876666401 | (37.7113938563146, -122.413838766664) | |||
| 55278 | 55278 | 177556 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1272 Sunnydale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6008061.6956 | 2087168.1827200002 | 37.711422088742104 | -122.413941594254 | (37.7114220887421, -122.413941594254) | |||
| 126328 | 126328 | 44414 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 715 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 11 | Permit Number 43765 | 6002608.88238 | 2087292.96021 | 37.711456946454504 | -122.43279681623699 | (37.7114569464545, -122.432796816237) | |
| 68450 | 68450 | 177557 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1272 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008002.127780001 | 2087190.6623 | 37.7114804673251 | -122.414149066054 | (37.7114804673251, -122.414149066054) | |||
| 185544 | 185544 | 44415 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 715 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 10 | Permit Number 43765 | 6002616.35291 | 2087303.28452 | 37.711485718453204 | -122.432771733227 | (37.7114857184532, -122.432771733227) | |
| 53130 | 53130 | 177558 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1272 Sunnydale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6007990.6783 | 2087195.6021 | 37.7114933878791 | -122.41418898783701 | (37.7114933878791, -122.414188987837) | |||
| 177982 | 177982 | 44413 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 715 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 11 | Permit Number 43765 | 6002624.57094 | 2087314.6775200001 | 37.7115174672301 | -122.432744142937 | (37.7115174672301, -122.432744142937) | |
| 1852 | 1852 | 178671 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 624 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6002757.8843 | 2087321.68 | 37.7115442544376 | -122.432283877092 | (37.7115442544376, -122.432283877092) | |||
| 90184 | 90184 | 44408 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1201 Naples St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43761 | 6001148.59414975 | 2087417.50046792 | 37.711715976255796 | -122.437852856075 | (37.7117159762558, -122.437852856075) | ||
| 4397 | 4397 | 251730 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 536 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:34:00 AM | 3 | 3x3 | 6002599.0 | 2087392.0 | 37.71172832759 | -122.432838043044 | (37.71172832759, -122.432838043044) | ||
| 167569 | 167569 | 177579 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 518 Rolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002528.751209999 | 2087456.67798 | 37.7119019345989 | -122.433085459944 | (37.7119019345989, -122.433085459944) | |||
| 9769 | 9769 | 159355 | Planning Code 138.1 required 4 | Melaleuca quinquenervia :: Cajeput 50 | 417 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998509.882680001 | 2087558.1907400002 | 37.7119518775514 | -122.44698304145001 | (37.7119518775514, -122.44698304145) | |
| 4208 | 4208 | 163311 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 261 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 08:33:00 AM | 3 | Width 0ft | 5994382.20064 | 2087745.46311 | 37.7122293948338 | -122.46126294184201 | (37.7122293948338, -122.461262941842) | ||
| 4269 | 4269 | 163375 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 204 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 07:56:00 AM | 3 | Width 0ft | 5994989.76466 | 2087776.26613 | 37.712348920149104 | -122.45916526416799 | (37.7123489201491, -122.459165264168) | ||
| 4263 | 4263 | 163376 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 204 Sadowa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 08:04:00 AM | 3 | Width 0ft | 5994976.692009999 | 2087776.5788200002 | 37.7123490271688 | -122.45921046950899 | (37.7123490271688, -122.459210469509) | ||
| 4262 | 4262 | 163377 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 210 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 08:24:00 AM | 3 | Width 0ft | 5994919.0 | 2087792.0 | 37.7123880531541 | -122.45941098523701 | (37.7123880531541, -122.459410985237) | ||
| 182274 | 182274 | 177559 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 321 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5998895.58023 | 2087925.27433 | 37.712981834213 | -122.44567634809201 | (37.712981834213, -122.445676348092) | |||
| 24208 | 24208 | 177560 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 321 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5998919.67884 | 2087945.88417 | 37.7130398000187 | -122.445594536777 | (37.7130398000187, -122.445594536777) | |||
| 163619 | 163619 | 73817 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 125 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 7 | 6000831.98332 | 2087914.4715900002 | 37.7130625393704 | -122.438982739962 | (37.7130625393704, -122.438982739962) | ||
| 27152 | 27152 | 72787 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 125 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 6000842.138719999 | 2087917.52073 | 37.7130714894434 | -122.43894785796199 | (37.7130714894434, -122.438947857962) | ||
| 130624 | 130624 | 78732 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 53 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 12 | 5998972.2526 | 2087962.75673 | 37.7130891296288 | -122.44541403745 | (37.7130891296288, -122.44541403745) | ||
| 86886 | 86886 | 44390 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 15 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43749 | 6001647.0719332 | 2087964.37014378 | 37.7132458927569 | -122.43616909431101 | (37.7132458927569, -122.436169094311) | ||
| 124286 | 124286 | 44389 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 15 Cordova St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | Permit Number 43749 | 6001647.0719332 | 2087964.37014378 | 37.7132458927569 | -122.43616909431101 | (37.7132458927569, -122.436169094311) | ||
| 149 | 149 | 26071 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 247 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 01:41:00 PM | 3 | 3X3 | 5993990.1569314 | 2088190.8403771 | 37.7134297247264 | -122.46265023824101 | (37.7134297247264, -122.462650238241) | ||
| 1808 | 1808 | 26069 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 271 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/1997 12:00:00 AM | 3 | 3X3 | 5993995.7894187 | 2088348.3730133998 | 37.713862596316 | -122.462642190986 | (37.713862596316, -122.462642190986) | ||
| 146403 | 146403 | 73117 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 170 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 13 | 5998798.49436 | 2089027.5311099999 | 37.7160028368265 | -122.44609114241699 | (37.7160028368265, -122.446091142417) | ||
| 28707 | 28707 | 177564 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 791 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001913.98711 | 2089225.11823 | 37.7167227891097 | -122.435336672548 | (37.7167227891097, -122.435336672548) | |||
| 11631 | 11631 | 15824 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5060 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1995 12:00:00 AM | 12 | 3X3 | 6000432.8297 | 2089486.0645 | 37.7173550615336 | -122.440474991501 | (37.7173550615336, -122.440474991501) | ||
| 145012 | 145012 | 15826 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5081 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 6 | 3X3 | 6000584.2194 | 2089509.2478099999 | 37.7174273368683 | -122.43995337049401 | (37.7174273368683, -122.439953370494) | ||
| 55854 | 55854 | 177563 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 738 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002044.3357 | 2089508.8562099999 | 37.7175092723187 | -122.434906402712 | (37.7175092723187, -122.434906402712) | |||
| 50306 | 50306 | 187447 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 5083 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000540.1333 | 2089544.2391 | 37.71752090531329 | -122.44010826310199 | (37.7175209053133, -122.440108263102) | |||
| 12125 | 12125 | 15819 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 5050 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/2001 12:00:00 AM | 12 | 3X3 | 6000495.0068 | 2089582.3782 | 37.717623057493896 | -122.440266977896 | (37.7176230574939, -122.440266977896) | ||
| 144351 | 144351 | 41038 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 10 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1999 12:00:00 AM | Permit Number 41823 | 6012891.67554567 | 2089346.007114 | 37.717672045776204 | -122.39740045328699 | (37.7176720457762, -122.397400453287) | |||
| 11034 | 11034 | 15821 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 5051 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1995 12:00:00 AM | 6 | 3X3 | 6000582.469 | 2089604.8822 | 37.717689827708895 | -122.43996627417101 | (37.7176898277089, -122.439966274171) |
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");