trees
221 rows where Police Districts = 1 and qSpecies_id = 53 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3804 | 117402 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
9205 | 96542 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767720 | 6013094 | 2116579 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | 4 | 1 | 10 | 28860 | 6 | ||||
11284 | 117186 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x GREENWICH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011833 | 2120374 | 37.8028090150843 | -122.40324129087 | (37.8028090150843, -122.40324129087) | 3 | 1 | 10 | 308 | 23 | ||||
11874 | 110985 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
12765 | 117400 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
18979 | 110983 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
20131 | 113298 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700X DAVIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013208 | 2119104 | 37.7993985951424 | -122.398393892143 | (37.7993985951424, -122.398393892143) | 3 | 1 | 10 | 28860 | 6 | ||||
25834 | 93215 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 499 Jackson St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53209 | 6011715 | 2118034 | 37.7963773511427 | -122.403484907832 | (37.7963773511427, -122.403484907832) | 3 | 1 | 10 | 28860 | 4 | |||
25882 | 40606 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 744 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48110 | 6011762.49765618 | 2117875.03517526 | 37.7959435248288 | -122.403309366526 | (37.7959435248288, -122.403309366526) | 3 | 1 | 10 | 28860 | 4 | |||
28305 | 121625 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 101x Trenton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010049 | 2117862 | 37.7958118850813 | -122.409237502382 | (37.7958118850813, -122.409237502382) | 3 | 1 | 10 | 308 | 4 | ||||
28662 | 99265 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | |||||
29680 | 65045 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1066 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2004 12:00:00 AM | Permit Number 45972 | 6007827.74406772 | 2119607.84984942 | 37.8004808586212 | -122.417047244449 | (37.8004808586212, -122.417047244449) | 5 | 1 | 1 | 308 | 32 | |||
31247 | 106090 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 615 Front St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012797.6 | 2118350.4 | 37.7973065196251 | -122.399761086072 | (37.7973065196251, -122.399761086072) | 3 | 1 | 10 | 28860 | 6 | |||||
35016 | 120999 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 390 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010815 | 2115725 | 37.7899870820688 | -122.406436332672 | (37.7899870820688, -122.406436332672) | 5 | 1 | 10 | 28857 | 6 | ||||
35445 | 253642 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010361.39347 | 2118971.94152 | 37.7988770104459 | -122.408234880635 | (37.7988770104459, -122.408234880635) | 3 | 1 | 10 | 308 | 4 | ||||
35514 | 110994 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
41004 | 99266 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | ||||
41372 | 95268 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2245 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | ||||
43430 | 112751 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
44244 | 110995 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
46917 | 122714 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 855x Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011188 | 2117923 | 37.7960431220576 | -122.40530062832 | (37.7960431220576, -122.40530062832) | 3 | 1 | 10 | 28857 | 4 | ||||
47816 | 107839 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1000x LEAVENWORTH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008256 | 2115925 | 37.790392745036 | -122.415304443955 | (37.790392745036, -122.415304443955) | 5 | 1 | 10 | 28858 | 21 | ||||
48222 | 100107 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 461 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
52074 | 117185 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011833 | 2120374 | 37.8028090150843 | -122.40324129087 | (37.8028090150843, -122.40324129087) | 3 | 1 | 10 | 308 | 23 | ||||
53203 | 110987 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
55775 | 44125 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 431 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43629 | 6012046.82946857 | 2118068.4414971 | 37.796490448112 | -122.402339123693 | (37.796490448112, -122.402339123693) | 3 | 1 | 10 | 28860 | 4 | ||||
56447 | 117399 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
57914 | 106105 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 744x MONTGOMERY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011751.6 | 2117873.5 | 37.7959387009634 | -122.403346966666 | (37.7959387009634, -122.403346966666) | 3 | 1 | 10 | 28860 | 4 | |||||
59611 | 106127 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1609 POWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6009609.6 | 2119208.8 | 37.7994852403002 | -122.410853080764 | (37.7994852403002, -122.410853080764) | 3 | 1 | 10 | 308 | 4 | ||||
65259 | 105658 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
67256 | 110998 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
68154 | 113299 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700X DAVIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013208 | 2119104 | 37.7993985951424 | -122.398393892143 | (37.7993985951424, -122.398393892143) | 3 | 1 | 10 | 28860 | 6 | ||||
73243 | 110988 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
73387 | 113573 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 901 LOMBARD ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007813 | 2120272 | 37.8023036186348 | -122.417145352251 | (37.8023036186348, -122.417145352251) | 5 | 1 | 10 | 308 | 32 | |||
74708 | 52076 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2005 12:00:00 AM | Permit Number 48272 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||
77923 | 256355 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
80346 | 122712 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 855x Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011188 | 2117923 | 37.7960431220576 | -122.40530062832 | (37.7960431220576, -122.40530062832) | 3 | 1 | 10 | 28857 | 4 | ||||
82064 | 117188 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200x GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x6 | 6011596 | 2120619 | 37.8034684863456 | -122.404078688914 | (37.8034684863456, -122.404078688914) | 3 | 1 | 10 | 28860 | 6 | ||||
82985 | 51836 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
83480 | 120997 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 360 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010836 | 2115566 | 37.7895516808253 | -122.406352466288 | (37.7895516808253, -122.406352466288) | 5 | 1 | 10 | 28857 | 6 | ||||
84456 | 254739 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 501 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009970 | 2119286 | 37.7997174141149 | -122.409611414659 | (37.7997174141149, -122.409611414659) | 3 | 1 | 10 | 308 | 4 | ||||
84659 | 117187 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200x GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x6 | 6011596 | 2120619 | 37.8034684863456 | -122.404078688914 | (37.8034684863456, -122.404078688914) | 3 | 1 | 10 | 28860 | 6 | ||||
88657 | 110984 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
99464 | 112750 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
99484 | 116156 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 755 SANSOME ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012110 | 2118369 | 37.7973192357085 | -122.402141679915 | (37.7973192357085, -122.402141679915) | 3 | 1 | 10 | 308 | 4 | ||||
101743 | 98254 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 571 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010764.4 | 2118536 | 37.797702579203 | -122.406809598565 | (37.797702579203, -122.406809598565) | 3 | 1 | 10 | 308 | 4 | ||||
102458 | 99269 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1327 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008010 | 2116967 | 37.7932399920042 | -122.416229420814 | (37.7932399920042, -122.416229420814) | 5 | 1 | 10 | 28858 | 32 | ||||
105476 | 120996 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 352 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x5 | 6010871.2 | 2115571.1 | 37.789567653219 | -122.406231036885 | (37.789567653219, -122.406231036885) | 5 | 1 | 10 | 28857 | 6 | ||||
107778 | 51837 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
108315 | 251688 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 925 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008132 | 2115128 | 37.788197407905 | -122.415677021756 | (37.788197407905, -122.415677021756) | 13 | 1 | 10 | 28858 | 21 | ||||
110473 | 49870 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 607@ JACKSON Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2003 12:00:00 AM | Permit Number 46636 | 6012838.36008757 | 2118235.08187981 | 37.7969921557212 | -122.399611944085 | (37.7969921557212, -122.399611944085) | 3 | 1 | 10 | 28860 | 6 | |||
114077 | 100108 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 461 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
117475 | 97938 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2133 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009831.3 | 2121360.2 | 37.8054048804892 | -122.410237896013 | (37.8054048804892, -122.410237896013) | 3 | 1 | 10 | 308 | 23 | ||||
118656 | 96541 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 100 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 767720 | 6013094 | 2116579 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | 4 | 1 | 10 | 28860 | 6 | ||||
120103 | 40159 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1999 12:00:00 AM | Permit Number 41353 | 6009783.18603588 | 2121626.8328918 | 37.8061342908169 | -122.410423240295 | (37.8061342908169, -122.410423240295) | 3 | 1 | 10 | 308 | 23 | |||
122731 | 100106 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 461 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
126032 | 110991 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
131150 | 51835 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
131827 | 99267 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1340 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008042 | 2117018 | 37.7933818247157 | -122.416122311937 | (37.7933818247157, -122.416122311937) | 5 | 1 | 10 | 28858 | 21 | ||||
136446 | 110992 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
138984 | 110996 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
150414 | 117403 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
151939 | 257912 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
152048 | 92896 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 226 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | 6009506.8 | 2122067 | 37.8073273816355 | -122.411410840149 | (37.8073273816355, -122.411410840149) | 3 | 1 | 10 | 308 | 23 | |||
154699 | 121624 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 101x Trenton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010049 | 2117862 | 37.7958118850813 | -122.409237502382 | (37.7958118850813, -122.409237502382) | 3 | 1 | 10 | 308 | 4 | ||||
157239 | 44224 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 150 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43669 | 6012974 | 2118691 | 37.7982515579635 | -122.399174613744 | (37.7982515579635, -122.399174613744) | 3 | 1 | 10 | 28860 | 6 | ||||
158673 | 117398 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
159895 | 113553 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 700 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3x3 | 6009263 | 2115423 | 37.7890709188275 | -122.411784791395 | (37.7890709188275, -122.411784791395) | 5 | 1 | 10 | 28857 | 21 | |||
159917 | 122820 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 776 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009771.51732552 | 2115777.23613944 | 37.7900720800575 | -122.410050397484 | (37.7900720800575, -122.410050397484) | 5 | 1 | 10 | 28857 | 21 | ||||
168362 | 95269 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2245 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6x6 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |||
171851 | 110997 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
177916 | 113574 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 901 LOMBARD ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6007968 | 2120121 | 37.8018977290678 | -122.416598272247 | (37.8018977290678, -122.416598272247) | 5 | 1 | 10 | 308 | 32 | |||
178040 | 120998 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 370 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010792 | 2115565 | 37.789546473623 | -122.406504631878 | (37.789546473623, -122.406504631878) | 5 | 1 | 10 | 28857 | 6 | ||||
179087 | 105657 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
182487 | 256357 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
182516 | 44225 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43670 | 6013393.18767606 | 2119056.04835121 | 37.799277245684 | -122.397749707821 | (37.799277245684, -122.397749707821) | 3 | 1 | 10 | 28860 | 6 | ||||
182781 | 117184 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 201x GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011833 | 2120374 | 37.8028090150843 | -122.40324129087 | (37.8028090150843, -122.40324129087) | 3 | 1 | 10 | 308 | 23 | ||||
183563 | 110986 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||||
185775 | 117401 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 75x BEACH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009846 | 2122112 | 37.8074699595292 | -122.410240137563 | (37.8074699595292, -122.410240137563) | 3 | 1 | 10 | 308 | 23 | ||||
186331 | 122713 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 855x Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011188 | 2117923 | 37.7960431220576 | -122.40530062832 | (37.7960431220576, -122.40530062832) | 3 | 1 | 10 | 28857 | 4 | ||||
188867 | 121000 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 390 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010815 | 2115725 | 37.7899870820688 | -122.406436332672 | (37.7899870820688, -122.406436332672) | 5 | 1 | 10 | 28857 | 6 | ||||
191099 | 100527 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1728 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4.5x6 | 6008341 | 2118363 | 37.7970916696404 | -122.415182998934 | (37.7970916696404, -122.415182998934) | 5 | 1 | 10 | 308 | 21 | ||||
191709 | 52838 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 795on Trenton Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48857 | 6010309.20673902 | 2118158.51574656 | 37.7966406195852 | -122.408358059553 | (37.7966406195852, -122.408358059553) | 3 | 1 | 10 | 308 | 4 | ||||
192030 | 256356 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
193319 | 257913 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
74524 | 95408 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1257 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | No record of tree being permitted for planting. | 6006989.2 | 2119073.6 | 37.7989667366731 | -122.419911018667 | (37.7989667366731, -122.419911018667) | 5 | 1 | 10 | 28858 | 32 | ||
96003 | 4693 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 781 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009263.30605 | 2120079.28345 | 37.801855948749 | -122.412112938993 | (37.801855948749, -122.412112938993) | 3 | 1 | 10 | 308 | 23 | |||
145725 | 112106 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
34305 | 102625 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1865X Grant Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 17346 | 6010349.4 | 2120908.5 | 37.804193651889 | -122.408413053021 | (37.804193651889, -122.408413053021) | 3 | 1 | 10 | 308 | 23 | ||
38641 | 102621 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 190X Pfeiffer St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | 3 | 1 | 10 | 308 | 23 | ||
54854 | 18511 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 626 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6010143.9604039 | 2115933.8512359 | 37.7905229751065 | -122.408772822924 | (37.7905229751065, -122.408772822924) | 5 | 1 | 10 | 28857 | 21 | |||
63395 | 21810 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2627 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6008310.29957 | 2121825.65474 | 37.806597526846 | -122.415534509856 | (37.806597526846, -122.415534509856) | 5 | 1 | 10 | 308 | 23 | |||
64595 | 20258 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 495X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 8x8 | 6009991.46116 | 2120547.45752 | 37.8031822677113 | -122.409626234652 | (37.8031822677113, -122.409626234652) | 3 | 1 | 10 | 308 | 23 | |||
79373 | 29910 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 791x Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6008575.10006 | 2120353.42874 | 37.8025700449008 | -122.414513871045 | (37.8025700449008, -122.414513871045) | 3 | 1 | 10 | 308 | 32 | ||||
83502 | 112109 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
85015 | 21812 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2631 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6008221.30715 | 2121822.90168 | 37.806584965078 | -122.415842290697 | (37.806584965078, -122.415842290697) | 5 | 1 | 10 | 308 | 23 | |||
103458 | 59152 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 190X Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1980 12:00:00 AM | 12 | 3x3 | Permit Number 18461 | 6009909.46799044 | 2121095.5996991 | 37.8046827351828 | -122.409948693589 | (37.8046827351828, -122.409948693589) | 3 | 1 | 10 | 308 | 23 | |
118093 | 102618 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 190X Pfeiffer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | 3 | 1 | 10 | 308 | 23 | ||
126231 | 112107 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
134743 | 107366 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 851 POST ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008079.7 | 2114773.8 | 37.7872219209064 | -122.415832880524 | (37.7872219209064, -122.415832880524) | 13 | 1 | 9 | 28858 | 36 |
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) );