11,761 rows where qSpecies_id = 17 sorted by qCaretaker_id

View and edit SQL

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)
129 107934 DPW Maintained 1 Tree(s) :: 17 3098X Market St 3 Median : Yard Tree DPW 1           5999920 2105144 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916) 2 4 5 28862 3
139 106382 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 9 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
271 107116 DPW Maintained 1 Tree(s) :: 17 300X LIBERTY ST 18 Median : Cutout Tree DPW 1     12     6004270.1 2103982.4 37.7573764628527 -122.428243896062 (37.7573764628527, -122.428243896062) 2 4 5 28862 3
383 94356 DPW Maintained 1 Tree(s) :: 17 455 Delano Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   5999581.42646 2091332.3229 37.7223759483442 -122.443550437353 (37.7223759483442, -122.443550437353) 9 7 6 28861 25
387 106394 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 21 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
477 113497 DPW Maintained 1 Tree(s) :: 17 200x MANSELL ST 3 Median : Cutout Tree DPW 1       3x3   6011136 2090597 37.7210091086741 -122.403557031831 (37.7210091086741, -122.403557031831) 10 3 7 309 28
833 106379 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 6 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
1249 107933 DPW Maintained 1 Tree(s) :: 17 3098X Market St 1 Median : Yard Tree DPW 1           5999920 2105144 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916) 2 4 5 28862 3
1752 865 DPW Maintained 1 Tree(s) :: 17 600X Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 1X1   6006086.2852895 2094767.6237118 37.7321773712618 -122.421308445577 (37.7321773712618, -122.421308445577) 2 7 7 28861 2
1970 260506 DPW Maintained 1 Tree(s) :: 17 289 08th St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6009625.74334 2110365.68554 37.7752050776892 -122.41017254363 (37.7752050776892, -122.41017254363) 8 2 9 28853 34
2010 260603 DPW Maintained 1 Tree(s) :: 17 1162 Ingerson Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6013406.09782 2090446.93369 37.7207235989971 -122.395699409803 (37.7207235989971, -122.395699409803) 10 3 8 58 1
2090 260628 DPW Maintained 1 Tree(s) :: 17 1251 Revere Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6016934.60308 2092996.85523 37.7279208386687 -122.383679778477 (37.7279208386687, -122.383679778477) 10 3 8 58 1
2201 107549 Significant Tree 6 Tree(s) :: 17 198X Jennings St 2 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
2764 262058 DPW Maintained 1 Tree(s) :: 17 851X Alemany Blvd 9 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
4399 260599 DPW Maintained 1 Tree(s) :: 17 1114 Hollister Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6014272.04969 2090150.96276 37.7199590543715 -122.392685364492 (37.7199590543715, -122.392685364492) 10 3 8 58 1
5607 260608 DPW Maintained 1 Tree(s) :: 17 1010 Ingerson Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6014125.00477 2089910.99969 37.7192919954616 -122.393176869863 (37.7192919954616, -122.393176869863) 10 3 8 58 1
5837 87442 DPW Maintained 1 Tree(s) :: 17 2801X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/22/2008 12:00:00 AM   3x3   5997499.095645 2087961.159651 37.7130005371424 -122.450505622879 (37.7130005371424, -122.450505622879) 9 7 6 28861 25
6001 262052 DPW Maintained 1 Tree(s) :: 17 851X Alemany Blvd 3 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
7347 262056 DPW Maintained 1 Tree(s) :: 17 851X Alemany Blvd 7 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
7837 96135 DPW Maintained 1 Tree(s) :: 17 1444X Innes Ave 1 Median : Yard Tree DPW 1     12     6016335.2 2096661 37.7379486980737 -122.386007263552 (37.7379486980737, -122.386007263552) 10 3 8 58 1
8002 212121 DPW Maintained 1 Tree(s) :: 17 2101x Monterey Blvd 3 Median : Yard Tree DPW 1   11/27/2019 12:00:00 AM 3 Width 10ft Permit Number 784468 5991651 2095488 37.7333309287491 -122.471266448142 (37.7333309287491, -122.471266448142) 9 8 4 59 40
8161 262050 DPW Maintained 1 Tree(s) :: 17 851X Alemany Blvd 1 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
8600 260856 DPW Maintained 1 Tree(s) :: 17 626 33rd Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF         5985689.47211 2111611.95975 37.7772562449138 -122.493064158363 (37.7772562449138, -122.493064158363) 11 6 2 55 26
8860 260613 DPW Maintained 1 Tree(s) :: 17 1271 Revere Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6016832.40592 2093073.03805 37.7281243722496 -122.384038382899 (37.7281243722496, -122.384038382899) 10 3 8 58 1
9426 107555 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
10202 261492 DPW Maintained 1 Tree(s) :: 17 1100X Portola Dr 8 Sidewalk: Property side : Yard Tree DPW 1       10x10   5995262 2098056 37.7405902419398 -122.458968175006 (37.7405902419398, -122.458968175006) 1 7 4 59 40
10614 260597 DPW Maintained 1 Tree(s) :: 17 1289 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6013389.69367 2090749.59472 37.7215537330103 -122.395777310596 (37.7215537330103, -122.395777310596) 10 3 8 58 1
10729 262053 DPW Maintained 1 Tree(s) :: 17 851X Alemany Blvd 4 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
11038 262060 DPW Maintained 1 Tree(s) :: 17 851X Alemany Blvd 11 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
11689 260606 DPW Maintained 1 Tree(s) :: 17 1038 Ingerson Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6013981.83254 2090017.73229 37.7195771072229 -122.393679232644 (37.7195771072229, -122.393679232644) 10 3 8 58 1
11972 99201 DPW Maintained 1 Tree(s) :: 17 4016 26th St   Sidewalk: Curb side : Cutout Landscaping DPW 1 FUF 04/12/2012 12:00:00 AM   6x10.5 Permit Number 768835 6003752.7 2100736.7 37.7484352450997 -122.429801769855 (37.7484352450997, -122.429801769855) 2 4 5 28862 22
12037 260602 DPW Maintained 1 Tree(s) :: 17 1152 Ingerson Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6013444.93607 2090417.98033 37.7206462592683 -122.395563129546 (37.7206462592683, -122.395563129546) 10 3 8 58 1
12610 262055 DPW Maintained 1 Tree(s) :: 17 851X Alemany Blvd 6 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
13334 106393 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 20 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
13376 29902 DPW Maintained 1 Tree(s) :: 17 1716 Divisadero St   Sidewalk: Curb side : Cutout Tree DPW 1           6001149.68281092 2114264.52722613 37.7854315611698 -122.439772670022 (37.7854315611698, -122.439772670022) 15 6 1 29490 27
13877 262059 DPW Maintained 1 Tree(s) :: 17 851X Alemany Blvd 10 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
14319 107554 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
14442 260627 DPW Maintained 1 Tree(s) :: 17 1557 Hudson Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6015914.7542 2097249.1447 37.7395403460526 -122.387501983912 (37.7395403460526, -122.387501983912) 10 3 8 58 1
14665 256768 DPW Maintained 1 Tree(s) :: 17 900 Brotherhood Way 7 Front Yard : Yard Tree DPW 1   09/25/2019 12:00:00 AM 3 Width 0ft Permit Number 782397 5987917.15522 2088760.91322 37.7146433748779 -122.483682180705 (37.7146433748779, -122.483682180705) 1 8 4 64 14
15172 260605 DPW Maintained 1 Tree(s) :: 17 1042 Ingerson Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6013961.37936 2090032.97981 37.719617837314 -122.393750999085 (37.719617837314, -122.393750999085) 10 3 8 58 1
15426 262040 DPW Maintained 1 Tree(s) :: 17 740 Jamestown Ave   Back Yard : Yard Tree DPW 1 Private         6015231.58289 2088478.1596 37.7154191081975 -122.38925181324 (37.7154191081975, -122.38925181324) 10 3 8 58 1
16125 260551 DPW Maintained 1 Tree(s) :: 17 937 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011850 2111438 37.7782738288903 -122.402553714468 (37.7782738288903, -122.402553714468) 14 2 9 28856 34
16232 262057 DPW Maintained 1 Tree(s) :: 17 851X Alemany Blvd 8 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
16275 260607 DPW Maintained 1 Tree(s) :: 17 1026 Ingerson Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6014043.19207 2089971.98975 37.71945491674 -122.393463933828 (37.71945491674, -122.393463933828) 10 3 8 58 1
16678 261979 DPW Maintained 1 Tree(s) :: 17 3471 21st St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005237 2103664 37.7565568729323 -122.424877318266 (37.7565568729323, -122.424877318266) 2 4 5 28859 19
17248 260604 DPW Maintained 1 Tree(s) :: 17 1058 Ingerson Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6013879.56666 2090093.96987 37.7197807571849 -122.394038065566 (37.7197807571849, -122.394038065566) 10 3 8 58 1
17296 262054 DPW Maintained 1 Tree(s) :: 17 851X Alemany Blvd 5 Side Yard : Yard Tree DPW 1       3x3   6004188 2094500 37.7313353304363 -122.42785218062 (37.7313353304363, -122.42785218062) 9 7 6 28861 5
17341 260857 DPW Maintained 1 Tree(s) :: 17 726 33rd Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/18/2019 12:00:00 AM 3     5985712.15541 2110932.69313 37.7753924991275 -122.492935643751 (37.7753924991275, -122.492935643751) 11 6 2 55 26
18448 260600 DPW Maintained 1 Tree(s) :: 17 1122 Hollister Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6014231.13861 2090181.46138 37.7200405252834 -122.392828913667 (37.7200405252834, -122.392828913667) 10 3 8 58 1
18757 261980 DPW Maintained 1 Tree(s) :: 17 718 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6004261 2104680 37.7592913923108 -122.428325085778 (37.7592913923108, -122.428325085778) 2 4 5 28862 3
19014 260601 DPW Maintained 1 Tree(s) :: 17 1142 Hollister Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3     6014128.86091 2090257.70792 37.7202442017659 -122.393187787982 (37.7202442017659, -122.393187787982) 10 3 8 58 1
19310 261482 DPW Maintained 1 Tree(s) :: 17 1000 Portola Dr 11 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
20195 90386 DPW Maintained 1 Tree(s) :: 17 20 12th St 6 Sidewalk: Curb side : Cutout Tree DPW 1   08/12/2013 03:31:00 PM 3 3x3   6006777.292282 2110019.638696 37.7740948433326 -122.420001435971 (37.7740948433326, -122.420001435971) 8 2 9 28853 19
22639 54521 DPW Maintained 1 Tree(s) :: 17 3500 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/31/1972 12:00:00 AM     Permit Number 10315 6006490.84096056 2100597.22904115 37.7482069647181 -122.420323418546 (37.7482069647181, -122.420323418546) 2 4 5 28859 19
23096 27581 DPW Maintained 1 Tree(s) :: 17 1299X Illinois St 32 Sidewalk: Curb side : Cutout Tree DPW 1   01/05/2001 12:00:00 AM 3 3X3   6016181.7533979 2103053.0321119 37.7554914042844 -122.38698349009 (37.7554914042844, -122.38698349009) 10 3 8 28856 29
24076 91328 DPW Maintained 1 Tree(s) :: 17 5089 Mission St   Sidewalk: Curb side : Cutout Tree DPW 1   06/05/2007 12:00:00 AM   3x3   6000514.1536 2089460.50315 37.7172895061936 -122.440192061387 (37.7172895061936, -122.440192061387) 9 7 6 28861 5
24117 27426 DPW Maintained 1 Tree(s) :: 17 98X Duboce Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/14/2012 12:00:00 AM 1 3x3   6006094.6477071 2108521.7458746 37.7699435048383 -122.422256382252 (37.7699435048383, -122.422256382252) 8 4 7 28853 19
25172 27441 DPW Maintained 1 Tree(s) :: 17 1690X Indiana St 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105) 10 3 8 58 1
26631 864 DPW Maintained 1 Tree(s) :: 17 600X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 1X1   6006086.2852895 2094767.6237118 37.7321773712618 -122.421308445577 (37.7321773712618, -122.421308445577) 2 7 7 28861 2
28338 97125 DPW Maintained 1 Tree(s) :: 17 1200x Harrison St 4 Sidewalk: Curb side : Cutout Tree DPW 1   07/23/2014 12:00:00 AM 3 3x3 Permit Number 772214 6009763.1 2109812.6 37.7736941320217 -122.409658347393 (37.7736941320217, -122.409658347393) 8 2 9 28853 34
31901 26849 DPW Maintained 1 Tree(s) :: 17 130 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2016 12:00:00 AM 3 4x14 Permit Number 774227 6006960.268726 2111024.2991523 37.7768637073231 -122.4194397761 (37.7768637073231, -122.4194397761) 7 9 9 28852 36
32524 107556 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
33388 96137 DPW Maintained 1 Tree(s) :: 17 1454X Innes Ave 2 Median : Yard Tree DPW 1     12     6016287.8 2096690.3 37.7380265265677 -122.386173192236 (37.7380265265677, -122.386173192236) 10 3 8 58 1
34310 109295 DPW Maintained 1 Tree(s) :: 17 1062 Carolina St 3 Median : Cutout Tree DPW 1           6012455.3 2103027.1 37.7552131559276 -122.39986897476 (37.7552131559276, -122.39986897476) 10 3 8 28856 29
35245 26847 DPW Maintained 1 Tree(s) :: 17 130 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2016 12:00:00 AM 3 4x14 Permit Number 774227 6006976.7555 2111107.62587 37.7770934310359 -122.419388656004 (37.7770934310359, -122.419388656004) 7 9 9 28852 36
36574 107552 Significant Tree 6 Tree(s) :: 17 1 Newhall St 2 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
37129 253672 DPW Maintained 1 Tree(s) :: 17 390 06th St 4 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
38316 107558 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
38783 104786 DPW Maintained 1 Tree(s) :: 17 750 Holly Park Cir 2 Median : Cutout Tree DPW 1       2x2   6006276.67386 2096799.83163 37.7377680961975 -122.420794450652 (37.7377680961975, -122.420794450652) 2 7 7 28859 2
39056 27438 DPW Maintained 1 Tree(s) :: 17 1690X Indiana St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105) 10 3 8 58 1
40220 107562 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 2 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
41288 107545 DPW Maintained 1 Tree(s) :: 17 198X Jennings St 6 Sidewalk: Curb side : Cutout Tree DPW 1       3x3 Permit Number 774049 6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
42715 881 DPW Maintained 1 Tree(s) :: 17 600X Alemany Blvd 19 Sidewalk: Curb side : Cutout Tree DPW 1     6 1X1   6006086.2852895 2094767.6237118 37.7321773712618 -122.421308445577 (37.7321773712618, -122.421308445577) 2 7 7 28861 2
44315 1036 DPW Maintained 1 Tree(s) :: 17 1992 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/23/2005 12:00:00 AM 3 3X3   6000710.3605652 2090584.316502 37.720386412787 -122.439594386876 (37.720386412787, -122.439594386876) 9 7 6 28861 25
45014 22801 DPW Maintained 1 Tree(s) :: 17 1 Turquoise Way 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/12/1997 12:00:00 AM 3 2x2   5998832.3639753 2099992.0164602 37.7461106679667 -122.446762549602 (37.7461106679667, -122.446762549602) 2 7 5 63 22
45360 107935 DPW Maintained 1 Tree(s) :: 17 1099X Market St 3 Median : Yard Tree DPW 1           6009025.86197 2112294.38137 37.7804671773494 -122.412384031944 (37.7804671773494, -122.412384031944) 14 2 9 28853 34
45926 96136 DPW Maintained 1 Tree(s) :: 17 1454X Innes Ave 1 Median : Yard Tree DPW 1     12     6016287.8 2096690.3 37.7380265265677 -122.386173192236 (37.7380265265677, -122.386173192236) 10 3 8 58 1
46419 106399 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 26 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
46702 107564 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 8 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
47250 106395 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 22 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
47889 138282 DPW Maintained 1 Tree(s) :: 17 1202 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     4 Width 0ft   6003789.8642 2112168.8213 37.7798272025121 -122.430488845982 (37.7798272025121, -122.430488845982) 15 9 11 29490 41
48370 106386 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 13 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
50319 26848 DPW Maintained 1 Tree(s) :: 17 130 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/04/2016 12:00:00 AM 3 4x14 Permit Number 774227 6006976.7555 2111107.62587 37.7770934310359 -122.419388656004 (37.7770934310359, -122.419388656004) 7 9 9 28852 36
50899 96141 DPW Maintained 1 Tree(s) :: 17 1468X Innes Ave 1 Median : Yard Tree DPW 1     12     6016228.8 2096740.9 37.738162198215 -122.386380713289 (37.738162198215, -122.386380713289) 10 3 8 58 1
51530 25577 DPW Maintained 1 Tree(s) :: 17 250 Industrial St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM   3X3   6010651.890723 2096938.1663788 37.7383935669237 -122.405676875145 (37.7383935669237, -122.405676875145) 10 3 8 58 1
52212 21648 DPW Maintained 1 Tree(s) :: 17 1660 Sutter St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X2   6004632.9541 2114713.0403 37.7868607185832 -122.427753554263 (37.7868607185832, -122.427753554263) 13 9 11 28858 27
52713 106374 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 1 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
53398 106380 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 7 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
55008 25575 DPW Maintained 1 Tree(s) :: 17 250 Industrial St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/05/1997 12:00:00 AM   3X3   6010651.890723 2096938.1663788 37.7383935669237 -122.405676875145 (37.7383935669237, -122.405676875145) 10 3 8 58 1
55037 876 DPW Maintained 1 Tree(s) :: 17 600X Alemany Blvd 14 Sidewalk: Curb side : Cutout Tree DPW 1     6 1X1   6006086.2852895 2094767.6237118 37.7321773712618 -122.421308445577 (37.7321773712618, -122.421308445577) 2 7 7 28861 2
56372 107551 Significant Tree 6 Tree(s) :: 17 1 Newhall St 1 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
59601 107546 DPW Maintained 1 Tree(s) :: 17 198X Jennings St 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3 Permit Number 774049 6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
60676 107559 DPW Maintained 1 Tree(s) :: 17 1 Newhall St 10 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
63586 186954 DPW Maintained 1 Tree(s) :: 17 2800 Sunset Blvd 28 Median : Yard Tree DPW 1     2 Width 0ft   5985211.8854 2096092.27 37.7346155220289 -122.493572437422 (37.7346155220289, -122.493572437422) 1 8 3 29491 35
66313 984 DPW Maintained 1 Tree(s) :: 17 1617 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/09/1997 12:00:00 AM 3 2X2   6001782.7037977 2092720.8776329 37.7263139026263 -122.436040457682 (37.7263139026263, -122.436040457682) 9 7 6 28861 25
68985 27385 DPW Maintained 1 Tree(s) :: 17 2200 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/07/2016 12:00:00 AM 3 3X3 Permit Number 779236 6007159.91681 2119895.63544 37.8012334551161 -122.419378628241 (37.8012334551161, -122.419378628241) 5 1 1 28858 32
69016 1317 DPW Maintained 1 Tree(s) :: 17 4050X Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1   06/11/1992 12:00:00 AM 3 TR   5991740.4279021 2087082.0100679 37.7102553211792 -122.470345319704 (37.7102553211792, -122.470345319704) 9 8 4 64 24
71130 27443 DPW Maintained 1 Tree(s) :: 17 1690X Indiana St 8 Sidewalk: Curb side : Cutout Tree DPW 1   05/13/2000 12:00:00 AM 3 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105) 10 3 8 58 1
73271 69781 DPW Maintained 1 Tree(s) :: 17 1136X ALEMANY BLVD 1 Sidewalk: Curb side : Cutout Tree DPW 1           6003354 2094330 37.7308213333418 -122.430723344194 (37.7308213333418, -122.430723344194) 9 7 5 28861 25
74792 106376 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 3 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);