trees
531 rows where Fire Prevention Districts = 15 and qSpecies_id = 54 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 144613 | 9631 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1439 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002709.6742 | 2111961.3805 | 37.7791963723972 | -122.434210861246 | (37.7791963723972, -122.434210861246) | 15 | 5 | 11 | 29490 | 41 | |||
| 145096 | 47470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2902 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | 14 | Permit Number 45371 | 5999554.6801 | 2114357.1647 | 37.7855950025795 | -122.445297547197 | (37.7855950025795, -122.445297547197) | 15 | 6 | 1 | 29490 | 31 | ||
| 147979 | 140482 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1137 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003743.6898 | 2112670.736 | 37.781202719512 | -122.430684409839 | (37.781202719512, -122.430684409839) | 15 | 9 | 11 | 29490 | 41 | |||
| 148115 | 138743 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2965 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999307.6319 | 2114263.2516 | 37.7853230365302 | -122.446145501349 | (37.7853230365302, -122.446145501349) | 15 | 6 | 1 | 29490 | 31 | |||
| 148694 | 119622 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 77 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6000135.3841 | 2112812.4267 | 37.7813866815394 | -122.44317750199 | (37.7813866815394, -122.44317750199) | 15 | 5 | 1 | 29490 | 16 | ||||
| 149382 | 22786 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1885 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001038.3513 | 2112073.2703 | 37.7794085922078 | -122.440000666135 | (37.7794085922078, -122.440000666135) | 15 | 5 | 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 | |||
| 149607 | 138740 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 PRESIDIO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999265.5073 | 2114223.1094 | 37.7852104108131 | -122.446288350453 | (37.7852104108131, -122.446288350453) | 15 | 6 | 1 | 29490 | 31 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 152340 | 9641 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1482 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002541.4785 | 2111991.5 | 37.7792695252567 | -122.434794873127 | (37.7792695252567, -122.434794873127) | 15 | 5 | 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 | |||
| 152825 | 138608 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999173.5218 | 2114868.2702 | 37.78697659984 | -122.446653025988 | (37.78697659984, -122.446653025988) | 15 | 6 | 1 | 29490 | 31 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 154652 | 106407 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5x6 | 5999244.445 | 2114365.5896 | 37.7856004213418 | -122.446371472736 | (37.7856004213418, -122.446371472736) | 15 | 6 | 1 | 29490 | 31 | |||
| 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 | |||
| 155852 | 139407 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1311 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000207.9303 | 2113507.632 | 37.7832996726996 | -122.442976468383 | (37.7832996726996, -122.442976468383) | 15 | 6 | 1 | 29490 | 31 | |||
| 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 | ||
| 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 | ||
| 157472 | 138742 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2965 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999291.2776 | 2114261.7649 | 37.7853180204784 | -122.446201975075 | (37.7853180204784, -122.446201975075) | 15 | 6 | 1 | 29490 | 31 | |||
| 158404 | 139083 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2512 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6000143.6633 | 2113744.4727 | 37.7839463117797 | -122.443215821997 | (37.7839463117797, -122.443215821997) | 15 | 6 | 11 | 29490 | 31 | |||
| 159022 | 54831 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 79 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1972 12:00:00 AM | 8 | Permit Number 10685 | 6000087.3282 | 2112805.9967 | 37.7813662861419 | -122.443343289517 | (37.7813662861419, -122.443343289517) | 15 | 5 | 1 | 29490 | 16 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 164343 | 140777 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 77 TERRA VISTA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000158.3968 | 2112814.4573 | 37.7813935692054 | -122.443098035367 | (37.7813935692054, -122.443098035367) | 15 | 5 | 1 | 29490 | 16 | |||
| 165670 | 61337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1984 12:00:00 AM | 10 | 5x6 | Permit Number 21242 | 5999250.392 | 2114334.8634 | 37.7855163948709 | -122.446348686743 | (37.7855163948709, -122.446348686743) | 15 | 6 | 1 | 29490 | 31 | |
| 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 | |||
| 174204 | 140775 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 79 TERRA VISTA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000103.2341 | 2112808.3657 | 37.7813736978278 | -122.443288433233 | (37.7813736978278, -122.443288433233) | 15 | 5 | 1 | 29490 | 16 | |||
| 179204 | 140428 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 7 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003076.6138 | 2112365.9894 | 37.7803281468599 | -122.432970381874 | (37.7803281468599, -122.432970381874) | 15 | 9 | 11 | 29490 | 41 | |||
| 180949 | 38058 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2844 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 15 | Permit Number 40253 | 5999884.3012 | 2114402.2303 | 37.7857375510232 | -122.44416039717 | (37.7857375510232, -122.44416039717) | 15 | 6 | 1 | 29490 | 31 | |
| 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 | |||
| 182958 | 138718 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1605 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999603.495 | 2114383.6783 | 37.7856705883683 | -122.445130569247 | (37.7856705883683, -122.445130569247) | 15 | 6 | 1 | 29490 | 31 | |||
| 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 | |||
| 184958 | 140491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1396 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003381.0328 | 2112450.7507 | 37.7805781423675 | -122.431923310003 | (37.7805781423675, -122.431923310003) | 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 | |||
| 191153 | 140423 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 13 | Width 0ft | 6002956.7531 | 2112350.9171 | 37.7802799627924 | -122.433383957928 | (37.7802799627924, -122.433383957928) | 15 | 9 | 11 | 29490 | 41 | |||
| 191363 | 140422 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6002931.6326 | 2112346.6107 | 37.7802667133087 | -122.433470553427 | (37.7802667133087, -122.433470553427) | 15 | 9 | 11 | 29490 | 41 | |||
| 194022 | 59752 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2375 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1981 12:00:00 AM | 11 | Permit Number 19189 | 6000826.215 | 2113783.3508 | 37.7840919573447 | -122.440857239763 | (37.7840919573447, -122.440857239763) | 15 | 6 | 11 | 29490 | 13 | ||
| 122 | 17067 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1355 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000506.9486 | 2109572.2346 | 37.7725111167076 | -122.441659471159 | (37.7725111167076, -122.441659471159) | 15 | 5 | 11 | 29492 | 9 | |||
| 581 | 248465 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997147.6982 | 2107925.2578 | 37.7677969745346 | -122.453160476336 | (37.7677969745346, -122.453160476336) | 15 | 5 | 11 | 29492 | 9 | |||
| 766 | 17084 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1575 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999487.0395 | 2109431.3054 | 37.7720659980909 | -122.445177292475 | (37.7720659980909, -122.445177292475) | 15 | 5 | 11 | 29492 | 9 | |||
| 1620 | 16991 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 899 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002773.5007 | 2109890.2869 | 37.7735132873347 | -122.433841985714 | (37.7735132873347, -122.433841985714) | 15 | 5 | 11 | 29492 | 9 | |||
| 4913 | 64501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 545 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 13 | Permit Number 25381 | 6001107.084 | 2110608.9242 | 37.7753917807448 | -122.439657882213 | (37.7753917807448, -122.439657882213) | 15 | 5 | 11 | 29492 | 10 | |
| 7238 | 17116 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1899 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997981.6278 | 2109222.6111 | 37.7714069348749 | -122.450369559944 | (37.7714069348749, -122.450369559944) | 15 | 5 | 11 | 29492 | 9 | |||
| 7894 | 7178 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 837 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/24/2020 11:28:00 AM | 12 | 6x6 | 6003458.7438 | 2111235.1971 | 37.7772449397217 | -122.431567664925 | (37.7772449397217, -122.431567664925) | 15 | 9 | 11 | 29492 | 10 | ||
| 8710 | 140706 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6002658.7155 | 2110338.0026 | 37.7747360892866 | -122.434271058386 | (37.7747360892866, -122.434271058386) | 15 | 5 | 11 | 29492 | 10 | |||
| 8783 | 7166 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 745 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003498.9011 | 2110946.3415 | 37.7764540897977 | -122.431408122706 | (37.7764540897977, -122.431408122706) | 15 | 9 | 11 | 29492 | 10 | |||
| 10837 | 70252 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001164.2534 | 2110490.0118 | 37.7750685309709 | -122.439451594404 | (37.7750685309709, -122.439451594404) | 15 | 5 | 11 | 29492 | 10 | |||
| 11591 | 246388 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1640 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997718.8338 | 2108194.9271 | 37.7685701345672 | -122.451204446298 | (37.7685701345672, -122.451204446298) | 15 | 5 | 11 | 29492 | 9 | |||
| 12978 | 7162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 727 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003506.9326 | 2110884.8593 | 37.7762857300682 | -122.431375949555 | (37.7762857300682, -122.431375949555) | 15 | 9 | 11 | 29492 | 10 | |||
| 14071 | 4509 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1807X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5998320.8634 | 2109271.3175 | 37.7715600792218 | -122.449199642237 | (37.7715600792218, -122.449199642237) | 15 | 5 | 11 | 29492 | 9 | |||
| 15279 | 248611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 862 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997689.6108 | 2107534.9111 | 37.7667562259025 | -122.45125791953 | (37.7667562259025, -122.45125791953) | 15 | 5 | 11 | 29492 | 9 | |||
| 15508 | 244193 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 531 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998442.5226 | 2108797.178 | 37.7702651709945 | -122.448744661621 | (37.7702651709945, -122.448744661621) | 15 | 5 | 11 | 29492 | 9 | |||
| 16062 | 247337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003076.0904 | 2109591.4739 | 37.7727099867472 | -122.432773934025 | (37.7727099867472, -122.432773934025) | 15 | 5 | 11 | 29492 | 9 | |||
| 16127 | 246164 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1756 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5997323.9447 | 2108138.6009 | 37.7683928596779 | -122.452566262235 | (37.7683928596779, -122.452566262235) | 15 | 5 | 11 | 29492 | 9 | |||
| 17314 | 71305 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 445 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6001154.5387 | 2110263.7555 | 37.7744467352044 | -122.439468977163 | (37.7744467352044, -122.439468977163) | 15 | 5 | 11 | 29492 | 10 | |||
| 18641 | 59622 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 448 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/1988 12:00:00 AM | 8 | Permit Number 25385 | 6001193.7685 | 2110273.1905 | 37.7744748738878 | -122.439333950555 | (37.7744748738878, -122.439333950555) | 15 | 5 | 11 | 29492 | 10 | |
| 18647 | 138987 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 661 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6003459.8516 | 2110684.9037 | 37.7757340330654 | -122.431524537427 | (37.7757340330654, -122.431524537427) | 15 | 9 | 11 | 29492 | 10 | |||
| 19779 | 140264 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2100X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5997701.9343 | 2110276.144 | 37.7742836533846 | -122.451413027686 | (37.7742836533846, -122.451413027686) | 15 | 5 | 2 | 29492 | 16 | |||
| 20537 | 141610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1501 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000537 | 2110949 | 37.7762930788063 | -122.441654341711 | (37.7762930788063, -122.441654341711) | 15 | 5 | 11 | 29492 | 16 | |||
| 20716 | 5146 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 217 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001830.6224 | 2108865.7235 | 37.7706465411236 | -122.437030167851 | (37.7706465411236, -122.437030167851) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 23620 | 141343 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 462 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001184.3335 | 2110341.7185 | 37.7746624976237 | -122.439371501085 | (37.7746624976237, -122.439371501085) | 15 | 5 | 11 | 29492 | 10 | |||
| 24027 | 17108 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1789 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5998462.7101 | 2109289.6892 | 37.7716186353865 | -122.448710312151 | (37.7716186353865, -122.448710312151) | 15 | 5 | 11 | 29492 | 9 | |||
| 24256 | 245132 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1585 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999461.1138 | 2109428.314 | 37.7720563046211 | -122.445266756098 | (37.7720563046211, -122.445266756098) | 15 | 5 | 11 | 29492 | 9 | |||
| 24536 | 16993 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002625.7759 | 2109923.0859 | 37.7735949613156 | -122.434355332323 | (37.7735949613156, -122.434355332323) | 15 | 5 | 11 | 29492 | 10 | |||
| 25184 | 244323 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003563.5505 | 2110000.7658 | 37.7738614359578 | -122.431116975625 | (37.7738614359578, -122.431116975625) | 15 | 9 | 11 | 29492 | 10 | |||
| 25823 | 140682 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 21366 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997596.5061 | 2110261.2804 | 37.7742368042101 | -122.451776648803 | (37.7742368042101, -122.451776648803) | 15 | 5 | 2 | 29492 | 16 | |||
| 26458 | 248312 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1375 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999157.272 | 2108349.6728 | 37.7690772810316 | -122.446240160162 | (37.7690772810316, -122.446240160162) | 15 | 5 | 11 | 29492 | 9 | |||
| 26924 | 142123 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 15 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5998622.5379 | 2110844.3781 | 37.7758965505953 | -122.448269431558 | (37.7758965505953, -122.448269431558) | 15 | 6 | 2 | 29492 | 16 | |||
| 27540 | 59659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 906 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19081 | 6002986.1752 | 2111478.2094 | 37.7778853946604 | -122.433219797973 | (37.7778853946604, -122.433219797973) | 15 | 9 | 11 | 29492 | 41 | ||
| 28067 | 142120 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1218 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6001961.8598 | 2110867.3987 | 37.7761501011447 | -122.436719523648 | (37.7761501011447, -122.436719523648) | 15 | 5 | 11 | 29492 | 10 | |||
| 29602 | 139484 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1216 FULTON ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 0ft | 6001778.449 | 2111192.2794 | 37.7770317168845 | -122.437377258879 | (37.7770317168845, -122.437377258879) | 15 | 5 | 11 | 29492 | 41 | |||
| 30933 | 245077 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1387 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000372.5007 | 2109554.1199 | 37.7724537171291 | -122.442123238035 | (37.7724537171291, -122.442123238035) | 15 | 5 | 11 | 29492 | 9 | |||
| 32007 | 7200 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 949 Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003420.9887 | 2111521.8792 | 37.7780299575939 | -122.431718745255 | (37.7780299575939, -122.431718745255) | 15 | 9 | 11 | 29492 | 41 | |||
| 32113 | 17114 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1889X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5998005.981 | 2109225.1746 | 37.7714153673222 | -122.45028550625 | (37.7714153673222, -122.45028550625) | 15 | 5 | 11 | 29492 | 9 | |||
| 32493 | 244027 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 510 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998001.7833 | 2108800.966 | 37.7702503589654 | -122.45026944288 | (37.7702503589654, -122.45026944288) | 15 | 5 | 11 | 29492 | 9 | |||
| 32823 | 248346 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1575 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5998065.2703 | 2108198.2582 | 37.7685991103156 | -122.45000639696 | (37.7685991103156, -122.45000639696) | 15 | 5 | 11 | 29492 | 9 | |||
| 32828 | 140712 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002642.8382 | 2110450.467 | 37.7750439873946 | -122.434334023387 | (37.7750439873946, -122.434334023387) | 15 | 5 | 11 | 29492 | 10 | |||
| 33663 | 14813 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1195 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003481.2511 | 2111720.7527 | 37.7785794305459 | -122.431524477475 | (37.7785794305459, -122.431524477475) | 15 | 9 | 11 | 29492 | 41 | |||
| 35369 | 140725 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 508 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002187.9434 | 2110254.4569 | 37.7744799618741 | -122.435893573485 | (37.7744799618741, -122.435893573485) | 15 | 5 | 11 | 29492 | 10 | |||
| 35755 | 246093 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997094.8545 | 2108310.1536 | 37.7688507707463 | -122.453371047271 | (37.7688507707463, -122.453371047271) | 15 | 5 | 11 | 29492 | 9 | |||
| 36701 | 59351 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52085 | 6000121.1922 | 2110676.4601 | 37.7755210539143 | -122.443073153769 | (37.7755210539143, -122.443073153769) | 15 | 5 | 11 | 29492 | 16 | |
| 36792 | 244324 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 717 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003593.9138 | 2110004.6215 | 37.7738737432923 | -122.431012219304 | (37.7738737432923, -122.431012219304) | 15 | 9 | 11 | 29492 | 10 | |||
| 38278 | 32778 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 555 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 2 | Permit Number 37147 | 6001101.7087 | 2110645.4763 | 37.7754918376538 | -122.439679097651 | (37.7754918376538, -122.439679097651) | 15 | 5 | 11 | 29492 | 10 | |
| 38889 | 246039 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1378 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5999138.4966 | 2108392.6745 | 37.7691942805388 | -122.446308196721 | (37.7691942805388, -122.446308196721) | 15 | 5 | 11 | 29492 | 9 | |||
| 38929 | 138927 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 901 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003523.5494 | 2110764.9413 | 37.7759574066142 | -122.431309905462 | (37.7759574066142, -122.431309905462) | 15 | 9 | 11 | 29492 | 10 | |||
| 39112 | 14585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1206 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999464.9463 | 2108691.264 | 37.7700327707282 | -122.44520049918 | (37.7700327707282, -122.44520049918) | 15 | 5 | 11 | 29492 | 9 | |||
| 39698 | 17058 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1285 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000917.1059 | 2109633.5588 | 37.7727028580257 | -122.440245097963 | (37.7727028580257, -122.440245097963) | 15 | 5 | 11 | 29492 | 9 | |||
| 40681 | 140585 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 949 FILLMORE ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6003432.0437 | 2111445.4153 | 37.7778206333488 | -122.431675041477 | (37.7778206333488, -122.431675041477) | 15 | 9 | 11 | 29492 | 41 | |||
| 40875 | 138980 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 712 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003074.6186 | 2110844.4251 | 37.7761501973749 | -122.432868552462 | (37.7761501973749, -122.432868552462) | 15 | 9 | 11 | 29492 | 10 | |||
| 41460 | 248350 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1587 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997973.5131 | 2108185.8423 | 37.7685597685915 | -122.450322880989 | (37.7685597685915, -122.450322880989) | 15 | 5 | 11 | 29492 | 9 | |||
| 41921 | 141342 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 454 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001185.8232 | 2110322.8485 | 37.7746107701242 | -122.439364995038 | (37.7746107701242, -122.439364995038) | 15 | 5 | 11 | 29492 | 10 | |||
| 43753 | 140708 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6002652.7615 | 2110375.0497 | 37.7748374734767 | -122.434294303619 | (37.7748374734767, -122.434294303619) | 15 | 5 | 11 | 29492 | 10 |
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) );