1,011 rows where qLegalStatus_id = 2 sorted by Zip Codes

View and edit SQL

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)
50738 253752 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
52682 192595 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1995 12:00:00 AM 3 Width 4ft Permit Number 770747 6008285.14461 2110684.68439 37.7760057386966 -122.414832573262 (37.7760057386966, -122.414832573262) 8 2 9 28853 34
57131 192563 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008747.97709 2111280.89227 37.7776687794229 -122.413273679445 (37.7776687794229, -122.413273679445) 8 2 9 28853 34
57149 115098 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010148.06204 2111925.42664 37.7795170247346 -122.408475763058 (37.7795170247346, -122.408475763058) 14 2 9 28853 34
57241 253248 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 570 Jessie St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.13768 37.7809123781536 -122.409958002933 (37.7809123781536, -122.409958002933) 14 2 9 28853 34
61025 253495 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 13 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
61214 15236 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2015 12:00:00 AM 3 3X3 Permit Number 770747 6008261.49106 2110663.48431 37.7759461992201 -122.414912896556 (37.7759461992201, -122.414912896556) 8 2 9 28853 34
61405 253746 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 12 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
61672 15237 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2015 12:00:00 AM 3 3X3 Permit Number 770747 6008256.52807 2110680.03106 37.7759913537931 -122.414931236282 (37.7759913537931, -122.414931236282) 8 2 9 28853 34
62404 253750 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
67103 253756 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 41x Division St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 5x5   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
71327 253751 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
71488 190612 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 9 Washburn St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2018 12:00:00 AM 3 Width 3ft Permit Number 775218 6008236.46776 2110619.04505 37.7758227734432 -122.414996312823 (37.7758227734432, -122.414996312823) 8 2 9 28853 34
73445 253735 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
74052 201694 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009941.3987 2109939.6045 37.7740528464887 -122.409050544971 (37.7740528464887, -122.409050544971) 8 2 9 28853 34
74410 201698 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6010000.12901 2109874.7171 37.7738779706193 -122.408842806955 (37.7738779706193, -122.408842806955) 8 2 9 28853 34
79696 253247 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 570 Jessie St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.13768 37.7809123781536 -122.409958002933 (37.7809123781536, -122.409958002933) 14 2 9 28853 34
84993 253492 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 10 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
85377 253490 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 8 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
85953 201697 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009987.20299 2109888.7351 37.7739157367544 -122.408888509595 (37.7739157367544, -122.408888509595) 8 2 9 28853 34
88035 113653 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
90566 120518 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 520 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010156 2108818 37.7709851997146 -122.408229076629 (37.7709851997146, -122.408229076629) 8 2 9 28853 34
93105 253487 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
93259 253749 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 2x Rhode Island St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
95654 253488 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
96128 73589 Planning Code 138.1 required 2 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 468 Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1995 12:00:00 AM 12 3x3 Permit Number 770905 6010928.13640467 2111848.51157587 37.7793494887795 -122.405771720076 (37.7793494887795, -122.405771720076) 14 2 9 28853 34
98537 196590 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 43 Lafayette St 2 : Tree Private 2     10 Width 3ft Permit Number 772992 6007565.69447 2109618.27361 37.7730371773558 -122.417245760983 (37.7730371773558, -122.417245760983) 8 2 9 28853 19
98758 101942 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010108.29372 2111885.47528 37.7794051005107 -122.408610520167 (37.7794051005107, -122.408610520167) 14 2 9 28853 34
98874 255694 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
99698 113643 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 5 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2016 12:00:00 AM 3 4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
105665 253493 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 11 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
105773 255696 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 6 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
106809 29017 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 120 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/09/2014 12:00:00 AM 6 3x3 Permit Number 770901 6008044.5664857 2110308.5131992 37.7749593412658 -122.415638158484 (37.7749593412658, -122.415638158484) 8 2 9 28853 34
107192 201696 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009973.11931 2109904.86997 37.773959250457 -122.408938366227 (37.773959250457, -122.408938366227) 8 2 9 28853 34
107596 151878 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1450 15th St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007623.77597 2107385.08821 37.7669086438472 -122.416886599646 (37.7669086438472, -122.416886599646) 8 4 7 28853 19
108346 255693 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
109444 255700 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 510 Townsend St 10 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
112760 196591 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 43 Lafayette St 3 : Tree Private 2     13 Width 3ft Permit Number 772992 6007555.65106 2109624.06249 37.7730525072055 -122.417280912782 (37.7730525072055, -122.417280912782) 8 2 9 28853 19
112949 244834 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1875 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2017 12:00:00 AM 3 Width 3ft   6006796.01232 2107481.11788 37.7671257231045 -122.419756521569 (37.7671257231045, -122.419756521569) 8 4 7 28853 19
115603 251289 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
116197 253754 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 8 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
117291 113647 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 4 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2016 12:00:00 AM 3 4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
119839 152118 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 44 Woodward St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2018 12:00:00 AM 3 3x3 Permit Number 780873 6006474.76942 2108215.62621 37.7691244070031 -122.420919809024 (37.7691244070031, -122.420919809024) 8 4 7 28853 19
121031 253742 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 8 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
121557 113652 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
121637 253479 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
122740 115096 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010119.08101 2111896.4319 37.7794357889593 -122.408573975335 (37.7794357889593, -122.408573975335) 14 2 9 28853 34
123458 253739 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
124821 113644 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2016 12:00:00 AM 3 4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
128069 104819 Planning Code 138.1 required 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 468 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3 3X3 Permit Number 770905 6011018.41682 2111922.08536 37.7795565535331 -122.405464583724 (37.7795565535331, -122.405464583724) 14 2 9 28853 34
128513 199503 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1009 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010500.98308 2111924.50305 37.7795342467397 -122.407254787701 (37.7795342467397, -122.407254787701) 14 2 9 28853 34
128863 253475 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
129348 251179 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 1043 Minna St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6007668 2109797 37.7735336727503 -122.41690453761 (37.7735336727503, -122.41690453761) 8 2 9 28853 19
130377 113654 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
132587 199504 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1009 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010510.13491 2111932.18806 37.7795558601644 -122.407223669342 (37.7795558601644, -122.407223669342) 14 2 9 28853 34
134197 201699 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6010014.86815 2109861.25987 37.7738418457656 -122.408790872027 (37.7738418457656, -122.408790872027) 8 2 9 28853 34
134719 253755 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 41x Division St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 5x5   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
134827 255697 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 7 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
135281 253476 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
137539 113649 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
138609 251178 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 1043 Minna St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6007668 2109797 37.7735336727503 -122.41690453761 (37.7735336727503, -122.41690453761) 8 2 9 28853 19
139476 113655 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 901X JESSIE ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2016 12:00:00 AM 3 3x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
139534 253737 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
142538 253747 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
146805 121136 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1875 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 12/04/2017 12:00:00 AM 3 3x3   6006784.10346 2107469.87255 37.7670941752111 -122.419796914586 (37.7670941752111, -122.419796914586) 8 4 7 28853 19
152719 113648 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 6 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2016 12:00:00 AM 3 4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
154892 113645 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2016 12:00:00 AM 3 4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
158086 15247 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1401X Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2016 12:00:00 AM 3 3X3 Permit Number 770901 6007902.55668 2110326.57547 37.7750009522643 -122.416130681693 (37.7750009522643, -122.416130681693) 8 2 9 28853 34
158927 251290 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
159122 253486 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
159283 192594 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/09/1995 12:00:00 AM 2 Width 4ft Permit Number 770747 6008274.3646 2110675.08431 37.7759787734355 -122.414869184668 (37.7759787734355, -122.414869184668) 8 2 9 28853 34
161626 255692 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
162521 192596 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1335 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1995 12:00:00 AM 3 Width 4ft Permit Number 770747 6008295.90964 2110693.56586 37.7760307299718 -122.414795962779 (37.7760307299718, -122.414795962779) 8 2 9 28853 34
163114 253748 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 2x Rhode Island St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
164004 201690 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 324 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009863.47645 2110020.43216 37.7742704149776 -122.409325797764 (37.7742704149776, -122.409325797764) 8 2 9 28853 34
168133 121551 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1125 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2017 12:00:00 AM 3 3x3 Permit Number 778243 6009293.51408 2111653.12836 37.7787214646499 -122.411412777974 (37.7787214646499, -122.411412777974) 8 2 9 28853 34
168421 241673 Planning Code 138.1 required 2 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 21 Rosemont Pl 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/2018 12:00:00 AM 3 4x4 Permit Number 778206 6005133.3823 2108100.0759 37.7687314320489 -122.425551368812 (37.7687314320489, -122.425551368812) 8 4 5 28853 19
169960 192564 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
169973 253496 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 14 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
170272 31068 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1450 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007659.7746 2107385.50696 37.7669118184545 -122.4167621155 (37.7669118184545, -122.4167621155) 8 4 7 28853 19
171171 253477 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
173158 253738 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
174788 253736 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
175654 201688 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 324 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009806.99553 2110077.79875 37.7744247656342 -122.409525226004 (37.7744247656342, -122.409525226004) 8 2 9 28853 34
176162 121550 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1125 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2017 12:00:00 AM 3 3x3 Permit Number 778243 6009252.51421 2111618.01515 37.7786227523886 -122.411552131552 (37.7786227523886, -122.411552131552) 8 2 9 28853 34
176904 190611 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 9 Washburn St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2018 12:00:00 AM 3 Width 3ft Permit Number 775218 6008250.0486 2110605.54207 37.7757864606069 -122.41494837717 (37.7757864606069, -122.41494837717) 8 2 9 28853 34
177182 15246 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1401X Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2016 12:00:00 AM 3 3x3 Permit Number 770901 6007883.54199 2110310.54573 37.7749558692557 -122.416195322271 (37.7749558692557, -122.416195322271) 8 2 9 28853 34
178080 253744 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 10 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
180989 255698 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 8 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
181014 253484 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
181676 196592 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 43 Lafayette St 4 : Tree Private 2     8 Width 3ft Permit Number 772992 6007533.59843 2109642.31042 37.7731013709756 -122.417358489209 (37.7731013709756, -122.417358489209) 8 2 9 28853 19
182348 173697 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1401X Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2016 12:00:00 AM 3 3X3 Permit Number 770901 6007975.5805432 2110395.7628537 37.775195030009 -122.415882976003 (37.775195030009, -122.415882976003) 8 2 9 28853 34
183224 115097 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010133.89472 2111910.59383 37.779475503918 -122.408523727481 (37.779475503918, -122.408523727481) 14 2 9 28853 34
186212 253740 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
187618 253249 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 570 Jessie St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.13768 37.7809123781536 -122.409958002933 (37.7809123781536, -122.409958002933) 14 2 9 28853 34
190069 15235 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2015 12:00:00 AM 3 3X3 Permit Number 770747 6008256.52807 2110680.03106 37.7759913537931 -122.414931236282 (37.7759913537931, -122.414931236282) 8 2 9 28853 34
190324 253494 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 12 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
193569 253745 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 11 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
194194 255691 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
5835 118375 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 4x6   6014712.48727 2114662.02755 37.7872856671566 -122.392876855803 (37.7872856671566, -122.392876855803) 6 2 9 28855 6

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);