Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 150055 | 150055 | 141767 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1 Hollis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003884.399 | 2113511.8848 | 37.783520274802896 | -122.43025765421301 | (37.7835202748029, -122.430257654213) | |||
| 182825 | 182825 | 142620 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1 Scotland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009140.6951 | 2120065.1504 | 37.8018102626301 | -122.412536232083 | (37.8018102626301, -122.412536232083) | |||
| 51707 | 51707 | 138041 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1 Wilmot St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003396.2249 | 2115029.767 | 37.7876603335628 | -122.43205497415701 | (37.7876603335628, -122.432054974157) | |||
| 162965 | 162965 | 138040 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1 Wilmot St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003385.4026 | 2115029.2516 | 37.7876583048425 | -122.432092380369 | (37.7876583048425, -122.432092380369) | |||
| 147652 | 147652 | 64012 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 10 Loyola Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1987 12:00:00 AM | 10 | Permit Number 24766 | 5998456.7381 | 2110792.4322 | 37.7757444404433 | -122.44883923078999 | (37.7757444404433, -122.44883923079) | ||
| 22132 | 22132 | 28299 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 100 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5995861.9776 | 2088092.909 | 37.713268452474104 | -122.45617353106701 | (37.7132684524741, -122.456173531067) | |||
| 1462 | 1462 | 247381 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1001 Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | |||
| 1466 | 1466 | 247380 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1001 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | |||
| 1468 | 1468 | 247377 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1001 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | |||
| 5342 | 5342 | 17679 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1004 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002429.082 | 2112004.3581 | 37.7792984485069 | -122.435184618671 | (37.7792984485069, -122.435184618671) | |||
| 5884 | 5884 | 17676 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1004 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002427.6935 | 2112026.5749 | 37.779359371412795 | -122.43519101157301 | (37.7793593714128, -122.435191011573) | |||
| 5252 | 5252 | 17675 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1010 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002421.1673 | 2112056.7065 | 37.779441734619205 | -122.435215744209 | (37.7794417346192, -122.435215744209) | |||
| 8120 | 8120 | 17670 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1015X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/1995 12:00:00 AM | 12 | 3X3 | 6002378.1109 | 2112076.6861 | 37.7794941484605 | -122.435366123882 | (37.7794941484605, -122.435366123882) | ||
| 6737 | 6737 | 17678 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1016 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002420.6118 | 2112080.0342 | 37.7795057550774 | -122.435219334932 | (37.7795057550774, -122.435219334932) | |||
| 35602 | 35602 | 217547 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 102 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5995842.2441 | 2088093.8487 | 37.713269899907104 | -122.45624180431801 | (37.7132698999071, -122.456241804318) | |||
| 36773 | 36773 | 140504 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003445.3738 | 2111793.5292 | 37.7787772231874 | -122.431653787974 | (37.7787772231874, -122.431653787974) | |||
| 48348 | 48348 | 140506 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003442.3352 | 2111811.0008 | 37.77882502362021 | -122.43166554740299 | (37.7788250236202, -122.431665547403) | |||
| 60153 | 60153 | 140509 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003414.9884 | 2111885.4448 | 37.779027878196004 | -122.43176546737101 | (37.779027878196, -122.431765467371) | |||
| 153736 | 153736 | 140503 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6003449.1719 | 2111783.654 | 37.7787503236279 | -122.43163994364099 | (37.7787503236279, -122.431639943641) | |||
| 168873 | 168873 | 140508 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003419.5462 | 2111864.9347 | 37.778971820925996 | -122.43174823532401 | (37.778971820926, -122.431748235324) | |||
| 183645 | 183645 | 140505 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003444.6141 | 2111801.8852 | 37.7788001236235 | -122.43165701281 | (37.7788001236235, -122.43165701281) | |||
| 2890 | 2890 | 17680 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1020 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002416.7239 | 2112103.0842 | 37.7795688238035 | -122.43523443397801 | (37.7795688238035, -122.435234433978) | |||
| 41284 | 41284 | 140538 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003370.5162 | 2111893.2524 | 37.7790467948997 | -122.43191987222 | (37.7790467948997, -122.43191987222) | |||
| 50506 | 50506 | 140544 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003387.6502 | 2111766.8151 | 37.7787006008552 | -122.431851568456 | (37.7787006008552, -122.431851568456) | |||
| 147281 | 147281 | 140543 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003386.4685 | 2111785.1308 | 37.7787508242216 | -122.43185696454799 | (37.7787508242216, -122.431856964548) | |||
| 160247 | 160247 | 140539 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003373.4703 | 2111871.9826 | 37.7789885607925 | -122.43190813363 | (37.7789885607925, -122.43190813363) | |||
| 161539 | 161539 | 140542 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003382.3327 | 2111808.7639 | 37.778815480381205 | -122.43187295981501 | (37.7788154803812, -122.431872959815) | |||
| 176807 | 176807 | 140541 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003379.3786 | 2111825.8979 | 37.7788623586164 | -122.43188440296001 | (37.7788623586164, -122.43188440296) | |||
| 184755 | 184755 | 140540 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003378.1969 | 2111847.7586 | 37.7789223156672 | -122.43189005228001 | (37.7789223156672, -122.43189005228) | |||
| 7736 | 7736 | 20147 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1025 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 12 | 3x3 | 6002893.7013 | 2111823.32 | 37.778827735903604 | -122.433564367127 | (37.7788277359036, -122.433564367127) | ||
| 15556 | 15556 | 7384 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1026 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6010763.6701 | 2111388.108 | 37.7780761292824 | -122.406308232523 | (37.7780761292824, -122.406308232523) | |||
| 13519 | 13519 | 113149 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6010826.0688 | 2111360.9298 | 37.7780049945656 | -122.406090456701 | (37.7780049945656, -122.406090456701) | |||
| 14599 | 14599 | 7391 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/1992 12:00:00 AM | 30 | 3x3 | 6010784.4697 | 2111320.9947 | 37.77789301527721 | -122.40623154915001 | (37.7778930152772, -122.40623154915) | ||
| 14749 | 14749 | 7388 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010798.3361 | 2111334.861 | 37.7779318645299 | -122.406184557349 | (37.7779318645299, -122.406184557349) | |||
| 14753 | 14753 | 7389 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010809.9838 | 2111345.3995 | 37.7779614523005 | -122.406145006296 | (37.7779614523005, -122.406145006296) | |||
| 16043 | 16043 | 7390 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6010768.3847 | 2111305.4643 | 37.7778494726714 | -122.40628609857299 | (37.7778494726714, -122.406286098573) | |||
| 5730 | 5730 | 4720 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1040 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5x5 | 6008353.7979 | 2120870.8765 | 37.8039783914932 | -122.415316341899 | (37.8039783914932, -122.415316341899) | |||
| 6233 | 6233 | 4722 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1040 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 4x4 | 6008317.4743 | 2120903.2884 | 37.804065344872704 | -122.415444338519 | (37.8040653448727, -122.415444338519) | |||
| 7692 | 7692 | 4721 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1040 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x5 | 6008335.3567 | 2120887.0824 | 37.8040218523597 | -122.415381307054 | (37.8040218523597, -122.415381307054) | |||
| 54338 | 54338 | 140510 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1040 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003410.4306 | 2111922.6668 | 37.7791298221794 | -122.43178389299601 | (37.7791298221794, -122.431783892996) | |||
| 130767 | 130767 | 140511 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1040 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003403.594 | 2111971.2833 | 37.7792629234397 | -122.431811015775 | (37.7792629234397, -122.431811015775) | |||
| 1873 | 1873 | 20151 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1043 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778996 | 6002888.3687 | 2111863.5194 | 37.7789378108444 | -122.433585688352 | (37.7789378108444, -122.433585688352) | |
| 159948 | 159948 | 247386 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1045 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001982.645 | 2109781.5209999997 | 37.773169733383 | -122.436569880602 | (37.773169733383, -122.436569880602) | |||
| 5637 | 5637 | 4723 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 5x5 | 6008295.1213 | 2120922.8472 | 37.804117792011795 | -122.41552307845801 | (37.8041177920118, -122.415523078458) | |||
| 5852 | 5852 | 4724 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6008259.9153 | 2120954.1415 | 37.8042017393393 | -122.41564712883101 | (37.8042017393393, -122.415647128831) | |||
| 7263 | 7263 | 4725 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6008238.1211 | 2120976.4945 | 37.8042618899237 | -122.415724133248 | (37.8042618899237, -122.415724133248) | |||
| 56022 | 56022 | 140512 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1050 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003399.7958 | 2111999.3898 | 37.779339881579205 | -122.431826162709 | (37.7793398815792, -122.431826162709) | |||
| 182858 | 182858 | 247387 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1053 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001955.5092 | 2109778.1291 | 37.7731588780046 | -122.43666350389 | (37.7731588780046, -122.43666350389) | |||
| 28588 | 28588 | 143227 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 106 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010308.3267 | 2121146.7978 | 37.8048456584244 | -122.408572011197 | (37.8048456584244, -122.408572011197) | |||
| 183602 | 183602 | 140513 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1060 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003397.5169 | 2112023.6980000003 | 37.779406496655604 | -122.431835782497 | (37.7794064966556, -122.431835782497) | |||
| 188842 | 188842 | 140546 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1060 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002924.6148 | 2111925.6484 | 37.779110458039604 | -122.43346473978701 | (37.7791104580396, -122.433464739787) | |||
| 23229 | 23229 | 28073 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1075 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008262.9463 | 2120869.8064 | 37.803970346765496 | -122.415630664984 | (37.8039703467655, -122.415630664984) | |||
| 23286 | 23286 | 4726 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1075 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 6008251.3021 | 2120879.6119999997 | 37.803996615927794 | -122.41567165532301 | (37.8039966159278, -122.415671655323) | ||||
| 136427 | 136427 | 140548 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1080 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002919.3909 | 2111977.3656 | 37.7792521641585 | -122.433486508226 | (37.7792521641585, -122.433486508226) | |||
| 175898 | 175898 | 199982 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1081 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6018036.5838 | 2092513.2332 | 37.7266537566215 | -122.379836574534 | (37.7266537566215, -122.379836574534) | |||
| 63452 | 63452 | 54834 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 109 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 17 | Permit Number 10688 | 5998714.6082 | 2110323.5588 | 37.7744717777818 | -122.447913432558 | (37.7744717777818, -122.447913432558) | ||
| 55013 | 55013 | 140533 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1099 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003358.5145 | 2111988.9607 | 37.7793089056656 | -122.43196822698799 | (37.7793089056656, -122.431968226988) | |||
| 134568 | 134568 | 140535 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1099 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003363.1308 | 2111944.3591 | 37.7791867024877 | -122.4319490716 | (37.7791867024877, -122.4319490716) | |||
| 163747 | 163747 | 140534 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1099 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003360.1767 | 2111967.4014 | 37.7792498034321 | -122.431960936856 | (37.7792498034321, -122.431960936856) | |||
| 175434 | 175434 | 140536 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1099 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003366.6758 | 2111915.9993 | 37.779109034509204 | -122.43193478240102 | (37.7791090345092, -122.431934782401) | |||
| 54336 | 54336 | 143505 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 11 Gerke Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010554.2854 | 2120185.3922 | 37.802219647583 | -122.40765301215599 | (37.802219647583, -122.407653012156) | |||
| 155154 | 155154 | 137517 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 11 Seymour St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001642.6038 | 2112140.9289 | 37.779628745329 | -122.437915153636 | (37.779628745329, -122.437915153636) | |||
| 164772 | 164772 | 137520 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 11 Seymour St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6001651.2928 | 2112086.3813 | 37.779479465517504 | -122.437881186624 | (37.7794794655175, -122.437881186624) | |||
| 174213 | 174213 | 137519 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 11 Seymour St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001649.8446 | 2112101.8284 | 37.7795217969961 | -122.437887303264 | (37.7795217969961, -122.437887303264) | |||
| 50947 | 50947 | 140439 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1100 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003462.4449 | 2112120.7446 | 37.77967664282979 | -122.431618099739 | (37.7796766428298, -122.431618099739) | |||
| 24888 | 24888 | 45611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1100 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 16 | Permit Number 44335 | 6003449.1823 | 2112117.4289 | 37.7796667869975 | -122.43166374401001 | (37.7796667869975, -122.43166374401) | ||
| 131817 | 131817 | 45603 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1100 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 14 | Permit Number 44335 | 6003434.2619 | 2112117.4289 | 37.779665941263104 | -122.43171536011101 | (37.7796659412631, -122.431715360111) | ||
| 17192 | 17192 | 17024 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1101 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001643.357000001 | 2109735.2672 | 37.7730234456568 | -122.437740206634 | (37.7730234456568, -122.437740206634) | |||
| 20516 | 20516 | 19219 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1101X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002112.0403 | 2110145.6145 | 37.774176795696995 | -122.436148345951 | (37.774176795697, -122.436148345951) | |||
| 21210 | 21210 | 19218 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1103X Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002097.9849 | 2110143.8576 | 37.7741711731344 | -122.43619684024799 | (37.7741711731344, -122.436196840248) | |||
| 19595 | 19595 | 7021 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002080.4157 | 2110140.9294 | 37.7741621348105 | -122.43625740553301 | (37.7741621348105, -122.436257405533) | |||
| 146337 | 146337 | 247502 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002054.0619 | 2110138.0012 | 37.7741525973198 | -122.436348358239 | (37.7741525973198, -122.436348358239) | |||
| 3051 | 3051 | 99233 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008063.2168 | 2121048.832 | 37.8044506767497 | -122.416334531861 | (37.8044506767497, -122.416334531861) | |||
| 5501 | 5501 | 99227 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008003.9616 | 2121103.5041 | 37.8045974602939 | -122.416543465428 | (37.8045974602939, -122.416543465428) | |||
| 5526 | 5526 | 99210 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007993.4855 | 2121112.3432 | 37.8046211410646 | -122.416580345595 | (37.8046211410646, -122.416580345595) | |||
| 6213 | 6213 | 99229 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008022.9494 | 2121084.5162 | 37.804546392141496 | -122.416476410342 | (37.8045463921415, -122.416476410342) | |||
| 6739 | 6739 | 99228 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008013.4555 | 2121093.6827 | 37.8045710271276 | -122.416509914664 | (37.8045710271276, -122.416509914664) | |||
| 8148 | 8148 | 99230 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008035.3898 | 2121073.3853 | 37.8045165290969 | -122.416432570152 | (37.8045165290969, -122.416432570152) | |||
| 8244 | 8244 | 99232 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008054.705 | 2121057.3439 | 37.8044735696368 | -122.416364591045 | (37.8044735696368, -122.416364591045) | |||
| 8426 | 8426 | 99231 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008046.5206 | 2121063.2366 | 37.804489289265106 | -122.416393331612 | (37.8044892892651, -122.416393331612) | |||
| 173948 | 173948 | 140405 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003761.2248 | 2112532.0496 | 37.7808229146257 | -122.430613848284 | (37.7808229146257, -122.430613848284) | |||
| 181633 | 181633 | 140404 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1113 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003757.2396 | 2112557.5551 | 37.7808927206056 | -122.430629455565 | (37.7808927206056, -122.430629455565) | |||
| 21361 | 21361 | 7023 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1115 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002035.3214 | 2110135.6586 | 37.7741451002744 | -122.43641301713801 | (37.7741451002744, -122.436413017138) | |||
| 186757 | 186757 | 140403 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1119 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003754.0514 | 2112594.2194 | 37.7809932110185 | -122.43064310216101 | (37.7809932110185, -122.430643102161) | |||
| 113892 | 113892 | 142943 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 112 PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010269.581 | 2121139.6226 | 37.8048237870919 | -122.408705588917 | (37.8048237870919, -122.408705588917) | |||
| 26086 | 26086 | 59151 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 112 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1980 12:00:00 AM | 13 | Permit Number 18460 | 6010290.1497 | 2121142.971 | 37.8048341329685 | -122.408634644798 | (37.8048341329685, -122.408634644798) | ||
| 26247 | 26247 | 140689 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003360.489 | 2112281.5531 | 37.780112403361294 | -122.431982295298 | (37.7801124033613, -122.431982295298) | |||
| 30246 | 30246 | 140690 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003362.1468 | 2112293.1578 | 37.7801443609542 | -122.431977389111 | (37.7801443609542, -122.431977389111) | |||
| 37138 | 37138 | 140693 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003357.1733 | 2112337.09 | 37.780264705851 | -122.43199773269801 | (37.780264705851, -122.431997732698) | |||
| 45184 | 45184 | 140688 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003366.7058 | 2112262.0737 | 37.780059270229295 | -122.431959397228 | (37.7800592702293, -122.431959397228) | |||
| 148925 | 148925 | 140691 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003358.8311 | 2112311.3938 | 37.780194244485294 | -122.43199016217899 | (37.7801942444853, -122.431990162179) | |||
| 150798 | 150798 | 140692 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003358.0022 | 2112322.1697 | 37.780223785424496 | -122.43199379942301 | (37.7802237854245, -122.431993799423) | |||
| 27146 | 27146 | 140419 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 STEINER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6002875.6498 | 2112268.3783 | 37.780048730384 | -122.43365863076201 | (37.780048730384, -122.433658630762) | |||
| 131547 | 131547 | 140420 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 STEINER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002874.2144 | 2112292.0633 | 37.7801136820125 | -122.43366528968599 | (37.7801136820125, -122.433665289686) | |||
| 150035 | 150035 | 140421 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 STEINER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002869.1903 | 2112320.0547 | 37.780190254306795 | -122.43368467143 | (37.7801902543068, -122.43368467143) | |||
| 65375 | 65375 | 200196 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1124 Fitzgerald Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 0ft | 6015063.1024 | 2090263.455 | 37.720311838731 | -122.38995879887301 | (37.720311838731, -122.389958798873) | |||
| 18114 | 18114 | 27413 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1125 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002017.7522 | 2110131.5591 | 37.774132845741704 | -122.436473498525 | (37.7741328457417, -122.436473498525) | |||
| 284 | 284 | 137592 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1125 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1990 12:00:00 AM | 18 | Width 0ft | 6002857.6038 | 2112094.871 | 37.7795712988398 | -122.433708655697 | (37.7795712988398, -122.433708655697) | ||
| 7509 | 7509 | 23794 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1125 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003750.8632 | 2112612.5515 | 37.7810433657763 | -122.43065544025299 | (37.7810433657763, -122.430655440253) | |||
| 74307 | 74307 | 137574 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1135 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002846.9387 | 2112168.7066 | 37.7797734277366 | -122.43375082949801 | (37.7797734277366, -122.433750829498) |
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");