trees
408 rows where Police Districts = 9 and qSpecies_id = 53 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 349 | 253694 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 536 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005450 | 2111168 | 37.7771730951376 | -122.424674483112 | (37.7771730951376, -122.424674483112) | 7 | 9 | 11 | 28852 | 10 | ||||
| 1142 | 260393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 2723 | 140583 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 FILLMORE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6003424.6737 | 2111485.9504 | 37.7779315149131 | -122.431703431668 | (37.7779315149131, -122.431703431668) | 15 | 9 | 11 | 29492 | 41 | |||
| 2956 | 139431 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005398.6042 | 2111220.8061 | 37.7773151849796 | -122.424856035409 | (37.7773151849796, -122.424856035409) | 7 | 9 | 11 | 28852 | 10 | |||
| 5715 | 140049 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 651 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005353.1353 | 2111583.6293 | 37.778308840554 | -122.42503914867 | (37.778308840554, -122.42503914867) | 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 | |||
| 6921 | 95036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 7 | 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 | ||||
| 7085 | 260395 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 7742 | 21626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004833.69671 | 2114745.44523 | 37.7869610478907 | -122.427061339905 | (37.7869610478907, -122.427061339905) | 13 | 9 | 11 | 28858 | 27 | |||
| 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 | ||||
| 10459 | 16731 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 19X Hollis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6003892.01293 | 2113485.99196 | 37.7834496108007 | -122.4302294651 | (37.7834496108007, -122.4302294651) | 7 | 9 | 11 | 29490 | 41 | |||
| 10644 | 260392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 2 | 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 | |
| 11809 | 7237 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1065 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003359.4574 | 2111944.18191 | 37.7791860077197 | -122.431961766737 | (37.7791860077197, -122.431961766737) | 15 | 9 | 11 | 29490 | 41 | |||
| 11986 | 95043 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 9 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |
| 12493 | 140066 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 614 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005423.0428 | 2111393.287 | 37.7777901557735 | -122.424783767818 | (37.7777901557735, -122.424783767818) | 7 | 9 | 11 | 28852 | 10 | |||
| 13855 | 260394 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 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 | |||
| 14920 | 255508 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | 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 | ||
| 15896 | 140067 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 616 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005420.4192 | 2111411.6517 | 37.7778404325738 | -122.424794150591 | (37.7778404325738, -122.424794150591) | 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 | |
| 18271 | 139433 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005406.0306 | 2111183.3028 | 37.7772126295238 | -122.424827676313 | (37.7772126295238, -122.424827676313) | 7 | 9 | 11 | 28852 | 10 | |||
| 18607 | 139432 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 539 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005403.0601 | 2111196.299 | 37.77724814614 | -122.424838877048 | (37.77724814614, -122.424838877048) | 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 | |||
| 22613 | 7891 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1187 Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005998.65959 | 2113925.10155 | 37.7847743933389 | -122.422972499839 | (37.7847743933389, -122.422972499839) | 13 | 9 | 11 | 28858 | 41 | |||
| 24360 | 26948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002746.89171 | 2114446.33864 | 37.7860215531341 | -122.434259812125 | (37.7860215531341, -122.434259812125) | 13 | 9 | 11 | 29490 | 27 | |||
| 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 | |||
| 26003 | 20242 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
| 26376 | 107654 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 600 Octavia St | 3 | 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 | ||
| 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 | |||
| 28409 | 23540 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005743.06666 | 2119831.60651 | 37.8009777467475 | -122.424276999326 | (37.8009777467475, -122.424276999326) | 13 | 9 | 1 | 28858 | 32 | |||
| 28468 | 23821 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Webster St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6003795.89428 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | 7 | 9 | 11 | 29490 | 41 | |||
| 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 | |||
| 30119 | 23811 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6003795.89428 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | 7 | 9 | 11 | 29490 | 41 | |||
| 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 | ||
| 32254 | 26946 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002793.58315 | 2114456.84816 | 37.7860530596313 | -122.434099024105 | (37.7860530596313, -122.434099024105) | 13 | 9 | 11 | 29490 | 27 | |||
| 33408 | 6246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1280 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004721.4422 | 2113335.3655 | 37.7830829720913 | -122.427349228935 | (37.7830829720913, -122.427349228935) | 7 | 9 | 11 | 28858 | 41 | |||
| 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 | ||||
| 35663 | 26954 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002832.1331203 | 2114461.0177044 | 37.7860666959211 | -122.433965949874 | (37.7860666959211, -122.433965949874) | 13 | 9 | 11 | 29490 | 27 | |||
| 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 | |||
| 37162 | 18698 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 251X Richardson Ave | 5 | Median : Cutout | Tree | DPW 1 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.447389461083 | (37.8006252370733, -122.447389461083) | 13 | 9 | 1 | 57 | 17 | |||
| 37545 | 21656 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1700 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004322.06269 | 2114670.60111 | 37.7867265999511 | -122.428826139996 | (37.7867265999511, -122.428826139996) | 13 | 9 | 11 | 29490 | 27 | |||
| 38327 | 17368 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2308X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005067.32521 | 2117488.78546 | 37.794506778582 | -122.426448444628 | (37.794506778582, -122.426448444628) | 13 | 9 | 1 | 28858 | 27 | |||
| 39319 | 23703 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2119X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005103.6033 | 2116867.23334 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | 13 | 9 | 1 | 28858 | 27 | |||
| 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 | |||
| 40439 | 2452 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1805X Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6003959.520066 | 2114567.2690482 | 37.7864223498862 | -122.430073076908 | (37.7864223498862, -122.430073076908) | 13 | 9 | 11 | 29490 | 13 | |||
| 40655 | 16939 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
| 43323 | 23820 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Webster St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6003795.89428 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | 7 | 9 | 11 | 29490 | 41 | |||
| 43653 | 95034 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 3 | 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 | ||||
| 43740 | 9577 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x5 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | 15 | 9 | 11 | 29490 | 41 | |||
| 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 | |||
| 45474 | 26944 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6002826.48876 | 2114460.91922 | 37.7860661051899 | -122.433985470782 | (37.7860661051899, -122.433985470782) | 13 | 9 | 11 | 29490 | 27 | |||
| 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 | |||
| 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 | |||
| 48251 | 23814 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6003795.89428 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | 7 | 9 | 11 | 29490 | 41 | |||
| 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 | ||
| 48975 | 21630 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1615 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1990 12:00:00 AM | 6 | 4X4 | 6004701.1521 | 2114671.0024 | 37.786749150585 | -122.427514608894 | (37.786749150585, -122.427514608894) | 13 | 9 | 11 | 28858 | 13 | ||
| 49601 | 16393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 250X Myrtle St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006231.99165 | 2114068.14091 | 37.7851803077551 | -122.422175412097 | (37.7851803077551, -122.422175412097) | 13 | 9 | 11 | 28858 | 41 | |||
| 50280 | 7218 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Fillmore St | 4 | 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 | |||
| 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 | ||||
| 50984 | 95035 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 5 | 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 | ||||
| 51362 | 2729 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2250 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002744.1445 | 2114802.6476 | 37.7869997310528 | -122.434294799469 | (37.7869997310528, -122.434294799469) | 13 | 9 | 11 | 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 | |||
| 51714 | 7156 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 712 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003631.55189 | 2110917.37527 | 37.7763820727629 | -122.430947178384 | (37.7763820727629, -122.430947178384) | 7 | 9 | 11 | 29492 | 10 | |||
| 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 | |||
| 53228 | 7198 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003395.68163 | 2111577.87165 | 37.7781822644093 | -122.431810290332 | (37.7781822644093, -122.431810290332) | 15 | 9 | 11 | 29492 | 41 | |||
| 54208 | 9683 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 298 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/1982 12:00:00 AM | 20 | 3X3 | 6006045.73768 | 2110624.99987 | 37.7757157759068 | -122.422575039685 | (37.7757157759068, -122.422575039685) | 7 | 9 | 11 | 28852 | 10 | ||
| 55002 | 13200 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
| 55528 | 23492 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005839.2618 | 2119053.89467 | 37.7988477792821 | -122.423888789861 | (37.7988477792821, -122.423888789861) | 13 | 9 | 1 | 28858 | 32 | |||
| 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 | |||
| 57812 | 13193 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2095 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002451.4681 | 2119463.3271 | 37.7997801365268 | -122.435640954547 | (37.7997801365268, -122.435640954547) | 13 | 9 | 1 | 57 | 17 | |||
| 59694 | 127215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 4 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999937.99418 | 2117121.61309 | 37.7932073277938 | -122.44417011406 | (37.7932073277938, -122.44417011406) | 13 | 9 | 1 | 57 | 27 | ||
| 60447 | 20241 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
| 60815 | 14812 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1190X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003455.90906 | 2111772.60341 | 37.7787203633271 | -122.431615848033 | (37.7787203633271, -122.431615848033) | 15 | 9 | 11 | 29490 | 41 | |||
| 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 | |||
| 61909 | 7229 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1040 Fillmore St | 2 | 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 | |||
| 62202 | 23539 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6005738.98285 | 2119846.6704 | 37.8010188777475 | -122.424292203059 | (37.8010188777475, -122.424292203059) | 13 | 9 | 1 | 28858 | 32 | |||
| 62418 | 2714 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2185X Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003185.15216 | 2114858.41892 | 37.7871778864418 | -122.432772999031 | (37.7871778864418, -122.432772999031) | 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 | |||
| 64713 | 7152 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 2 | 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 | |||
| 65216 | 23529 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005762.85494 | 2119704.71005 | 37.8006304387912 | -122.42419949344 | (37.8006304387912, -122.42419949344) | 13 | 9 | 1 | 28858 | 32 | |||
| 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 | |||
| 66280 | 94296 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 2 | 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 | ||||
| 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 | |||
| 67556 | 9975 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 812X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003525.87553 | 2111110.58272 | 37.7769065842705 | -122.431326537326 | (37.7769065842705, -122.431326537326) | 7 | 9 | 11 | 29492 | 10 | |||
| 67743 | 26950 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3X3 | 6002695.46817 | 2114444.00008 | 37.7860122131882 | -122.434437556188 | (37.7860122131882, -122.434437556188) | 13 | 9 | 11 | 29490 | 27 | |||
| 67817 | 16940 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
| 68956 | 16394 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 250X Myrtle St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006231.99165 | 2114068.14091 | 37.7851803077551 | -122.422175412097 | (37.7851803077551, -122.422175412097) | 13 | 9 | 11 | 28858 | 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 | |||
| 70974 | 23955 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1985X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6002890.93346 | 2119517.51166 | 37.7999538645084 | -122.434124118866 | (37.7999538645084, -122.434124118866) | 13 | 9 | 1 | 57 | 17 | |||
| 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 |
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) );