Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PermitNotes
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 284 | 284 | 137592 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1125 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1990 12:00:00 AM | 18 | Width 0ft | 6002857.6038 | 2112094.871 | 37.7795712988398 | -122.433708655697 | (37.7795712988398, -122.433708655697) | ||
| 954 | 954 | 251405 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 540 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:08:00 PM | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | |||
| 1154 | 1154 | 246084 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999058.5497 | 2108380.2585 | 37.7691556230859 | -122.446583834228 | (37.7691556230859, -122.446583834228) | |||
| 1164 | 1164 | 246083 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999078.2336 | 2108382.6812 | 37.7691633995354 | -122.446515923307 | (37.7691633995354, -122.446515923307) | |||
| 1169 | 1169 | 246080 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 12 | Width 0ft | Permit Number 17683 | 5999123.3551 | 2108389.3434 | 37.7691842694065 | -122.446360330481 | (37.7691842694065, -122.446360330481) | |
| 1172 | 1172 | 143012 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 336 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010686.887999999 | 2120692.5302 | 37.803619545603205 | -122.40722991099 | (37.8036195456032, -122.40722991099) | |||
| 1176 | 1176 | 246082 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999092.1637 | 2108384.801 | 37.7691700156221 | -122.44646789257601 | (37.7691700156221, -122.446467892576) | |||
| 2607 | 2607 | 139083 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2512 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6000143.6633 | 2113744.4727 | 37.7839463117797 | -122.443215821997 | (37.7839463117797, -122.443215821997) | |||
| 2797 | 2797 | 142505 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 620 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 22 | Width 0ft | Permit Number 774306 | 6010566.6807 | 2118940.2612 | 37.7988015168915 | -122.407522281284 | (37.7988015168915, -122.407522281284) | |
| 2908 | 2908 | 140145 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997912.6072 | 2109907.6306 | 37.7732838718856 | -122.45065770078699 | (37.7732838718856, -122.450657700787) | |||
| 2909 | 2909 | 140144 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997892.6775 | 2109904.5645 | 37.7732743123753 | -122.450726418895 | (37.7732743123753, -122.450726418895) | |||
| 2910 | 2910 | 140146 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997931.7703 | 2109910.6967 | 37.773293387477395 | -122.450591634422 | (37.7732933874774, -122.450591634422) | |||
| 2923 | 2923 | 140143 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1981 12:00:00 AM | 9 | Width 0ft | Permit Number 19125 | 5997871.2148 | 2109901.8816 | 37.7732657172386 | -122.45080046745001 | (37.7732657172386, -122.45080046745) | |
| 3219 | 3219 | 142514 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 624 VALLEJO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 20 | Width 0ft | Permit Number 774306 | 6010535.3238 | 2118936.1488 | 37.7987884700296 | -122.407630496745 | (37.7987884700296, -122.407630496745) | |
| 3249 | 3249 | 142515 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 624 VALLEJO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 21 | Width 0ft | Permit Number 774306 | 6010502.9388 | 2118931.0084 | 37.7987725428783 | -122.40774219721901 | (37.7987725428783, -122.407742197219) | |
| 3328 | 3328 | 140422 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6002931.6326 | 2112346.6107 | 37.7802667133087 | -122.43347055342699 | (37.7802667133087, -122.433470553427) | |||
| 3334 | 3334 | 140424 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6002981.8736 | 2112352.3525 | 37.7802853291655 | -122.43329715719 | (37.7802853291655, -122.43329715719) | |||
| 3335 | 3335 | 140428 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003076.6138 | 2112365.9894 | 37.7803281468599 | -122.43297038187401 | (37.7803281468599, -122.432970381874) | |||
| 3337 | 3337 | 140433 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 15 | Width 0ft | 6003251.7396 | 2112391.1099 | 37.7804070531695 | -122.432366335522 | (37.7804070531695, -122.432366335522) | |||
| 3339 | 3339 | 140429 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 15 | Width 0ft | 6003096.7102 | 2112369.578 | 37.7803391401181 | -122.432901115602 | (37.7803391401181, -122.432901115602) | |||
| 3342 | 3342 | 140426 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 12 | Width 0ft | 6003027.0905 | 2112359.5298 | 37.7803076012967 | -122.43314124413601 | (37.7803076012967, -122.433141244136) | |||
| 3343 | 3343 | 140423 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6002956.7531 | 2112350.9171 | 37.7802799627924 | -122.43338395792802 | (37.7802799627924, -122.433383957928) | |||
| 3344 | 3344 | 140425 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 12 | Width 0ft | 6003006.2764 | 2112357.3766 | 37.780300508432795 | -122.43321309578998 | (37.7803005084328, -122.43321309579) | |||
| 3347 | 3347 | 140434 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 Turk St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003279.731000001 | 2112394.6985 | 37.780418493723204 | -122.43226975660299 | (37.7804184937232, -122.432269756603) | |||
| 3349 | 3349 | 140427 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003052.211 | 2112362.4007 | 37.7803169090148 | -122.43305454594 | (37.7803169090148, -122.43305454594) | |||
| 3351 | 3351 | 140431 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003184.2731 | 2112381.0617 | 37.7803756375453 | -122.432599015585 | (37.7803756375453, -122.432599015585) | |||
| 4223 | 4223 | 246149 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998439.5671 | 2108294.2551 | 37.7688841037799 | -122.44871865576 | (37.7688841037799, -122.44871865576) | |||
| 4236 | 4236 | 246150 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998421.7001 | 2108292.1353 | 37.7688772616464 | -122.448780303512 | (37.7688772616464, -122.448780303512) | |||
| 4243 | 4243 | 246126 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998264.228999999 | 2108270.3316 | 37.768808388052605 | -122.449323411621 | (37.7688083880526, -122.449323411621) | |||
| 4247 | 4247 | 246146 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | 16 | Width 0ft | Permit Number 18128 | 5998494.9848 | 2108301.523 | 37.76890722837079 | -122.44852749406 | (37.7689072283708, -122.44852749406) | |
| 4265 | 4265 | 246125 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 13 | Width 0ft | Permit Number 17701 | 5998276.9478 | 2108272.4514 | 37.7688149359981 | -122.44927957115101 | (37.7688149359981, -122.449279571151) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");