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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 523 | 523 | 247328 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 696X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6003691.2873 | 2110070.3794 | 37.774059815342795 | -122.430680081912 | (37.7740598153428, -122.430680081912) | |||
| 593 | 593 | 140072 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 594 | 594 | 140071 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 611 | 611 | 140070 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 1904 | 1904 | 245410 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010125.3081 | 2102244.3008 | 37.752933591707794 | -122.40787161420401 | (37.7529335917078, -122.407871614204) | |||
| 3051 | 3051 | 99233 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008063.2168 | 2121048.832 | 37.8044506767497 | -122.416334531861 | (37.8044506767497, -122.416334531861) | |||
| 3338 | 3338 | 138120 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1970 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003157.8417 | 2114507.235 | 37.7862120754355 | -122.432842389477 | (37.7862120754355, -122.432842389477) | |||
| 3362 | 3362 | 114879 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1454 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000868.0 | 2110394.0 | 37.7747880422892 | -122.440469509771 | (37.7747880422892, -122.440469509771) | ||||
| 4221 | 4221 | 244055 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997910.1594 | 2109123.3007 | 37.771130163517704 | -122.450609610411 | (37.7711301635177, -122.450609610411) | |||
| 4252 | 4252 | 244056 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997913.0484 | 2109110.0936 | 37.771094065570296 | -122.45059866498 | (37.7710940655703, -122.45059866498) | |||
| 4278 | 4278 | 246148 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998461.6736 | 2108298.4947 | 37.768897008730896 | -122.44864249661501 | (37.7688970087309, -122.448642496615) | |||
| 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) | |||
| 5526 | 5526 | 99210 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007993.4855 | 2121112.3432 | 37.8046211410646 | -122.416580345595 | (37.8046211410646, -122.416580345595) | |||
| 5763 | 5763 | 107346 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 247 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5998163.7387 | 2112864.5437 | 37.7814171604492 | -122.450002161775 | (37.7814171604492, -122.450002161775) | |||
| 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) | |||
| 6400 | 6400 | 106204 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1600X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x5 | 6003122.9413 | 2113972.2468 | 37.7847411535968 | -122.432924900964 | (37.7847411535968, -122.432924900964) | |||
| 6691 | 6691 | 121389 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2646 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999473.1272 | 2113649.2828 | 37.7836466874196 | -122.445528775036 | (37.7836466874196, -122.445528775036) | |||
| 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) | |||
| 6997 | 6997 | 106207 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1600X Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5x5 | 6003107.6347 | 2114075.5662 | 37.785023974383705 | -122.43298524084 | (37.7850239743837, -122.43298524084) | |||
| 7025 | 7025 | 113774 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1716 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6000066.4859 | 2114892.9793 | 37.787095412064296 | -122.443565357608 | (37.7870954120643, -122.443565357608) | |||
| 7264 | 7264 | 121250 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 31 Orben Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x3 | Permit Number 778957 | 6003136.4072 | 2115361.6956 | 37.788556991677495 | -122.432977615629 | (37.7885569916775, -122.432977615629) | ||
| 7285 | 7285 | 113773 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1718 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x6 | 6000060.5464 | 2114943.4646 | 37.7872336928249 | -122.44358953494499 | (37.7872336928249, -122.443589534945) | |||
| 7887 | 7887 | 106203 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1600X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x5 | 6003127.4057 | 2113944.8226 | 37.784666106882796 | -122.432907495725 | (37.7846661068828, -122.432907495725) | |||
| 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) | |||
| 8244 | 8244 | 99232 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008054.705 | 2121057.3439 | 37.8044735696368 | -122.416364591045 | (37.8044735696368, -122.416364591045) | |||
| 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) | |||
| 13740 | 13740 | 97243 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016226.9194 | 2094855.7145 | 37.7329857540551 | -122.38625582218701 | (37.7329857540551, -122.386255822187) | |||
| 15892 | 15892 | 97244 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016216.2447 | 2094842.5281 | 37.7329489559822 | -122.38629180873501 | (37.7329489559822, -122.386291808735) | |||
| 16688 | 16688 | 97242 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016235.0824 | 2094868.9009 | 37.7330224130953 | -122.386228519291 | (37.7330224130953, -122.386228519291) | |||
| 18161 | 18161 | 107661 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1312 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5999086.9 | 2105066.2 | 37.7600576690463 | -122.446247345124 | (37.7600576690463, -122.446247345124) | |||
| 22298 | 22298 | 143213 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010427.9747 | 2121297.8273 | 37.8052670481181 | -122.40816861291 | (37.8052670481181, -122.40816861291) | |||
| 22359 | 22359 | 246131 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998602.7919 | 2108317.2701 | 37.768956629428395 | -122.448155732181 | (37.7689566294284, -122.448155732181) | |||
| 22888 | 22888 | 245220 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 351 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6005075.2787 | 2110089.7787 | 37.774191391909596 | -122.425893994936 | (37.7741913919096, -122.425893994936) | |||
| 23633 | 23633 | 137529 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300 Pierce St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6002258.0131 | 2113181.285 | 37.7825202770743 | -122.43586064910801 | (37.7825202770743, -122.435860649108) | |||
| 23704 | 23704 | 138749 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1528 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000156.6321 | 2114235.0077 | 37.785293933510104 | -122.443206197892 | (37.7852939335101, -122.443206197892) | |||
| 23797 | 23797 | 143335 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1820 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004232.6567 | 2118749.9753 | 37.7979224644928 | -122.42942648353399 | (37.7979224644928, -122.429426483534) | |||
| 23838 | 23838 | 140159 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 251 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998783.859 | 2109828.5826 | 37.77311665794689 | -122.44763824308501 | (37.7731166579469, -122.447638243085) | |||
| 24010 | 24010 | 248469 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 145 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998248.1791 | 2107933.2828 | 37.7678820197346 | -122.449354639507 | (37.7678820197346, -122.449354639507) | |||
| 24233 | 24233 | 140776 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 77 TERRA VISTA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000147.5673 | 2112813.1036 | 37.7813892348129 | -122.443135402805 | (37.7813892348129, -122.443135402805) | |||
| 24268 | 24268 | 139286 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 847 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003452.0971 | 2111280.6163 | 37.777369272847295 | -122.431593901382 | (37.7773692728473, -122.431593901382) | |||
| 24338 | 24338 | 142592 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008300.8769 | 2120835.2204 | 37.803877514381 | -122.415496953155 | (37.803877514381, -122.415496953155) | |||
| 24575 | 24575 | 138501 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1799 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002528.8099 | 2114345.6813 | 37.7857327932764 | -122.435007113669 | (37.7857327932764, -122.435007113669) | |||
| 24601 | 24601 | 138420 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1819 STEINER ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 6002521.5979 | 2114452.899 | 37.786026776312596 | -122.435039736101 | (37.7860267763126, -122.435039736101) | |||
| 24837 | 24837 | 217620 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1830 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5994327.7005 | 2092483.4396 | 37.7252356086447 | -122.461794638623 | (37.7252356086447, -122.461794638623) | |||
| 25206 | 25206 | 98347 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1331 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6011023.1341 | 2119487.8255 | 37.800330533908294 | -122.40598139081999 | (37.8003305339083, -122.40598139082) | |||
| 26124 | 26124 | 143189 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 184 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010358.1536 | 2121339.5444 | 37.8053776832044 | -122.408413183131 | (37.8053776832044, -122.408413183131) | |||
| 26187 | 26187 | 244530 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 557 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998936.3155 | 2108740.8879 | 37.7701388371467 | -122.44703258946998 | (37.7701388371467, -122.44703258947) | |||
| 26219 | 26219 | 201182 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 620 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6013434.6654 | 2113939.6272 | 37.785231064684204 | -122.39724720317801 | (37.7852310646842, -122.397247203178) | |||
| 26247 | 26247 | 140689 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003360.489 | 2112281.5531 | 37.780112403361294 | -122.431982295298 | (37.7801124033613, -122.431982295298) | |||
| 26256 | 26256 | 142499 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 521 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6009964.3012 | 2119317.683 | 37.7998040885057 | -122.40963337214 | (37.7998040885057, -122.40963337214) | |||
| 26431 | 26431 | 143534 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2095 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003009.3374 | 2118534.798 | 37.797262307390795 | -122.433644124881 | (37.7972623073908, -122.433644124881) | |||
| 26479 | 26479 | 138715 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2900 BUSH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999573.0166 | 2114358.1558 | 37.785598770554294 | -122.445234179741 | (37.7855987705543, -122.445234179741) | |||
| 26522 | 26522 | 140712 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 PIERCE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002642.8382 | 2110450.4669999997 | 37.7750439873946 | -122.434334023387 | (37.7750439873946, -122.434334023387) | |||
| 26537 | 26537 | 199734 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014741.5822 | 2092253.0007 | 37.725756899909 | -122.391209195431 | (37.725756899909, -122.391209195431) | |||
| 26624 | 26624 | 141693 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998717.1894 | 2112334.7102 | 37.7799940283513 | -122.448049338774 | (37.7799940283513, -122.448049338774) | |||
| 27146 | 27146 | 140419 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 STEINER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6002875.6498 | 2112268.3783 | 37.780048730384 | -122.43365863076201 | (37.780048730384, -122.433658630762) | |||
| 27277 | 27277 | 138678 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2811 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000338.1385 | 2114753.4825 | 37.786727879036704 | -122.442615482645 | (37.7867278790367, -122.442615482645) | |||
| 27278 | 27278 | 248364 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1501 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998466.8217 | 2108253.3731 | 37.768773410658895 | -122.44862143957701 | (37.7687734106589, -122.448621439577) | |||
| 27423 | 27423 | 251079 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 5616 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5989547.9545 | 2112698.1385 | 37.7804634926969 | -122.479796079248 | (37.7804634926969, -122.479796079248) | |||
| 27469 | 27469 | 143247 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 153 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010131.5523 | 2121103.7243 | 37.8047174875245 | -122.40918071917 | (37.8047174875245, -122.40918071917) | |||
| 27737 | 27737 | 248360 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1485 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998667.1431 | 2108281.3848 | 37.768861776014795 | -122.447930562543 | (37.7688617760148, -122.447930562543) | |||
| 27933 | 27933 | 143258 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6009397.1671 | 2120467.3833 | 37.8029290843214 | -122.41167715318599 | (37.8029290843214, -122.411677153186) | |||
| 27952 | 27952 | 143521 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2224 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002337.2397 | 2118485.1098 | 37.7970877186103 | -122.43596619228902 | (37.7970877186103, -122.435966192289) | |||
| 28034 | 28034 | 140161 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 251 ASHBURY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998791.141 | 2109784.5074 | 37.7729960548875 | -122.44760988046998 | (37.7729960548875, -122.44760988047) | |||
| 28054 | 28054 | 247274 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1637 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999148.0173 | 2109382.8294 | 37.7719135384803 | -122.446346504856 | (37.7719135384803, -122.446346504856) | |||
| 28056 | 28056 | 110580 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 403 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001169.4361 | 2110112.2986 | 37.7740317204292 | -122.43940658540899 | (37.7740317204292, -122.439406585409) | |||
| 28588 | 28588 | 143227 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 106 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010308.3267 | 2121146.7978 | 37.8048456584244 | -122.408572011197 | (37.8048456584244, -122.408572011197) | |||
| 28791 | 28791 | 142940 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 318 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6010703.4174 | 2118721.6624 | 37.7982089506036 | -122.40703370934798 | (37.7982089506036, -122.407033709348) | |||
| 28900 | 28900 | 98468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011948.2516 | 2107041.0959 | 37.7662064164751 | -122.40190466033701 | (37.7662064164751, -122.401904660337) | |||
| 29051 | 29051 | 181932 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2378 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 5985195.246 | 2099024.2764 | 37.74266505256279 | -122.49384596323 | (37.7426650525628, -122.49384596323) | |||
| 29158 | 29158 | 142470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1443 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010970.8958 | 2119887.8443 | 37.8014259659921 | -122.406190355577 | (37.8014259659921, -122.406190355577) | |||
| 29172 | 29172 | 138854 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 519 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004884.6976 | 2111071.1642 | 37.776875264769295 | -122.42662314727501 | (37.7768752647693, -122.426623147275) | |||
| 29189 | 29189 | 140683 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 21288 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5997608.0859 | 2110262.8359 | 37.774241738407795 | -122.451736704617 | (37.7742417384078, -122.451736704617) | |||
| 29557 | 29557 | 141085 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 3370 GEARY BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5996665.207 | 2112963.3629 | 37.781602631354794 | -122.455193467958 | (37.7816026313548, -122.455193467958) | |||
| 29578 | 29578 | 108616 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 289 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6010459.7673 | 2120958.2392 | 37.8043364033733 | -122.408034626667 | (37.8043364033733, -122.408034626667) | |||
| 29669 | 29669 | 137591 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1235 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6002786.4345 | 2112612.3356 | 37.7809880882364 | -122.433991859956 | (37.7809880882364, -122.433991859956) | |||
| 29701 | 29701 | 138739 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999270.4631 | 2114185.9407 | 37.7851086382869 | -122.446268530298 | (37.7851086382869, -122.446268530298) | |||
| 29770 | 29770 | 138507 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1701 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003042.8042 | 2114198.3962 | 37.785357557038296 | -122.433218313249 | (37.7853575570383, -122.433218313249) | |||
| 29780 | 29780 | 143503 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 24 GERKE ALY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010601.2344 | 2120203.101 | 37.80227089957479 | -122.407491794352 | (37.8022708995748, -122.407491794352) | |||
| 29795 | 29795 | 142969 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 155 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010117.5609 | 2121101.8588 | 37.804711581482294 | -122.40922900630501 | (37.8047115814823, -122.409229006305) | |||
| 29940 | 29940 | 138506 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1701 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003039.875 | 2114221.8295 | 37.7854217327846 | -122.43323012236999 | (37.7854217327846, -122.43323012237) | |||
| 30246 | 30246 | 140690 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003362.1468 | 2112293.1578 | 37.7801443609542 | -122.431977389111 | (37.7801443609542, -122.431977389111) | |||
| 30263 | 30263 | 143538 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2145 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002756.9739 | 2118500.147 | 37.797152842338704 | -122.434514886579 | (37.7971528423387, -122.434514886579) | |||
| 30500 | 30500 | 140709 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 PIERCE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002649.4537 | 2110396.2195 | 37.7748954127382 | -122.43430725979401 | (37.7748954127382, -122.434307259794) | |||
| 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) | |||
| 30721 | 30721 | 246053 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1456 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998746.9386 | 2108335.7426 | 37.7690155895077 | -122.447658470154 | (37.7690155895077, -122.447658470154) | |||
| 30821 | 30821 | 143043 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 443 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010277.7096 | 2120592.1376 | 37.8033209840901 | -122.40863881299299 | (37.8033209840901, -122.408638812993) | |||
| 30879 | 30879 | 247445 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 811 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003098.9445 | 2109936.0688 | 37.7736574554899 | -122.432719499751 | (37.7736574554899, -122.432719499751) | |||
| 30887 | 30887 | 140482 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1137 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003743.6898 | 2112670.736 | 37.781202719512 | -122.430684409839 | (37.781202719512, -122.430684409839) | |||
| 31071 | 31071 | 247300 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 815 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002551.3233 | 2109517.7945 | 37.772477905220796 | -122.434583889381 | (37.7724779052208, -122.434583889381) | |||
| 31190 | 31190 | 142631 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 241 BAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009683.097 | 2121540.8838 | 37.8058926846956 | -122.410763542627 | (37.8058926846956, -122.410763542627) | |||
| 31191 | 31191 | 143519 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2174 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002630.1383 | 2118528.26 | 37.79722283258779 | -122.434955780242 | (37.7972228325878, -122.434955780242) | |||
| 31267 | 31267 | 140047 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 997 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6002926.2641 | 2111608.0681 | 37.778238555435 | -122.433436333455 | (37.778238555435, -122.433436333455) | |||
| 31784 | 31784 | 98024 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1639 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988098.058999999 | 2098940.517 | 37.742604479099 | -122.483802857352 | (37.742604479099, -122.483802857352) | |||
| 31925 | 31925 | 139285 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 855 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003448.7737 | 2111306.0955 | 37.7774390440386 | -122.431607217597 | (37.7774390440386, -122.431607217597) | |||
| 32305 | 32305 | 141109 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 154 WOOD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998503.1758 | 2112860.4826 | 37.7814254265925 | -122.44882758656601 | (37.7814254265925, -122.448827586566) | |||
| 32946 | 32946 | 143537 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2125 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002811.2386 | 2118507.9925 | 37.797177464275705 | -122.434327678668 | (37.7971774642757, -122.434327678668) | |||
| 33304 | 33304 | 248365 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 701 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998521.6337 | 2108231.8723 | 37.7687175089215 | -122.44843030114201 | (37.7687175089215, -122.448430301142) | |||
| 33367 | 33367 | 141080 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 192 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996588.0468 | 2113019.8793 | 37.7817533832417 | -122.45546448989799 | (37.7817533832417, -122.455464489898) | |||
| 33458 | 33458 | 244504 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 697 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003691.552 | 2110018.3364 | 37.773916933054 | -122.430675451783 | (37.773916933054, -122.430675451783) |
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");