Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 354 | 354 | 93479 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 1.5x3 | Tree 4 on Leroy | 6008317.250990001 | 2116630.80353 | 37.792334150853 | -122.415142500331 | (37.792334150853, -122.415142500331) | ||
| 470 | 470 | 98535 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1805X Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x6 | Permit Number 779899 | 5999990.232999999 | 2115142.7171 | 37.7877767779168 | -122.44384712433799 | (37.7877767779168, -122.443847124338) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 1777 | 1777 | 251693 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 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) | |||
| 2442 | 2442 | 192161 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | Width 5ft | Permit Number 779453 | 6007448.619659999 | 2109968.2743599997 | 37.7739916089565 | -122.417675550588 | (37.7739916089565, -122.417675550588) | ||
| 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) | |||
| 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) | |||
| 5400 | 5400 | 100479 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 340 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009830.0840300005 | 2114659.89537 | 37.7870074133103 | -122.40976885865601 | (37.7870074133103, -122.409768858656) | |||
| 5454 | 5454 | 26842 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 775213 | 6006970.057999999 | 2110963.93279 | 37.7766985071661 | -122.419401628405 | (37.7766985071661, -122.419401628405) | ||
| 6163 | 6163 | 27270 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2080 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006058.24019 | 2117527.2274 | 37.7946682962453 | -122.423022484211 | (37.7946682962453, -122.423022484211) | |||
| 6780 | 6780 | 105542 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2098X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 10x6 | 6002909.68864 | 2119260.2606900004 | 37.7992485848011 | -122.434040819625 | (37.7992485848011, -122.434040819625) | |||
| 6869 | 6869 | 61837 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1945 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 8 | 3x3 | Permit Number 772931 | 6005379.73194 | 2116818.03322 | 37.792682717295 | -122.425319723246 | (37.792682717295, -122.425319723246) | |
| 7199 | 7199 | 23528 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005747.5216 | 2119833.83468 | 37.800984116282294 | -122.42426174187901 | (37.8009841162823, -122.424261741879) | |||
| 7354 | 7354 | 42635 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x5 | Permit Number 42688 | 6005113.3477300005 | 2118824.42387 | 37.7981767035488 | -122.426384344263 | (37.7981767035488, -122.426384344263) |
| 7484 | 7484 | 11441 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2200X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6005093.38761 | 2117287.76065 | 37.7939562886077 | -122.42634394583901 | (37.7939562886077, -122.426343945839) | |||
| 7936 | 7936 | 18691 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999098.6283 | 2119842.2472900003 | 37.8006295414886 | -122.447270262423 | (37.8006295414886, -122.447270262423) | |||
| 14501 | 14501 | 103346 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 29899 | 6010363.2937900005 | 2108386.27696 | 37.7698113928049 | -122.40748159581001 | (37.7698113928049, -122.40748159581) | ||
| 15285 | 15285 | 18358 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 530 Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010328.61302 | 2105815.65836 | 37.762751119382 | -122.40742030251499 | (37.762751119382, -122.407420302515) | |||
| 15546 | 15546 | 117216 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2016 12:00:00 AM | 3 | Permit Number 778712 | 6013770.84151 | 2111284.28441 | 37.7779588107877 | -122.395897993299 | (37.7779588107877, -122.395897993299) | |
| 15832 | 15832 | 100861 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 665 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014522.73449 | 2111811.16047 | 37.7794472948859 | -122.39333378872101 | (37.7794472948859, -122.393333788721) | |||
| 16261 | 16261 | 6803 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1381 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016702.460969999 | 2097342.51463 | 37.7398403182643 | -122.384784912507 | (37.7398403182643, -122.384784912507) | |||
| 16456 | 16456 | 15031 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 900 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015804.02925 | 2096508.49114 | 37.7375005287238 | -122.38783316007 | (37.7375005287238, -122.38783316007) | |||
| 16467 | 16467 | 100269 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Federal St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 1x1 | 6015149.19988 | 2113471.58342 | 37.78404122616921 | -122.391282662663 | (37.7840412261692, -122.391282662663) | |||
| 16778 | 16778 | 111580 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1501-1555 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2015 12:00:00 AM | 3 | 6012799.17131 | 2106096.7853200003 | 37.7636610021682 | -122.39889519177099 | (37.7636610021682, -122.398895191771) | |||
| 18672 | 18672 | 5363 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 240 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004802.21847 | 2106929.2313599996 | 37.7654978566596 | -122.426613454658 | (37.7654978566596, -122.426613454658) | |||
| 22380 | 22380 | 9871 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1450X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6005453.91763 | 2114704.56484 | 37.786883852758 | -122.424912604636 | (37.786883852758, -122.424912604636) | |||
| 22444 | 22444 | 7931 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1355 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6005884.64786 | 2114736.13414 | 37.786994854263604 | -122.42342462055001 | (37.7869948542636, -122.42342462055) | |||
| 22493 | 22493 | 6152 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 998X Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6006127.91467 | 2113531.0311 | 37.78369966545571 | -122.42249730802901 | (37.7836996654557, -122.422497308029) | |||
| 22528 | 22528 | 7887 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1187 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005988.84512 | 2113979.6927799997 | 37.784923733590205 | -122.423010336179 | (37.7849237335902, -122.423010336179) | |||
| 22629 | 22629 | 7867 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006097.1257 | 2113612.9246799997 | 37.7839227881431 | -122.42260964772 | (37.7839227881431, -122.42260964772) | |||
| 22630 | 22630 | 9866 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1400X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6005472.9324900005 | 2114589.87673 | 37.7865700217345 | -122.424838655194 | (37.7865700217345, -122.424838655194) | |||
| 22746 | 22746 | 21582 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1499 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005545.80681 | 2114788.2647599997 | 37.7871188617926 | -122.42460064511101 | (37.7871188617926, -122.424600645111) | |||
| 23319 | 23319 | 6750 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1215 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6017497.29462 | 2096749.0937700002 | 37.7382548314821 | -122.381995416066 | (37.7382548314821, -122.381995416066) | |||
| 23392 | 23392 | 110672 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1400 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6007104.69317 | 2115747.32611 | 37.7898401230814 | -122.419275288041 | (37.7898401230814, -122.419275288041) | |||
| 23640 | 23640 | 218911 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Laguna Honda Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5995731.43182 | 2099885.12493 | 37.745639539837605 | -122.457477374284 | (37.7456395398376, -122.457477374284) | |||
| 23929 | 23929 | 127728 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 50 Leroy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 6008337.80395 | 2116548.86512 | 37.792110323090895 | -122.41506558401501 | (37.7921103230909, -122.415065584015) | |||
| 24034 | 24034 | 128289 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011528.34981 | 2120758.00025 | 37.8038463669751 | -122.404322585929 | (37.8038463669751, -122.404322585929) | |||
| 24293 | 24293 | 225524 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Belcher St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6003760.51975 | 2108247.79044 | 37.769059353622495 | -122.43031053521999 | (37.7690593536225, -122.43031053522) | |||
| 24773 | 24773 | 189744 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1800 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6012222.85042 | 2105643.19188 | 37.762383405490205 | -122.400856648227 | (37.7623834054902, -122.400856648227) | |||
| 24865 | 24865 | 127538 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 170 O'Farrell St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6010539.53779 | 2114494.20954 | 37.7865922116181 | -122.40730261183701 | (37.7865922116181, -122.407302611837) | |||
| 25434 | 25434 | 249351 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 645 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008312.55041 | 2114752.31158 | 37.787176006507394 | -122.415025744055 | (37.7871760065074, -122.415025744055) | |||
| 25631 | 25631 | 127192 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3185 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5999529.76691 | 2116004.12819 | 37.790115711323104 | -122.445502209659 | (37.7901157113231, -122.445502209659) | |||
| 26204 | 26204 | 225456 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3687 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002389.36899 | 2106450.1305 | 37.7640456583921 | -122.434924677857 | (37.7640456583921, -122.434924677857) | |||
| 26666 | 26666 | 127245 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2519 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6001653.05408 | 2117228.28357 | 37.793597910566604 | -122.438243553917 | (37.7935979105666, -122.438243553917) | |||
| 26872 | 26872 | 128721 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 534 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011277.67301 | 2118010.43905 | 37.7962882216763 | -122.40499650011299 | (37.7962882216763, -122.404996500113) | |||
| 26921 | 26921 | 189656 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 587 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6011259.34947 | 2105671.01798 | 37.7624060198488 | -122.404191016916 | (37.7624060198488, -122.404191016916) | |||
| 27267 | 27267 | 128000 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2445 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008809.46269 | 2121658.5666 | 37.8061667896209 | -122.41379522957199 | (37.8061667896209, -122.413795229572) | |||
| 27365 | 27365 | 128529 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 350 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6012461.93985 | 2116858.6183599997 | 37.79319172545561 | -122.400817703074 | (37.7931917254556, -122.400817703074) | |||
| 28176 | 28176 | 126662 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2901 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6003876.54626 | 2118720.27712 | 37.797820752774896 | -122.43065660601201 | (37.7978207527749, -122.430656606012) | |||
| 28482 | 28482 | 225408 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3910 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6004212.98689 | 2104256.35102 | 37.7581254357618 | -122.428460941824 | (37.7581254357618, -122.428460941824) | |||
| 28680 | 28680 | 51923 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Walnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2005 12:00:00 AM | 8 | Permit Number 48124 | 5998456.35251 | 2116110.3853599997 | 37.7903461275183 | -122.44922377968001 | (37.7903461275183, -122.44922377968) | ||
| 28710 | 28710 | 189732 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 Carolina St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6012411.88865 | 2105040.54683 | 37.7607392181654 | -122.400160504611 | (37.7607392181654, -122.400160504611) | |||
| 29411 | 29411 | 189802 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2301 Alameda St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6010120.949580001 | 2107827.64789 | 37.7682639581367 | -122.408280455504 | (37.7682639581367, -122.408280455504) | |||
| 30836 | 30836 | 49846 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 549 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 12 | Permit Number 46626 | 6013978.58215 | 2112382.57733 | 37.7809860286255 | -122.39525629464599 | (37.7809860286255, -122.395256294646) | ||
| 31034 | 31034 | 127807 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1807 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008682.83254 | 2119063.74728 | 37.7990349526585 | -122.41404977008499 | (37.7990349526585, -122.414049770085) | |||
| 31438 | 31438 | 226527 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 635 Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6010443.26884 | 2105321.1926 | 37.7613998448343 | -122.40698889324699 | (37.7613998448343, -122.406988893247) | |||
| 31778 | 31778 | 115924 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 355 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6014772.1 | 2113383.3816299997 | 37.7837781088235 | -122.392581129936 | (37.7837781088235, -122.392581129936) | |||
| 32331 | 32331 | 127525 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 535 Post St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6009652.45173 | 2115007.72817 | 37.787952522523604 | -122.41040799874399 | (37.7879525225236, -122.410407998744) | |||
| 33006 | 33006 | 190233 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 536 Mission St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6013086.524119999 | 2115360.2171099996 | 37.789112285559 | -122.39855139355 | (37.789112285559, -122.39855139355) | |||
| 33542 | 33542 | 190139 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Barneveld Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011347.78295 | 2098111.56945 | 37.741654371349604 | -122.40335333078501 | (37.7416543713496, -122.403353330785) | |||
| 34007 | 34007 | 127830 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2137 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006387.919919999 | 2118090.94727 | 37.796234727295996 | -122.42192181025601 | (37.796234727296, -122.421921810256) | |||
| 34051 | 34051 | 127597 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 7 Ada Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008089.60741 | 2114232.29446 | 37.7857356352316 | -122.41576024556299 | (37.7857356352316, -122.415760245563) | |||
| 34273 | 34273 | 114487 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 490 02nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6014406.36888 | 2113149.0715400004 | 37.7831144289291 | -122.39383002563999 | (37.7831144289291, -122.39383002564) | |||
| 34574 | 34574 | 128396 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 316 Sutter St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 2ft | 6010818.135480001 | 2115581.56402 | 37.7895934165555 | -122.40641537306801 | (37.7895934165555, -122.406415373068) | |||
| 34620 | 34620 | 127615 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 888 O'Farrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6007172.25057 | 2114025.1098599997 | 37.7851151443975 | -122.41891934716499 | (37.7851151443975, -122.418919347165) | |||
| 34782 | 34782 | 127883 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1907 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007728.55241 | 2118929.99486 | 37.7986140582581 | -122.41734242461399 | (37.7986140582581, -122.417342424614) | |||
| 35125 | 35125 | 126705 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1892 Union St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6003941.41641 | 2118712.11066 | 37.7978020046276 | -122.430431554269 | (37.7978020046276, -122.430431554269) | |||
| 35557 | 35557 | 126743 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600 Union St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6000482.352969999 | 2118232.54865 | 37.7962887046279 | -122.4423663951 | (37.7962887046279, -122.4423663951) | |||
| 35571 | 35571 | 128434 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 315 Montgomery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6011885.105269999 | 2116641.71943 | 37.792563981601205 | -122.40279833757401 | (37.7925639816012, -122.402798337574) | |||
| 35790 | 35790 | 128025 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2601 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007851.1983900005 | 2121552.2036900003 | 37.8058208834027 | -122.41710393161999 | (37.8058208834027, -122.41710393162) | |||
| 35871 | 35871 | 127790 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 895 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6009126.89498 | 2119041.74076 | 37.7989994591099 | -122.412511602934 | (37.7989994591099, -122.412511602934) | |||
| 35936 | 35936 | 127887 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1041 Union St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007964.59189 | 2119228.98683 | 37.7994482927562 | -122.41654684207701 | (37.7994482927562, -122.416546842077) | |||
| 36029 | 36029 | 128557 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 504 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012193.64498 | 2117427.3491 | 37.7947383561395 | -122.401786021132 | (37.7947383561395, -122.401786021132) | |||
| 36047 | 36047 | 116001 | 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 | 6008454.947369999 | 2117570.68172 | 37.7949225624765 | -122.41473261091998 | (37.7949225624765, -122.41473261092) | |||
| 36609 | 36609 | 120464 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 75 West Clay St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5988508.84723 | 2115012.1663900004 | 37.786756737379996 | -122.483560494571 | (37.78675673738, -122.483560494571) | |||
| 36754 | 36754 | 128146 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 580 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007731.2336099995 | 2121681.8087299997 | 37.8061699966036 | -122.417528280328 | (37.8061699966036, -122.417528280328) | |||
| 36956 | 36956 | 127738 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1370 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6008134.40546 | 2116588.64024 | 37.7922081036696 | -122.41577216517099 | (37.7922081036696, -122.415772165171) | |||
| 36970 | 36970 | 128372 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010309.70066 | 2115852.08524 | 37.790307747156795 | -122.40819359985001 | (37.7903077471568, -122.40819359985) | |||
| 37199 | 37199 | 128473 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 211 Front St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6013040.74729 | 2116776.4158400004 | 37.792998283992 | -122.398809207596 | (37.792998283992, -122.398809207596) | |||
| 37302 | 37302 | 128464 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 341 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012520.637080001 | 2116804.75779 | 37.7930471108983 | -122.400610820334 | (37.7930471108983, -122.400610820334) | |||
| 37722 | 37722 | 114782 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400x 17th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5990625.810959999 | 2112587.7910599997 | 37.780223067743705 | -122.47605924392599 | (37.7802230677437, -122.476059243926) | |||
| 37796 | 37796 | 127264 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2580 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6001230.031140001 | 2117290.6597599997 | 37.7937451106869 | -122.439711718727 | (37.7937451106869, -122.439711718727) | |||
| 38466 | 38466 | 128681 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 270 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013134.279630001 | 2117941.09199 | 37.796201420016295 | -122.398567343933 | (37.7962014200163, -122.398567343933) | |||
| 38540 | 38540 | 190287 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 190 Steuart St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6015169.048880001 | 2116262.66084 | 37.791705986981896 | -122.391409175691 | (37.7917059869819, -122.391409175691) | |||
| 38631 | 38631 | 224339 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2789 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6010760.41543 | 2101782.2861200003 | 37.75170053697279 | -122.40564274303699 | (37.7517005369728, -122.405642743037) | |||
| 38715 | 38715 | 190292 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 180 Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014894.2538 | 2116028.18792 | 37.791046923328096 | -122.39234356590401 | (37.7910469233281, -122.392343565904) | |||
| 38836 | 38836 | 128483 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 330 Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012246.35245 | 2116465.43051 | 37.7921000977961 | -122.401536006882 | (37.7921000977961, -122.401536006882) | |||
| 38989 | 38989 | 120722 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 21st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5989381.54871 | 2112550.53538 | 37.780048547094104 | -122.48036094165 | (37.7800485470941, -122.48036094165) | |||
| 38999 | 38999 | 127821 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1518 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6006275.26375 | 2118341.15873 | 37.7969153908809 | -122.42232941087099 | (37.7969153908809, -122.422329410871) | |||
| 39148 | 39148 | 190156 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 70 Steuart St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6014301.5385 | 2117166.17817 | 37.79413864863079 | -122.394474072441 | (37.7941386486308, -122.394474072441) | |||
| 39485 | 39485 | 127520 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 330 Geary St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6010050.03669 | 2114776.41152 | 37.787339662444296 | -122.409016092817 | (37.7873396624443, -122.409016092817) | |||
| 39558 | 39558 | 226573 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3705 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005744.88516 | 2101373.53681 | 37.7502964650211 | -122.422958081044 | (37.7502964650211, -122.422958081044) | |||
| 40216 | 40216 | 225353 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 133 Otis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006771.02851 | 2109235.94991 | 37.771942668242396 | -122.41996747911699 | (37.7719426682424, -122.419967479117) |
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");