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) | ||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | |||||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 4988 | 4988 | 3545 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 201X Cargo Way | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 07:40:00 AM | 3 | 3X3 | 6018602.9683 | 2097669.9697 | 37.740844373569004 | -122.37823641090799 | (37.740844373569, -122.378236410908) | ||
| 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) | |||
| 14617 | 14617 | 11525 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018584.76615 | 2096814.86638 | 37.7384954262103 | -122.37824000008499 | (37.7384954262103, -122.378240000085) | |||
| 16434 | 16434 | 3544 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 54 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6018582.49326 | 2097682.52078 | 37.740877707832 | -122.378308077855 | (37.740877707832, -122.378308077855) | |||
| 827 | 827 | 191800 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2 Newhall St | 5 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 19 | Width 4ft | Permit Number 774049 | 6018580.4534 | 2097158.49779 | 37.739438732322704 | -122.37827876085301 | (37.7394387323227, -122.378278760853) | |
| 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) | |||
| 14283 | 14283 | 11524 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018572.85172 | 2096797.82035 | 37.7384479645089 | -122.378280011831 | (37.7384479645089, -122.378280011831) | |||
| 14781 | 14781 | 3543 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6018555.97345 | 2097704.22378 | 37.74093583821671 | -122.378401280909 | (37.7409358382167, -122.378401280909) | ||
| 791 | 791 | 191798 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2 Newhall St | 3 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 6 | Width 3ft | Permit Number 774049 | 6018546.987380001 | 2097184.73725 | 37.7395089360924 | -122.378396294176 | (37.7395089360924, -122.378396294176) | |
| 102490 | 102490 | 10537 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 125 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1992 12:00:00 AM | 12 | 3X4 | 6018546.167565 | 2094480.7523869 | 37.73208428002779 | -122.37821146712 | (37.7320842800278, -122.37821146712) | ||
| 14633 | 14633 | 11522 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018545.03968 | 2096763.4476400001 | 37.738352050906 | -122.37837378772801 | (37.738352050906, -122.378373787728) |
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");