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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80072 | 80072 | 11492 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
81124 | 81124 | 11506 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
85301 | 85301 | 11491 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
87201 | 87201 | 11504 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
91987 | 91987 | 11505 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
94164 | 94164 | 11508 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
98320 | 98320 | 11502 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
102462 | 102462 | 11493 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
104769 | 104769 | 11500 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
107854 | 107854 | 11501 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
119826 | 119826 | 11490 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 100 Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
123191 | 123191 | 11510 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
126552 | 126552 | 11503 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
129014 | 129014 | 11507 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
138869 | 138869 | 11509 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
140516 | 140516 | 11495 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
15112 | 15112 | 11554 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Jennings St | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018972.44427 | 2097338.24769 | 37.7399538873755 | -122.37693587968398 | (37.7399538873755, -122.376935879684) | ||
13240 | 13240 | 187608 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
13250 | 13250 | 187606 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
13256 | 13256 | 187607 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
23085 | 23085 | 11553 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 29 | 3X3 | 6018940.8378099995 | 2097294.9489700003 | 37.7398332568108 | -122.377042159778 | (37.7398332568108, -122.377042159778) | ||
23241 | 23241 | 11550 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6018907.35155 | 2097248.08652 | 37.7397027373041 | -122.37715469195601 | (37.7397027373041, -122.377154691956) | |||
15985 | 15985 | 11549 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018893.31945 | 2097233.60379 | 37.7396621976446 | -122.37720220492399 | (37.7396621976446, -122.377202204924) | |||
14511 | 14511 | 11548 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018882.85871 | 2097216.8887400003 | 37.7396157251883 | -122.377237214629 | (37.7396157251883, -122.377237214629) | |||
16881 | 16881 | 11487 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6018880.35523 | 2097308.40588 | 37.7398668752499 | -122.37725221891 | (37.7398668752499, -122.37725221891) | |||
16854 | 16854 | 11488 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/1993 12:00:00 AM | 6 | 4X4 | 6018872.157000001 | 2097296.32677 | 37.7398332567899 | -122.377279727371 | (37.7398332567899, -122.377279727371) | ||
16472 | 16472 | 11547 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018868.04549 | 2097199.54045 | 37.7395672742039 | -122.377287229525 | (37.7395672742039, -122.377287229525) | |||
13810 | 13810 | 11546 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018856.19666 | 2097185.73418 | 37.7395287121888 | -122.37732724037701 | (37.7395287121888, -122.377327240377) | |||
15245 | 15245 | 11544 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Jennings St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018840.43674 | 2097157.24182 | 37.7394496095988 | -122.37737975539 | (37.7394496095988, -122.37737975539) | ||
168459 | 168459 | 188642 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Cargo Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6018846.51114 | 2097536.89048 | 37.7404923843103 | -122.377385089264 | (37.7404923843103, -122.377385089264) | ||||
116499 | 116499 | 3555 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018831.8 | 2097475.1 | 37.7403219094469 | -122.377431668566 | (37.7403219094469, -122.377431668566) | ||
14775 | 14775 | 11542 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018808.16459 | 2097116.8368799998 | 37.739336887696396 | -122.377488536484 | (37.7393368876964, -122.377488536484) | |||
15231 | 15231 | 11541 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018795.49875 | 2097098.36536 | 37.7392854707446 | -122.377531048337 | (37.7392854707446, -122.377531048337) | |||
20656 | 20656 | 107549 | Significant Tree 6 | Tree(s) :: 17 | 198X Jennings St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | ||
78577 | 78577 | 107545 | DPW Maintained 3 | Tree(s) :: 17 | 198X Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | |||
85184 | 85184 | 107546 | DPW Maintained 3 | Tree(s) :: 17 | 198X Jennings St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | |||
102762 | 102762 | 107548 | DPW Maintained 3 | Tree(s) :: 17 | 198X Jennings St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | |
108486 | 108486 | 107550 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 198X Jennings St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | |||||
142715 | 142715 | 107544 | DPW Maintained 3 | Tree(s) :: 17 | 198X Jennings St | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | ||
146073 | 146073 | 107543 | DPW Maintained 3 | Tree(s) :: 17 | 198X Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | |||
115107 | 115107 | 107540 | DPW Maintained 3 | Tree(s) :: 17 | 198X JENNINGS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.0 | 2097136.0 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | ||
124630 | 124630 | 107538 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 198X JENNINGS ST | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6018784.0 | 2097136.0 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | |||||
140881 | 140881 | 107539 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 198X JENNINGS ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6018784.0 | 2097136.0 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | |||||
13473 | 13473 | 11540 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018782.49291 | 2097080.98118 | 37.7392370206652 | -122.37757481115 | (37.7392370206652, -122.37757481115) | |||
97811 | 97811 | 11555 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018780.12501 | 2097120.54601 | 37.7393455274029 | -122.377585743327 | (37.7393455274029, -122.377585743327) | |||
16384 | 16384 | 11539 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018768.44621 | 2097065.7782599998 | 37.739194502529294 | -122.37762232410601 | (37.7391945025293, -122.377622324106) | |||
118205 | 118205 | 11552 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018755.385009999 | 2097093.20201 | 37.7392690830796 | -122.377669387059 | (37.7392690830796, -122.377669387059) | |||
13656 | 13656 | 3557 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 2 | 3X3 | 6018758.221530001 | 2097553.75967 | 37.740533839473294 | -122.377691534151 | (37.7405338394733, -122.377691534151) | ||
86584 | 86584 | 16461 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018746.801501201 | 2097101.6577332001 | 37.739291827880294 | -122.37769965200899 | (37.7392918278803, -122.377699652009) | |||
89329 | 89329 | 16462 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018746.801501201 | 2097101.6577332001 | 37.739291827880294 | -122.37769965200899 | (37.7392918278803, -122.377699652009) | |||
97946 | 97946 | 16466 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018746.801501201 | 2097101.6577332001 | 37.739291827880294 | -122.37769965200899 | (37.7392918278803, -122.377699652009) | |||
106236 | 106236 | 16460 | DPW Maintained 3 | Tree(s) :: 17 | 2X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3X3 | Permit Number 774049 | 6018746.801501201 | 2097101.6577332001 | 37.739291827880294 | -122.37769965200899 | (37.7392918278803, -122.377699652009) | |
14711 | 14711 | 11538 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018744.95776 | 2097030.5986900001 | 37.7390966122121 | -122.377701096637 | (37.7390966122121, -122.377701096637) | |||
16379 | 16379 | 11537 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018733.38325 | 2097012.4655799998 | 37.7390461845215 | -122.37773985832399 | (37.7390461845215, -122.377739858324) | |||
13840 | 13840 | 3556 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018742.23536 | 2097565.89761 | 37.740566287010395 | -122.377747650939 | (37.7405662870104, -122.377747650939) | |||
77416 | 77416 | 107558 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
79120 | 79120 | 107551 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
81584 | 81584 | 107564 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
83430 | 83430 | 107562 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
84607 | 84607 | 107559 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
98961 | 98961 | 107560 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
103606 | 103606 | 107561 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 12 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
108428 | 108428 | 107553 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
112266 | 112266 | 107554 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |||
120274 | 120274 | 107563 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
123339 | 123339 | 107555 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
125335 | 125335 | 107556 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
128143 | 128143 | 107552 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
142291 | 142291 | 107557 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
13507 | 13507 | 11536 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018721.15121 | 2096997.58655 | 37.739004655647 | -122.377781119206 | (37.739004655647, -122.377781119206) | |||
110882 | 110882 | 11545 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018711.11401 | 2097026.79601 | 37.7390843059742 | -122.377817850373 | (37.7390843059742, -122.377817850373) | |||
78194 | 78194 | 11543 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Jennings St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018704.60401 | 2097015.07701 | 37.7390517691962 | -122.377839546083 | (37.7390517691962, -122.377839546083) | ||
15019 | 15019 | 11534 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018698.318659999 | 2096968.53923 | 37.7389236393092 | -122.37785804901002 | (37.7389236393092, -122.37785804901) | |||
4990 | 4990 | 3550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 201X Cargo Way | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1990 12:00:00 AM | 6 | 3X3 | 6018708.52549 | 2097590.55589 | 37.7406321362531 | -122.377865918974 | (37.7406321362531, -122.377865918974) | ||
72210 | 72210 | 16475 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
115131 | 115131 | 16473 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
118199 | 118199 | 16470 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 9X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
140227 | 140227 | 16472 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
142877 | 142877 | 16478 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 9X Newhall St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/1997 12:00:00 AM | 6 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | ||
15591 | 15591 | 11533 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018685.57005 | 2096950.68125 | 37.738873902319 | -122.377900889128 | (37.738873902319, -122.377900889128) | |||
5011 | 5011 | 3549 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 07:34:00 AM | 3 | 3X3 | 6018691.67406 | 2097603.0587400002 | 37.740665537995895 | -122.377925053006 | (37.7406655379959, -122.377925053006) | ||
15661 | 15661 | 11532 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018674.73047 | 2096936.9392900001 | 37.738835572289794 | -122.377937414197 | (37.7388355722898, -122.377937414197) | |||
92067 | 92067 | 10533 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 110 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2000 12:00:00 AM | 6 | 3X4 | 6018619.6109690005 | 2094462.9973511002 | 37.7320395756797 | -122.377956322439 | (37.7320395756797, -122.377956322439) | ||
101596 | 101596 | 10535 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 110 Harbor Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018619.6109690005 | 2094462.9973511002 | 37.7320395756797 | -122.377956322439 | (37.7320395756797, -122.377956322439) | |||
141185 | 141185 | 10534 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 110 Harbor Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/10/1998 12:00:00 AM | 6 | 3X4 | 6018619.6109690005 | 2094462.9973511002 | 37.7320395756797 | -122.377956322439 | (37.7320395756797, -122.377956322439) | ||
127949 | 127949 | 10536 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 112 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018616.6219539 | 2094466.5861691001 | 37.7320492651591 | -122.37796690523999 | (37.7320492651591, -122.37796690524) | |||
16675 | 16675 | 16465 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018666.35636 | 2097096.27558 | 37.7392726167438 | -122.37797742504 | (37.7392726167438, -122.37797742504) | |||
13546 | 13546 | 11531 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018661.768080001 | 2096921.7146599998 | 37.7387930541475 | -122.37798117610501 | (37.7387930541475, -122.377981176105) | |||
16339 | 16339 | 3548 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018674.8366 | 2097616.25665 | 37.7407008489755 | -122.37798418701999 | (37.7407008489755, -122.37798418702) | |||
15806 | 15806 | 11530 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018648.41512 | 2096905.05742 | 37.7387465808009 | -122.37802618897 | (37.7387465808009, -122.37802618897) | |||
2210 | 2210 | 10530 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 101 Harbor Rd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/2004 12:00:00 AM | 3 | 3X4 | 6018595.5303624 | 2094415.3270740001 | 37.7319073553399 | -122.378036267473 | (37.7319073553399, -122.378036267473) | ||
51553 | 51553 | 10529 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 105 Harbor Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018595.5303624 | 2094415.3270740001 | 37.7319073553399 | -122.378036267473 | (37.7319073553399, -122.378036267473) | |||
86052 | 86052 | 10528 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 105 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6018595.5303624 | 2094415.3270740001 | 37.7319073553399 | -122.378036267473 | (37.7319073553399, -122.378036267473) | ||
108832 | 108832 | 10531 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 105 Harbor Rd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018595.5303624 | 2094415.3270740001 | 37.7319073553399 | -122.378036267473 | (37.7319073553399, -122.378036267473) | |||
16233 | 16233 | 3547 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6018659.18869 | 2097627.86643 | 37.7407318647912 | -122.378039097821 | (37.7407318647912, -122.378039097821) | |||
15014 | 15014 | 11529 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018637.527419999 | 2096885.1095 | 37.7386912077413 | -122.37806244962401 | (37.7386912077413, -122.378062449624) | |||
105734 | 105734 | 10539 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 130 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018576.7086503 | 2094524.5653192 | 37.732206265014206 | -122.378108918967 | (37.7322062650142, -122.378108918967) | |||
13431 | 13431 | 11527 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018609.30332 | 2096848.22468 | 37.738588373848295 | -122.378157476493 | (37.7385883738483, -122.378157476493) | |||
16604 | 16604 | 3546 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018623.4169 | 2097653.5081700003 | 37.740800300486704 | -122.378164564055 | (37.7408003004867, -122.378164564055) | ||
16833 | 16833 | 16463 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018612.88561 | 2097134.8000900003 | 37.7393754506279 | -122.378164978648 | (37.7393754506279, -122.378164978648) |
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");