Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2461 | 2461 | 201834 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 2419 | 2419 | 201835 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.7385 | 2092807.85492 | 37.72760966254629 | -122.370626184075 | (37.7276096625463, -122.370626184075) | |
| 2372 | 2372 | 201583 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 2453 | 2453 | 201836 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 2452 | 2452 | 201837 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 2400 | 2400 | 201838 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020663.4716 | 2092744.71005 | 37.7274339035298 | -122.37077139578501 | (37.7274339035298, -122.370771395785) | |
| 28938 | 28938 | 201582 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020666.22255 | 2092954.7050599998 | 37.7280106612574 | -122.370776399631 | (37.7280106612574, -122.370776399631) | |||
| 157712 | 157712 | 201581 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020642.22702 | 2092924.8193 | 37.7279272833017 | -122.370857288241 | (37.7279272833017, -122.370857288241) | |||
| 179913 | 179913 | 201580 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020628.78345 | 2092907.8245700002 | 37.7278798809349 | -122.370902588897 | (37.7278798809349, -122.370902588897) | |||
| 2456 | 2456 | 201598 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020624.74965 | 2092745.3424200001 | 37.7274335141325 | -122.370905303063 | (37.7274335141325, -122.370905303063) | |
| 156960 | 156960 | 201545 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Innes Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6020633.70615 | 2093371.77747 | 37.729154078192394 | -122.37091763995701 | (37.7291540781924, -122.370917639957) | ||||
| 188792 | 188792 | 201569 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 600 Donahue St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6020624.73776 | 2092976.30056 | 37.728067680971606 | -122.370921308297 | (37.7280676809716, -122.370921308297) | |||
| 65523 | 65523 | 201544 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 601 Innes Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6020625.625519999 | 2093377.92947 | 37.7291705267859 | -122.370946000964 | (37.7291705267859, -122.370946000964) | ||||
| 69081 | 69081 | 201579 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020614.668740001 | 2092891.85925 | 37.7278352682694 | -122.370950280826 | (37.7278352682694, -122.370950280826) | |||
| 76765 | 76765 | 201543 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6020620.74495 | 2093375.17595 | 37.72916269819 | -122.370962683378 | (37.72916269819, -122.370962683378) | ||||
| 2441 | 2441 | 201599 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020607.895690001 | 2092757.2128700002 | 37.72746518285071 | -122.37096438849899 | (37.7274651828507, -122.370964388499) | |
| 164394 | 164394 | 201578 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020600.888259999 | 2092872.2369900001 | 37.727780632667105 | -122.370996564459 | (37.7277806326671, -122.370996564459) | |||
| 2430 | 2430 | 201600 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 188512 | 188512 | 201577 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020588.137 | 2092854.48102 | 37.727731178034894 | -122.37103941895799 | (37.7277311780349, -122.371039418958) | |||
| 61517 | 61517 | 201542 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 Innes Ave | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 6020585.50312 | 2093400.1960900002 | 37.7292294638519 | -122.37108624845699 | (37.7292294638519, -122.371086248457) | ||||
| 71593 | 71593 | 201576 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020573.723230001 | 2092835.80455 | 37.7276791045865 | -122.37108795716101 | (37.7276791045865, -122.371087957161) | |||
| 60468 | 60468 | 201541 | Undocumented 2 | Pyrus spp :: Pear Tree 291 | 601 Innes Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6020571.225269999 | 2093411.7582900003 | 37.7292604275206 | -122.371136408139 | (37.7292604275206, -122.371136408139) | ||||
| 80292 | 80292 | 93212 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 81510 | 81510 | 93211 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 84352 | 84352 | 93214 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 99680 | 99680 | 93208 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 111669 | 111669 | 93209 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 113795 | 113795 | 93213 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 146160 | 146160 | 93210 | Permitted Site 1 | Tree(s) :: 17 | 655 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.729376996017606 | -122.371154647854 | (37.7293769960176, -122.371154647854) | ||
| 40324 | 40324 | 201540 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 601 Innes Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6020451.57641 | 2093498.37325 | 37.729491685489 | -122.37155603899201 | (37.729491685489, -122.371556038992) | ||||
| 47028 | 47028 | 201539 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 601 Innes Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6020431.263809999 | 2093508.99897 | 37.7295197461253 | -122.37162699728201 | (37.7295197461253, -122.371626997282) | ||||
| 130534 | 130534 | 201524 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 740 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020392.93719 | 2093745.64338 | 37.730167421677606 | -122.371775862971 | (37.7301674216776, -122.371775862971) | ||||
| 24447 | 24447 | 201523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 799 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 6020371.96237 | 2093662.3098400002 | 37.729937451546704 | -122.371842613372 | (37.7299374515467, -122.371842613372) | |||
| 73961 | 73961 | 201525 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 740 Earl St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6020363.02265 | 2093708.60357 | 37.730064074283106 | -122.371876721056 | (37.7300640742831, -122.371876721056) | ||||
| 165139 | 165139 | 201526 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 740 Earl St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6020358.69967 | 2093703.87805 | 37.7300508614476 | -122.371891339508 | (37.7300508614476, -122.371891339508) | ||||
| 45365 | 45365 | 201527 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 740 Earl St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 5ft | 6020341.20189 | 2093704.82943 | 37.730052512603294 | -122.371951898056 | (37.7300525126033, -122.371951898056) | |||
| 156492 | 156492 | 201538 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6020320.60238 | 2093595.7564 | 37.7297518872405 | -122.37201557005899 | (37.7297518872405, -122.372015570059) | ||||
| 82128 | 82128 | 39988 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 702 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | Permit Number 41246 | 6020313.39222717 | 2093680.55714076 | 37.729984337867705 | -122.37204636190701 | (37.7299843378677, -122.372046361907) | ||
| 178375 | 178375 | 201528 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6020307.12095 | 2093692.07813 | 37.7300156278056 | -122.372068839601 | (37.7300156278056, -122.372068839601) | |||
| 53060 | 53060 | 39989 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 710 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 12 | Permit Number 41247 | 6020263.29136 | 2093725.43573 | 37.73010481357829 | -122.372222673141 | (37.7301048135783, -122.372222673141) | |
| 73500 | 73500 | 39990 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 714 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41248 | 6020251.6051199995 | 2093735.0931099998 | 37.730130688869295 | -122.372263742486 | (37.7301306888693, -122.372263742486) | |
| 47751 | 47751 | 201529 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 718 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020227.99181 | 2093752.40727 | 37.7301769329099 | -122.372346575457 | (37.7301769329099, -122.372346575457) | |||
| 51306 | 51306 | 39991 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 724 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41249 | 6020211.31416 | 2093764.16933 | 37.730208312959995 | -122.372405046655 | (37.73020831296, -122.372405046655) | |
| 47385 | 47385 | 201537 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020208.273080001 | 2093682.62725 | 37.729984246855295 | -122.372409919208 | (37.7299842468553, -122.372409919208) | ||||
| 76336 | 76336 | 201530 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 724 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6020205.16729 | 2093768.9038799999 | 37.7302209753954 | -122.37242662498899 | (37.7302209753954, -122.372426624989) | |||
| 65008 | 65008 | 201531 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 724 Innes Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020190.2852300005 | 2093779.8282400002 | 37.7302501539023 | -122.37247883063101 | (37.7302501539023, -122.372478830631) | |||
| 58893 | 58893 | 201536 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020184.941240001 | 2093703.94604 | 37.730041502210895 | -122.372492056066 | (37.7300415022109, -122.372492056066) | ||||
| 181388 | 181388 | 39992 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 744 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 10 | Permit Number 41250 | 6020175.81777 | 2093790.38567 | 37.7302783476475 | -122.372529577584 | (37.7302783476475, -122.372529577584) | |
| 172235 | 172235 | 201654 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 744 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6020169.84192 | 2093795.1774099998 | 37.73029117649 | -122.372550568669 | (37.73029117649, -122.372550568669) | |||
| 163809 | 163809 | 201655 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 734 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6020157.476530001 | 2093804.76916 | 37.7303168341394 | -122.372593981633 | (37.7303168341394, -122.372593981633) | |||
| 184047 | 184047 | 201550 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6020135.10106 | 2093474.49697 | 37.7294087400981 | -122.372648486831 | (37.7294087400981, -122.372648486831) | ||||
| 57763 | 57763 | 201551 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6020116.66531 | 2093486.6381700002 | 37.7294410644355 | -122.37271306177901 | (37.7294410644355, -122.372713061779) | ||||
| 86028 | 86028 | 201535 | Undocumented 2 | Juglans californica :: Walnut: Black (s.calif) 407 | 601 Innes Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020117.52711 | 2093745.9964 | 37.730153260063794 | -122.372728027393 | (37.7301532600638, -122.372728027393) | ||||
| 66551 | 66551 | 201656 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 748 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020105.93205 | 2093842.3371599999 | 37.7304171562079 | -122.37277477954099 | (37.7304171562079, -122.372774779541) | |||
| 59918 | 59918 | 201657 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 748 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020084.79381 | 2093857.53228 | 37.7304577174311 | -122.372848909746 | (37.7304577174311, -122.372848909746) | |||
| 52457 | 52457 | 201534 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6020030.3592 | 2093817.11357 | 37.7303437436519 | -122.373034303211 | (37.7303437436519, -122.373034303211) | ||||
| 177662 | 177662 | 201533 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6020026.382119999 | 2093819.59918 | 37.7303503500706 | -122.37304822470301 | (37.7303503500706, -122.373048224703) | ||||
| 150232 | 150232 | 201532 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 601 Innes Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6020021.83334 | 2093823.70013 | 37.7303613604801 | -122.373064234453 | (37.7303613604801, -122.373064234453) | ||||
| 55574 | 55574 | 194005 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6019962.69863 | 2093253.82353 | 37.728793337639296 | -122.373229233067 | (37.7287933376393, -122.373229233067) | |||
| 157235 | 157235 | 194006 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6019953.97455 | 2093259.9764900003 | 37.7288097529433 | -122.37325981899099 | (37.7288097529433, -122.373259818991) | |||
| 45320 | 45320 | 201553 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6019956.36355 | 2093604.98051 | 37.72975719952 | -122.373275437534 | (37.72975719952, -122.373275437534) | ||||
| 47244 | 47244 | 201554 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | 6019933.4891099995 | 2093619.80077 | 37.729796635696296 | -122.373355543719 | (37.7297966356963, -122.373355543719) | ||||
| 72337 | 72337 | 201555 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6019901.03231 | 2093652.00045 | 37.7298832655955 | -122.373469980666 | (37.7298832655955, -122.373469980666) | ||||
| 173224 | 173224 | 201556 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6019865.267469999 | 2093672.4938299998 | 37.729937570248 | -122.37359504397101 | (37.729937570248, -122.373595043971) | ||||
| 56492 | 56492 | 112098 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6019849.108630001 | 2093255.57368 | 37.7287918987073 | -122.373622047041 | (37.7287918987073, -122.373622047041) | |||
| 146878 | 146878 | 201557 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 9ft | 6019843.77362 | 2093685.4029299999 | 37.7299718344327 | -122.373670245296 | (37.7299718344327, -122.373670245296) | |||
| 150959 | 150959 | 201558 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 7ft | 6019824.624340001 | 2093697.32313 | 37.7300035121512 | -122.37373727266899 | (37.7300035121512, -122.373737272669) | |||
| 56527 | 56527 | 201482 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6019833.06925 | 2094138.86397 | 37.731216363049704 | -122.373738644125 | (37.7312163630497, -122.373738644125) | |||
| 160233 | 160233 | 201483 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6019824.354280001 | 2094127.5426599998 | 37.731184797722705 | -122.37376798991899 | (37.7311847977227, -122.373767989919) | |||
| 153943 | 153943 | 201484 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6019815.12004 | 2094115.72508 | 37.731151841174004 | -122.37379909656 | (37.731151841174, -122.37379909656) | |||
| 41705 | 41705 | 112097 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019796.6756 | 2093294.4131599998 | 37.7288956616077 | -122.373806002468 | (37.7288956616077, -122.373806002468) | |||
| 149821 | 149821 | 201485 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6019804.87091 | 2094104.0965 | 37.7311193477698 | -122.373833724951 | (37.7311193477698, -122.373833724951) | |||
| 68526 | 68526 | 201560 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 5ft | 6019794.81537 | 2093720.05192 | 37.7300642820202 | -122.373841900702 | (37.7300642820202, -122.373841900702) | |||
| 35495 | 35495 | 112096 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019785.67464 | 2093301.20525 | 37.7289137064936 | -122.373844504239 | (37.7289137064936, -122.373844504239) | |||
| 160216 | 160216 | 112095 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019776.75141 | 2093308.7775 | 37.7289340077863 | -122.373875877092 | (37.7289340077863, -122.373875877092) | |||
| 77552 | 77552 | 50767 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
| 81095 | 81095 | 50764 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
| 142095 | 142095 | 50766 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
| 143984 | 143984 | 50765 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Innes Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | Permit Number 47301 | 6019786.72970778 | 2094070.44918577 | 37.73102596117 | -122.373894113437 | (37.73102596117, -122.373894113437) | |||
| 132560 | 132560 | 112094 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019767.42453 | 2093316.7688799999 | 37.7289554377256 | -122.37390867444401 | (37.7289554377256, -122.373908674444) | |||
| 170529 | 170529 | 112093 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019760.126019999 | 2093323.07612 | 37.7289723548671 | -122.373934342906 | (37.7289723548671, -122.373934342906) | |||
| 152971 | 152971 | 112092 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019748.33316 | 2093331.52762 | 37.728994912587105 | -122.373975697329 | (37.7289949125871, -122.373975697329) | |||
| 175526 | 175526 | 50769 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019759.98299 | 2094100.60005 | 37.7311072788765 | -122.373988670067 | (37.7311072788765, -122.373988670067) | ||
| 54120 | 54120 | 201561 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Jerrold Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 8ft | 6019745.83299 | 2093765.2966200002 | 37.730185821819795 | -122.374014373583 | (37.7301858218198, -122.374014373583) | |||
| 73047 | 73047 | 112091 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019736.09499 | 2093338.3445099997 | 37.729012957477295 | -122.37401847808901 | (37.7290129574773, -122.374018478089) | |||
| 147101 | 147101 | 50770 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019742.9176 | 2094113.11365 | 37.7311407003688 | -122.374048535228 | (37.7311407003688, -122.374048535228) | ||
| 163408 | 163408 | 112090 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019725.52267 | 2093345.9498 | 37.7290332587574 | -122.374055554419 | (37.7290332587574, -122.374055554419) | |||
| 169783 | 169783 | 112089 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019713.35879 | 2093356.4623200002 | 37.7290614551979 | -122.37409833427799 | (37.7290614551979, -122.374098334278) | |||
| 123411 | 123411 | 50768 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019728.52002 | 2094123.20714 | 37.7311676233867 | -122.374099009669 | (37.7311676233867, -122.374099009669) | ||
| 43046 | 43046 | 201567 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 799 Jerrold Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 9ft | 6019712.532430001 | 2093705.4483299998 | 37.730019658579295 | -122.37412535530899 | (37.7300196585793, -122.374125355309) | |||
| 66229 | 66229 | 112088 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729x Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6019699.12491 | 2093366.60559 | 37.729088523892706 | -122.37414824484199 | (37.7290885238927, -122.374148244842) | |||
| 178131 | 178131 | 201566 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 799 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6019697.16467 | 2093717.76615 | 37.7300526357971 | -122.374179337111 | (37.7300526357971, -122.374179337111) | ||||
| 153819 | 153819 | 201565 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | 6019673.98228 | 2093813.8250099998 | 37.730315120044295 | -122.374266134286 | (37.7303151200443, -122.374266134286) | ||||
| 33756 | 33756 | 44524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019592.367330001 | 2094224.8297299999 | 37.73143917097 | -122.37457675743799 | (37.73143917097, -122.374576757438) | ||
| 65032 | 65032 | 44522 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019580.98035 | 2094232.6652900001 | 37.731460059529795 | -122.37461666754601 | (37.7314600595298, -122.374616667546) | ||
| 61890 | 61890 | 44521 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019557.73451 | 2094250.2049099999 | 37.731506941191 | -122.37469824864999 | (37.731506941191, -122.37469824865) | ||
| 166299 | 166299 | 192724 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 900 Kirkwood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6019533.42418 | 2093575.80573 | 37.729653833243 | -122.37473558218001 | (37.729653833243, -122.37473558218) | |||
| 53030 | 53030 | 44523 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 6 | Permit Number 43824 | 6019546.1676 | 2094257.53708 | 37.7315264375989 | -122.37473874602101 | (37.7315264375989, -122.374738746021) | ||
| 137993 | 137993 | 187765 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 91 Kiska Rd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6019429.17387 | 2093568.53818 | 37.7296281423191 | -122.375095487273 | (37.7296281423191, -122.375095487273) | ||||
| 33831 | 33831 | 201522 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 863 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6019436.4693599995 | 2094253.9637900002 | 37.7315105906351 | -122.375117750879 | (37.7315105906351, -122.375117750879) |
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");