Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87 | 87 | 11032 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007492.86428 | 2117507.22815 | 37.794694232707 | -122.41805706457599 | (37.794694232707, -122.418057064576) | |||
| 116 | 116 | 26163 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999083.87135 | 2119853.9919 | 37.8006609458028 | -122.447322173097 | (37.8006609458028, -122.447322173097) | |||
| 143 | 143 | 18836 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2055 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004953.14987 | 2116100.2629400003 | 37.7906877916676 | -122.426744576702 | (37.7906877916676, -122.426744576702) | |||
| 181 | 181 | 9914 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1900 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 126 | 3X3 | 6005235.69262 | 2116267.9294 | 37.7911641319684 | -122.42577893234899 | (37.7911641319684, -122.425778932349) | |||
| 183 | 183 | 15429 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2015 12:00:00 AM | 15 | 4X4 | 6006871.98757 | 2105962.63928 | 37.762960616913205 | -122.41938599878401 | (37.7629606169132, -122.419385998784) | ||
| 206 | 206 | 4750 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007660.31382 | 2121409.3470799997 | 37.8054178953714 | -122.417754386066 | (37.8054178953714, -122.417754386066) | |||
| 269 | 269 | 127441 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2101 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 4ft | 6005937.76794 | 2117668.55868 | 37.795049557533105 | -122.423449386982 | (37.7950495575331, -122.423449386982) | |||
| 288 | 288 | 226558 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 320 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 7ft | 6004836.50691 | 2106380.98977 | 37.7639944545966 | -122.42645581878 | (37.7639944545966, -122.42645581878) | |||
| 312 | 312 | 226557 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 320 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 7ft | 6004833.37225 | 2106401.74543 | 37.7640512674875 | -122.42646813862 | (37.7640512674875, -122.42646813862) | |||
| 315 | 315 | 127442 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2101 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 4ft | 6005941.14617 | 2117647.79475 | 37.794992735681504 | -122.423436220932 | (37.7949927356815, -122.423436220932) | |||
| 388 | 388 | 11057 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1630 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007426.31744 | 2117960.00612 | 37.795933702633796 | -122.418319444503 | (37.7959337026338, -122.418319444503) | |||
| 436 | 436 | 6932 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 500 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004980.8762 | 2110598.20876 | 37.775582081585895 | -122.42625675563801 | (37.7755820815859, -122.426256755638) | |||
| 542 | 542 | 224353 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3024 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6006632.75905 | 2106740.0972599997 | 37.7650818572521 | -122.42026859194901 | (37.7650818572521, -122.420268591949) | |||
| 592 | 592 | 251331 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 599 | 599 | 251330 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 728 | 728 | 2813 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009225.04881 | 2116342.3210299998 | 37.7915930222591 | -122.41198109107599 | (37.7915930222591, -122.411981091076) | |||
| 762 | 762 | 7350 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2239 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002792.88059 | 2116041.24067 | 37.790403357673895 | -122.434214763813 | (37.7904033576739, -122.434214763813) | |||
| 901 | 901 | 224716 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 13 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 905 | 905 | 224715 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 12 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 910 | 910 | 7954 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1756 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6005736.45543 | 2116153.36588 | 37.7908778543671 | -122.424038156058 | (37.7908778543671, -122.424038156058) | |||
| 916 | 916 | 224714 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 11 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 926 | 926 | 19204 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 630 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012243.07343 | 2117875.4725099998 | 37.7959715542054 | -122.401646502996 | (37.7959715542054, -122.401646502996) | |||
| 928 | 928 | 224422 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 2 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 16 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 941 | 941 | 18512 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 626 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010135.39241 | 2115955.1821 | 37.790581064620106 | -122.408803973339 | (37.7905810646201, -122.408803973339) | |||
| 1018 | 1018 | 7366 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2360 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002774.54957 | 2116438.38146 | 37.79149276403471 | -122.434306592692 | (37.7914927640347, -122.434306592692) | |||
| 1021 | 1021 | 189660 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2573 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 4ft | 6015900.45488 | 2103484.96239 | 37.7566618134199 | -122.38798645493601 | (37.7566618134199, -122.387986454936) | |||
| 1035 | 1035 | 189666 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 5ft | 6015923.45326 | 2103178.08659 | 37.7558204715491 | -122.38788550510598 | (37.7558204715491, -122.387885505106) | |||
| 1037 | 1037 | 189668 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 5ft | 6015920.2977599995 | 2103253.32542 | 37.7560268866495 | -122.387901667748 | (37.7560268866495, -122.387901667748) | |||
| 1044 | 1044 | 189667 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 5ft | 6015923.778390001 | 2103213.67674 | 37.7559182125844 | -122.38788686398199 | (37.7559182125844, -122.387886863982) | |||
| 1046 | 1046 | 189659 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2573 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 4ft | 6015895.51865 | 2103530.26934 | 37.7567859432258 | -122.388006687875 | (37.7567859432258, -122.388006687875) | |||
| 1055 | 1055 | 21993 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015910.4355 | 2103353.3332599998 | 37.756300940646604 | -122.387942753271 | (37.7563009406466, -122.387942753271) | |||
| 1057 | 1057 | 189664 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 5ft | 6015924.43943 | 2103136.85911 | 37.755707324239395 | -122.38787921795799 | (37.7557073242394, -122.387879217958) | |||
| 1062 | 1062 | 189665 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2585 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 5ft | 6015925.0907 | 2103156.8300799998 | 37.755762196378996 | -122.387878359099 | (37.755762196379, -122.387878359099) | |||
| 1074 | 1074 | 11442 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2200X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6005100.87554 | 2117226.15448 | 37.7937875569128 | -122.42631364855801 | (37.7937875569128, -122.426313648558) | |||
| 1182 | 1182 | 11089 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1900 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/10/2007 12:00:00 AM | 70 | 3X3 | 6007306.35542 | 2118856.39008 | 37.798388195314296 | -122.418798140138 | (37.7983881953143, -122.418798140138) | ||
| 1217 | 1217 | 113450 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 21X Leroy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008324.74095 | 2116562.6798400003 | 37.7921475208351 | -122.415111760598 | (37.7921475208351, -122.415111760598) | |||
| 1306 | 1306 | 127778 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1459 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 5ft | 6007455.77406 | 2117413.73976 | 37.794435449198495 | -122.418178770753 | (37.7944354491985, -122.418178770753) | |||
| 1381 | 1381 | 189623 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 347 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6009091.0 | 2109329.0 | 37.7723285943803 | -122.411949073152 | (37.7723285943803, -122.411949073152) | |||
| 1403 | 1403 | 122808 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1830 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x4 | 6011911.59203 | 2106562.15691 | 37.7648893115244 | -122.401997787192 | (37.7648893115244, -122.401997787192) | ||
| 1435 | 1435 | 226556 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 301 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 6ft | 6004916.06592 | 2106558.9555200003 | 37.7644876032441 | -122.42619331838199 | (37.7644876032441, -122.426193318382) | |||
| 1441 | 1441 | 226555 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 301 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 6ft | 6004913.144780001 | 2106531.61539 | 37.7644123686589 | -122.42620147522699 | (37.7644123686589, -122.426201475227) | |||
| 1450 | 1450 | 18855 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2222 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6003966.78981 | 2116014.3774900003 | 37.790396155900105 | -122.43015119962 | (37.7903961559001, -122.43015119962) | |||
| 1568 | 1568 | 251592 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1999X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6007220.0 | 2119146.0 | 37.799178528828 | -122.41911751038602 | (37.799178528828, -122.419117510386) | |||
| 1678 | 1678 | 25510 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1845 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005220.005340001 | 2116049.4982 | 37.7905634882709 | -122.42581765535401 | (37.7905634882709, -122.425817655354) | |||
| 1752 | 1752 | 11021 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1407 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007490.12051 | 2117192.20597 | 37.7938291055709 | -122.41804421508002 | (37.7938291055709, -122.41804421508) | |||
| 1787 | 1787 | 11037 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1523 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007436.11305 | 2117588.78298 | 37.794914967702496 | -122.41825921689801 | (37.7949149677025, -122.418259216898) | |||
| 1802 | 1802 | 123705 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 448 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 7 | Width 3ft | 5994163.86514 | 2111457.6280799997 | 37.7773244619044 | -122.46373753196501 | (37.7773244619044, -122.463737531965) | ||
| 1903 | 1903 | 127944 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012622.90875 | 2119176.76577 | 37.7995657819845 | -122.400423640834 | (37.7995657819845, -122.400423640834) | ||
| 1908 | 1908 | 127945 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 2ft | 6012656.99006 | 2119182.6904 | 37.7995839500992 | -122.40030612282601 | (37.7995839500992, -122.400306122826) | ||
| 1911 | 1911 | 127947 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 855 Front St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012711.6665 | 2119148.4967900002 | 37.7994931113801 | -122.400114518675 | (37.7994931113801, -122.400114518675) | ||
| 1913 | 1913 | 127946 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 855 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012709.78092 | 2119164.70922 | 37.7995375216859 | -122.400122182714 | (37.7995375216859, -122.400122182714) | ||
| 1924 | 1924 | 127943 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2017 12:00:00 AM | 3 | Width 3ft | 6012601.19681 | 2119174.02118 | 37.7995570351977 | -122.400498579547 | (37.7995570351977, -122.400498579547) | ||
| 1960 | 1960 | 18692 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999079.26803 | 2119858.05546 | 37.800671840202796 | -122.447338395052 | (37.8006718402028, -122.447338395052) | |||
| 2003 | 2003 | 127110 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3201 Laguna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 6ft | 6003718.35126 | 2119752.0994 | 37.8006449063974 | -122.431277695812 | (37.8006449063974, -122.431277695812) | |||
| 2043 | 2043 | 127861 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1898 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 6007317.93078 | 2118761.71757 | 37.798128900073294 | -122.418751368192 | (37.7981289000733, -122.418751368192) | |||
| 2047 | 2047 | 127862 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1898 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 3ft | 6007316.9194 | 2118776.88276 | 37.7981704829404 | -122.41875594393 | (37.7981704829404, -122.41875594393) | |||
| 2060 | 2060 | 127860 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1898 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 6ft | 6007322.606430001 | 2118731.77235 | 37.798046941256 | -122.418733064272 | (37.798046941256, -122.418733064272) | |||
| 2116 | 2116 | 11044 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1550 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 6007464.945230001 | 2117711.8455 | 37.795254489665 | -122.418168182118 | (37.795254489665, -122.418168182118) | |||
| 2161 | 2161 | 127894 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6010099.45524 | 2119176.61212 | 37.7994243150494 | -122.40915572694999 | (37.7994243150494, -122.40915572695) | |||
| 2209 | 2209 | 189798 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6010293.93626 | 2108038.50565 | 37.7688526102954 | -122.407696978027 | (37.7688526102954, -122.407696978027) | |||
| 2472 | 2472 | 224776 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 6005221.0 | 2098972.0 | 37.743672820465896 | -122.42459890056001 | (37.7436728204659, -122.42459890056) | |||
| 2493 | 2493 | 127969 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 73 Castle St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6011253.45973 | 2119573.0614099996 | 37.8005774500495 | -122.405190374142 | (37.8005774500495, -122.405190374142) | |||
| 2505 | 2505 | 127968 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 73 Castle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6011251.91529 | 2119582.84216 | 37.8006042192626 | -122.405196407682 | (37.8006042192626, -122.405196407682) | |||
| 2646 | 2646 | 18988 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2939 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000733.58986 | 2115514.6365 | 37.7888403449574 | -122.44130195304301 | (37.7888403449574, -122.441301953043) | |||
| 2653 | 2653 | 116000 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1454 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6008456.02855 | 2117561.49656 | 37.7948974030383 | -122.41472821952499 | (37.7948974030383, -122.414728219525) | |||
| 2659 | 2659 | 253154 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1454 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008456.02855 | 2117561.49656 | 37.7948974030383 | -122.41472821952499 | (37.7948974030383, -122.414728219525) | ||||
| 2697 | 2697 | 11019 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1401 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6007491.51177 | 2117162.78636 | 37.793748404921 | -122.418037314589 | (37.793748404921, -122.418037314589) | |||
| 2750 | 2750 | 23535 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005732.6393 | 2119914.78395 | 37.8012055419589 | -122.424319001733 | (37.8012055419589, -122.424319001733) | |||
| 2770 | 2770 | 9915 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1900 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3X3 | 6005229.572240001 | 2116308.1912 | 37.791274334888705 | -122.42580297571999 | (37.7912743348887, -122.42580297572) | |||
| 2843 | 2843 | 23527 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005732.6493 | 2119830.06962 | 37.800972938614294 | -122.424312938499 | (37.8009729386143, -122.424312938499) | |||
| 2893 | 2893 | 11107 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2016 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007247.08519 | 2119278.6571299997 | 37.799544297196995 | -122.419033200434 | (37.799544297197, -122.419033200434) | |||
| 2950 | 2950 | 9693 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 414 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2012 12:00:00 AM | 3 | 3X3 | 6005939.70475 | 2111200.2280099997 | 37.777289230461705 | -122.422982727867 | (37.7772892304617, -122.422982727867) | ||
| 3018 | 3018 | 128709 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4x Columbus Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 19 | Width 9ft | 6011726.08303 | 2117794.9108 | 37.795721488711294 | -122.403429729102 | (37.7957214887113, -122.403429729102) | |||
| 3064 | 3064 | 104743 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010761.049240001 | 2116971.9366099997 | 37.7934078523287 | -122.406710911 | (37.7934078523287, -122.406710911) | |||
| 3067 | 3067 | 104742 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010759.24365 | 2116982.20549 | 37.793435947175205 | -122.406717882525 | (37.7934359471752, -122.406717882525) | |||
| 3069 | 3069 | 128380 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010746.0 | 2116993.0 | 37.7934648453026 | -122.406764467868 | (37.7934648453026, -122.406764467868) | |||
| 3241 | 3241 | 23530 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005733.88187 | 2119852.14358 | 37.8010336176693 | -122.424310244146 | (37.8010336176693, -122.424310244146) | |||
| 3308 | 3308 | 220877 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 600X Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998682.13916 | 2105626.63204 | 37.7615733510574 | -122.44768755773701 | (37.7615733510574, -122.447687557737) | |||
| 3329 | 3329 | 110970 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2485 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6002790.71835 | 2116462.02658 | 37.791558605188705 | -122.434252340185 | (37.7915586051887, -122.434252340185) | |||
| 3358 | 3358 | 11102 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1987 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007225.03995 | 2119093.74122 | 37.799035323169704 | -122.419096361621 | (37.7990353231697, -122.419096361621) | |||
| 3407 | 3407 | 11127 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2124 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6007196.70195 | 2119630.59252 | 37.8005077858571 | -122.419232523471 | (37.8005077858571, -122.419232523471) | |||
| 3414 | 3414 | 102265 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2029 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6001885.4061199995 | 2115556.68597 | 37.789021347891 | -122.437319848541 | (37.789021347891, -122.437319848541) | |||
| 3474 | 3474 | 106212 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 585X Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 12 | 3x5 | 6010752.41967 | 2115858.63176 | 37.790350501826204 | -122.406662277468 | (37.7903505018262, -122.406662277468) | |||
| 3499 | 3499 | 85478 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1745 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6007333.51995 | 2118328.0568 | 37.7969390538357 | -122.41866665564699 | (37.7969390538357, -122.418666655647) | |||
| 3516 | 3516 | 7363 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2343 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002738.924769999 | 2116408.16832 | 37.791407784388795 | -122.434427692684 | (37.7914077843888, -122.434427692684) | |||
| 3564 | 3564 | 127915 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1175 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6007842.32885 | 2121243.82267 | 37.8049736482837 | -122.417112761139 | (37.8049736482837, -122.417112761139) | |||
| 3574 | 3574 | 127916 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1175 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007863.0053199995 | 2121226.60678 | 37.8049275409425 | -122.417039987112 | (37.8049275409425, -122.417039987112) | |||
| 3594 | 3594 | 127750 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1033 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008528.0 | 2116225.0 | 37.791231755005896 | -122.41438457516001 | (37.7912317550059, -122.41438457516) | |||
| 3607 | 3607 | 107433 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3000 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999745.83562 | 2116735.23196 | 37.792135462722705 | -122.444807206383 | (37.7921354627227, -122.444807206383) | |||
| 3624 | 3624 | 127356 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100 Webster St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | 6003284.8942599995 | 2116317.33043 | 37.7911893426569 | -122.432532159241 | (37.7911893426569, -122.432532159241) | ||
| 3628 | 3628 | 127357 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100 Webster St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | 6003276.2668 | 2116362.2656799997 | 37.791312234126295 | -122.432565221033 | (37.7913122341263, -122.432565221033) | ||
| 3655 | 3655 | 116023 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 755 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x5 | 6012121.98551 | 2118393.88956 | 37.7973882454367 | -122.40210195745199 | (37.7973882454367, -122.402101957452) | |||
| 3669 | 3669 | 128007 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 450 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6008574.61168 | 2121448.10995 | 37.8055757371873 | -122.414593071218 | (37.8055757371873, -122.414593071218) | ||
| 3671 | 3671 | 128005 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 444 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2017 12:00:00 AM | 3 | Width 3ft | 6008626.93235 | 2121456.53692 | 37.805601814825394 | -122.414412604251 | (37.8056018148254, -122.414412604251) | ||
| 3728 | 3728 | 18515 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 634 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6010129.36296 | 2116007.85487 | 37.790725353638 | -122.408828552704 | (37.790725353638, -122.408828552704) | |||
| 3741 | 3741 | 11063 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1706 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X4 | 6007392.7334199995 | 2118206.86499 | 37.7966096249815 | -122.418453164696 | (37.7966096249815, -122.418453164696) | |||
| 3802 | 3802 | 11116 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2054 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007222.73261 | 2119440.0608900003 | 37.7999860999421 | -122.419128924277 | (37.7999860999421, -122.419128924277) | |||
| 3995 | 3995 | 18900 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2590 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002437.1511699995 | 2115800.3303799997 | 37.789721683256296 | -122.435428321554 | (37.7897216832563, -122.435428321554) | |||
| 4442 | 4442 | 11124 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2115 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/14/2002 12:00:00 AM | 3 | 3X3 | 6007136.72657 | 2119705.75668 | 37.8007107898386 | -122.41944539839899 | (37.8007107898386, -122.419445398399) | ||
| 4476 | 4476 | 94930 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1771 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004538.80013 | 2118744.2703 | 37.7979241280397 | -122.428366733352 | (37.7979241280397, -122.428366733352) |
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");