Data source: data.sfgov.org
This data as json, CSV (advanced)
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) | |
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) | |||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
77972 | 77972 | 59691 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 185 Seal Rock Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1981 12:00:00 AM | 38 | 4x3 | Permit Number 19118 | 5980952.62035506 | 2112920.61231564 | 37.7805712485973 | -122.50954737591499 | (37.7805712485973, -122.509547375915) | |
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) | ||
45218 | 45218 | 250986 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 185 Seal Rock Dr | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 5980980.82201 | 2112923.78682 | 37.7805816277787 | -122.50945005058 | (37.7805816277787, -122.50945005058) | |||
75339 | 75339 | 103704 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4700 Cabrillo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | 5980950.21824 | 2110299.88198 | 37.7733753570212 | -122.50936099615801 | (37.7733753570212, -122.509360996158) | |||
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) | |||
24690 | 24690 | 103701 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4700 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | 5980981.42101 | 2110300.97358 | 37.7733801939619 | -122.50925314442 | (37.7733801939619, -122.50925314442) | |||
153493 | 153493 | 118477 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 562 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5981021.8691 | 2111857.25612 | 37.7776556713315 | -122.509228826135 | (37.7776556713315, -122.509228826135) | |||
159650 | 159650 | 109509 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7200X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5980988.44063 | 2109621.98513 | 37.7715163048766 | -122.50917843155399 | (37.7715163048766, -122.509178431554) | |||
31425 | 31425 | 119228 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 701 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5981020.55796 | 2110899.83837 | 37.7750268077692 | -122.509162246597 | (37.7750268077692, -122.509162246597) | |||
37608 | 37608 | 119226 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 715 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5981020.44403 | 2110823.32053 | 37.774816705617106 | -122.509156957318 | (37.7748167056171, -122.509156957318) | |||
157477 | 157477 | 119227 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 711 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 5981021.77199 | 2110849.56022 | 37.7748888303639 | -122.50915431266199 | (37.7748888303639, -122.509154312662) |
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");