trees
408 rows where Police Districts = 9 and qSpecies_id = 53
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117 | 108152 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
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 | ||||
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 | ||||
2653 | 100053 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | ||||
11093 | 95037 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 8 | Sidewalk: Property side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
11207 | 108105 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
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 | |||
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 | |||
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 | ||||
15062 | 102786 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3345 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4.5x6 | Permit Number 772480 | 6003174.4 | 2119873.2 | 37.8009465759098 | -122.433168646536 | (37.8009465759098, -122.433168646536) | 13 | 9 | 1 | 57 | 17 | ||
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 | |||
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 | ||
21029 | 102504 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 290X Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | 7 | 9 | 11 | 29492 | 10 | ||||
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 | |||
22585 | 23704 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2119X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6005103.6033 | 2116867.23334 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |||
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 | |||
29416 | 7261 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1727 Fillmore St | 2 | 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 | |||
29776 | 44063 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.438319307967 | (37.7948463022786, -122.438319307967) | 13 | 9 | 1 | 57 | 27 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
36681 | 22720 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
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 | |||
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 | |||
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 | |||
38667 | 21584 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1499 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005574.52113 | 2114792.70084 | 37.787132663766 | -122.424501615425 | (37.787132663766, -122.424501615425) | 13 | 9 | 1 | 28858 | 41 | |||
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 | |||
39370 | 107630 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2164 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6001495 | 2119755 | 37.8005266206576 | -122.438971595662 | (37.8005266206576, -122.438971595662) | 13 | 9 | 1 | 57 | 17 | |||
39669 | 95554 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1333@ Larkin Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007121 | 2115358 | 37.7887720478953 | -122.419191239667 | (37.7887720478953, -122.419191239667) | 13 | 9 | 10 | 28858 | 21 | |||||
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 | |||
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 | |||
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 | |||
44254 | 20167 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1175 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 4X4 | 6002828.6579039 | 2112263.6806979 | 37.7800331654734 | -122.433820860908 | (37.7800331654734, -122.433820860908) | 15 | 9 | 11 | 29490 | 41 | |||
44436 | 22716 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 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 | |||
45498 | 22719 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 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 | |||
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 | ||||
48110 | 108103 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
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 |
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) );