trees
1,626 rows where qSpecies_id = 53 sorted by qAddress descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40345 | 17320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
64749 | 17324 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
72154 | 17321 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
155474 | 17322 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
173835 | 17323 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
79513 | 47917 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 999 Revised) Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2002 12:00:00 AM | Permit Number 45655 | 6006486.39229912 | 2113910.68802822 | 37.7847623267063 | -122.421284078173 | (37.7847623267063, -122.421284078173) | 13 | 9 | 11 | 28858 | 41 | |||
106301 | 98984 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 993 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 19087 | 6002920 | 2111648 | 37.7783478430736 | -122.433460857601 | (37.7783478430736, -122.433460857601) | 15 | 9 | 11 | 29492 | 41 | ||
178705 | 59665 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 993 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 12 | 2x2 | Permit Number 19087 | 6002914.43276984 | 2111641.44659541 | 37.7783295332017 | -122.433479648258 | (37.7783295332017, -122.433479648258) | 15 | 9 | 11 | 29492 | 41 | |
112940 | 106936 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 98X EUREKA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x5 | 6001388 | 2105433 | 37.7611959604452 | -122.438315238354 | (37.7611959604452, -122.438315238354) | 15 | 4 | 5 | 28862 | 3 | |||
183075 | 17003 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 985 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x9 | 6002297.8184 | 2109825.1269 | 37.7733073694664 | -122.435482776108 | (37.7733073694664, -122.435482776108) | 15 | 5 | 11 | 29492 | 9 | |||
54052 | 4709 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 968 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/2016 07:32:00 AM | 3 | 5x5 | 6008598.66291 | 2120633.4675 | 37.8033402849031 | -122.414452158528 | (37.8033402849031, -122.414452158528) | 3 | 1 | 10 | 308 | 23 | ||
261 | 119280 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995293 | 2090512 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | 9 | 8 | 6 | 28861 | 24 | ||||
146767 | 119279 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 95 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995293 | 2090512 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | 9 | 8 | 6 | 28861 | 24 | ||||
33092 | 92818 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 95 Burlwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2009 12:00:00 AM | 3x3 | Permit Number 53027 | 5996883 | 2096019 | 37.7350901820695 | -122.453216393363 | (37.7350901820695, -122.453216393363) | 9 | 7 | 4 | 59 | 40 | ||
53228 | 7198 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003395.68163 | 2111577.87165 | 37.7781822644093 | -122.431810290332 | (37.7781822644093, -122.431810290332) | 15 | 9 | 11 | 29492 | 41 | |||
175601 | 7197 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003395.68163 | 2111577.87165 | 37.7781822644093 | -122.431810290332 | (37.7781822644093, -122.431810290332) | 15 | 9 | 11 | 29492 | 41 | |||
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 | |||
66963 | 45334 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 946 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44166 | 6002468.75387281 | 2109900.46778234 | 37.7735239435411 | -122.434896876631 | (37.7735239435411, -122.434896876631) | 15 | 5 | 11 | 29492 | 10 | ||||
20552 | 15171 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 941 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010472.08374 | 2112774.72891 | 37.7818671496492 | -122.407414720255 | (37.7818671496492, -122.407414720255) | 14 | 2 | 9 | 28853 | 34 | |||
97139 | 15172 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 941 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010497.86985 | 2112769.44604 | 37.7818540873698 | -122.40732513932 | (37.7818540873698, -122.40732513932) | 14 | 2 | 9 | 28853 | 34 | |||
162339 | 10147 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 940 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2x3 | 6005660.7422371 | 2103489.3240903 | 37.7561011788947 | -122.423399446987 | (37.7561011788947, -122.423399446987) | 2 | 4 | 5 | 28859 | 19 | |||
128036 | 4704 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 940 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6008705.2823 | 2120549.3769 | 37.8031153821632 | -122.414077244448 | (37.8031153821632, -122.414077244448) | 3 | 1 | 10 | 308 | 23 | |||
81588 | 113833 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 932 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6007966 | 2102301 | 37.7529681504442 | -122.415342945464 | (37.7529681504442, -122.415342945464) | 2 | 4 | 7 | 28859 | 19 | ||||
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 | |||
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 | ||||
39074 | 20124 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 924X Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
80201 | 20122 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 924X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
147048 | 47565 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 920 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45425 | 6011901.71412119 | 2111593.71793264 | 37.7787042813354 | -122.402385767126 | (37.7787042813354, -122.402385767126) | 14 | 2 | 9 | 28856 | 34 | |||
168743 | 7855 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 915 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006074.49976 | 2113274.48833 | 37.7829922485484 | -122.422663866925 | (37.7829922485484, -122.422663866925) | 7 | 9 | 11 | 28858 | 41 | |||
172277 | 10647 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 913 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6003471.55966 | 2110689.4075 | 37.775747062973 | -122.431484357932 | (37.775747062973, -122.431484357932) | 15 | 9 | 11 | 29492 | 10 | ||
32968 | 16997 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 903 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6002604.56537 | 2109869.28932 | 37.7734460452794 | -122.43442485558 | (37.7734460452794, -122.43442485558) | 15 | 5 | 11 | 29492 | 9 | |||
134874 | 16999 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 903 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6002647.07822 | 2109875.66562 | 37.7734659661022 | -122.434278253633 | (37.7734659661022, -122.434278253633) | 15 | 5 | 11 | 29492 | 9 | |||
193656 | 16998 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 903 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002629.22495 | 2109872.04506 | 37.7734550115897 | -122.434339751705 | (37.7734550115897, -122.434339751705) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
155915 | 6134 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 900X Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6006541.37151 | 2113590.32225 | 37.7838857802496 | -122.421071112727 | (37.7838857802496, -122.421071112727) | 7 | 9 | 11 | 28858 | 41 | |||
94050 | 6131 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 900X ELLIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6006542 | 2113585 | 37.7838712020833 | -122.421068560353 | (37.7838712020833, -122.421068560353) | 7 | 9 | 11 | 28858 | 41 | |||
156320 | 6133 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 900X ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6006542 | 2113585 | 37.7838712020833 | -122.421068560353 | (37.7838712020833, -122.421068560353) | 7 | 9 | 11 | 28858 | 41 | |||
18243 | 96948 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007359.7 | 2102053.2 | 37.7522536530624 | -122.417422091759 | (37.7522536530624, -122.417422091759) | 2 | 4 | 7 | 28859 | 19 | |||
41221 | 96947 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007389 | 2101516 | 37.750780272338 | -122.417282702809 | (37.750780272338, -122.417282702809) | 2 | 4 | 7 | 28859 | 19 | |||
28626 | 100399 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 4x4 | 6011664 | 2118384 | 37.7973355180624 | -122.403686018548 | (37.7973355180624, -122.403686018548) | 3 | 1 | 10 | 308 | 23 | ||
176337 | 104331 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 9 Beaver St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002844 | 2106791 | 37.7650074058753 | -122.433376604069 | (37.7650074058753, -122.433376604069) | 15 | 5 | 5 | 28862 | 3 | ||||
69091 | 7190 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5X5 | 6003496.10413 | 2111301.12929 | 37.7774280906657 | -122.431443131507 | (37.7774280906657, -122.431443131507) | 7 | 9 | 11 | 29492 | 10 | |||
83917 | 7189 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5X5 | 6003518.08132 | 2111313.80886 | 37.7774641511736 | -122.43136801056 | (37.7774641511736, -122.43136801056) | 7 | 9 | 11 | 29492 | 10 | |||
115819 | 7191 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5X5 | 6003494.59692 | 2111314.73243 | 37.7774653560924 | -122.431449316775 | (37.7774653560924, -122.431449316775) | 7 | 9 | 11 | 29492 | 10 | |||
20310 | 112288 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 895x PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002361 | 2109458 | 37.7723029182135 | -122.435237957834 | (37.7723029182135, -122.435237957834) | 15 | 5 | 11 | 29492 | 9 | ||||
8874 | 15149 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
19070 | 15154 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
27832 | 15155 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
31550 | 15160 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 14 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
34792 | 15148 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
39622 | 15164 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 18 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
45235 | 15147 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
58538 | 15152 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
67792 | 15158 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 12 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
68900 | 15165 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 19 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
92451 | 15169 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 23 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
103078 | 15168 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 22 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
110518 | 15161 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 15 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
112808 | 15167 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 21 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
115831 | 15162 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 16 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
121554 | 15163 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 17 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
143433 | 15157 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 11 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
143636 | 15150 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 18 | 3x3 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
185169 | 15159 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 13 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | Private | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | ||
51694 | 173776 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 89 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001439 | 2105287 | 37.7607979807122 | -122.438128392537 | (37.7607979807122, -122.438128392537) | 15 | 4 | 5 | 28862 | 3 | ||||
140006 | 173777 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 89 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001439 | 2105287 | 37.7607979807122 | -122.438128392537 | (37.7607979807122, -122.438128392537) | 15 | 4 | 5 | 28862 | 3 | ||||
97770 | 18392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
186502 | 18393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
32399 | 102602 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
84141 | 102599 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
98499 | 102601 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
100078 | 102598 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
150564 | 102603 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
155305 | 102600 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014255.3 | 2116583.4 | 37.7925359054466 | -122.394593235194 | (37.7925359054466, -122.394593235194) | 12 | 2 | 9 | 28855 | 6 | |||
46738 | 113373 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 88 HOWARD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2015 12:00:00 AM | 3x3 | 6014757 | 2116474 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | 12 | 2 | 9 | 28855 | 6 | |||
182974 | 16988 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 879 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002804.94816 | 2109899.79468 | 37.773541177823 | -122.433733884114 | (37.773541177823, -122.433733884114) | 15 | 5 | 11 | 29492 | 9 | |||
122006 | 4883 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 87 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 2X2 | 6000657.5251593 | 2098217.505729 | 37.7413423773337 | -122.440324154875 | (37.7413423773337, -122.440324154875) | 2 | 7 | 5 | 63 | 7 | |||
158510 | 18390 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 866 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010418.2672605 | 2104189.3928818 | 37.7582907781506 | -122.406995587546 | (37.7582907781506, -122.406995587546) | 10 | 4 | 7 | 28859 | 19 | |||
50755 | 7185 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 865 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003457.39592 | 2111275.80383 | 37.7773563593355 | -122.431575227386 | (37.7773563593355, -122.431575227386) | 15 | 9 | 11 | 29492 | 10 | |||
97854 | 117647 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 86 ROSSI AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 5996396 | 2111643 | 37.7779618147655 | -122.456029304513 | (37.7779618147655, -122.456029304513) | 11 | 6 | 2 | 54 | 16 | |||
127826 | 117648 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 86 ROSSI AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 5996396 | 2111643 | 37.7779618147655 | -122.456029304513 | (37.7779618147655, -122.456029304513) | 11 | 6 | 2 | 54 | 16 | |||
109824 | 17315 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
157267 | 17313 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
175687 | 17314 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
190383 | 17316 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
347 | 108327 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
77006 | 108328 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
93090 | 108326 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
138240 | 108324 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
162113 | 108325 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 86 11TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | ||||
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 | |||
50875 | 7183 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 857 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003432.47617 | 2111314.05853 | 37.7774599847744 | -122.43166416476 | (37.7774599847744, -122.43166416476) | 15 | 9 | 11 | 29492 | 10 | |||
132184 | 7184 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 857 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003432.47617 | 2111314.05853 | 37.7774599847744 | -122.43166416476 | (37.7774599847744, -122.43166416476) | 15 | 9 | 11 | 29492 | 10 | |||
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 | ||||
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 | ||||
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 | ||||
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 |
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) );