trees
11,761 rows where qSpecies_id = 17 sorted by qCaretaker_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );