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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164315 | 164315 | 64505 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 412 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 9 | Permit Number 25386 | 6001213.6317 | 2110153.0182 | 37.7741460412807 | -122.439256624823 | (37.7741460412807, -122.439256624823) | |
| 165135 | 165135 | 101264 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Permit Number 20727 | 5989453.6006 | 2106533.1127 | 37.7635305455459 | -122.479671267422 | (37.7635305455459, -122.479671267422) | |||
| 165399 | 165399 | 32294 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011626.7926 | 2107023.9767 | 37.7661414653506 | -122.403015326989 | (37.7661414653506, -122.403015326989) | ||
| 165971 | 165971 | 30704 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 369 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 12 | Permit Number 34615 | 6005232.8948 | 2110236.794 | 37.774603966343605 | -122.42535923638 | (37.7746039663436, -122.42535923638) | |
| 166509 | 166509 | 59660 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 910 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 15 | Permit Number 19082 | 6002982.2355 | 2111513.667 | 37.777982528898704 | -122.43323596098 | (37.7779825288987, -122.43323596098) | ||
| 166552 | 166552 | 62362 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1905 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1985 12:00:00 AM | 13 | Permit Number 22507 | 6004330.152000001 | 2115433.2423 | 37.7888210787145 | -122.42885254308399 | (37.7888210787145, -122.428852543084) | ||
| 166843 | 166843 | 63488 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 811 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/07/1987 12:00:00 AM | 12 | Permit Number 24085 | 5999970.1497 | 2111784.3859 | 37.7785545222825 | -122.443675254762 | (37.7785545222825, -122.443675254762) | |
| 167853 | 167853 | 32297 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011502.2034 | 2107015.4172 | 37.766111004805396 | -122.40344565674499 | (37.7661110048054, -122.403445656745) | ||
| 169263 | 169263 | 33692 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 11 | Permit Number 37765 | 6005361.9877 | 2111137.3022 | 37.7770838353758 | -122.42497676123001 | (37.7770838353758, -122.42497676123) | ||
| 171274 | 171274 | 59153 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 20 Bellair Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/1982 12:00:00 AM | 11 | Permit Number 19779 | 6010063.4155 | 2121130.5341 | 37.8047872831513 | -122.40941840765801 | (37.8047872831513, -122.409418407658) | ||
| 171478 | 171478 | 61148 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2237 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/1983 12:00:00 AM | 7 | Permit Number 21005 | 5997050.2982 | 2110479.7459 | 37.7748053558267 | -122.453681848705 | (37.7748053558267, -122.453681848705) | ||
| 171803 | 171803 | 60926 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1983 12:00:00 AM | 13 | Permit Number 20727 | 5989507.2134 | 2106536.1763 | 37.7635420716385 | -122.479486064031 | (37.7635420716385, -122.479486064031) | ||
| 171990 | 171990 | 58122 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 24 Orben Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1978 12:00:00 AM | 13 | Permit Number 17103 | 6003170.2635 | 2115307.1662 | 37.7884091881086 | -122.43285658098499 | (37.7884091881086, -122.432856580985) | ||
| 174672 | 174672 | 66381 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 648 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 13 | Permit Number 29507 | 6003596.4072 | 2110594.4854 | 37.775493505524004 | -122.43104570278601 | (37.775493505524, -122.431045702786) | |
| 174864 | 174864 | 64376 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 69 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1988 12:00:00 AM | 11 | Permit Number 25215 | 5996673.1599 | 2112554.0417 | 37.7804791997483 | -122.45513636713801 | (37.7804791997483, -122.455136367138) | ||
| 175055 | 175055 | 59662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 911 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 17 | Permit Number 19084 | 6002943.8621 | 2111474.7299 | 37.777873440392206 | -122.433365924976 | (37.7778734403922, -122.433365924976) | ||
| 175202 | 175202 | 63909 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2119 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1987 12:00:00 AM | 12 | Permit Number 24624 | 6009399.6734 | 2120957.786 | 37.804275748547504 | -122.41170315133301 | (37.8042757485475, -122.411703151333) | ||
| 176490 | 176490 | 38608 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2003 12:00:00 AM | 6 | Permit Number 45423 | 6015284.7491 | 2094285.2369 | 37.7313671428977 | -122.38947335260099 | (37.7313671428977, -122.389473352601) | |
| 177440 | 177440 | 61824 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 568 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1985 12:00:00 AM | 19 | Permit Number 21857 | 6005139.9121 | 2110969.4321 | 37.7766103583758 | -122.425733039566 | (37.7766103583758, -122.425733039566) | ||
| 177466 | 177466 | 32291 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1400 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 7 | Permit Number 36872 | 6014236.59 | 2091225.7906 | 37.722908348540294 | -122.39288309530001 | (37.7229083485403, -122.3928830953) | ||
| 177611 | 177611 | 110909 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6013356.5185 | 2113781.277 | 37.7847919207208 | -122.397506459776 | (37.7847919207208, -122.397506459776) | ||||
| 180558 | 180558 | 66720 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 819 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1991 12:00:00 AM | 14 | Permit Number 29962 | 5999956.9512 | 2111893.0193 | 37.778852049002 | -122.44372871968399 | (37.778852049002, -122.443728719684) | ||
| 181919 | 181919 | 53486 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 3360 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1969 12:00:00 AM | 14 | Permit Number 6395 | 5996703.1102 | 2112969.116 | 37.7816206023811 | -122.455062757544 | (37.7816206023811, -122.455062757544) | ||
| 185285 | 185285 | 105341 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1407 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6000167.325 | 2113807.8025 | 37.7841215482425 | -122.44313851129999 | (37.7841215482425, -122.4431385113) | ||||
| 185441 | 185441 | 38610 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015263.8639 | 2094301.7253 | 37.7314112587254 | -122.38954670833701 | (37.7314112587254, -122.389546708337) | |
| 186817 | 186817 | 55476 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 500 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 17 | Permit Number 11428 | 6002664.0079 | 2110296.3247 | 37.7746219525119 | -122.434249770689 | (37.7746219525119, -122.434249770689) | ||
| 188085 | 188085 | 71703 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 530 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1982 12:00:00 AM | 14 | 6005189.8095 | 2111320.4314 | 37.7775769362179 | -122.425585416633 | (37.7775769362179, -122.425585416633) | ||
| 8195 | 8195 | 13291 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2671 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5999604.2969 | 2119102.6495 | 37.7986276847794 | -122.44546723704599 | (37.7986276847794, -122.445467237046) | |||
| 20899 | 20899 | 16992 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 900 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 1x1 | 6002640.9603 | 2109924.6842 | 37.773600211727 | -122.434302921546 | (37.773600211727, -122.434302921546) | |||
| 30671 | 30671 | 111734 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 2.5x3 | 6005865.3001 | 2111209.4164 | 37.777310260787 | -122.423240771205 | (37.777310260787, -122.423240771205) | |||
| 60040 | 60040 | 111732 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x3 | 6005836.5524 | 2111203.7796 | 37.777293161078795 | -122.423339818124 | (37.7772931610788, -122.423339818124) | |||
| 64849 | 64849 | 111733 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 2.5x3 | 6005854.5902 | 2111208.289 | 37.777306560799 | -122.42327774010201 | (37.777306560799, -122.423277740102) | |||
| 71150 | 71150 | 111730 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x3 | 6005810.6231 | 2111200.9612 | 37.7772839590018 | -122.42342931564501 | (37.7772839590018, -122.423429315645) | |||
| 136070 | 136070 | 111735 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 2.5x3 | 6005874.8827 | 2111210.5438 | 37.7773138971451 | -122.423207702005 | (37.7773138971451, -122.423207702005) | |||
| 155936 | 155936 | 111731 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 2.5x3 | 6005824.7151 | 2111202.6522 | 37.7772893974301 | -122.423380687053 | (37.7772893974301, -122.423380687053) | |||
| 2173 | 2173 | 21585 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005366.3574 | 2114813.7602 | 37.7871787298771 | -122.425223316098 | (37.7871787298771, -122.425223316098) | |||
| 7192 | 7192 | 21587 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005314.2609 | 2114809.1294 | 37.787163071612795 | -122.42540322917601 | (37.7871630716128, -122.425403229176) | |||
| 7382 | 7382 | 2590 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1712 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6005179.844 | 2115138.5122 | 37.788059879281505 | -122.42589173782301 | (37.7880598792815, -122.425891737823) | |||
| 7706 | 7706 | 21589 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005274.899 | 2114802.7621 | 37.7871433646236 | -122.425538959573 | (37.7871433646236, -122.425538959573) | |||
| 8536 | 8536 | 21588 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005294.0011 | 2114805.6563 | 37.7871523906748 | -122.42547307647301 | (37.7871523906748, -122.425473076473) | |||
| 8583 | 8583 | 21586 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005346.0976 | 2114810.866 | 37.7871696385608 | -122.425293204645 | (37.7871696385608, -122.425293204645) | |||
| 8894 | 8894 | 21590 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005256.9547 | 2114799.289 | 37.78713281444121 | -122.425600795702 | (37.7871328144412, -122.425600795702) | |||
| 5501 | 5501 | 99227 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008003.9616 | 2121103.5041 | 37.8045974602939 | -122.416543465428 | (37.8045974602939, -122.416543465428) | |||
| 6213 | 6213 | 99229 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008022.9494 | 2121084.5162 | 37.804546392141496 | -122.416476410342 | (37.8045463921415, -122.416476410342) | |||
| 6739 | 6739 | 99228 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008013.4555 | 2121093.6827 | 37.8045710271276 | -122.416509914664 | (37.8045710271276, -122.416509914664) | |||
| 8148 | 8148 | 99230 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008035.3898 | 2121073.3853 | 37.8045165290969 | -122.416432570152 | (37.8045165290969, -122.416432570152) | |||
| 8426 | 8426 | 99231 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008046.5206 | 2121063.2366 | 37.804489289265106 | -122.416393331612 | (37.8044892892651, -122.416393331612) | |||
| 17687 | 17687 | 9652 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 75 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 3 | 2x3 | 6006083.2108 | 2109791.7339 | 37.773429942464205 | -122.42238619158998 | (37.7734299424642, -122.42238619159) | ||
| 296 | 296 | 18021 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.78692829139071 | -122.44112805661501 | (37.7869282913907, -122.441128056615) | |||
| 911 | 911 | 12249 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 511 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004989.1563 | 2110705.1842 | 37.7758762780635 | -122.42623573054199 | (37.7758762780635, -122.426235730542) | |||
| 1064 | 1064 | 7177 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 827 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003463.7289 | 2111198.6401 | 37.7771448458144 | -122.431547809387 | (37.7771448458144, -122.431547809387) | |||
| 1121 | 1121 | 13143 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1800 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6003680.9036 | 2119717.0807 | 37.8005466318744 | -122.431404778789 | (37.8005466318744, -122.431404778789) | |||
| 1463 | 1463 | 13191 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2095 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002470.5921 | 2119469.4635 | 37.7997980716779 | -122.43557521775601 | (37.7997980716779, -122.435575217756) | |||
| 1528 | 1528 | 13126 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6004190.6649 | 2119706.135 | 37.8005454550984 | -122.42964001675399 | (37.8005454550984, -122.429640016754) | |||
| 1759 | 1759 | 7200 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 949 Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003420.9887 | 2111521.8792 | 37.7780299575939 | -122.431718745255 | (37.7780299575939, -122.431718745255) | |||
| 2005 | 2005 | 7164 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 733 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003503.3323 | 2110918.6468 | 37.7763782981407 | -122.43139081647399 | (37.7763782981407, -122.431390816474) | |||
| 2132 | 2132 | 13212 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2190 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6001925.0681 | 2119471.9545 | 37.7997739121356 | -122.437463108341 | (37.7997739121356, -122.437463108341) | |||
| 2225 | 2225 | 7163 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 730 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6003538.8779 | 2111021.3343 | 37.776662267069895 | -122.43127518600001 | (37.7766622670699, -122.431275186) | |||
| 2890 | 2890 | 17680 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1020 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002416.7239 | 2112103.0842 | 37.7795688238035 | -122.43523443397801 | (37.7795688238035, -122.435234433978) | |||
| 2903 | 2903 | 13280 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2524 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/15/1993 12:00:00 AM | 40 | 3X3 | 6000256.3025 | 2119240.7621 | 37.7990441048198 | -122.44322102307699 | (37.7990441048198, -122.443221023077) | ||
| 3435 | 3435 | 13052 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 557 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009686.1191 | 2120512.8313 | 37.8030700779734 | -122.410680437216 | (37.8030700779734, -122.410680437216) | |||
| 3729 | 3729 | 18005 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2683 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001144.5248 | 2114870.2639 | 37.787094464568796 | -122.43983396035101 | (37.7870944645688, -122.439833960351) | |||
| 3945 | 3945 | 6232 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1220 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6005007.0756 | 2113377.0261 | 37.7832135118405 | -122.42636402033199 | (37.7832135118405, -122.426364020332) | ||
| 4022 | 4022 | 22785 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1885 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001011.2725 | 2112069.058 | 37.7793954847522 | -122.44009404075399 | (37.7793954847522, -122.440094040754) | |||
| 4302 | 4302 | 13161 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1895 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6003359.5664 | 2119590.4223 | 37.8001806439695 | -122.432507683341 | (37.8001806439695, -122.432507683341) | |||
| 4440 | 4440 | 28068 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3445 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5996452.8473 | 2112841.7002 | 37.78125639187 | -122.455919329089 | (37.78125639187, -122.455919329089) | |||
| 4497 | 4497 | 13125 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1688 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 25 | 3X3 | 6004309.8631 | 2119808.6849 | 37.8008337792511 | -122.429234859067 | (37.8008337792511, -122.429234859067) | ||
| 5324 | 5324 | 4600 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 256 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6010961.6739 | 2118493.2807 | 37.7975963184564 | -122.406123962239 | (37.7975963184564, -122.406123962239) | |||
| 5332 | 5332 | 10639 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 877 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003685.3267 | 2110714.3548 | 37.7758276754833 | -122.43074666505301 | (37.7758276754833, -122.430746665053) | |||
| 5342 | 5342 | 17679 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1004 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002429.082 | 2112004.3581 | 37.7792984485069 | -122.435184618671 | (37.7792984485069, -122.435184618671) | |||
| 5353 | 5353 | 7166 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 745 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003498.9011 | 2110946.3415 | 37.7764540897977 | -122.43140812270599 | (37.7764540897977, -122.431408122706) | |||
| 5382 | 5382 | 7155 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 710 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003553.4142 | 2110901.6518 | 37.776334472306 | -122.431216355856 | (37.776334472306, -122.431216355856) | |||
| 5648 | 5648 | 7179 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 833 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003463.175 | 2111217.4725 | 37.777196523521795 | -122.431551070298 | (37.7771965235218, -122.431551070298) | |||
| 5652 | 5652 | 6235 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1250 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004904.9664 | 2113362.05 | 37.7831666187465 | -122.426716210533 | (37.7831666187465, -122.426716210533) | ||
| 5653 | 5653 | 12271 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 700X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004951.5507 | 2111300.9055 | 37.7775098574182 | -122.426408243779 | (37.7775098574182, -122.426408243779) | |||
| 5657 | 5657 | 26166 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1501 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005131.2215 | 2119837.4845 | 37.8009593191179 | -122.426394664407 | (37.8009593191179, -122.426394664407) | |||
| 5702 | 5702 | 7267 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1750 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003061.8978 | 2114394.5816 | 37.785897315625796 | -122.433166277822 | (37.7858973156258, -122.433166277822) | |||
| 5748 | 5748 | 6994 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 870 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003272.597999999 | 2110360.7630000003 | 37.77483340788321 | -122.43214914086201 | (37.7748334078832, -122.432149140862) | |||
| 5822 | 5822 | 18009 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2704 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6000887.4934 | 2114883.9407 | 37.787117383440794 | -122.440724211427 | (37.7871173834408, -122.440724211427) | |||
| 5835 | 5835 | 7158 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 719 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003514.1332 | 2110837.5014 | 37.7761561050706 | -122.431347659332 | (37.7761561050706, -122.431347659332) | |||
| 5865 | 5865 | 13184 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2055X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002517.9206 | 2119475.0682 | 37.799816148716296 | -122.435411844948 | (37.7998161487163, -122.435411844948) | |||
| 5904 | 5904 | 24490 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 852 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003356.8582 | 2110371.9538 | 37.7748689119653 | -122.431858466675 | (37.7748689119653, -122.431858466675) | ||
| 5946 | 5946 | 18013 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000963.2953 | 2114846.642 | 37.7870192873225 | -122.440459278057 | (37.7870192873225, -122.440459278057) | |||
| 6034 | 6034 | 17999 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2663 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001215.9923 | 2114878.7551 | 37.7871218470279 | -122.439587308087 | (37.7871218470279, -122.439587308087) | |||
| 6061 | 6061 | 14540 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 712 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999232.8618 | 2110380.1211 | 37.7746566927117 | -122.44612477022 | (37.7746566927117, -122.44612477022) | |||
| 6065 | 6065 | 13190 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2095 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6002390.8808 | 2119455.1404 | 37.7997542165181 | -122.435850022657 | (37.7997542165181, -122.435850022657) | ||
| 6076 | 6076 | 8204 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1369 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001211.3032 | 2111062.2036 | 37.7766423030153 | -122.439329862063 | (37.7766423030153, -122.439329862063) | |||
| 6110 | 6110 | 13189 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2055X Lombard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002690.4208 | 2119498.1098 | 37.7998892100694 | -122.43481657946998 | (37.7998892100694, -122.43481657947) | |||
| 6126 | 6126 | 7180 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 837 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003455.9744 | 2111255.1372 | 37.7772995333232 | -122.43157866908199 | (37.7772995333232, -122.431578669082) | |||
| 6173 | 6173 | 13020 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 423 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6010295.8571 | 2120595.8738 | 37.8033322591341 | -122.40857627636002 | (37.8033322591341, -122.40857627636) | |||
| 6214 | 6214 | 23797 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1143 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003734.1252 | 2112710.5884 | 37.7813116023897 | -122.430720343349 | (37.7813116023897, -122.430720343349) | |||
| 6232 | 6232 | 13105 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1530 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6004999.0901 | 2119899.25 | 37.8011214413621 | -122.426856296775 | (37.8011214413621, -122.426856296775) | ||
| 6264 | 6264 | 18011 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2707 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000900.4249 | 2114838.7005 | 37.786993901953394 | -122.440676225149 | (37.7869939019534, -122.440676225149) | |||
| 6452 | 6452 | 13171 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1940X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003096.45 | 2119636.9817 | 37.8002935599258 | -122.433421496602 | (37.8002935599258, -122.433421496602) | |||
| 6528 | 6528 | 13104 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1530 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6005037.4004 | 2119906.2866 | 37.801142928088495 | -122.426724227861 | (37.8011429280885, -122.426724227861) | ||
| 6530 | 6530 | 8195 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1301 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001448.9604 | 2111096.3198 | 37.776749499067705 | -122.438510182933 | (37.7767494990677, -122.438510182933) | |||
| 6546 | 6546 | 13195 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2098 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6002408.3176 | 2119538.5881 | 37.7999843325384 | -122.435795658785 | (37.7999843325384, -122.435795658785) | |||
| 6639 | 6639 | 12264 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004966.4829 | 2111191.3303 | 37.7772098348265 | -122.42634878470301 | (37.7772098348265, -122.426348784703) | |||
| 6652 | 6652 | 13197 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2114 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6002204.6803 | 2119511.1874 | 37.799897528014704 | -122.436498357806 | (37.7998975280147, -122.436498357806) | |||
| 6713 | 6713 | 12985 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 306 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3X3 | 6010818.9339 | 2120706.9936 | 37.8036666476299 | -122.406773977327 | (37.8036666476299, -122.406773977327) |
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");