194,517 rows sorted by XCoord descending

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)
174485 201834 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020718.56969 2092826.63123 37.7276618681873 -122.37058658062 (37.7276618681873, -122.37058658062) 10 3 8 58 1
146566 201835 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020706.7385 2092807.85492 37.7276096625463 -122.370626184075 (37.7276096625463, -122.370626184075) 10 3 8 58 1
132327 201583 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 501 Donahue St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020706.31037 2093011.12913 37.7281677917075 -122.370641712658 (37.7281677917075, -122.370641712658) 10 3 8 58 1
108420 201836 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 6 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020688.4191 2092782.87071 37.7275400550072 -122.370687788509 (37.7275400550072, -122.370687788509) 10 3 8 58 1
129793 201837 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020676.58787 2092764.09442 37.7274878493838 -122.370727391967 (37.7274878493838, -122.370727391967) 10 3 8 58 1
104666 201582 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 601 Donahue St 7 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6020666.22255 2092954.70506 37.7280106612574 -122.370776399631 (37.7280106612574, -122.370776399631) 10 3 8 58 1
52248 201838 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 350 Friedell St 8 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 5ft Permit Number 770566 6020663.4716 2092744.71005 37.7274339035298 -122.370771395785 (37.7274339035298, -122.370771395785) 10 3 8 58 1
90911 201581 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 601 Donahue St 6 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6020642.22702 2092924.8193 37.7279272833017 -122.370857288241 (37.7279272833017, -122.370857288241) 10 3 8 58 1
100867 201545 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 601 Innes Ave 14 Sidewalk: Property side : Yard Tree Private 2     27     6020633.70615 2093371.77747 37.7291540781924 -122.370917639957 (37.7291540781924, -122.370917639957) 10 3 8 58 1
164504 201580 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 601 Donahue St 5 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6020628.78345 2092907.82457 37.7278798809349 -122.370902588897 (37.7278798809349, -122.370902588897) 10 3 8 58 1
182690 201544 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 601 Innes Ave 13 Sidewalk: Property side : Yard Tree Private 2     3     6020625.62552 2093377.92947 37.7291705267859 -122.370946000964 (37.7291705267859, -122.370946000964) 10 3 8 58 1
115036 201598 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 98 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020624.74965 2092745.34242 37.7274335141325 -122.370905303063 (37.7274335141325, -122.370905303063) 10 3 8 58 1
99577 201569 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 600 Donahue St 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 5ft   6020624.73776 2092976.30056 37.7280676809716 -122.370921308297 (37.7280676809716, -122.370921308297) 10 3 8 58 1
47481 201543 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 12 Sidewalk: Property side : Yard Tree Private 2     7     6020620.74495 2093375.17595 37.72916269819 -122.370962683378 (37.72916269819, -122.370962683378) 10 3 8 58 1
41509 201579 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 601 Donahue St 4 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6020614.66874 2092891.85925 37.7278352682694 -122.370950280826 (37.7278352682694, -122.370950280826) 10 3 8 58 1
77884 201599 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 98 Kirkwood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020607.89569 2092757.21287 37.7274651828507 -122.370964388499 (37.7274651828507, -122.370964388499) 10 3 8 58 1
126816 201578 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 601 Donahue St 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6020600.88826 2092872.23699 37.7277806326671 -122.370996564459 (37.7277806326671, -122.370996564459) 10 3 8 58 1
69593 201600 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 98 Kirkwood Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 Width 4ft Permit Number 770566 6020594.26008 2092766.53995 37.7274900446232 -122.371012172182 (37.7274900446232, -122.371012172182) 10 3 8 58 1
165001 201577 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 601 Donahue St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6020588.137 2092854.48102 37.7277311780349 -122.371039418958 (37.7277311780349, -122.371039418958) 10 3 8 58 1
59739 201542 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 601 Innes Ave 11 Sidewalk: Curb side : Yard Tree Private 2     28     6020585.50312 2093400.19609 37.7292294638519 -122.371086248457 (37.7292294638519, -122.371086248457) 10 3 8 58 1
83734 201576 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 601 Donahue St 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6020573.72323 2092835.80455 37.7276791045865 -122.371087957161 (37.7276791045865, -122.371087957161) 10 3 8 58 1
183325 201541 DPW Maintained 1 Pyrus spp :: Pear Tree 281 601 Innes Ave 10 Sidewalk: Curb side : Yard Tree Private 2     2     6020571.22527 2093411.75829 37.7292604275206 -122.371136408139 (37.7292604275206, -122.371136408139) 10 3 8 58 1
49733 93214 Permitted Site 7 Tree(s) :: 17 655 Innes Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53208 6020566.8 2093454.3 37.7293769960176 -122.371154647854 (37.7293769960176, -122.371154647854) 10 3 8 58 1
51209 93212 Permitted Site 7 Tree(s) :: 17 655 Innes Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53208 6020566.8 2093454.3 37.7293769960176 -122.371154647854 (37.7293769960176, -122.371154647854) 10 3 8 58 1
56367 93211 Permitted Site 7 Tree(s) :: 17 655 Innes Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53208 6020566.8 2093454.3 37.7293769960176 -122.371154647854 (37.7293769960176, -122.371154647854) 10 3 8 58 1
109508 93208 Permitted Site 7 Tree(s) :: 17 655 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53208 6020566.8 2093454.3 37.7293769960176 -122.371154647854 (37.7293769960176, -122.371154647854) 10 3 8 58 1
135446 93213 Permitted Site 7 Tree(s) :: 17 655 Innes Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53208 6020566.8 2093454.3 37.7293769960176 -122.371154647854 (37.7293769960176, -122.371154647854) 10 3 8 58 1
148134 93209 Permitted Site 7 Tree(s) :: 17 655 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53208 6020566.8 2093454.3 37.7293769960176 -122.371154647854 (37.7293769960176, -122.371154647854) 10 3 8 58 1
191338 93210 Permitted Site 7 Tree(s) :: 17 655 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53208 6020566.8 2093454.3 37.7293769960176 -122.371154647854 (37.7293769960176, -122.371154647854) 10 3 8 58 1
56586 201540 DPW Maintained 1 Eucalyptus camaldulensis :: River Red Gum 342 601 Innes Ave 9 Front Yard : Yard Tree Private 2     15     6020451.57641 2093498.37325 37.729491685489 -122.371556038992 (37.729491685489, -122.371556038992) 10 3 8 58 1
154603 201539 DPW Maintained 1 Eucalyptus camaldulensis :: River Red Gum 342 601 Innes Ave 8 Front Yard : Yard Tree Private 2     19     6020431.26381 2093508.99897 37.7295197461253 -122.371626997282 (37.7295197461253, -122.371626997282) 10 3 8 58 1
161991 201524 DPW Maintained 1 Pinus thunbergii :: Japanese Black Pine 207 740 Earl St 1 Front Yard : Yard Tree Private 2     4     6020392.93719 2093745.64338 37.7301674216776 -122.371775862971 (37.7301674216776, -122.371775862971) 10 3 8 58 1
113881 201523 DPW Maintained 1 Myoporum laetum :: Myoporum 62 799 Earl St 1 Front Yard : Yard Tree Private 2     18 Width 10ft   6020371.96237 2093662.30984 37.7299374515467 -122.371842613372 (37.7299374515467, -122.371842613372) 10 3 8 58 1
191950 201525 DPW Maintained 1 Cupressocyparis leylandii :: Leyland Cypress 185 740 Earl St 2 Front Yard : Yard Tree Private 2     13     6020363.02265 2093708.60357 37.7300640742831 -122.371876721056 (37.7300640742831, -122.371876721056) 10 3 8 58 1
109290 201526 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 740 Earl St 3 Front Yard : Yard Tree Private 2     1     6020358.69967 2093703.87805 37.7300508614476 -122.371891339508 (37.7300508614476, -122.371891339508) 10 3 8 58 1
146004 201527 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 740 Earl St 4 : Tree Private 2     6 Width 5ft   6020341.20189 2093704.82943 37.7300525126033 -122.371951898056 (37.7300525126033, -122.371951898056) 10 3 8 58 1
147935 201538 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 7 Front Yard : Yard Tree Private 2     11     6020320.60238 2093595.7564 37.7297518872405 -122.372015570059 (37.7297518872405, -122.372015570059) 10 3 8 58 1
56177 39988 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 702 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/1999 12:00:00 AM     Permit Number 41246 6020313.39222717 2093680.55714076 37.7299843378677 -122.372046361907 (37.7299843378677, -122.372046361907) 10 3 8 58 1
54777 201528 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 700 Innes Ave 1 : Tree Private 2     10 Width 3ft   6020307.12095 2093692.07813 37.7300156278056 -122.372068839601 (37.7300156278056, -122.372068839601) 10 3 8 58 1
139414 39989 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 710 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/1999 12:00:00 AM 12   Permit Number 41247 6020263.29136 2093725.43573 37.7301048135783 -122.372222673141 (37.7301048135783, -122.372222673141) 10 3 8 58 1
33543 39990 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 714 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/1999 12:00:00 AM 10   Permit Number 41248 6020251.60512 2093735.09311 37.7301306888693 -122.372263742486 (37.7301306888693, -122.372263742486) 10 3 8 58 1
47671 201529 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 718 Innes Ave 1 : Tree Private 2     5 Width 3ft   6020227.99181 2093752.40727 37.7301769329099 -122.372346575457 (37.7301769329099, -122.372346575457) 10 3 8 58 1
169735 39991 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 724 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/1999 12:00:00 AM 10   Permit Number 41249 6020211.31416 2093764.16933 37.73020831296 -122.372405046655 (37.73020831296, -122.372405046655) 10 3 8 58 1
30228 201537 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 6 Front Yard : Yard Tree Private 2     4     6020208.27308 2093682.62725 37.7299842468553 -122.372409919208 (37.7299842468553, -122.372409919208) 10 3 8 58 1
117678 201530 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 724 Innes Ave 2 : Tree Private 2     11 Width 3ft   6020205.16729 2093768.90388 37.7302209753954 -122.372426624989 (37.7302209753954, -122.372426624989) 10 3 8 58 1
179713 201531 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 724 Innes Ave 3 : Tree Private 2     5 Width 3ft   6020190.28523 2093779.82824 37.7302501539023 -122.372478830631 (37.7302501539023, -122.372478830631) 10 3 8 58 1
61479 201536 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 5 Front Yard : Yard Tree Private 2     4     6020184.94124 2093703.94604 37.7300415022109 -122.372492056066 (37.7300415022109, -122.372492056066) 10 3 8 58 1
72991 39992 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 744 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/1999 12:00:00 AM 10   Permit Number 41250 6020175.81777 2093790.38567 37.7302783476475 -122.372529577584 (37.7302783476475, -122.372529577584) 10 3 8 58 1
121044 201654 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 744 Innes Ave 2 : Tree Private 2     3 Width 3ft   6020169.84192 2093795.17741 37.73029117649 -122.372550568669 (37.73029117649, -122.372550568669) 10 3 8 58 1
112956 201655 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 734 Innes Ave 1 : Tree Private 2     9 Width 3ft   6020157.47653 2093804.76916 37.7303168341394 -122.372593981633 (37.7303168341394, -122.372593981633) 10 3 8 58 1
104502 201550 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 1 Sidewalk: Property side : Yard Tree Private 2     31     6020135.10106 2093474.49697 37.7294087400981 -122.372648486831 (37.7294087400981, -122.372648486831) 10 3 8 58 1
154052 201535 DPW Maintained 1 Juglans californica :: Walnut: Black (s.calif) 412 601 Innes Ave 4 Front Yard : Yard Tree Private 2     4     6020117.52711 2093745.9964 37.7301532600638 -122.372728027393 (37.7301532600638, -122.372728027393) 10 3 8 58 1
179421 201551 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 2 Sidewalk: Property side : Yard Tree Private 2     31     6020116.66531 2093486.63817 37.7294410644355 -122.372713061779 (37.7294410644355, -122.372713061779) 10 3 8 58 1
135791 201656 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 748 Innes Ave 1 : Tree Private 2     5 Width 3ft   6020105.93205 2093842.33716 37.7304171562079 -122.372774779541 (37.7304171562079, -122.372774779541) 10 3 8 58 1
104328 201657 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 748 Innes Ave 2 : Tree Private 2     5 Width 3ft   6020084.79381 2093857.53228 37.7304577174311 -122.372848909746 (37.7304577174311, -122.372848909746) 10 3 8 58 1
28188 201534 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 3 Front Yard : Yard Tree Private 2     4     6020030.3592 2093817.11357 37.7303437436519 -122.373034303211 (37.7303437436519, -122.373034303211) 10 3 8 58 1
138482 201533 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 2 Front Yard : Yard Tree Private 2     7     6020026.38212 2093819.59918 37.7303503500706 -122.373048224703 (37.7303503500706, -122.373048224703) 10 3 8 58 1
153456 201532 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 1 Front Yard : Yard Tree Private 2     5     6020021.83334 2093823.70013 37.7303613604801 -122.373064234453 (37.7303613604801, -122.373064234453) 10 3 8 58 1
20792 194005 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 900 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6019962.69863 2093253.82353 37.7287933376393 -122.373229233067 (37.7287933376393, -122.373229233067) 10 3 8 58 1
64408 201553 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 4 Sidewalk: Property side : Yard Tree Private 2     31     6019956.36355 2093604.98051 37.72975719952 -122.373275437534 (37.72975719952, -122.373275437534) 10 3 8 58 1
116139 194006 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 900 Kirkwood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6019953.97455 2093259.97649 37.7288097529433 -122.373259818991 (37.7288097529433, -122.373259818991) 10 3 8 58 1
90979 201554 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 5 Sidewalk: Property side : Yard Tree Private 2     37     6019933.48911 2093619.80077 37.7297966356963 -122.373355543719 (37.7297966356963, -122.373355543719) 10 3 8 58 1
191706 201555 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 6 Sidewalk: Property side : Yard Tree Private 2     10     6019901.03231 2093652.00045 37.7298832655955 -122.373469980666 (37.7298832655955, -122.373469980666) 10 3 8 58 1
109134 201556 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 7 Sidewalk: Property side : Yard Tree Private 2     27     6019865.26747 2093672.49383 37.729937570248 -122.373595043971 (37.729937570248, -122.373595043971) 10 3 8 58 1
63763 112098 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729x Kirkwood Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6019849.10863 2093255.57368 37.7287918987073 -122.373622047041 (37.7287918987073, -122.373622047041) 10 3 8 58 1
107167 201557 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 8 Sidewalk: Property side : Yard Tree Private 2     25 Width 9ft   6019843.77362 2093685.40293 37.7299718344327 -122.373670245296 (37.7299718344327, -122.373670245296) 10 3 8 58 1
135620 201482 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 801 Arelious Walker Dr 1 : Tree Private 2     4 Width 3ft   6019833.06925 2094138.86397 37.7312163630497 -122.373738644125 (37.7312163630497, -122.373738644125) 10 3 8 58 1
177739 201558 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 9 Sidewalk: Property side : Yard Tree Private 2     12 Width 7ft   6019824.62434 2093697.32313 37.7300035121512 -122.373737272669 (37.7300035121512, -122.373737272669) 10 3 8 58 1
190629 201483 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 801 Arelious Walker Dr 2 : Tree Private 2     5 Width 3ft   6019824.35428 2094127.54266 37.7311847977227 -122.373767989919 (37.7311847977227, -122.373767989919) 10 3 8 58 1
145414 201484 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 801 Arelious Walker Dr 3 : Tree Private 2     4 Width 3ft   6019815.12004 2094115.72508 37.731151841174 -122.37379909656 (37.731151841174, -122.37379909656) 10 3 8 58 1
170863 201485 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 801 Arelious Walker Dr 4 : Tree Private 2     4 Width 3ft   6019804.87091 2094104.0965 37.7311193477698 -122.373833724951 (37.7311193477698, -122.373833724951) 10 3 8 58 1
64209 112097 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729x Kirkwood Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6019796.6756 2093294.41316 37.7288956616077 -122.373806002468 (37.7288956616077, -122.373806002468) 10 3 8 58 1
154609 201560 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 11 Sidewalk: Property side : Yard Tree Private 2     19 Width 5ft   6019794.81537 2093720.05192 37.7300642820202 -122.373841900702 (37.7300642820202, -122.373841900702) 10 3 8 58 1
28566 50767 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 800 Innes Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2004 12:00:00 AM     Permit Number 47301 6019786.72970778 2094070.44918577 37.73102596117 -122.373894113437 (37.73102596117, -122.373894113437) 10 3 8 58 1
44476 50764 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 800 Innes Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2004 12:00:00 AM     Permit Number 47301 6019786.72970778 2094070.44918577 37.73102596117 -122.373894113437 (37.73102596117, -122.373894113437) 10 3 8 58 1
182059 50765 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 800 Innes Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2004 12:00:00 AM     Permit Number 47301 6019786.72970778 2094070.44918577 37.73102596117 -122.373894113437 (37.73102596117, -122.373894113437) 10 3 8 58 1
186607 50766 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 800 Innes Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2004 12:00:00 AM     Permit Number 47301 6019786.72970778 2094070.44918577 37.73102596117 -122.373894113437 (37.73102596117, -122.373894113437) 10 3 8 58 1
45076 112096 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729x Kirkwood Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6019785.67464 2093301.20525 37.7289137064936 -122.373844504239 (37.7289137064936, -122.373844504239) 10 3 8 58 1
112228 112095 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729x Kirkwood Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6019776.75141 2093308.7775 37.7289340077863 -122.373875877092 (37.7289340077863, -122.373875877092) 10 3 8 58 1
194228 112094 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729x Kirkwood Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6019767.42453 2093316.76888 37.7289554377256 -122.373908674444 (37.7289554377256, -122.373908674444) 10 3 8 58 1
75354 112093 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729x Kirkwood Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6019760.12602 2093323.07612 37.7289723548671 -122.373934342906 (37.7289723548671, -122.373934342906) 10 3 8 58 1
80105 50769 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 800 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2004 12:00:00 AM 5   Permit Number 47301 6019759.98299 2094100.60005 37.7311072788765 -122.373988670067 (37.7311072788765, -122.373988670067) 10 3 8 58 1
29856 112092 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729x Kirkwood Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6019748.33316 2093331.52762 37.7289949125871 -122.373975697329 (37.7289949125871, -122.373975697329) 10 3 8 58 1
118510 201561 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 200 Jerrold Ave 12 Sidewalk: Property side : Yard Tree Private 2     24 Width 8ft   6019745.83299 2093765.29662 37.7301858218198 -122.374014373583 (37.7301858218198, -122.374014373583) 10 3 8 58 1
91149 50770 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 800 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2004 12:00:00 AM 5   Permit Number 47301 6019742.9176 2094113.11365 37.7311407003688 -122.374048535228 (37.7311407003688, -122.374048535228) 10 3 8 58 1
172727 112091 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729x Kirkwood Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6019736.09499 2093338.34451 37.7290129574773 -122.374018478089 (37.7290129574773, -122.374018478089) 10 3 8 58 1
116756 50768 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 800 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2004 12:00:00 AM 5   Permit Number 47301 6019728.52002 2094123.20714 37.7311676233867 -122.374099009669 (37.7311676233867, -122.374099009669) 10 3 8 58 1
40571 112090 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729x Kirkwood Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6019725.52267 2093345.9498 37.7290332587574 -122.374055554419 (37.7290332587574, -122.374055554419) 10 3 8 58 1
107821 112089 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729x Kirkwood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6019713.35879 2093356.46232 37.7290614551979 -122.374098334278 (37.7290614551979, -122.374098334278) 10 3 8 58 1
37949 201567 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 799 Jerrold Ave 2 Sidewalk: Property side : Yard Tree Private 2     15 Width 9ft   6019712.53243 2093705.44833 37.7300196585793 -122.374125355309 (37.7300196585793, -122.374125355309) 10 3 8 58 1
45852 112088 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 729x Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6019699.12491 2093366.60559 37.7290885238927 -122.374148244842 (37.7290885238927, -122.374148244842) 10 3 8 58 1
25286 201566 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 799 Jerrold Ave 1 Sidewalk: Property side : Yard Tree Private 2     11     6019697.16467 2093717.76615 37.7300526357971 -122.374179337111 (37.7300526357971, -122.374179337111) 10 3 8 58 1
4778 201565 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 200 Jerrold Ave 16 Sidewalk: Property side : Yard Tree Private 2     45     6019673.98228 2093813.82501 37.7303151200443 -122.374266134286 (37.7303151200443, -122.374266134286) 10 3 8 58 1
70973 44524 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 828 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2001 12:00:00 AM 7   Permit Number 43824 6019592.36733 2094224.82973 37.73143917097 -122.374576757438 (37.73143917097, -122.374576757438) 10 3 8 58 1
29584 44522 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 828 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2001 12:00:00 AM 7   Permit Number 43824 6019580.98035 2094232.66529 37.7314600595298 -122.374616667546 (37.7314600595298, -122.374616667546) 10 3 8 58 1
101103 44521 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 828 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2001 12:00:00 AM 7   Permit Number 43824 6019557.73451 2094250.20491 37.731506941191 -122.37469824865 (37.731506941191, -122.37469824865) 10 3 8 58 1
175923 44523 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 828 Innes Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2001 12:00:00 AM 6   Permit Number 43824 6019546.1676 2094257.53708 37.7315264375989 -122.374738746021 (37.7315264375989, -122.374738746021) 10 3 8 58 1
159773 192724 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 900 Kirkwood Ave 3 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6019533.42418 2093575.80573 37.729653833243 -122.37473558218 (37.729653833243, -122.37473558218) 10 3 8 58 1
137217 201522 DPW Maintained 1 Yucca gloriosa :: Spanish Dagger 126 863 Innes Ave 2 : Tree Private 2     4 Width 2ft   6019436.46936 2094253.96379 37.7315105906351 -122.375117750879 (37.7315105906351, -122.375117750879) 10 3 8 58 1
2967 39994 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 863 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/1999 12:00:00 AM 12 3x3 Permit Number 41252 6019434.68731 2094262.5096 37.7315339577268 -122.375124503897 (37.7315339577268, -122.375124503897) 10 3 8 58 1

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