Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124 | 124 | 20281 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 738 | 738 | 20446 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15 | ||||||||
| 1497 | 1497 | 20382 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 2559 | 2559 | 19580 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY4 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 8 | ||||||||
| 3177 | 3177 | 46976 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44996 | ||||||||
| 5603 | 5603 | 34246 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38056 | ||||||||||
| 5617 | 5617 | 35204 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 5800 | 5800 | 20309 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 5832 | 5832 | 20376 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 5867 | 5867 | 19581 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY4 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 8 | ||||||||
| 6514 | 6514 | 20450 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 6778 | 6778 | 20443 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 6825 | 6825 | 35207 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 6835 | 6835 | 35197 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7167 | 7167 | 35203 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7953 | 7953 | 20384 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 8093 | 8093 | 20375 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 8280 | 8280 | 109193 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4124 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773525 | |||||
| 8347 | 8347 | 20438 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 8840 | 8840 | 20436 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15 | ||||||||
| 9617 | 9617 | 35183 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 10310 | 10310 | 35176 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 10572 | 10572 | 20406 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 51 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 10924 | 10924 | 20441 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 15 | ||||||||
| 11091 | 11091 | 20440 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 11273 | 11273 | 102842 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 11317 | 11317 | 35209 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11577 | 11577 | 20282 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 11758 | 11758 | 19579 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY4 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | ||||||||
| 11935 | 11935 | 20304 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 11988 | 11988 | 35180 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12161 | 12161 | 20448 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 12435 | 12435 | 35178 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12458 | 12458 | 35205 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12489 | 12489 | 35198 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12584 | 12584 | 20383 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 12698 | 12698 | 20444 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 12872 | 12872 | 35210 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14186 | 14186 | 20442 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 14195 | 14195 | 35181 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14347 | 14347 | 87020 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 Osceola Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49949 | ||||||||
| 14540 | 14540 | 20403 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 14575 | 14575 | 35206 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14588 | 14588 | 35174 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14986 | 14986 | 20437 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15 | ||||||||
| 15382 | 15382 | 20449 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 15571 | 15571 | 20439 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15 | ||||||||
| 16081 | 16081 | 35175 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16133 | 16133 | 35179 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16225 | 16225 | 35208 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16281 | 16281 | 20445 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 16353 | 16353 | 20447 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 16452 | 16452 | 35177 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16540 | 16540 | 19872 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY33 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 16638 | 16638 | 35212 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16789 | 16789 | 20000 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY46 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
| 3807 | 3807 | 90290 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4825X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980449.0 | 2110794.0 | 37.7747024934985 | -122.51113148443301 | (37.7747024934985, -122.511131484433) | ||
| 29595 | 29595 | 65028 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4875 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1989 12:00:00 AM | 3 | Permit Number 26080 | 5980518.0662 | 2110908.1981200003 | 37.775020123379996 | -122.51090106429199 | (37.77502012338, -122.510901064292) | ||
| 92241 | 92241 | 90291 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4800X Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980520.080019999 | 2110961.83438 | 37.7751675115073 | -122.51089808547701 | (37.7751675115073, -122.510898085477) | ||
| 63455 | 63455 | 118676 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4825 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5980559.76523 | 2110909.18852 | 37.7750253031785 | -122.510756894567 | (37.7750253031785, -122.510756894567) | |||
| 185367 | 185367 | 118675 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4825 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5980581.14799 | 2110910.44383 | 37.77503001151079 | -122.51068302162099 | (37.7750300115108, -122.510683021621) | |||
| 149104 | 149104 | 118674 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4825 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5980614.91009 | 2110910.7476 | 37.7750328375051 | -122.51056625589199 | (37.7750328375051, -122.510566255892) | |||
| 40796 | 40796 | 118904 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 701 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980709.06279 | 2110874.30302 | 37.774938325765 | -122.51023785876801 | (37.774938325765, -122.510237858768) | |||
| 148615 | 148615 | 46282 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 705 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | 5 | Permit Number 44561 | 5980709.06285 | 2110831.64762 | 37.7748212066407 | -122.51023468862499 | (37.7748212066407, -122.510234688625) | ||
| 153898 | 153898 | 46284 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 711 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | 7 | Permit Number 44563 | 5980709.97353 | 2110788.7442400004 | 37.7747034603493 | -122.51022835010299 | (37.7747034603493, -122.510228350103) | ||
| 118817 | 118817 | 41420 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 725 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 6 | 5x5 | Permit Number 42027 | 5980710.81691 | 2110753.36996 | 37.774606382770706 | -122.510222803918 | (37.7746063827707, -122.510222803918) | |
| 163227 | 163227 | 41421 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 731A B C La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 7 | Permit Number 42028 | 5980717.31821 | 2110693.46667 | 37.774442289512 | -122.51019586344 | (37.774442289512, -122.51019586344) | ||
| 50808 | 50808 | 41422 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 737A B C La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 7 | Permit Number 42029 | 5980718.37612 | 2110657.40313 | 37.7743433320773 | -122.510189524011 | (37.7743433320773, -122.510189524011) | ||
| 51136 | 51136 | 41423 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 743A B C La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 6 | Permit Number 42030 | 5980719.58689 | 2110639.12886 | 37.7742932277433 | -122.510183977803 | (37.7742932277433, -122.510183977803) | ||
| 174851 | 174851 | 40217 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 755 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 9 | Permit Number 41396 | 5980721.24963 | 2110609.89549 | 37.7742130596134 | -122.51017605378999 | (37.7742130596134, -122.51017605379) | |
| 110513 | 110513 | 46283 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4801 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44562 | 5980721.66048407 | 2110916.40891105 | 37.77505467920321 | -122.510197410494 | (37.7750546792032, -122.510197410494) | |||
| 179917 | 179917 | 118910 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 779 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5980721.87491 | 2110457.7346200002 | 37.773795307624795 | -122.51016258355699 | (37.7737953076248, -122.510162583557) | |||
| 178793 | 178793 | 118909 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 775 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5980722.52384 | 2110466.61703 | 37.773819734381206 | -122.510160998907 | (37.7738197343812, -122.510160998907) | |||
| 72083 | 72083 | 118906 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 763 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5980722.84871 | 2110577.69802 | 37.774124749182604 | -122.510168129734 | (37.7741247491826, -122.510168129734) | |||
| 53142 | 53142 | 118907 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 767 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980723.00275 | 2110520.89615 | 37.7739687970878 | -122.510163375859 | (37.7739687970878, -122.510163375859) | |||
| 179481 | 179481 | 118905 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 759 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5980723.1377 | 2110591.1502 | 37.774161701946795 | -122.51016812974 | (37.7741617019468, -122.51016812974) | |||
| 26156 | 26156 | 118911 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 783 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5980723.51809 | 2110427.58911 | 37.7737126338651 | -122.510154659499 | (37.7737126338651, -122.510154659499) | |||
| 183739 | 183739 | 118912 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 787 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5980724.35298 | 2110402.4794799997 | 37.7736437394687 | -122.510149905624 | (37.7736437394687, -122.510149905624) | |||
| 156610 | 156610 | 118908 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 771 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980724.52574 | 2110506.4926400003 | 37.7739293391312 | -122.51015703733499 | (37.7739293391312, -122.510157037335) | |||
| 31879 | 31879 | 118913 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 791 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980726.27409 | 2110374.60886 | 37.7735673282771 | -122.51014118926001 | (37.7735673282771, -122.51014118926) | |||
| 54840 | 54840 | 118914 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 795 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5980726.65599 | 2110349.7369999997 | 37.7734990600053 | -122.51013802000601 | (37.7734990600053, -122.510138020006) | |||
| 62939 | 62939 | 118918 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 855 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5980739.80677 | 2109948.8930200003 | 37.7723992361183 | -122.51006274477301 | (37.7723992361183, -122.510062744773) | |||
| 137573 | 137573 | 118923 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 855 La Playa | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5980744.20111 | 2109822.88075 | 37.7720535026603 | -122.51003818124599 | (37.7720535026603, -122.510038181246) | |||
| 173330 | 173330 | 118925 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 855 La Playa | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5980744.81689 | 2109798.23147 | 37.7719858593014 | -122.51003421969601 | (37.7719858593014, -122.510034219696) | |||
| 49842 | 49842 | 118926 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 875 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5980750.36595 | 2109715.30711 | 37.7717585006639 | -122.510008863841 | (37.7717585006639, -122.510008863841) | |||
| 166801 | 166801 | 118927 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 875 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5980750.45803 | 2109699.47585 | 37.7717150381052 | -122.510007369019 | (37.7717150381052, -122.510007369019) | |||
| 102383 | 102383 | 90287 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4740 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980821.753219999 | 2110975.07524 | 37.775221663232 | -122.50985553309401 | (37.775221663232, -122.509855533094) | ||
| 155117 | 155117 | 186636 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Lower Great Hwy | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980864.6099 | 2105729.0507 | 37.7608201372164 | -122.509317602916 | (37.7608201372164, -122.509317602916) | |||
| 180173 | 180173 | 186625 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Lower Great Hwy | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980868.2988 | 2105582.371 | 37.76041761449721 | -122.50929395155 | (37.7604176144972, -122.50929395155) | |||
| 52895 | 52895 | 186634 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Lower Great Hwy | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980874.0957 | 2105690.7559 | 37.7607155500113 | -122.509281952349 | (37.7607155500113, -122.509281952349) | |||
| 182401 | 182401 | 186519 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Lower Great Hwy | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980902.9388 | 2105057.6001 | 37.758978786758 | -122.509135180581 | (37.758978786758, -122.509135180581) | |||
| 39317 | 39317 | 186508 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Lower Great Hwy | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980903.4565 | 2105112.4796 | 37.759129500629896 | -122.50913746543199 | (37.7591295006299, -122.509137465432) | |||
| 90608 | 90608 | 90296 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4725 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980914.473680001 | 2110921.9769 | 37.77508133874971 | -122.509530853193 | (37.7750813387497, -122.509530853193) | ||
| 47080 | 47080 | 181618 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1396 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5980931.0935 | 2105583.8021 | 37.7604252460715 | -122.509076883921 | (37.7604252460715, -122.509076883921) | |||
| 163734 | 163734 | 183264 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1396 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5980931.0935 | 2105603.235 | 37.7604786032233 | -122.509078326964 | (37.7604786032233, -122.509078326964) | |||
| 93917 | 93917 | 47887 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1396 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | Permit Number 45633 | 5980936.26532386 | 2105566.37783375 | 37.7603777089466 | -122.50905770342301 | (37.7603777089466, -122.509057703423) | ||
| 141830 | 141830 | 47888 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1396 La Playa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | Permit Number 45633 | 5980936.26532386 | 2105566.37783375 | 37.7603777089466 | -122.50905770342301 | (37.7603777089466, -122.509057703423) | ||
| 82139 | 82139 | 83316 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1516 Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50185 | 5980939.77097966 | 2104729.07463785 | 37.7580789214423 | -122.50898340594401 | (37.7580789214423, -122.508983405944) | ||
| 93422 | 93422 | 83930 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1516 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50185 | 5980939.77097966 | 2104729.07463785 | 37.7580789214423 | -122.50898340594401 | (37.7580789214423, -122.508983405944) | ||
| 95572 | 95572 | 11609 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4390 JUDAH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4x4 | 5980943.0 | 2105553.0 | 37.760341374292004 | -122.509033418341 | (37.760341374292, -122.509033418341) |
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");