Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16896 | 16896 | 100001 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X 01st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Address is 100 1st Street | |||||||||
| 165598 | 165598 | 176477 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 37 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002111.84755 | 2087511.4643599999 | 37.7120287084207 | -122.434530308936 | (37.7120287084207, -122.434530308936) | |||
| 107056 | 107056 | 104507 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99x DICHIERA CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5998517.0 | 2087907.0 | 37.7129100350962 | -122.44698352706499 | (37.7129100350962, -122.446983527065) | |||
| 60199 | 60199 | 30866 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 8 Tioga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | 13 | Permit Number 34703 | 6011319.26825 | 2088660.76535 | 37.7157028373837 | -122.402787421618 | (37.7157028373837, -122.402787421618) | ||
| 35305 | 35305 | 176450 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 306 Niagara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5998817.229619999 | 2090113.0618900002 | 37.718984525607 | -122.446104420884 | (37.718984525607, -122.446104420884) | |||
| 60281 | 60281 | 202078 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Gould St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6012742.601 | 2090834.0731400002 | 37.721749674703496 | -122.398020073164 | (37.7217496747035, -122.398020073164) | ||||
| 11127 | 11127 | 17225 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1880X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1990 12:00:00 AM | 20 | 3X3 | 6001020.116669999 | 2091172.22125 | 37.7220182913915 | -122.438565764807 | (37.7220182913915, -122.438565764807) | ||
| 72441 | 72441 | 176475 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 631 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 53 | Width 3ft | 6009778.33855 | 2091470.0330700001 | 37.7233303456119 | -122.40831163228201 | (37.7233303456119, -122.408311632282) | |||
| 67956 | 67956 | 176458 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 457 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007542.94981 | 2091608.68611 | 37.723585627160794 | -122.41604878674299 | (37.7235856271608, -122.416048786743) | |||
| 46699 | 46699 | 176455 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1535 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007043.36789 | 2091721.1381400002 | 37.72386629477921 | -122.41778372465099 | (37.7238662947792, -122.417783724651) | |||
| 61616 | 61616 | 176459 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 413 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6007513.47384 | 2091725.2307 | 37.7239039763787 | -122.416158930301 | (37.7239039763787, -122.416158930301) | |||
| 63116 | 63116 | 34940 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 448 Amherst St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/2000 12:00:00 AM | 6 | Permit Number 38537 | 6007767.30311 | 2091743.1741799999 | 37.7239675143844 | -122.415282750512 | (37.7239675143844, -122.415282750512) | |
| 31530 | 31530 | 176457 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 432 Amherst St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007753.63778 | 2091789.4964700001 | 37.7240939374796 | -122.415333267232 | (37.7240939374796, -122.415333267232) | |||
| 158485 | 158485 | 176456 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 418 Amherst St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6007734.27889 | 2091838.5588099998 | 37.7242275641336 | -122.415403659872 | (37.7242275641336, -122.415403659872) | |||
| 74833 | 74833 | 176447 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 843 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001152.60647 | 2092059.5558 | 37.7244622467113 | -122.438171314947 | (37.7244622467113, -122.438171314947) | |||
| 64822 | 64822 | 176448 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 843 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6001153.28465 | 2092061.4502700001 | 37.724467487066 | -122.43816910622401 | (37.724467487066, -122.438169106224) | |||
| 30172 | 30172 | 176454 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1609 Burrows St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6006663.80662 | 2092086.9978599998 | 37.7248494992863 | -122.41912174768801 | (37.7248494992863, -122.419121747688) | |||
| 72845 | 72845 | 176436 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 463 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009577.49826 | 2092143.36094 | 37.725167914146 | -122.40905338952 | (37.725167914146, -122.40905338952) | |||
| 59721 | 59721 | 176437 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 463 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009568.704580001 | 2092164.8194900001 | 37.725226342194794 | -122.409085301949 | (37.7252263421948, -122.409085301949) | |||
| 184054 | 184054 | 176438 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 457 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009565.15013 | 2092176.9971099999 | 37.725259580258204 | -122.409098448262 | (37.7252595802582, -122.409098448262) | |||
| 111915 | 111915 | 176439 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 457 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6009562.305930001 | 2092184.9167799999 | 37.725281166673 | -122.409108838997 | (37.725281166673, -122.409108838997) | |||
| 44703 | 44703 | 176440 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 451 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009554.85724 | 2092203.7224400002 | 37.7253323857764 | -122.40913591488399 | (37.7253323857764, -122.409135914884) | |||
| 56299 | 56299 | 176441 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 451 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6009551.98522 | 2092218.4392099997 | 37.725372634037 | -122.409146881221 | (37.725372634037, -122.409146881221) | |||
| 185388 | 185388 | 176449 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 817 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001220.52796 | 2092231.19277 | 37.7249373855418 | -122.43794880828501 | (37.7249373855418, -122.437948808285) | |||
| 158913 | 158913 | 62132 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 145 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/31/1985 12:00:00 AM | 11 | Permit Number 22246 | 6001265.02575 | 2092251.26554 | 37.724995031173 | -122.437796421771 | (37.724995031173, -122.437796421771) | |
| 54717 | 54717 | 176442 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 439 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6009537.48644 | 2092260.08015 | 37.7254861590383 | -122.40919993944401 | (37.7254861590383, -122.409199939444) | |||
| 64350 | 64350 | 176443 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 439 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6009532.53015 | 2092277.47605 | 37.7255336468499 | -122.409218299982 | (37.7255336468499, -122.409218299982) | |||
| 170010 | 170010 | 176444 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 427 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 1ft | 6009521.33765 | 2092315.76215 | 37.725638145367896 | -122.409259692199 | (37.7256381453679, -122.409259692199) | |||
| 162841 | 162841 | 62134 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 215 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/31/1985 12:00:00 AM | 11 | Permit Number 22242 | 6001128.8833099995 | 2092317.53271 | 37.725169243356795 | -122.438271795315 | (37.7251692433568, -122.438271795315) | |
| 13023 | 13023 | 96561 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 421 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x2 | 6009510.75375 | 2092344.78253 | 37.725717236250404 | -122.40929832706101 | (37.7257172362504, -122.409298327061) | |||
| 12965 | 12965 | 96562 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 421 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x2 | 6009504.65574 | 2092358.16495 | 37.7257536399061 | -122.40932035147199 | (37.7257536399061, -122.409320351472) | |||
| 170240 | 170240 | 67288 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 78 Valmar Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1992 12:00:00 AM | 10 | Permit Number 30764 | 6005282.20957 | 2092652.1251400001 | 37.7263233136635 | -122.423937939201 | (37.7263233136635, -122.423937939201) | |
| 59193 | 59193 | 190149 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2399 Lane St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6013956.81212 | 2092846.6213599998 | 37.727343279763296 | -122.393963643334 | (37.7273432797633, -122.393963643334) | ||||
| 131235 | 131235 | 190150 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2399 Lane St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6013973.08997 | 2092870.4197900002 | 37.7274095301006 | -122.393909035588 | (37.7274095301006, -122.393909035588) | ||||
| 187632 | 187632 | 68261 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 331 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 4 | Permit Number 32067 | 6009662.93548 | 2092873.24927 | 37.72717681975 | -122.40880951134301 | (37.72717681975, -122.408809511343) | |
| 152165 | 152165 | 176453 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 140 Madison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6005488.1147 | 2093033.7267 | 37.7273827303155 | -122.42325324845801 | (37.7273827303155, -122.423253248458) | |||
| 24553 | 24553 | 218912 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 67 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993729.09341 | 2093249.4084299998 | 37.727304294154294 | -122.463919522093 | (37.7273042941543, -122.463919522093) | |||
| 44328 | 44328 | 176451 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 26 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004464.43685 | 2093359.77432 | 37.7282201592217 | -122.426815314696 | (37.7282201592217, -122.426815314696) | |||
| 40335 | 40335 | 176452 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 302 Congdon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004691.53481 | 2093582.22817 | 37.728843805794604 | -122.42604605710501 | (37.7288438057946, -122.426046057105) | |||
| 34828 | 34828 | 218916 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 544 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5996794.9301 | 2093643.7566799999 | 37.728563285644604 | -122.453349451027 | (37.7285632856446, -122.453349451027) | |||
| 188597 | 188597 | 63627 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 67 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1987 12:00:00 AM | 4 | Permit Number 24270 | 6007827.91665 | 2093727.62728 | 37.7294198035797 | -122.415213626819 | (37.7294198035797, -122.415213626819) | ||
| 38130 | 38130 | 176461 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 University St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 6007804.4952 | 2093798.5187099997 | 37.7296131398345 | -122.415299613696 | (37.7296131398345, -122.415299613696) | |||
| 171580 | 171580 | 176462 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 49 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007792.32037 | 2093837.33535 | 37.7297190376839 | -122.41534445031 | (37.7297190376839, -122.41534445031) | |||
| 57234 | 57234 | 176460 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 44 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007750.308680001 | 2093850.57918 | 37.7297530410657 | -122.41549062698999 | (37.7297530410657, -122.41549062699) | |||
| 50904 | 50904 | 60868 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 37 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | 11 | Permit Number 20650 | 6001292.560409999 | 2093871.7493599998 | 37.7294460754672 | -122.437817248275 | (37.7294460754672, -122.437817248275) | ||
| 74714 | 74714 | 176445 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 37 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001283.54641 | 2093883.1202 | 37.7294767846155 | -122.43784922458 | (37.7294767846155, -122.43784922458) | |||
| 38704 | 38704 | 52949 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 31 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 14 | Permit Number 48936 | 6001265.83557 | 2093905.19731 | 37.7295363961645 | -122.437912033237 | (37.7295363961645, -122.437912033237) | |
| 33976 | 33976 | 218944 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 135 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996130.94498 | 2093909.94735 | 37.7292560999702 | -122.455664103608 | (37.7292560999702, -122.455664103608) | |||
| 70146 | 70146 | 176476 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 718 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007131.88508 | 2094081.13811 | 37.730351325829794 | -122.417644925979 | (37.7303513258298, -122.417644925979) | |||
| 117025 | 117025 | 176446 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 43 Gorham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002168.44276 | 2094346.29605 | 37.7307988392865 | -122.434823165056 | (37.7307988392865, -122.434823165056) | |||
| 46230 | 46230 | 176467 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 131 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010016.33557 | 2094749.8963400002 | 37.732349484523894 | -122.407720071722 | (37.7323494845239, -122.407720071722) | |||
| 179621 | 179621 | 176466 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 254 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009274.61582 | 2094752.0999599998 | 37.732313985602396 | -122.410284534429 | (37.7323139856024, -122.410284534429) | |||
| 182418 | 182418 | 176465 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 217 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009430.63613 | 2094763.1944799998 | 37.732353193350704 | -122.409745916959 | (37.7323531933507, -122.409745916959) | |||
| 130468 | 130468 | 111177 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 211 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009453.8507900005 | 2094770.8247200001 | 37.732375445275395 | -122.409666196537 | (37.7323754452754, -122.409666196537) | |||
| 183005 | 183005 | 176468 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 118 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010056.1152800005 | 2094810.2688799999 | 37.7325174814929 | -122.407586798503 | (37.7325174814929, -122.407586798503) | |||
| 187826 | 187826 | 176464 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300 Gaven St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6008910.663480001 | 2094859.0925900002 | 37.7325873561203 | -122.41155036257099 | (37.7325873561203, -122.411550362571) | |||
| 148862 | 148862 | 176463 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300 Gaven St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 4ft | 6008926.06204 | 2094862.35921 | 37.7325971892913 | -122.41149735652 | (37.7325971892913, -122.41149735652) | |||
| 54987 | 54987 | 176469 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 167 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009736.652980001 | 2094872.31447 | 37.7326699579377 | -122.40869563649099 | (37.7326699579377, -122.408695636491) | |||
| 168230 | 168230 | 176472 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 178 Sweeny St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 4ft | 6009645.3136599995 | 2094885.75982 | 37.732701759760396 | -122.40901236872699 | (37.7327017597604, -122.409012368727) | |||
| 76916 | 76916 | 218961 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 387 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999533.62345 | 2094950.56733 | 37.7323080815474 | -122.443975525052 | (37.7323080815474, -122.443975525052) | |||
| 65997 | 65997 | 176471 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 138 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6009867.29954 | 2094965.9555099998 | 37.7329343927939 | -122.40825055931002 | (37.7329343927939, -122.40825055931) | |||
| 69664 | 69664 | 176470 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 130 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6009916.73377 | 2094983.66925 | 37.732985798939204 | -122.408080900424 | (37.7329857989392, -122.408080900424) | |||
| 41511 | 41511 | 176474 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 230 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009301.38379 | 2094985.2153200002 | 37.732955570929 | -122.410208443664 | (37.732955570929, -122.410208443664) | |||
| 164774 | 164774 | 218960 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 374 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5999594.52291 | 2094990.63523 | 37.7324215723769 | -122.44376785989901 | (37.7324215723769, -122.443767859899) | ||||
| 65095 | 65095 | 54543 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 147 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 9 | Permit Number 10338 | 6009783.43308 | 2095111.41047 | 37.73332908455421 | -122.408550765616 | (37.7333290845542, -122.408550765616) | ||
| 448 | 448 | 224849 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 779889 | 6003244.1353400005 | 2095137.54828 | 37.733032453088704 | -122.431160782146 | (37.7330324530887, -122.431160782146) | ||
| 44706 | 44706 | 176473 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 146 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009765.775830001 | 2095153.6821 | 37.7334441645219 | -122.40861479285499 | (37.7334441645219, -122.408614792855) | |||
| 462 | 462 | 187628 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779889 | 6003236.0 | 2095183.0 | 37.7331567921798 | -122.431192151262 | (37.7331567921798, -122.431192151262) | |||
| 160666 | 160666 | 224905 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 426 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003200.720369999 | 2095197.1222400002 | 37.7331935693215 | -122.431315130093 | (37.7331935693215, -122.431315130093) | |||
| 164292 | 164292 | 224850 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 319 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6003637.59911 | 2095225.12175 | 37.7332951990002 | -122.42980671882499 | (37.7332951990002, -122.429806718825) | |||
| 184433 | 184433 | 224906 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 410 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003435.91528 | 2095250.54652 | 37.7333535865804 | -122.43050580859101 | (37.7333535865804, -122.430505808591) | |||
| 97686 | 97686 | 2016 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 598 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | Permit Number 772999 | 6002387.133452299 | 2095371.0933820999 | 37.7336251126369 | -122.43414034926901 | (37.7336251126369, -122.434140349269) | ||
| 114573 | 114573 | 4953 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 598 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 772999 | 6002387.133452299 | 2095371.0933820999 | 37.7336251126369 | -122.43414034926901 | (37.7336251126369, -122.434140349269) | ||
| 160053 | 160053 | 224907 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 24 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003963.261390001 | 2095488.3476200001 | 37.734036394155 | -122.42869957243799 | (37.734036394155, -122.428699572438) | |||
| 136586 | 136586 | 224886 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2830 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6002399.509869999 | 2095496.0741700002 | 37.7339689836782 | -122.43410649173799 | (37.7339689836782, -122.434106491738) | |||
| 45382 | 45382 | 190151 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 43 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6013910.41512 | 2095496.0882400002 | 37.7346155971136 | -122.39430946233699 | (37.7346155971136, -122.394309462337) | |||
| 118765 | 118765 | 105165 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1600X OAKDALE AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 16 | 3x3 | 6015006.0 | 2095503.0 | 37.734695414582795 | -122.390522107646 | (37.7346954145828, -122.390522107646) | |||
| 39707 | 39707 | 224908 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 22 Cuvier St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003958.12248 | 2095520.7076700001 | 37.7341249567003 | -122.42871964530701 | (37.7341249567003, -122.428719645307) | |||
| 152138 | 152138 | 224909 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 22 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003953.55531 | 2095536.32016 | 37.734167566584 | -122.42873654804701 | (37.734167566584, -122.428736548047) | |||
| 54316 | 54316 | 218958 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 806 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999461.39114 | 2095552.35302 | 37.733956323011896 | -122.44426847741501 | (37.7339563230119, -122.444268477415) | |||
| 186089 | 186089 | 224910 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 14 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003951.88648 | 2095603.60095 | 37.7343522099779 | -122.428747112408 | (37.7343522099779, -122.428747112408) | |||
| 56664 | 56664 | 225334 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 536 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003396.7885 | 2095656.62848 | 37.734466378904 | -122.43067004818701 | (37.734466378904, -122.430670048187) | |||
| 1825 | 1825 | 224880 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2016 12:00:00 AM | 15 | Width 3ft | Permit Number 779045 | 6002530.35822 | 2095666.1320599997 | 37.734443349068606 | -122.43366625920099 | (37.7344433490686, -122.433666259201) | |
| 136696 | 136696 | 30564 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 633 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 9 | Permit Number 34542 | 6002889.41967 | 2095678.38488 | 37.734497359672496 | -122.43242574157401 | (37.7344973596725, -122.432425741574) | ||
| 28536 | 28536 | 224881 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 631 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002911.10799 | 2095680.3620099998 | 37.7345040182354 | -122.43235089908801 | (37.7345040182354, -122.432350899088) | |||
| 49211 | 49211 | 218959 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113 Stillings Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6000075.97071 | 2095686.0154799998 | 37.7343583730463 | -122.44215328546998 | (37.7343583730463, -122.44215328547) | |||
| 74488 | 74488 | 224879 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 670 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6002563.91545 | 2095705.58789 | 37.734553589773604 | -122.433553059737 | (37.7345535897736, -122.433553059737) | |||
| 18294 | 18294 | 4311 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 704 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002439.77272 | 2095706.35497 | 37.734548651581605 | -122.433982316925 | (37.7345486515816, -122.433982316925) | |||
| 170502 | 170502 | 224878 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 660 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6002621.84248 | 2095706.5467599998 | 37.7345595091169 | -122.433352855352 | (37.7345595091169, -122.433352855352) | |||
| 132482 | 132482 | 224877 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 654 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6002658.40723 | 2095708.2163200001 | 37.7345661676825 | -122.433226558173 | (37.7345661676825, -122.433226558173) | |||
| 66006 | 66006 | 224876 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 630 Chenery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002697.41175 | 2095710.1050900002 | 37.7345735664086 | -122.43309184153401 | (37.7345735664086, -122.433091841534) | |||
| 57548 | 57548 | 224874 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 630 Chenery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6002734.235780001 | 2095711.23062 | 37.734578745619004 | -122.432964609036 | (37.734578745619, -122.432964609036) | |||
| 184564 | 184564 | 224875 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 630 Chenery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6002716.38989 | 2095711.8688299998 | 37.7345794857458 | -122.43302635378201 | (37.7345794857458, -122.433026353782) | |||
| 36348 | 36348 | 224873 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 630 Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6002752.39129 | 2095712.47226 | 37.7345831846595 | -122.432901928087 | (37.7345831846595, -122.432901928087) | |||
| 164620 | 164620 | 224872 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 630 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 1ft | 6002774.43666 | 2095713.1357200001 | 37.734586256738 | -122.432825757301 | (37.734586256738, -122.432825757301) | |||
| 57131 | 57131 | 225337 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3121 Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6002904.9845 | 2095758.9731299998 | 37.734719519198606 | -122.432377682707 | (37.7347195191986, -122.432377682707) | |||
| 40783 | 40783 | 190148 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1711 Oakdale Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014397.54059 | 2095926.93864 | 37.735825689785706 | -122.39265542203199 | (37.7358256897857, -122.392655422032) | |||
| 41209 | 41209 | 218952 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 9 Burlwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996293.67263 | 2095955.2526 | 37.734881352179606 | -122.45524929224301 | (37.7348813521796, -122.455249292243) | |||
| 60125 | 60125 | 225338 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3045 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6002897.8907699995 | 2095961.4085900001 | 37.7352749584633 | -122.432416662015 | (37.7352749584633, -122.432416662015) | |||
| 2140 | 2140 | 225336 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3030 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | 15 | Width 2ft | Permit Number 18789 | 6002856.92306 | 2096000.60547 | 37.7353802609748 | -122.43256110120899 | (37.7353802609748, -122.432561101209) |
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");