Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189114 | 189114 | 226186 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 148 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008641.8529900005 | 2097858.0991599998 | 37.740806894324706 | -122.412691646299 | (37.7408068943247, -122.412691646299) | |||
| 189084 | 189084 | 226247 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 3388 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005816.50215 | 2103176.18646 | 37.7552501655856 | -122.422838522483 | (37.7552501655856, -122.422838522483) | |||
| 189075 | 189075 | 219048 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1511 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994267.29691 | 2105231.39459 | 37.760234822608204 | -122.462927900797 | (37.7602348226082, -122.462927900797) | |||
| 189030 | 189030 | 128980 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 199 McAllister St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6008492.62721 | 2112417.9062099997 | 37.7807764092316 | -122.414237490093 | (37.7807764092316, -122.414237490093) | |||
| 188933 | 188933 | 219023 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1700 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993391.46248 | 2103845.40057 | 37.7563787563006 | -122.465856267847 | (37.7563787563006, -122.465856267847) | |||
| 188913 | 188913 | 34598 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3200 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38292 | 5999298.828509999 | 2116018.40828 | 37.7901417341159 | -122.446302262734 | (37.7901417341159, -122.446302262734) | |
| 188883 | 188883 | 228271 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 16 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003334.18679 | 2107439.7667900003 | 37.766816559572895 | -122.43172749535 | (37.7668165595729, -122.43172749535) | |||
| 188829 | 188829 | 192455 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015093.59636 | 2102524.29003 | 37.753979277831505 | -122.390709755862 | (37.7539792778315, -122.390709755862) | |||
| 188768 | 188768 | 52696 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1825@ BAKER McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/31/2006 12:00:00 AM | 1 | Permit Number 48763 | 6000364.5723 | 2111291.0627 | 37.777222470367 | -122.44227537661502 | (37.777222470367, -122.442275376615) | |
| 188728 | 188728 | 200873 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1699 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6011533.1129 | 2106956.9269 | 37.7659521300216 | -122.403334631195 | (37.7659521300216, -122.403334631195) | |||
| 188634 | 188634 | 192500 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1600 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6012867.40065 | 2105213.28647 | 37.7612389111745 | -122.39859720412501 | (37.7612389111745, -122.398597204125) | |||
| 188627 | 188627 | 128882 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2728 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5999935.66766 | 2118151.33165 | 37.7960345301288 | -122.444252194282 | (37.7960345301288, -122.444252194282) | |||
| 188603 | 188603 | 129020 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 979 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010113.76388 | 2117481.29123 | 37.794770179562896 | -122.40898653121401 | (37.7947701795629, -122.408986531214) | |||
| 188571 | 188571 | 190561 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 28 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012183.89339 | 2107477.90893 | 37.767418955150106 | -122.40112031234501 | (37.7674189551501, -122.401120312345) | |||
| 188351 | 188351 | 247804 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 488 30th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6003501.316380001 | 2098369.19661 | 37.7419203917212 | -122.430502145662 | (37.7419203917212, -122.430502145662) | |||
| 188313 | 188313 | 49817 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1226 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46608 | 6012208.775640001 | 2102677.6526599997 | 37.7542399031726 | -122.400696986204 | (37.7542399031726, -122.400696986204) |
| 188287 | 188287 | 228293 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2309 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002091.66431 | 2107038.0943299998 | 37.7656431556226 | -122.435996424216 | (37.7656431556226, -122.435996424216) | |||
| 188067 | 188067 | 228312 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 229 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000835.94926 | 2106462.40588 | 37.7639910407901 | -122.440298367199 | (37.7639910407901, -122.440298367199) | |||
| 188037 | 188037 | 226039 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 200 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006471.1678 | 2104908.6672099996 | 37.7600440727952 | -122.420697473205 | (37.7600440727952, -122.420697473205) | |||
| 187876 | 187876 | 128909 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1620 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004047.371 | 2120116.17018 | 37.8016631907718 | -122.430165140031 | (37.8016631907718, -122.430165140031) | |||
| 187816 | 187816 | 43812 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 193 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2000 12:00:00 AM | 1 | Permit Number 43443 | 5990206.91027 | 2114192.65817 | 37.7846052867946 | -122.477625737803 | (37.7846052867946, -122.477625737803) | ||
| 187718 | 187718 | 129002 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1564 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006007.80394 | 2118305.26867 | 37.7968017552614 | -122.423252333851 | (37.7968017552614, -122.423252333851) | |||
| 187696 | 187696 | 64369 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 522 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 5 | Permit Number 25208 | 6010359.9072 | 2120301.2434 | 37.8025268636696 | -122.408333834018 | (37.8025268636696, -122.408333834018) | |
| 187622 | 187622 | 113847 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2x Bay View St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 4x4 | 6014575.046159999 | 2094706.3840700001 | 37.7324841526011 | -122.391956386193 | (37.7324841526011, -122.391956386193) | |||
| 187543 | 187543 | 80805 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 991 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2003 12:00:00 AM | 3 | 6015535.39126 | 2104617.2014200003 | 37.7597504684343 | -122.389328050963 | (37.7597504684343, -122.389328050963) | ||
| 187502 | 187502 | 128903 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 341 Spruce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997136.99207 | 2115139.1761 | 37.78760389404871 | -122.45371848962601 | (37.7876038940487, -122.453718489626) | |||
| 187428 | 187428 | 190614 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 54 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008913.4409300005 | 2109768.34345 | 37.7735249651431 | -122.412594331567 | (37.7735249651431, -122.412594331567) | |||
| 187421 | 187421 | 70618 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1557 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 2 | 6007346.38924 | 2116443.2469099998 | 37.7917645589423 | -122.418488407316 | (37.7917645589423, -122.418488407316) | ||
| 187189 | 187189 | 225618 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Lippard Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002076.31903 | 2096053.6546599998 | 37.7354816235692 | -122.435263729452 | (37.7354816235692, -122.435263729452) | |||
| 187114 | 187114 | 225993 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 47 Octavia St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6005632.01245 | 2109568.33209 | 37.77279107248339 | -122.423931063861 | (37.7727910724834, -122.423931063861) | |||
| 187062 | 187062 | 34615 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3251 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38299 | 5999148.918409999 | 2115949.9944 | 37.789945324867396 | -122.44681601304801 | (37.7899453248674, -122.446816013048) | |
| 187043 | 187043 | 226235 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 59 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005919.60311 | 2102846.7932700003 | 37.7543515449941 | -122.422458564316 | (37.7543515449941, -122.422458564316) | |||
| 186829 | 186829 | 192496 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 301 Kansas St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6011473.84765 | 2106919.34293 | 37.765845622699 | -122.403536974176 | (37.765845622699, -122.403536974176) | |||
| 186674 | 186674 | 71812 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 340 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1982 12:00:00 AM | 7 | 5997177.69428 | 2115152.46792 | 37.787642723191 | -122.45357862886499 | (37.787642723191, -122.453578628865) | ||
| 186435 | 186435 | 226048 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 939 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009966.30699 | 2103737.55457 | 37.7570248301416 | -122.40852679868799 | (37.7570248301416, -122.408526798688) | |||
| 186158 | 186158 | 31686 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 27 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35190 | 5998796.85554 | 2105377.1167099997 | 37.7608947999625 | -122.447272843484 | (37.7608947999625, -122.447272843484) | |
| 186074 | 186074 | 219018 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1371 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991112.59614 | 2106090.92873 | 37.7624126595246 | -122.473901124453 | (37.7624126595246, -122.473901124453) | |||
| 186037 | 186037 | 46276 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 950 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2002 12:00:00 AM | 5 | Permit Number 44559 | 6011785.7533599995 | 2111490.43088 | 37.7784142049779 | -122.402779656872 | (37.7784142049779, -122.402779656872) | ||
| 186006 | 186006 | 128912 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2451 Steiner St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6002274.04301 | 2116265.77897 | 37.790990420708795 | -122.43602597863399 | (37.7909904207088, -122.436025978634) | |||
| 185903 | 185903 | 219024 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1700 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993391.6022 | 2103829.01605 | 37.756333776709795 | -122.46585459421001 | (37.7563337767098, -122.46585459421) | |||
| 185876 | 185876 | 190602 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 355 Campus Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015271.57365 | 2107530.7974 | 37.7677359418886 | -122.39044405476601 | (37.7677359418886, -122.390444054766) | |||
| 185839 | 185839 | 250211 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 212 Union St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011741.8662 | 2119796.92436 | 37.80121941579 | -122.40351603796002 | (37.80121941579, -122.40351603796) | |||
| 185812 | 185812 | 48898 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2220 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/2002 12:00:00 AM | 3 | Permit Number 46101 | 6003904.89835 | 2116333.0784400003 | 37.7912677221834 | -122.430388088265 | (37.7912677221834, -122.430388088265) | |
| 185787 | 185787 | 176545 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 211 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001932.43432 | 2093910.0603200002 | 37.7295876332484 | -122.43560788559401 | (37.7295876332484, -122.435607885594) | |||
| 185689 | 185689 | 51882 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3655 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | 3 | Permit Number 48098 | 5997353.65964 | 2115375.0125 | 37.7882638570339 | -122.45298589648701 | (37.7882638570339, -122.452985896487) | ||
| 185577 | 185577 | 226131 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 485 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002839.72641 | 2098580.41414 | 37.742462845679704 | -122.43280479319999 | (37.7424628456797, -122.4328047932) | |||
| 185488 | 185488 | 228305 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 27 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000858.57569 | 2106214.0094 | 37.7633102935442 | -122.440202295322 | (37.7633102935442, -122.440202295322) | |||
| 185385 | 185385 | 92889 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 800 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 53104 Tree no. 1 on Montgomery St | 6011723.54732 | 2118091.83637 | 37.796536633310204 | -122.403459403146 | (37.7965366333102, -122.403459403146) | |
| 185320 | 185320 | 190379 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 701 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011294.578919999 | 2105037.91315 | 37.7606696241197 | -122.40402461443999 | (37.7606696241197, -122.40402461444) | |||
| 185299 | 185299 | 226287 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 409 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001522.23249 | 2103413.51849 | 37.755658588185 | -122.437706349282 | (37.755658588185, -122.437706349282) | |||
| 185282 | 185282 | 34599 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3200 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38292 | 5999320.20166 | 2116021.69073 | 37.7901519674937 | -122.446228549814 | (37.7901519674937, -122.446228549814) | |
| 185259 | 185259 | 200877 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1699 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6011650.0936 | 2106961.6822 | 37.765971719834496 | -122.402930351127 | (37.7659717198345, -122.402930351127) | |||
| 185163 | 185163 | 226087 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 328 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009452.41278 | 2099606.00584 | 37.7456517238662 | -122.410012386961 | (37.7456517238662, -122.410012386961) | |||
| 185150 | 185150 | 192507 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1635 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012770.1192 | 2105624.27861 | 37.7623619845437 | -122.398962508731 | (37.7623619845437, -122.398962508731) | |||
| 185149 | 185149 | 190465 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 253 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014265.46141 | 2115228.4043099997 | 37.7888159670408 | -122.39446315554399 | (37.7888159670408, -122.394463155544) | |||
| 185148 | 185148 | 128890 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997463.97068 | 2116280.29604 | 37.790755845141796 | -122.452669602227 | (37.7907558451418, -122.452669602227) | |||
| 185134 | 185134 | 226179 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 566 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007667.81657 | 2096713.25784 | 37.737608695594794 | -122.415978455238 | (37.7376086955948, -122.415978455238) | |||
| 184991 | 184991 | 226262 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1107 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001973.07538 | 2100820.5309200003 | 37.748564487677896 | -122.435961663593 | (37.7485644876779, -122.435961663593) | |||
| 184926 | 184926 | 141543 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2000 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998090.9824 | 2110680.0015 | 37.77541481179011 | -122.450096360144 | (37.7754148117901, -122.450096360144) | |||
| 184879 | 184879 | 190583 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 448 South St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015780.1959 | 2107952.51143 | 37.7689220784184 | -122.388714219602 | (37.7689220784184, -122.388714219602) | |||
| 184786 | 184786 | 219120 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Brompton Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002027.685269999 | 2095060.20973 | 37.7327510902846 | -122.435360833759 | (37.7327510902846, -122.435360833759) | |||
| 184777 | 184777 | 190486 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 543 Delancey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 6ft | 6015531.29876 | 2113374.48851 | 37.7837958236503 | -122.38995394312201 | (37.7837958236503, -122.389953943122) | |||
| 184752 | 184752 | 190412 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 15 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012337.1891 | 2100920.23068 | 37.7494215649704 | -122.400129481597 | (37.7494215649704, -122.400129481597) | |||
| 184706 | 184706 | 228244 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 4004 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003567.670609999 | 2104224.8478200003 | 37.7580023968168 | -122.43069047450899 | (37.7580023968168, -122.430690474509) | |||
| 184648 | 184648 | 228338 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1768 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003965.24462 | 2097947.62405 | 37.7407891201243 | -122.428867983974 | (37.7407891201243, -122.428867983974) | |||
| 184609 | 184609 | 190458 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 5 Anthony St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6012807.74756 | 2115150.71577 | 37.788521509194396 | -122.39950121700399 | (37.7885215091944, -122.399501217004) | |||
| 184451 | 184451 | 219039 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1627 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 5993060.22205 | 2104376.39967 | 37.757817628384295 | -122.46704040701 | (37.7578176283843, -122.46704040701) | |||
| 184450 | 184450 | 225726 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 746 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001865.2835099995 | 2101826.25024 | 37.751319829644295 | -122.436406375661 | (37.7513198296443, -122.436406375661) | |||
| 184412 | 184412 | 96002 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1440 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767657 | 6015789.5338 | 2093564.664 | 37.729416568442204 | -122.387677946908 | (37.7294165684422, -122.387677946908) |
| 184373 | 184373 | 128923 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2101 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004469.58856 | 2116691.73972 | 37.792284485798895 | -122.42845985006201 | (37.7922844857989, -122.428459850062) | |||
| 184338 | 184338 | 219126 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 149 Hamerton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001351.76751 | 2095328.8585299999 | 37.7334503284649 | -122.437716879455 | (37.7334503284649, -122.437716879455) | |||
| 184310 | 184310 | 190596 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 526 Nelson Rising Ln | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015327.51547 | 2108275.8962 | 37.7697849230597 | -122.390302621093 | (37.7697849230597, -122.390302621093) | |||
| 184265 | 184265 | 226214 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1305 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6009286.15828 | 2101504.17744 | 37.7508543630588 | -122.41072130007099 | (37.7508543630588, -122.410721300071) | |||
| 184119 | 184119 | 128998 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1717 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008298.90003 | 2118387.0949 | 37.797155462209204 | -122.41533038218999 | (37.7971554622092, -122.41533038219) | |||
| 184087 | 184087 | 46280 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 950 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2002 12:00:00 AM | 4 | Permit Number 44559 | 6011730.78732 | 2111437.87728 | 37.7782668357705 | -122.402966108791 | (37.7782668357705, -122.402966108791) | ||
| 184008 | 184008 | 225766 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 3810 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004180.53314 | 2104840.25019 | 37.7597268477429 | -122.428614802339 | (37.7597268477429, -122.428614802339) | |||
| 183968 | 183968 | 226171 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1306 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997796.8768 | 2106112.09551 | 37.7628556763806 | -122.450784307568 | (37.7628556763806, -122.450784307568) | |||
| 183908 | 183908 | 120713 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 124 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5989311.23496 | 2114525.1179299997 | 37.7854661101097 | -122.480748784796 | (37.7854661101097, -122.480748784796) | |||
| 183786 | 183786 | 54864 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1801 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1992 12:00:00 AM | 3 | Permit Number 30984 | 5999159.7757 | 2110086.9017 | 37.773847413176206 | -122.446356490513 | (37.7738474131762, -122.446356490513) | ||
| 183755 | 183755 | 219140 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002002.66106 | 2094856.00835 | 37.732188978916994 | -122.43543274625 | (37.732188978917, -122.43543274625) | |||
| 183754 | 183754 | 190491 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 541 Delancey St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6015329.13045 | 2113592.35808 | 37.7843828300441 | -122.390668605586 | (37.7843828300441, -122.390668605586) | |||
| 183661 | 183661 | 190548 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 888 07th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6012403.14406 | 2108680.79722 | 37.7707340441832 | -122.400446452154 | (37.7707340441832, -122.400446452154) | |||
| 183616 | 183616 | 101840 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 654 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769499 | 6011223.03061 | 2105283.28605 | 37.761339365434395 | -122.404289339783 | (37.7613393654344, -122.404289339783) | |
| 183518 | 183518 | 128927 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2101 Washington St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6004695.29857 | 2116719.42491 | 37.7923732722634 | -122.427680861803 | (37.7923732722634, -122.427680861803) | |||
| 183449 | 183449 | 190390 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1750 22nd St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6012854.72935 | 2103804.1749299997 | 37.7573690942352 | -122.39854214671699 | (37.7573690942352, -122.398542146717) | ||||
| 183415 | 183415 | 49085 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 694 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2003 12:00:00 AM | 3 | Permit Number 46235 | 6012078.79624 | 2105212.56248 | 37.7611929566964 | -122.40132461763399 | (37.7611929566964, -122.401324617634) | ||
| 183398 | 183398 | 225761 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 566 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6003615.33526 | 2104949.13531 | 37.7599938177664 | -122.430577311017 | (37.7599938177664, -122.430577311017) | |||
| 183327 | 183327 | 225723 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 4334 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001685.739130001 | 2101191.65268 | 37.74956717239 | -122.43698183206499 | (37.74956717239, -122.436981832065) | |||
| 183299 | 183299 | 225664 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 38 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005708.08098 | 2097456.05555 | 37.7395378753597 | -122.422806976984 | (37.7395378753597, -122.422806976984) | |||
| 183285 | 183285 | 219054 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1020 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992916.05504 | 2098440.23001 | 37.7415101074999 | -122.467107408302 | (37.7415101074999, -122.467107408302) | |||
| 183247 | 183247 | 98791 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950 Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 1 | 3x6 | Permit Number 768771 | 6010164.1906 | 2117196.54488 | 37.7939911598214 | -122.408791948484 | (37.7939911598214, -122.408791948484) | |
| 183194 | 183194 | 190529 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 21 Clarence Pl | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6014722.79424 | 2111890.37318 | 37.7796759079438 | -122.392647234607 | (37.7796759079438, -122.392647234607) | |||
| 183182 | 183182 | 225722 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 4372 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001470.61216 | 2101182.2984 | 37.74952925789 | -122.43772507676701 | (37.74952925789, -122.437725076767) | |||
| 183178 | 183178 | 190605 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 355 Campus Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015358.3408699995 | 2107532.97001 | 37.767746720263794 | -122.390144086798 | (37.7677467202638, -122.390144086798) | |||
| 183057 | 183057 | 226282 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 121 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000625.83806 | 2102333.64132 | 37.7526424976587 | -122.44072889961299 | (37.7526424976587, -122.440728899613) | |||
| 182988 | 182988 | 129014 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1500 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6011826.76829 | 2120892.13124 | 37.8042313289751 | -122.40329932649901 | (37.8042313289751, -122.403299326499) | |||
| 182911 | 182911 | 190416 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1881 Oakdale Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6013555.65434 | 2096549.25202 | 37.7374876405431 | -122.39560976237699 | (37.7374876405431, -122.395609762377) | |||
| 182892 | 182892 | 219127 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 137 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001368.15711 | 2095390.1183799999 | 37.733619465763205 | -122.437664601839 | (37.7336194657632, -122.437664601839) | |||
| 182829 | 182829 | 226067 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 797 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010176.28579 | 2104603.76436 | 37.7594150051135 | -122.40786168886801 | (37.7594150051135, -122.407861688868) | |||
| 182788 | 182788 | 97538 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2001 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2011 12:00:00 AM | 2 | 3x3 | Permit Number 58907 | 6011736.89369 | 2105103.8240099996 | 37.7608753035814 | -122.40249947307501 | (37.7608753035814, -122.402499473075) |
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");