trees
1,381 rows where qSpecies_id = 54 sorted by qAddress
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 149390 | 141767 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1 Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003884.399 | 2113511.8848 | 37.7835202748029 | -122.430257654213 | (37.7835202748029, -122.430257654213) | 7 | 9 | 11 | 29490 | 41 | |||
| 153779 | 142620 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1 Scotland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009140.6951 | 2120065.1504 | 37.8018102626301 | -122.412536232083 | (37.8018102626301, -122.412536232083) | 3 | 1 | 10 | 308 | 4 | |||
| 56443 | 138041 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1 Wilmot St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003396.2249 | 2115029.767 | 37.7876603335628 | -122.432054974157 | (37.7876603335628, -122.432054974157) | 13 | 9 | 11 | 29490 | 27 | |||
| 146663 | 138040 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1 Wilmot St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003385.4026 | 2115029.2516 | 37.7876583048425 | -122.432092380369 | (37.7876583048425, -122.432092380369) | 13 | 9 | 11 | 29490 | 27 | |||
| 140116 | 64012 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 10 Loyola Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1987 12:00:00 AM | 10 | Permit Number 24766 | 5998456.7381 | 2110792.4322 | 37.7757444404433 | -122.44883923079 | (37.7757444404433, -122.44883923079) | 15 | 6 | 2 | 29492 | 16 | ||
| 109680 | 28299 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 100 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 5995861.9776 | 2088092.909 | 37.7132684524741 | -122.456173531067 | (37.7132684524741, -122.456173531067) | 9 | 8 | 6 | 28861 | 24 | |||
| 105740 | 247381 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1001 Oak St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6002208 | 2109818 | 37.7732826991746 | -122.435792959812 | (37.7732826991746, -122.435792959812) | 15 | 5 | 11 | 29492 | 9 | |||
| 130663 | 247380 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1001 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6002208 | 2109818 | 37.7732826991746 | -122.435792959812 | (37.7732826991746, -122.435792959812) | 15 | 5 | 11 | 29492 | 9 | |||
| 139481 | 247377 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1001 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6002208 | 2109818 | 37.7732826991746 | -122.435792959812 | (37.7732826991746, -122.435792959812) | 15 | 5 | 11 | 29492 | 9 | |||
| 63639 | 17679 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1004 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002429.082 | 2112004.3581 | 37.7792984485069 | -122.435184618671 | (37.7792984485069, -122.435184618671) | 15 | 5 | 11 | 29490 | 41 | |||
| 82645 | 17676 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1004 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002427.6935 | 2112026.5749 | 37.7793593714128 | -122.435191011573 | (37.7793593714128, -122.435191011573) | 15 | 5 | 11 | 29490 | 41 | |||
| 47862 | 17675 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1010 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002421.1673 | 2112056.7065 | 37.7794417346192 | -122.435215744209 | (37.7794417346192, -122.435215744209) | 15 | 5 | 11 | 29490 | 41 | |||
| 162051 | 17670 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1015X Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/1995 12:00:00 AM | 12 | 3X3 | 6002378.1109 | 2112076.6861 | 37.7794941484605 | -122.435366123882 | (37.7794941484605, -122.435366123882) | 15 | 5 | 11 | 29490 | 41 | ||
| 142896 | 17678 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1016 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002420.6118 | 2112080.0342 | 37.7795057550774 | -122.435219334932 | (37.7795057550774, -122.435219334932) | 15 | 5 | 11 | 29490 | 41 | |||
| 114700 | 217547 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 102 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5995842.2441 | 2088093.8487 | 37.7132698999071 | -122.456241804318 | (37.7132698999071, -122.456241804318) | 9 | 8 | 6 | 28861 | 24 | |||
| 25325 | 140508 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003419.5462 | 2111864.9347 | 37.778971820926 | -122.431748235324 | (37.778971820926, -122.431748235324) | 15 | 9 | 11 | 29490 | 41 | |||
| 83911 | 140506 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003442.3352 | 2111811.0008 | 37.7788250236202 | -122.431665547403 | (37.7788250236202, -122.431665547403) | 15 | 9 | 11 | 29490 | 41 | |||
| 123905 | 140503 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003449.1719 | 2111783.654 | 37.7787503236279 | -122.431639943641 | (37.7787503236279, -122.431639943641) | 15 | 9 | 11 | 29490 | 41 | |||
| 129185 | 140505 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003444.6141 | 2111801.8852 | 37.7788001236235 | -122.43165701281 | (37.7788001236235, -122.43165701281) | 15 | 9 | 11 | 29490 | 41 | |||
| 149566 | 140509 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003414.9884 | 2111885.4448 | 37.779027878196 | -122.431765467371 | (37.779027878196, -122.431765467371) | 15 | 9 | 11 | 29490 | 41 | |||
| 181350 | 140504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003445.3738 | 2111793.5292 | 37.7787772231874 | -122.431653787974 | (37.7787772231874, -122.431653787974) | 15 | 9 | 11 | 29490 | 41 | |||
| 24624 | 17680 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002416.7239 | 2112103.0842 | 37.7795688238035 | -122.435234433978 | (37.7795688238035, -122.435234433978) | 15 | 5 | 11 | 29490 | 41 | |||
| 17155 | 140539 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003373.4703 | 2111871.9826 | 37.7789885607925 | -122.43190813363 | (37.7789885607925, -122.43190813363) | 15 | 9 | 11 | 29490 | 41 | |||
| 43602 | 140542 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003382.3327 | 2111808.7639 | 37.7788154803812 | -122.431872959815 | (37.7788154803812, -122.431872959815) | 15 | 9 | 11 | 29490 | 41 | |||
| 86062 | 140540 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003378.1969 | 2111847.7586 | 37.7789223156672 | -122.43189005228 | (37.7789223156672, -122.43189005228) | 15 | 9 | 11 | 29490 | 41 | |||
| 152377 | 140541 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003379.3786 | 2111825.8979 | 37.7788623586164 | -122.43188440296 | (37.7788623586164, -122.43188440296) | 15 | 9 | 11 | 29490 | 41 | |||
| 154385 | 140543 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003386.4685 | 2111785.1308 | 37.7787508242216 | -122.431856964548 | (37.7787508242216, -122.431856964548) | 15 | 9 | 11 | 29490 | 41 | |||
| 161906 | 140538 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003370.5162 | 2111893.2524 | 37.7790467948997 | -122.43191987222 | (37.7790467948997, -122.43191987222) | 15 | 9 | 11 | 29490 | 41 | |||
| 170061 | 140544 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003387.6502 | 2111766.8151 | 37.7787006008552 | -122.431851568456 | (37.7787006008552, -122.431851568456) | 15 | 9 | 11 | 29490 | 41 | |||
| 150065 | 20147 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/1989 12:00:00 AM | 12 | 3x3 | 6002893.7013 | 2111823.32 | 37.7788277359036 | -122.433564367127 | (37.7788277359036, -122.433564367127) | 15 | 9 | 11 | 29490 | 41 | ||
| 125485 | 7384 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1026 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6010763.6701 | 2111388.108 | 37.7780761292824 | -122.406308232523 | (37.7780761292824, -122.406308232523) | 14 | 2 | 9 | 28853 | 34 | |||
| 5424 | 113149 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6010826.0688 | 2111360.9298 | 37.7780049945656 | -122.406090456701 | (37.7780049945656, -122.406090456701) | 14 | 2 | 9 | 28853 | 34 | |||
| 70476 | 7391 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/1992 12:00:00 AM | 30 | 3x3 | 6010784.4697 | 2111320.9947 | 37.7778930152772 | -122.40623154915 | (37.7778930152772, -122.40623154915) | 14 | 2 | 9 | 28853 | 34 | ||
| 79570 | 7389 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010809.9838 | 2111345.3995 | 37.7779614523005 | -122.406145006296 | (37.7779614523005, -122.406145006296) | 14 | 2 | 9 | 28853 | 34 | |||
| 95032 | 7388 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010798.3361 | 2111334.861 | 37.7779318645299 | -122.406184557349 | (37.7779318645299, -122.406184557349) | 14 | 2 | 9 | 28853 | 34 | |||
| 148626 | 7390 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1035X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010768.3847 | 2111305.4643 | 37.7778494726714 | -122.406286098573 | (37.7778494726714, -122.406286098573) | 14 | 2 | 9 | 28853 | 34 | |||
| 60133 | 4721 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1040 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5x5 | 6008335.3567 | 2120887.0824 | 37.8040218523597 | -122.415381307054 | (37.8040218523597, -122.415381307054) | 5 | 1 | 10 | 308 | 23 | |||
| 82332 | 4722 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1040 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 4x4 | 6008317.4743 | 2120903.2884 | 37.8040653448727 | -122.415444338519 | (37.8040653448727, -122.415444338519) | 5 | 1 | 10 | 308 | 23 | |||
| 139954 | 4720 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1040 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5x5 | 6008353.7979 | 2120870.8765 | 37.8039783914932 | -122.415316341899 | (37.8039783914932, -122.415316341899) | 5 | 1 | 10 | 308 | 23 | |||
| 53713 | 140510 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1040 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003410.4306 | 2111922.6668 | 37.7791298221794 | -122.431783892996 | (37.7791298221794, -122.431783892996) | 15 | 9 | 11 | 29490 | 41 | |||
| 151193 | 140511 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1040 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003403.594 | 2111971.2833 | 37.7792629234397 | -122.431811015775 | (37.7792629234397, -122.431811015775) | 15 | 9 | 11 | 29490 | 41 | |||
| 84754 | 20151 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1043 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778996 | 6002888.3687 | 2111863.5194 | 37.7789378108444 | -122.433585688352 | (37.7789378108444, -122.433585688352) | 15 | 9 | 11 | 29490 | 41 | |
| 50148 | 247386 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1045 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001982.645 | 2109781.521 | 37.773169733383 | -122.436569880602 | (37.773169733383, -122.436569880602) | 15 | 5 | 11 | 29492 | 9 | |||
| 4593 | 4724 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4x4 | 6008259.9153 | 2120954.1415 | 37.8042017393393 | -122.415647128831 | (37.8042017393393, -122.415647128831) | 5 | 1 | 10 | 308 | 23 | |||
| 48457 | 4725 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4x4 | 6008238.1211 | 2120976.4945 | 37.8042618899237 | -122.415724133248 | (37.8042618899237, -122.415724133248) | 5 | 1 | 10 | 308 | 23 | |||
| 81395 | 4723 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 5x5 | 6008295.1213 | 2120922.8472 | 37.8041177920118 | -122.415523078458 | (37.8041177920118, -122.415523078458) | 5 | 1 | 10 | 308 | 23 | |||
| 141751 | 140512 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1050 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6003399.7958 | 2111999.3898 | 37.7793398815792 | -122.431826162709 | (37.7793398815792, -122.431826162709) | 15 | 9 | 11 | 29490 | 41 | |||
| 77368 | 247387 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1053 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001955.5092 | 2109778.1291 | 37.7731588780046 | -122.43666350389 | (37.7731588780046, -122.43666350389) | 15 | 5 | 11 | 29492 | 9 | |||
| 123304 | 143227 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 106 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010308.3267 | 2121146.7978 | 37.8048456584244 | -122.408572011197 | (37.8048456584244, -122.408572011197) | 3 | 1 | 10 | 308 | 23 | |||
| 13607 | 140513 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1060 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003397.5169 | 2112023.698 | 37.7794064966556 | -122.431835782497 | (37.7794064966556, -122.431835782497) | 15 | 9 | 11 | 29490 | 41 | |||
| 162822 | 140546 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1060 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002924.6148 | 2111925.6484 | 37.7791104580396 | -122.433464739787 | (37.7791104580396, -122.433464739787) | 15 | 9 | 11 | 29490 | 41 | |||
| 150356 | 28073 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1075 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008262.9463 | 2120869.8064 | 37.8039703467655 | -122.415630664984 | (37.8039703467655, -122.415630664984) | 5 | 1 | 10 | 308 | 32 | |||
| 156904 | 4726 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1075 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 6008251.3021 | 2120879.612 | 37.8039966159278 | -122.415671655323 | (37.8039966159278, -122.415671655323) | 5 | 1 | 10 | 308 | 32 | ||||
| 62539 | 140548 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1080 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002919.3909 | 2111977.3656 | 37.7792521641585 | -122.433486508226 | (37.7792521641585, -122.433486508226) | 15 | 9 | 11 | 29490 | 41 | |||
| 133221 | 199982 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1081 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6018036.5838 | 2092513.2332 | 37.7266537566215 | -122.379836574534 | (37.7266537566215, -122.379836574534) | 10 | 3 | 8 | 58 | 1 | |||
| 191893 | 54834 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 109 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 17 | Permit Number 10688 | 5998714.6082 | 2110323.5588 | 37.7744717777818 | -122.447913432558 | (37.7744717777818, -122.447913432558) | 15 | 5 | 11 | 29492 | 16 | ||
| 45831 | 140535 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1099 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003363.1308 | 2111944.3591 | 37.7791867024877 | -122.4319490716 | (37.7791867024877, -122.4319490716) | 15 | 9 | 11 | 29490 | 41 | |||
| 112637 | 140534 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1099 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003360.1767 | 2111967.4014 | 37.7792498034321 | -122.431960936856 | (37.7792498034321, -122.431960936856) | 15 | 9 | 11 | 29490 | 41 | |||
| 153637 | 140536 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1099 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003366.6758 | 2111915.9993 | 37.7791090345092 | -122.431934782401 | (37.7791090345092, -122.431934782401) | 15 | 9 | 11 | 29490 | 41 | |||
| 155392 | 140533 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1099 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003358.5145 | 2111988.9607 | 37.7793089056656 | -122.431968226988 | (37.7793089056656, -122.431968226988) | 15 | 9 | 11 | 29490 | 41 | |||
| 159544 | 143505 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 11 Gerke Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010554.2854 | 2120185.3922 | 37.802219647583 | -122.407653012156 | (37.802219647583, -122.407653012156) | 3 | 1 | 10 | 308 | 23 | |||
| 53616 | 137517 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 11 Seymour St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001642.6038 | 2112140.9289 | 37.779628745329 | -122.437915153636 | (37.779628745329, -122.437915153636) | 15 | 5 | 11 | 29490 | 41 | |||
| 90781 | 137519 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 11 Seymour St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001649.8446 | 2112101.8284 | 37.7795217969961 | -122.437887303264 | (37.7795217969961, -122.437887303264) | 15 | 5 | 11 | 29490 | 41 | |||
| 138695 | 137520 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 11 Seymour St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6001651.2928 | 2112086.3813 | 37.7794794655175 | -122.437881186624 | (37.7794794655175, -122.437881186624) | 15 | 5 | 11 | 29490 | 41 | |||
| 68988 | 140439 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 1100 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003462.4449 | 2112120.7446 | 37.7796766428298 | -122.431618099739 | (37.7796766428298, -122.431618099739) | 15 | 9 | 11 | 29490 | 41 | |||
| 122184 | 45603 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1100 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2001 12:00:00 AM | 14 | Permit Number 44335 | 6003434.2619 | 2112117.4289 | 37.7796659412631 | -122.431715360111 | (37.7796659412631, -122.431715360111) | 15 | 9 | 11 | 29490 | 41 | ||
| 157137 | 45611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1100 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2001 12:00:00 AM | 16 | Permit Number 44335 | 6003449.1823 | 2112117.4289 | 37.7796667869975 | -122.43166374401 | (37.7796667869975, -122.43166374401) | 15 | 9 | 11 | 29490 | 41 | ||
| 21641 | 17024 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1101 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001643.357 | 2109735.2672 | 37.7730234456568 | -122.437740206634 | (37.7730234456568, -122.437740206634) | 15 | 5 | 11 | 29492 | 9 | |||
| 117070 | 19219 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1101X Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002112.0403 | 2110145.6145 | 37.774176795697 | -122.436148345951 | (37.774176795697, -122.436148345951) | 15 | 5 | 11 | 29492 | 10 | |||
| 166099 | 19218 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1103X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002097.9849 | 2110143.8576 | 37.7741711731344 | -122.436196840248 | (37.7741711731344, -122.436196840248) | 15 | 5 | 11 | 29492 | 10 | |||
| 177129 | 247502 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002054.0619 | 2110138.0012 | 37.7741525973198 | -122.436348358239 | (37.7741525973198, -122.436348358239) | 15 | 5 | 11 | 29492 | 10 | |||
| 190613 | 7021 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002080.4157 | 2110140.9294 | 37.7741621348105 | -122.436257405533 | (37.7741621348105, -122.436257405533) | 15 | 5 | 11 | 29492 | 10 | |||
| 46849 | 99233 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008063.2168 | 2121048.832 | 37.8044506767497 | -122.416334531861 | (37.8044506767497, -122.416334531861) | 5 | 1 | 10 | 308 | 32 | |||
| 88548 | 99210 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007993.4855 | 2121112.3432 | 37.8046211410646 | -122.416580345595 | (37.8046211410646, -122.416580345595) | 5 | 1 | 10 | 308 | 32 | |||
| 96661 | 99228 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008013.4555 | 2121093.6827 | 37.8045710271276 | -122.416509914664 | (37.8045710271276, -122.416509914664) | 5 | 1 | 10 | 308 | 32 | |||
| 109841 | 99229 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008022.9494 | 2121084.5162 | 37.8045463921415 | -122.416476410342 | (37.8045463921415, -122.416476410342) | 5 | 1 | 10 | 308 | 32 | |||
| 147046 | 99232 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008054.705 | 2121057.3439 | 37.8044735696368 | -122.416364591045 | (37.8044735696368, -122.416364591045) | 5 | 1 | 10 | 308 | 32 | |||
| 172700 | 99231 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008046.5206 | 2121063.2366 | 37.8044892892651 | -122.416393331612 | (37.8044892892651, -122.416393331612) | 5 | 1 | 10 | 308 | 32 | |||
| 176662 | 99230 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008035.3898 | 2121073.3853 | 37.8045165290969 | -122.416432570152 | (37.8045165290969, -122.416432570152) | 5 | 1 | 10 | 308 | 32 | |||
| 192594 | 99227 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008003.9616 | 2121103.5041 | 37.8045974602939 | -122.416543465428 | (37.8045974602939, -122.416543465428) | 5 | 1 | 10 | 308 | 32 | |||
| 68422 | 140405 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003761.2248 | 2112532.0496 | 37.7808229146257 | -122.430613848284 | (37.7808229146257, -122.430613848284) | 15 | 9 | 11 | 29490 | 41 | |||
| 108725 | 140404 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1111 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003767 | 2112659 | 37.7811718159606 | -122.430602930425 | (37.7811718159606, -122.430602930425) | 15 | 9 | 11 | 29490 | 41 | |||
| 167293 | 7023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1115 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002035.3214 | 2110135.6586 | 37.7741451002744 | -122.436413017138 | (37.7741451002744, -122.436413017138) | 15 | 5 | 11 | 29492 | 10 | |||
| 54101 | 140403 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1119 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003754.0514 | 2112594.2194 | 37.7809932110185 | -122.430643102161 | (37.7809932110185, -122.430643102161) | 15 | 9 | 11 | 29490 | 41 | |||
| 148028 | 142943 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 112 PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010269.581 | 2121139.6226 | 37.8048237870919 | -122.408705588917 | (37.8048237870919, -122.408705588917) | 3 | 1 | 10 | 308 | 23 | |||
| 65586 | 59151 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 112 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1980 12:00:00 AM | 13 | Permit Number 18460 | 6010290.1497 | 2121142.971 | 37.8048341329685 | -122.408634644798 | (37.8048341329685, -122.408634644798) | 3 | 1 | 10 | 308 | 23 | ||
| 75521 | 140689 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003360.489 | 2112281.5531 | 37.7801124033613 | -122.431982295298 | (37.7801124033613, -122.431982295298) | 15 | 9 | 11 | 29490 | 41 | |||
| 128043 | 140692 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003358.0022 | 2112322.1697 | 37.7802237854245 | -122.431993799423 | (37.7802237854245, -122.431993799423) | 15 | 9 | 11 | 29490 | 41 | |||
| 136964 | 140690 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003362.1468 | 2112293.1578 | 37.7801443609542 | -122.431977389111 | (37.7801443609542, -122.431977389111) | 15 | 9 | 11 | 29490 | 41 | |||
| 150721 | 140693 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003357.1733 | 2112337.09 | 37.780264705851 | -122.431997732698 | (37.780264705851, -122.431997732698) | 15 | 9 | 11 | 29490 | 41 | |||
| 154157 | 140688 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003366.7058 | 2112262.0737 | 37.7800592702293 | -122.431959397228 | (37.7800592702293, -122.431959397228) | 15 | 9 | 11 | 29490 | 41 | |||
| 186344 | 140691 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003358.8311 | 2112311.3938 | 37.7801942444853 | -122.431990162179 | (37.7801942444853, -122.431990162179) | 15 | 9 | 11 | 29490 | 41 | |||
| 27263 | 140420 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 STEINER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002874.2144 | 2112292.0633 | 37.7801136820125 | -122.433665289686 | (37.7801136820125, -122.433665289686) | 15 | 9 | 11 | 29490 | 41 | |||
| 68432 | 140421 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 STEINER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002869.1903 | 2112320.0547 | 37.7801902543068 | -122.43368467143 | (37.7801902543068, -122.43368467143) | 15 | 9 | 11 | 29490 | 41 | |||
| 154590 | 140419 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 STEINER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6002875.6498 | 2112268.3783 | 37.780048730384 | -122.433658630762 | (37.780048730384, -122.433658630762) | 15 | 9 | 11 | 29490 | 41 | |||
| 122068 | 200196 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1124 Fitzgerald Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 0ft | 6015063.1024 | 2090263.455 | 37.720311838731 | -122.389958798873 | (37.720311838731, -122.389958798873) | 10 | 3 | 8 | 58 | 1 | |||
| 190509 | 27413 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1125 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002017.7522 | 2110131.5591 | 37.7741328457417 | -122.436473498525 | (37.7741328457417, -122.436473498525) | 15 | 5 | 11 | 29492 | 10 | |||
| 157331 | 137592 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1125 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1990 12:00:00 AM | 18 | Width 0ft | 6002857.6038 | 2112094.871 | 37.7795712988398 | -122.433708655697 | (37.7795712988398, -122.433708655697) | 15 | 9 | 11 | 29490 | 41 | ||
| 136329 | 23794 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1125 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003750.8632 | 2112612.5515 | 37.7810433657763 | -122.430655440253 | (37.7810433657763, -122.430655440253) | 15 | 9 | 11 | 29490 | 41 | |||
| 184887 | 137574 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1135 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002846.9387 | 2112168.7066 | 37.7797734277366 | -122.433750829498 | (37.7797734277366, -122.433750829498) | 15 | 9 | 11 | 29490 | 41 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );