trees
408 rows where Police Districts = 9 and qSpecies_id = 53 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47028 | 110967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2439 WASHINGTON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003043 | 2116458 | 37.7915618650441 | -122.433379161821 | (37.7915618650441, -122.433379161821) | 13 | 9 | 1 | 29490 | 27 | ||||
| 156467 | 109326 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1624 VALLEJO ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005582.1 | 2118270.7 | 37.7966828044962 | -122.424722909098 | (37.7966828044962, -122.424722909098) | 13 | 9 | 1 | 57 | 17 | |||||
| 280 | 8072 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 661 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005345.6576 | 2111619.4154 | 37.7784066780298 | -122.425067563729 | (37.7784066780298, -122.425067563729) | 7 | 9 | 11 | 28852 | 10 | |||
| 2280 | 116028 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1500 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006937 | 2117734 | 37.7952855901943 | -122.419996533467 | (37.7952855901943, -122.419996533467) | 13 | 9 | 10 | 28858 | 32 | ||||
| 4658 | 46466 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3310X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2002 12:00:00 AM | 12 | 3x3 | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | 13 | 9 | 1 | 57 | 17 | |
| 5822 | 16933 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 530 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 3X3 | 6004214.00427 | 2110149.16937 | 37.7743057532085 | -122.428877532014 | (37.7743057532085, -122.428877532014) | 7 | 9 | 11 | 28852 | 10 | |||
| 6753 | 140065 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 612 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005425.1416 | 2111379.12 | 37.7777513751906 | -122.424775499228 | (37.7777513751906, -122.424775499228) | 7 | 9 | 11 | 28852 | 10 | |||
| 9194 | 260391 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 11231 | 57646 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 666 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 16 | 7x7 | Permit Number 19439 | 6005402.5793 | 2111576.4092 | 37.7782918087921 | -122.424867589608 | (37.7782918087921, -122.424867589608) | 7 | 9 | 11 | 28852 | 10 | |
| 12223 | 59958 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 515 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | 17 | Permit Number 19435 | 6005418.82 | 2111104.349 | 37.7769965639956 | -122.424777815426 | (37.7769965639956, -122.424777815426) | 7 | 9 | 11 | 28852 | 10 | |
| 14128 | 16935 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 542 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004164.66828 | 2110140.85762 | 37.7742801386068 | -122.429047601533 | (37.7742801386068, -122.429047601533) | 7 | 9 | 11 | 28852 | 10 | |||
| 14200 | 33719 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 27 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | 13 | Permit Number 37787 | 6004127.51235208 | 2108864.68166901 | 37.7707739677449 | -122.429085120408 | (37.7707739677449, -122.429085120408) | 7 | 9 | 11 | 29492 | 10 | ||
| 14444 | 7238 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1085 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4X4 | 6003353.84267 | 2112023.38614 | 37.7794031644909 | -122.431986847688 | (37.7794031644909, -122.431986847688) | 15 | 9 | 11 | 29490 | 41 | |||
| 15312 | 59957 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1981 12:00:00 AM | 12 | Permit Number 19434 | 6005396.005 | 2111241.6 | 37.7773721331465 | -122.424866506623 | (37.7773721331465, -122.424866506623) | 7 | 9 | 11 | 28852 | 10 | |
| 15375 | 57511 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 636 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | 17 | Permit Number 16364 | 6005408.351 | 2111510.821 | 37.7781120456222 | -122.424842955768 | (37.7781120456222, -122.424842955768) | 7 | 9 | 11 | 28852 | 10 | ||
| 16922 | 59787 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1755 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1981 12:00:00 AM | Permit Number 19237 | 6004552.42886001 | 2119092.68520918 | 37.7988815571833 | -122.428344419585 | (37.7988815571833, -122.428344419585) | 13 | 9 | 1 | 57 | 17 | ||
| 17302 | 59963 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 523 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1981 12:00:00 AM | 15 | Permit Number 19442 | 6005413.5665 | 2111133.9591 | 37.777077569392 | -122.424798095948 | (37.777077569392, -122.424798095948) | 7 | 9 | 11 | 28852 | 10 | |
| 20388 | 6375 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 309X Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006152.1987649 | 2112618.7866796 | 37.7811962356475 | -122.422348456516 | (37.7811962356475, -122.422348456516) | 7 | 9 | 11 | 28852 | 41 | |||
| 20638 | 21644 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1657 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004676.7022509 | 2114666.9735246 | 37.7867367053745 | -122.427598912468 | (37.7867367053745, -122.427598912468) | 13 | 9 | 11 | 28858 | 13 | |||
| 20994 | 100049 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 768990 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | ||
| 21498 | 98979 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 38 MILEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778225 | 5999656 | 2118689 | 37.7974948649915 | -122.4452585722 | (37.7974948649915, -122.4452585722) | 13 | 9 | 1 | 57 | 17 | ||
| 21570 | 7202 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 926 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003476.58431 | 2111463.23602 | 37.7778720892035 | -122.431522232661 | (37.7778720892035, -122.431522232661) | 15 | 9 | 11 | 29492 | 41 | |||
| 24683 | 16945 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 602 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004026.09211 | 2110141.24132 | 37.7742733469863 | -122.429526989132 | (37.7742733469863, -122.429526989132) | 7 | 9 | 11 | 29492 | 10 | |||
| 28315 | 6990 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 855 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003337.33996 | 2110322.66362 | 37.7747324668328 | -122.431922464006 | (37.7747324668328, -122.431922464006) | 15 | 9 | 11 | 29492 | 10 | |||
| 29320 | 21640 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1645 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004732.1765743 | 2114674.6857014 | 37.7867610187213 | -122.427407534005 | (37.7867610187213, -122.427407534005) | 13 | 9 | 11 | 28858 | 13 | |||
| 29407 | 16958 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 705 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x5 | 6003566.56897 | 2110004.67754 | 37.7738723476787 | -122.431106813505 | (37.7738723476787, -122.431106813505) | 15 | 9 | 11 | 29492 | 10 | |||
| 30808 | 21696 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1890 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 16 | 4x4 | 6003576.7245218 | 2114564.5327129 | 37.7863931493079 | -122.431397256992 | (37.7863931493079, -122.431397256992) | 13 | 9 | 11 | 29490 | 27 | ||
| 31660 | 7182 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 857 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003432.47617 | 2111314.05853 | 37.7774599847744 | -122.43166416476 | (37.7774599847744, -122.43166416476) | 15 | 9 | 11 | 29492 | 10 | |||
| 32727 | 16390 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 246 Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006205.61528 | 2114051.709 | 37.7851337020107 | -122.422265498437 | (37.7851337020107, -122.422265498437) | 13 | 9 | 11 | 28858 | 41 | |||
| 32743 | 22671 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1140X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6003752.72615 | 2112639.82159 | 37.7811183481869 | -122.430650941901 | (37.7811183481869, -122.430650941901) | 15 | 9 | 11 | 29490 | 41 | |||
| 34036 | 9687 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 330 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2001 12:00:00 AM | 16 | 3x3 | 6006025.52151 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | 7 | 9 | 11 | 28852 | 10 | ||
| 34775 | 14651 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 655X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.7797037167615 | -122.422781416289 | (37.7797037167615, -122.422781416289) | 7 | 9 | 11 | 28852 | 10 | |||
| 35407 | 94294 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
| 35689 | 7151 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
| 37838 | 102503 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 290X Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | 7 | 9 | 11 | 29492 | 10 | ||||
| 38287 | 22723 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 3 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 39760 | 21735 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1980 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x4 | 6003153.81629 | 2114507.53827 | 37.7862126798287 | -122.432856338004 | (37.7862126798287, -122.432856338004) | 13 | 9 | 11 | 29490 | 27 | |||
| 41634 | 13254 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2408 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 45 | 3X3 | 6000832.23006 | 2119380.36917 | 37.7994602521243 | -122.441238147567 | (37.7994602521243, -122.441238147567) | 13 | 9 | 1 | 57 | 17 | ||
| 41963 | 21634 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1629 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004806.293908 | 2114684.9896753 | 37.786793502462 | -122.427151839633 | (37.786793502462, -122.427151839633) | 13 | 9 | 11 | 28858 | 13 | |||
| 43983 | 10710 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 17X Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003901.15311 | 2113362.61867 | 37.7831113762968 | -122.430189039187 | (37.7831113762968, -122.430189039187) | 7 | 9 | 11 | 29490 | 41 | |||
| 45836 | 9661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 112 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006079.13931 | 2110176.88384 | 37.7744872417771 | -122.422427647286 | (37.7744872417771, -122.422427647286) | 7 | 9 | 11 | 28852 | 10 | |||
| 46032 | 121039 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2101 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
| 46932 | 17830 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1961 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004561.39396 | 2115345.0767756 | 37.7885920838825 | -122.428046192771 | (37.7885920838825, -122.428046192771) | 13 | 9 | 11 | 28858 | 27 | |||
| 48721 | 9675 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 235 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1981 12:00:00 AM | 12 | 3X3 | 6005972.11971 | 2110519.21136 | 37.7754211527567 | -122.422822183014 | (37.7754211527567, -122.422822183014) | 7 | 9 | 11 | 28852 | 10 | ||
| 50755 | 7185 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 865 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003457.39592 | 2111275.80383 | 37.7773563593355 | -122.431575227386 | (37.7773563593355, -122.431575227386) | 15 | 9 | 11 | 29492 | 10 | |||
| 50801 | 95033 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 50810 | 20244 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
| 51471 | 20141 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1001 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002903.1358 | 2111776.1473 | 37.7786987467479 | -122.433528357436 | (37.7786987467479, -122.433528357436) | 15 | 9 | 11 | 29490 | 41 | |||
| 52416 | 6378 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 310 Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006136.3622128 | 2112667.0618885 | 37.7813278942368 | -122.422406674363 | (37.7813278942368, -122.422406674363) | 7 | 9 | 11 | 28852 | 41 | |||
| 57513 | 12263 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004991.72568 | 2111198.95935 | 37.7772322091826 | -122.426262005109 | (37.7772322091826, -122.426262005109) | 7 | 9 | 11 | 28852 | 10 | |||
| 61171 | 16895 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 371 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005249.75731 | 2110166.87775 | 37.7744129459718 | -122.425295929281 | (37.7744129459718, -122.425295929281) | 7 | 9 | 11 | 28852 | 10 | |||
| 61417 | 7288 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1860 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x5 | 6003020.21181 | 2114689.03027 | 37.7867034322579 | -122.433331547756 | (37.7867034322579, -122.433331547756) | 13 | 9 | 11 | 29490 | 27 | |||
| 62512 | 21625 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004858.21198 | 2114748.18478 | 37.7869699562504 | -122.426976717781 | (37.7869699562504, -122.426976717781) | 13 | 9 | 11 | 28858 | 27 | |||
| 65399 | 7150 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003528.61787 | 2110726.18593 | 37.7758512811844 | -122.431289605258 | (37.7758512811844, -122.431289605258) | 15 | 9 | 11 | 29492 | 10 | |||
| 66815 | 23796 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1133 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003746.01833 | 2112690.85168 | 37.7812580840725 | -122.430677790145 | (37.7812580840725, -122.430677790145) | 15 | 9 | 11 | 29490 | 41 | |||
| 70605 | 7148 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 670X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6003788.041 | 2110084.01472 | 37.7741027355458 | -122.430346367315 | (37.7741027355458, -122.430346367315) | 7 | 9 | 11 | 29492 | 10 | |||
| 71007 | 116518 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 480 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2016 12:00:00 AM | 3 | 9x6 | 6003703 | 2109976 | 37.7738013362642 | -122.430632829648 | (37.7738013362642, -122.430632829648) | 7 | 9 | 11 | 29492 | 10 | ||
| 72584 | 16863 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 215 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005958.79101 | 2110336.37823 | 37.774918385113 | -122.422855293382 | (37.774918385113, -122.422855293382) | 7 | 9 | 11 | 28852 | 10 | |||
| 72817 | 121043 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2125 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118096 | 37.7962471953974 | -122.422008397548 | (37.7962471953974, -122.422008397548) | 13 | 9 | 10 | 28858 | 32 | ||||
| 77688 | 1668 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2679X LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5999625 | 2119128 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | 13 | 9 | 1 | 57 | 17 | |||
| 77904 | 56931 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1909 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 17 | Permit Number 14175 | 6004317.92538 | 2118019.69798 | 37.795922137343 | -122.429079333669 | (37.795922137343, -122.429079333669) | 13 | 9 | 1 | 28858 | 27 | ||
| 78906 | 7228 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1040 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003407.87597 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | 15 | 9 | 11 | 29490 | 41 | |||
| 79190 | 7215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.431717632161 | (37.778666518442, -122.431717632161) | 15 | 9 | 11 | 29490 | 41 | |||
| 79471 | 59271 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2017 12:00:00 AM | 3 | Permit Number 18607 | 6004280.88948873 | 2109181.36087728 | 37.7716521728269 | -122.428577162778 | (37.7716521728269, -122.428577162778) | 7 | 9 | 11 | 28852 | 10 | ||
| 81527 | 26942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x5 | 6002862.4862 | 2114464.90765 | 37.7860790992099 | -122.433861214618 | (37.7860790992099, -122.433861214618) | 13 | 9 | 11 | 29490 | 27 | |||
| 81976 | 7711 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 43 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006508.0978555 | 2110273.8315465 | 37.7747776257034 | -122.420950679235 | (37.7747776257034, -122.420950679235) | 7 | 9 | 11 | 28852 | 10 | |||
| 82016 | 16948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 617 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004030.19479 | 2110006.18975 | 37.7739027607756 | -122.429503163951 | (37.7739027607756, -122.429503163951) | 7 | 9 | 11 | 29492 | 10 | |||
| 83704 | 10626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 414 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005955 | 2111106 | 37.7770313662769 | -122.422923117926 | (37.7770313662769, -122.422923117926) | 7 | 9 | 11 | 28852 | 10 | |||
| 83755 | 7286 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1848 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003026.38997 | 2114635.62779 | 37.7865571530845 | -122.433306355459 | (37.7865571530845, -122.433306355459) | 13 | 9 | 11 | 29490 | 27 | |||
| 83917 | 7189 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5X5 | 6003518.08132 | 2111313.80886 | 37.7774641511736 | -122.43136801056 | (37.7774641511736, -122.43136801056) | 7 | 9 | 11 | 29492 | 10 | |||
| 84337 | 9917 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1905X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3x3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
| 87434 | 7222 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1005 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003381.12091 | 2111775.83058 | 37.7787249849862 | -122.431874799698 | (37.7787249849862, -122.431874799698) | 15 | 9 | 11 | 29490 | 41 | |||
| 87750 | 53929 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1700 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1972 12:00:00 AM | 3x3 | Permit Number 9642 | 6004487.99959123 | 2114676.46033991 | 37.786752078395 | -122.428252455396 | (37.786752078395, -122.428252455396) | 13 | 9 | 11 | 28858 | 27 | ||
| 90065 | 13211 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2190 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6001897.52108 | 2119466.22991 | 37.7997566277665 | -122.437558020868 | (37.7997566277665, -122.437558020868) | 13 | 9 | 1 | 57 | 17 | |||
| 90207 | 6932 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 500 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | Permit Number 780762 | 6004980.8762 | 2110598.20876 | 37.7755820815859 | -122.426256755638 | (37.7755820815859, -122.426256755638) | 7 | 9 | 11 | 28852 | 10 | ||
| 90763 | 113321 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 222 HERMANN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6004169 | 2108774 | 37.7705273263251 | -122.428935147688 | (37.7705273263251, -122.428935147688) | 7 | 9 | 11 | 29492 | 10 | |||
| 91924 | 21638 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1637 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004769.4625949 | 2114679.8692957 | 37.7867773603046 | -122.427278902509 | (37.7867773603046, -122.427278902509) | 13 | 9 | 11 | 28858 | 13 | |||
| 92133 | 62276 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 124 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/1985 12:00:00 AM | 13 | 21x6 | Permit Number 22414 | 6003841.87853288 | 2108837.79837285 | 37.7706839798213 | -122.430071215032 | (37.7706839798213, -122.430071215032) | 7 | 9 | 11 | 29492 | 10 | |
| 93569 | 7144 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 685X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003730.75372 | 2110025.58578 | 37.7739390589029 | -122.430540363958 | (37.7739390589029, -122.430540363958) | 7 | 9 | 11 | 29492 | 10 | |||
| 93831 | 7281 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1820X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6003034.84406 | 2114579.8244 | 37.7864044107242 | -122.433273117504 | (37.7864044107242, -122.433273117504) | 13 | 9 | 11 | 29490 | 27 | |||
| 95502 | 16899 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 406 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005035.08833 | 2110252.02045 | 37.7746345969303 | -122.426044572686 | (37.7746345969303, -122.426044572686) | 7 | 9 | 11 | 28852 | 10 | |||
| 96607 | 21642 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1649 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004713.5335639 | 2114672.0939043 | 37.7867528478772 | -122.427471849732 | (37.7867528478772, -122.427471849732) | 13 | 9 | 11 | 28858 | 13 | |||
| 98717 | 33718 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 25 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1996 12:00:00 AM | 13 | Permit Number 37786 | 6004139.32588988 | 2108866.31797637 | 37.7707791293659 | -122.429044373837 | (37.7707791293659, -122.429044373837) | 7 | 9 | 11 | 29492 | 10 | |
| 99582 | 99612 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
| 100106 | 7244 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1700 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 4x4 | 6003093.09301 | 2114182.05294 | 37.785315535228 | -122.433043161197 | (37.785315535228, -122.433043161197) | 13 | 9 | 11 | 29490 | 13 | |||
| 100259 | 7260 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1727 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6003024.60166 | 2114236.6744 | 37.7854616266825 | -122.433284024643 | (37.7854616266825, -122.433284024643) | 13 | 9 | 11 | 29490 | 13 | |||
| 101481 | 7279 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1803 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6x6 | 6002990.14459 | 2114551.19489 | 37.7863232654697 | -122.43342571959 | (37.7863232654697, -122.43342571959) | 13 | 9 | 11 | 29490 | 27 | |||
| 102040 | 7235 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1055 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003361.88401 | 2111924.41801 | 37.7791318785406 | -122.431951960454 | (37.7791318785406, -122.431951960454) | 15 | 9 | 11 | 29490 | 41 | |||
| 103903 | 7712 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 47 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006492.59831 | 2110356.24747 | 37.7750030463236 | -122.421010148365 | (37.7750030463236, -122.421010148365) | 7 | 9 | 11 | 28852 | 10 | |||
| 104538 | 21643 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1653 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004694.8905536 | 2114669.5021072 | 37.786744676998 | -122.427536165445 | (37.786744676998, -122.427536165445) | 13 | 9 | 11 | 28858 | 13 | |||
| 104550 | 21748 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1840X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002560.9316389 | 2114541.9034523 | 37.786273393243 | -122.434910019678 | (37.786273393243, -122.434910019678) | 13 | 9 | 11 | 29490 | 27 | |||
| 105287 | 18158 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1380X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005557.7830834 | 2114491.983444 | 37.7863060232386 | -122.424538126694 | (37.7863060232386, -122.424538126694) | 13 | 9 | 1 | 28858 | 41 | |||
| 109776 | 23705 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004026.4448 | 2110044.61455 | 37.7740080535371 | -122.429518876644 | (37.7740080535371, -122.429518876644) | 7 | 9 | 11 | 29492 | 10 | |||
| 110637 | 7234 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1035 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003369.22487 | 2111874.56942 | 37.7789954228838 | -122.431923005031 | (37.7789954228838, -122.431923005031) | 15 | 9 | 11 | 29490 | 41 | |||
| 112012 | 2718 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2185X Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003092.7695 | 2114646.14799 | 37.786589804405 | -122.433077450713 | (37.786589804405, -122.433077450713) | 13 | 9 | 11 | 29490 | 27 | |||
| 113219 | 16946 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 609 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004030.19479 | 2110006.18975 | 37.7739027607756 | -122.429503163951 | (37.7739027607756, -122.429503163951) | 7 | 9 | 11 | 29492 | 10 | |||
| 115162 | 7181 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 847 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003442.40326 | 2111287.35095 | 37.7773872150711 | -122.431627916454 | (37.7773872150711, -122.431627916454) | 15 | 9 | 11 | 29492 | 10 | |||
| 115288 | 107652 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 600 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2014 12:00:00 AM | 3 | Permit Number 772916 | 6005452.33302 | 2111401.13742 | 37.7778133653937 | -122.424683001313 | (37.7778133653937, -122.424683001313) | 7 | 9 | 11 | 28852 | 10 | ||
| 115478 | 13204 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2150 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6001979.60867 | 2119494.8171 | 37.7998397874351 | -122.437276016047 | (37.7998397874351, -122.437276016047) | 13 | 9 | 1 | 57 | 17 | |||
| 118707 | 94293 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 1 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 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) );