trees
8,758 rows where qSpecies_id = 16 sorted by Zip Codes descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▲ | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408 | 109629 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200X GELLERT DR | 30 | Median : Cutout | Tree | DPW 1 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||||
2361 | 256460 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 9 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
3330 | 213252 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 239 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5991927.67162 | 2090111.22138 | 37.7185836258199 | -122.4699185829 | (37.7185836258199, -122.4699185829) | 9 | 8 | 6 | 64 | 24 | |||
3548 | 296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3451X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X3 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | 1 | 8 | 4 | 64 | 14 | |||
3811 | 32184 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 191 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35516 | 5984219.12182319 | 2094256.3665376 | 37.7295164954065 | -122.49686924842 | (37.7295164954065, -122.49686924842) | 1 | 8 | 4 | 64 | 35 | ||
3999 | 213261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 255 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992959.15066 | 2088902.16567 | 37.7153234215169 | -122.466265391939 | (37.7153234215169, -122.466265391939) | 9 | 8 | 6 | 64 | 24 | |||
4153 | 19360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 711 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992081.20032 | 2089838.16122 | 37.7178427427344 | -122.469368036824 | (37.7178427427344, -122.469368036824) | 9 | 8 | 6 | 64 | 24 | |||
4197 | 262260 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
5991 | 217563 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5991900.5999 | 2088650.2079 | 37.714570473344 | -122.469905841257 | (37.714570473344, -122.469905841257) | 9 | 8 | 6 | 64 | 24 | |||
6030 | 19323 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X5 | 5993467.32802 | 2089853.93143 | 37.7179660496774 | -122.4645779904 | (37.7179660496774, -122.4645779904) | 9 | 8 | 6 | 64 | 24 | |||
6775 | 256471 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 15 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
10436 | 105254 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 130 GONZALEZ DR | Front Yard : Yard | Tree | Private 2 | 2 | 5990327 | 2090136 | 37.7185590045312 | -122.47545320092 | (37.7185590045312, -122.47545320092) | 1 | 8 | 4 | 64 | 14 | |||||
11238 | 1253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3802X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X5 | 5992813.09767 | 2087592.82096 | 37.7117198470729 | -122.466675091581 | (37.7117198470729, -122.466675091581) | 9 | 8 | 4 | 64 | 24 | ||
12017 | 213228 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 Bright St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5993764.44098 | 2088418.41063 | 37.7140415764298 | -122.46344689056 | (37.7140415764298, -122.46344689056) | 9 | 8 | 6 | 64 | 24 | |||
12437 | 1235 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3645 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5993271.90922 | 2087553.28553 | 37.7116377596374 | -122.465086457186 | (37.7116377596374, -122.465086457186) | 9 | 8 | 4 | 64 | 24 | |||
12474 | 51019 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 251 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47497 | 5992948.45681034 | 2088862.24435583 | 37.7152131901669 | -122.466299454682 | (37.7152131901669, -122.466299454682) | 9 | 8 | 6 | 64 | 24 | |||
13141 | 386 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3721X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | |||
15037 | 262257 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
17777 | 219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2949 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 5X8 | 5990525.93487 | 2095591.0616 | 37.7335487664486 | -122.475163590944 | (37.7335487664486, -122.475163590944) | 1 | 8 | 4 | 64 | 35 | |||
18388 | 217560 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5991890.4732 | 2088641.6156 | 37.7145462955922 | -122.469940217678 | (37.7145462955922, -122.469940217678) | 9 | 8 | 6 | 64 | 24 | |||
18983 | 262256 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4210 Ocean Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |||
20674 | 217568 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5991802.0948 | 2088763.4428 | 37.7148756943238 | -122.470254552609 | (37.7148756943238, -122.470254552609) | 9 | 8 | 6 | 64 | 24 | |||
21006 | 31183 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 627 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34881 | 5992393.27316776 | 2089825.88959744 | 37.7178270773306 | -122.468288456554 | (37.7178270773306, -122.468288456554) | 9 | 8 | 6 | 64 | 24 | ||
21654 | 177726 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5989405.70354 | 2089245.56508 | 37.7160606434521 | -122.478572628528 | (37.7160606434521, -122.478572628528) | 1 | 8 | 4 | 64 | 14 | ||||
21715 | 1234 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3633 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993305.81701 | 2087547.31495 | 37.7116233210332 | -122.464968830366 | (37.7116233210332, -122.464968830366) | 9 | 8 | 4 | 64 | 24 | |||
22302 | 213174 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1385 Holloway Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5991471.72957 | 2091205.18544 | 37.7215610158113 | -122.471574247351 | (37.7215610158113, -122.471574247351) | 9 | 8 | 6 | 64 | 24 | ||||
26727 | 213267 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 Sargent St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992669.53864 | 2089173.08469 | 37.7160505854524 | -122.467286097274 | (37.7160505854524, -122.467286097274) | 9 | 8 | 6 | 64 | 24 | |||
27102 | 177715 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988076.41192 | 2090188.68677 | 37.7185729508557 | -122.483236326522 | (37.7185729508557, -122.483236326522) | 1 | 8 | 4 | 64 | 14 | ||||
27229 | 19352 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/16/1998 12:00:00 AM | 3 | 3X3 | 5992301.66271 | 2089835.42474 | 37.7178479668989 | -122.468605803823 | (37.7178479668989, -122.468605803823) | 9 | 8 | 6 | 64 | 24 | ||
27360 | 11818 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
27750 | 110300 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3521 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5993646.27224 | 2087441.41839 | 37.7113521790304 | -122.463784453814 | (37.7113521790304, -122.463784453814) | 9 | 8 | 4 | 64 | 24 | |||
27790 | 1239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3702X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3X5 | 5993039.27607 | 2087635.23978 | 37.711849369237 | -122.465896444163 | (37.711849369237, -122.465896444163) | 9 | 8 | 4 | 64 | 24 | |||
28499 | 185065 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Crestlake Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5987046.1967 | 2096207.6545 | 37.7350394726269 | -122.48723916054 | (37.7350394726269, -122.48723916054) | 1 | 8 | 3 | 64 | 35 | |||
30386 | 236 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2996X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X5 | 5990618.96661 | 2095242.77985 | 37.7325978647004 | -122.474816544366 | (37.7325978647004, -122.474816544366) | 1 | 8 | 4 | 64 | 40 | |||
30531 | 11610 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X3 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
31593 | 89364 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2690 Ocean Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51942 | 5990665.5 | 2095192.3 | 37.7324619562673 | -122.474651985861 | (37.7324619562673, -122.474651985861) | 1 | 8 | 4 | 64 | 40 | ||||
32853 | 99729 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2645 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990840.1 | 2094977 | 37.7318809123737 | -122.474032655501 | (37.7318809123737, -122.474032655501) | 1 | 8 | 4 | 64 | 40 | ||||
36866 | 213275 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 7 | : | Tree | Private 2 | 7 | Width 0ft | 5991009.60744 | 2091179.22643 | 37.7214629924139 | -122.473169770586 | (37.7214629924139, -122.473169770586) | 9 | 8 | 4 | 64 | 40 | |||
38473 | 213276 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 8 | : | Tree | Private 2 | 6 | Width 0ft | 5991051.68263 | 2091187.7754 | 37.721488901863 | -122.473024952766 | (37.721488901863, -122.473024952766) | 9 | 8 | 4 | 64 | 40 | |||
38746 | 217564 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5991893.5419 | 2088652.6629 | 37.7145768061888 | -122.469930414978 | (37.7145768061888, -122.469930414978) | 9 | 8 | 6 | 64 | 24 | |||
40208 | 175046 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 3ft | 5991566.54873 | 2087591.25852 | 37.7116435395983 | -122.470983349614 | (37.7116435395983, -122.470983349614) | 9 | 8 | 4 | 64 | 24 | |||
41432 | 177712 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3597 Alemany Blvd | 2 | : | Tree | Private 2 | 18 | Width 3ft | 5993573.43523 | 2087465.73541 | 37.7114147502636 | -122.464037959205 | (37.7114147502636, -122.464037959205) | 9 | 8 | 4 | 64 | 24 | |||
43122 | 1232 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3609 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 5993415.10362 | 2087526.3221 | 37.7115719805367 | -122.464589586241 | (37.7115719805367, -122.464589586241) | 9 | 8 | 4 | 64 | 24 | |||
44394 | 96864 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620 Palmetto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 2x2 | 5991921.11564 | 2087237.00736 | 37.7106913517985 | -122.469732108476 | (37.7106913517985, -122.469732108476) | 9 | 8 | 4 | 64 | 24 | |||
45130 | 19329 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 236 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5993303.7779 | 2089855.08219 | 37.7179597795907 | -122.46514339057 | (37.7179597795907, -122.46514339057) | 9 | 8 | 6 | 64 | 24 | |||
46185 | 256462 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 11 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
47136 | 185063 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20 Crestlake Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 0ft | 5989067.2897 | 2096124.6086 | 37.7349290995059 | -122.480245525571 | (37.7349290995059, -122.480245525571) | 1 | 8 | 3 | 64 | 35 | |||
47288 | 2743 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 731X Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992122.3671804 | 2089830.3132143 | 37.7178235729337 | -122.469225171627 | (37.7178235729337, -122.469225171627) | 9 | 8 | 6 | 64 | 24 | |||
48001 | 185066 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Crestlake Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 0ft | 5987075.6475 | 2096199.9602 | 37.7350200634269 | -122.487136775025 | (37.7350200634269, -122.487136775025) | 1 | 8 | 3 | 64 | 35 | |||
49009 | 213271 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 68 Rossmoor Dr | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5990888.94102 | 2094543.24113 | 37.730692748968 | -122.473832170746 | (37.730692748968, -122.473832170746) | 9 | 8 | 4 | 64 | 40 | |||
49252 | 256461 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 10 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
49547 | 32186 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 439 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35518 | 5984780.78334223 | 2095663.00503944 | 37.7334116463821 | -122.49503123788 | (37.7334116463821, -122.49503123788) | 1 | 8 | 4 | 64 | 35 | ||
49554 | 32187 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 439 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35518 | 5984780.78334223 | 2095663.00503944 | 37.7334116463821 | -122.49503123788 | (37.7334116463821, -122.49503123788) | 1 | 8 | 4 | 64 | 35 | ||
49854 | 213260 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 247 Ramsell St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 5992958.0895 | 2088851.66693 | 37.715184702892 | -122.466265391946 | (37.715184702892, -122.466265391946) | 9 | 8 | 6 | 64 | 24 | |||
51155 | 213257 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Byxbee St | 5 | : | Tree | Private 2 | 14 | Width 3ft | 5991914.21978 | 2088676.05712 | 37.7146422363243 | -122.469860646752 | (37.7146422363243, -122.469860646752) | 9 | 8 | 6 | 64 | 24 | |||
51548 | 11638 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 5991362.1134613 | 2093824.2614448 | 37.7287460056648 | -122.472143968924 | (37.7287460056648, -122.472143968924) | 9 | 8 | 4 | 64 | 40 | |||
54263 | 99731 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991009.5 | 2094863.7 | 37.7315796303384 | -122.473438749026 | (37.7315796303384, -122.473438749026) | 1 | 8 | 4 | 64 | 40 | ||||
55260 | 213230 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 Bright St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5993766.05565 | 2088461.67012 | 37.7141604497148 | -122.463444447129 | (37.7141604497148, -122.463444447129) | 9 | 8 | 6 | 64 | 24 | |||
55988 | 217562 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5991901.2136 | 2088641.0019 | 37.7145452313743 | -122.469903050206 | (37.7145452313743, -122.469903050206) | 9 | 8 | 6 | 64 | 24 | |||
56989 | 177719 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987711.1405 | 2090208.21579 | 37.7186053084801 | -122.484500336223 | (37.7186053084801, -122.484500336223) | 1 | 8 | 4 | 64 | 14 | ||||
58609 | 256463 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 12 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
59510 | 280 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3250 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2 | 5990676.28121 | 2094101.04473 | 37.7294662695904 | -122.474535101923 | (37.7294662695904, -122.474535101923) | 9 | 8 | 4 | 64 | 40 | |||
60703 | 213249 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 28 Monticello St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 5991688.58808 | 2088978.22145 | 37.7154588612137 | -122.470662510183 | (37.7154588612137, -122.470662510183) | 9 | 8 | 6 | 64 | 24 | |||
62363 | 11621 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80X Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
64087 | 298 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3451X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | 1 | 8 | 4 | 64 | 14 | |||
64520 | 235 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2994 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1994 12:00:00 AM | 14 | 3X3 | 5990616.42942 | 2095306.68002 | 37.7327731713422 | -122.474829978418 | (37.7327731713422, -122.474829978418) | 1 | 8 | 4 | 64 | 40 | ||
64752 | 102570 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 107 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/04/2013 12:00:00 AM | Permit Number 769786 | 5990356.6 | 2090236.8 | 37.7188374921756 | -122.475358242341 | (37.7188374921756, -122.475358242341) | 1 | 8 | 4 | 64 | 14 | |||
65330 | 217561 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 5991880.3465 | 2088659.414 | 37.7145945802946 | -122.469976514468 | (37.7145945802946, -122.469976514468) | 9 | 8 | 6 | 64 | 24 | |||
66546 | 213165 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 951 Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5991289.23593 | 2091020.58342 | 37.7210435845665 | -122.472191622972 | (37.7210435845665, -122.472191622972) | 9 | 8 | 6 | 64 | 24 | |||
66605 | 256473 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 17 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
67811 | 24815 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1410 Holloway Ave | 1 | Median : Cutout | Tree | DPW 1 | 03/29/1996 12:00:00 AM | 6 | 5X5 | 5991090.406971 | 2091239.8933513 | 37.7216342467929 | -122.472894893115 | (37.7216342467929, -122.472894893115) | 9 | 8 | 4 | 64 | 40 | ||
72193 | 114077 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 32 HIGUERA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
72570 | 213258 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Byxbee St | 6 | : | Tree | Private 2 | 14 | Width 3ft | 5991914.34073 | 2088658.3813 | 37.7145937097982 | -122.469858942549 | (37.7145937097982, -122.469858942549) | 9 | 8 | 6 | 64 | 24 | |||
72680 | 177720 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5987685.94194 | 2090080.2958 | 37.718252605151 | -122.484578058334 | (37.718252605151, -122.484578058334) | 1 | 8 | 4 | 64 | 14 | ||||
73000 | 114215 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 16 HIGUERA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988029 | 2090212 | 37.7186342037977 | -122.483401916227 | (37.7186342037977, -122.483401916227) | 1 | 8 | 4 | 64 | 14 | ||||
73200 | 213263 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Victoria St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993232.40294 | 2090201.31031 | 37.7189063223512 | -122.465415237623 | (37.7189063223512, -122.465415237623) | 9 | 8 | 6 | 64 | 24 | |||
73521 | 254161 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5991180 | 2089593 | 37.717117469349 | -122.472465193375 | (37.717117469349, -122.472465193375) | 9 | 8 | 6 | 64 | 24 | ||||
75111 | 1302 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4000X Alemany Blvd | 10 | Median : Cutout | Tree | DPW 1 | 25 | 10 | 5991739.11571 | 2087020.66511 | 37.7100868068254 | -122.470345390352 | (37.7100868068254, -122.470345390352) | 9 | 8 | 4 | 64 | 24 | |||
75239 | 213279 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3596 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5990577.22167 | 2092622.63953 | 37.7254012000893 | -122.474769693263 | (37.7254012000893, -122.474769693263) | 9 | 8 | 4 | 64 | 40 | |||
78213 | 29612 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900X Junipero Serra Blvd | 20 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991180.99541 | 2090994.86594 | 37.7209667060276 | -122.472563900905 | (37.7209667060276, -122.472563900905) | 9 | 8 | 4 | 64 | 40 | ||
79707 | 250 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3060 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 38 | 2x10 | 5990631.19828 | 2094871.04681 | 37.7315778886877 | -122.474747134678 | (37.7315778886877, -122.474747134678) | 1 | 8 | 4 | 64 | 40 | |||
79781 | 66295 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2101 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1990 12:00:00 AM | 9 | Permit Number 29406 | 5986495.0816 | 2097061.7763 | 37.7373525128537 | -122.489207312631 | (37.7373525128537, -122.489207312631) | 1 | 8 | 3 | 64 | 35 | ||
82290 | 11757 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 901X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | 9 | 8 | 6 | 64 | 24 | |||
82952 | 213277 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Holloway Ave | 9 | : | Tree | Private 2 | 9 | Width 0ft | 5991091.24453 | 2091195.38436 | 37.7215120845989 | -122.472888754009 | (37.7215120845989, -122.472888754009) | 9 | 8 | 4 | 64 | 40 | |||
84007 | 320 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3486X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
84508 | 177725 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 0 Higuera Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988008.57998 | 2090059.31291 | 37.7182137751147 | -122.483461311716 | (37.7182137751147, -122.483461311716) | 1 | 8 | 4 | 64 | 14 | ||||
84826 | 174950 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 309 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987294 | 2096147 | 37.7348873783654 | -122.486377975564 | (37.7348873783654, -122.486377975564) | 1 | 8 | 3 | 64 | 35 | ||||
84894 | 105259 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 466 GONZALEZ DR | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | 1 | 8 | 4 | 64 | 14 | ||||
85615 | 11723 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 899X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
86282 | 19341 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 508 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/16/1998 12:00:00 AM | 6 | 3X3 | 5992648.47976 | 2089862.00209 | 37.7179409702755 | -122.467408952775 | (37.7179409702755, -122.467408952775) | 9 | 8 | 6 | 64 | 24 | ||
87912 | 258213 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 225X Head St | 2 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5993438 | 2087500 | 37.7115010262354 | -122.4645085409 | (37.7115010262354, -122.4645085409) | 9 | 8 | 4 | 64 | 24 | ||||
88855 | 1287 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3946 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5992400.04881 | 2087412.81679 | 37.7112017530194 | -122.468089602866 | (37.7112017530194, -122.468089602866) | 9 | 8 | 4 | 64 | 24 | |||
89010 | 24381 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1430 Holloway Ave | 1 | Median : Cutout | Tree | DPW 1 | 05/26/1995 12:00:00 AM | 6 | 5X5 | 5990969.5329007 | 2091213.2242802 | 37.7215540216702 | -122.473310774241 | (37.7215540216702, -122.473310774241) | 9 | 8 | 4 | 64 | 40 | ||
90044 | 11730 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | |||
90590 | 213253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Byxbee St | 1 | : | Tree | Private 2 | 18 | Width 3ft | 5991916.13394 | 2088790.40392 | 37.7149563155577 | -122.469862350985 | (37.7149563155577, -122.469862350985) | 9 | 8 | 6 | 64 | 24 | |||
90621 | 209805 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4994 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5990631.22098 | 2093516.7238 | 37.7278592603924 | -122.474648248823 | (37.7278592603924, -122.474648248823) | 9 | 8 | 4 | 64 | 40 | |||
90817 | 175379 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5991355.5778 | 2088944.15197 | 37.7153460520673 | -122.471811049665 | (37.7153460520673, -122.471811049665) | 9 | 8 | 6 | 64 | 24 | |||
92577 | 114401 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1X HIGUERA AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
96463 | 217567 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5991851.8076 | 2088697.159 | 37.7146965691194 | -122.47007790234 | (37.7146965691194, -122.47007790234) | 9 | 8 | 6 | 64 | 24 | |||
96724 | 213256 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Byxbee St | 4 | : | Tree | Private 2 | 14 | Width 3ft | 5991914.37776 | 2088706.98259 | 37.7147271593 | -122.469862350964 | (37.7147271593, -122.469862350964) | 9 | 8 | 6 | 64 | 24 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );