trees

8,758 rows where qSpecies_id = 16 sorted by qAddress

✎ View and edit SQL

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)
89874 124198 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Rossi Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5996310.06451 2111872.62247 37.7785873647191 -122.456343191663 (37.7785873647191, -122.456343191663) 11 6 2 54 16
106187 124195 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Rossi Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5996301.89172 2111985.69463 37.7788973618681 -122.456379642576 (37.7788973618681, -122.456379642576) 11 6 2 54 16
107762 124200 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Rossi Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5996321.21235 2111801.03897 37.7783914552509 -122.456299449973 (37.7783914552509, -122.456299449973) 11 6 2 54 16
114132 124197 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Rossi Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   5996306.67631 2111912.14603 37.778695691486 -122.456357771299 (37.778695691486, -122.456357771299) 11 6 2 54 16
127003 124193 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Rossi Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5996287.60217 2112048.11001 37.7790679176894 -122.456433590029 (37.7790679176894, -122.456433590029) 11 6 2 54 16
168568 124194 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Rossi Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5996292.62306 2112026.18035 37.7790079928752 -122.456414634674 (37.7790079928752, -122.456414634674) 11 6 2 54 16
171983 124196 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Rossi Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   5996306.60538 2111949.08179 37.7787971032678 -122.456360688135 (37.7787971032678, -122.456360688135) 11 6 2 54 16
187212 124201 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Rossi Ave 12 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5996330.2443 2111769.37189 37.778305024271 -122.456265914994 (37.778305024271, -122.456265914994) 11 6 2 54 16
162642 177768 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Stoneybrook Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6005940.49308 2094411.38696 37.7311910030448 -122.421787188054 (37.7311910030448, -122.421787188054) 9 7 6 28861 5
182153 140830 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 WOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5998403.2567 2113719.651 37.7837787640446 -122.449235173997 (37.7837787640446, -122.449235173997) 15 6 1 54 31
31816 232802 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Beaver St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002745.52279 2106821.60259 37.7650858457666 -122.433719399242 (37.7650858457666, -122.433719399242) 15 5 5 28862 3
82480 64177 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Cerritos Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1987 12:00:00 AM     Permit Number 24960 5992869.30578156 2093188.45106841 37.7270873338596 -122.466887350359 (37.7270873338596, -122.466887350359) 9 8 4 59 40
53243 231259 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Cumberland St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 6ft   6005519.56128 2104619.55288 37.7591965535096 -122.423968067388 (37.7591965535096, -122.423968067388) 2 4 5 28859 19
38064 250040 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Daniel Burnham Ct 2 : Tree Private 2     9 Width 3ft   6006198.948 2114743.14871 37.7870318487916 -122.422337709814 (37.7870318487916, -122.422337709814) 13 9 1 28858 41
143410 250039 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Daniel Burnham Ct 1 : Tree Private 2     10 Width 3ft   6006219.93247 2114745.11482 37.7870384309268 -122.42226524787 (37.7870384309268, -122.42226524787) 13 9 1 28858 41
8173 193892 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 De Boom St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6014902.21965 2113000.89074 37.7827351011774 -122.392104203263 (37.7827351011774, -122.392104203263) 6 2 9 28856 6
22482 193893 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 De Boom St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6014872.0348 2112972.27336 37.7826548483902 -122.392206628835 (37.7826548483902, -122.392206628835) 6 2 9 28856 6
169651 193895 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 De Boom St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6014849.59091 2112947.8199 37.7825864585261 -122.392282564904 (37.7825864585261, -122.392282564904) 6 2 9 28856 6
180700 193894 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 De Boom St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6014858.98059 2112957.79621 37.7826143725838 -122.392250778347 (37.7826143725838, -122.392250778347) 6 2 9 28856 6
161120 66560 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Lupine Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/10/1991 12:00:00 AM     Permit Number 29748 5998362.4893973 2113830.03162696 37.7840795084333 -122.449384168554 (37.7840795084333, -122.449384168554) 15 6 1 54 31
1340 87020 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Osceola Dr 2 Sidewalk: Property side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49949                    
188540 232693 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Rousseau St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003472.08991 2095328.98345 37.7335710057983 -122.430386337287 (37.7335710057983, -122.430386337287) 2 7 5 28861 25
173906 111924 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 SEACLIFF AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     24     5988171 2115833 37.788990841692 -122.484789589413 (37.788990841692, -122.484789589413) 11 6 1 55 33
156419 250399 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Seacliff Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 4ft   5988151.26478 2115836.13663 37.7889983045622 -122.484858100014 (37.7889983045622, -122.484858100014) 11 6 1 55 33
26010 117999 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Shore View Ave 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5984594.8721 2112880.0619 37.7806740097418 -122.496944292743 (37.7806740097418, -122.496944292743) 11 6 2 55 26
125653 117998 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Shore View Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5984603.65921 2112880.89318 37.7806768070955 -122.496913955742 (37.7806768070955, -122.496913955742) 11 6 2 55 26
147548 117997 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Shore View Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5984612.88755 2112881.86038 37.7806800034926 -122.496882102371 (37.7806800034926, -122.496882102371) 11 6 2 55 26
33933 231203 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 27th St 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6005825.85771 2100250.83508 37.747218351845 -122.422598301884 (37.747218351845, -122.422598301884) 2 7 5 28859 22
114272 231204 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 27th St 3 Sidewalk: Curb side : Yard Tree Private 2     11 Width 6ft   6005794.5833 2100249.17319 37.7472120242265 -122.422706328451 (37.7472120242265, -122.422706328451) 2 7 5 28859 22
114364 231205 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 27th St 4 Sidewalk: Curb side : Yard Tree Private 2     16 Width 6ft   6005776.4324 2100248.01004 37.7472078063944 -122.422769010297 (37.7472078063944, -122.422769010297) 2 7 5 28859 22
116021 30795 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Acadia St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/1995 12:00:00 AM     Permit Number 34663 6001438.86054667 2094658.17341001 37.7316137334439 -122.437367766054 (37.7316137334439, -122.437367766054) 9 7 4 63 40
22541 231262 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Alemany Blvd 11 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009538.46924 2096046.19853 37.7358820898763 -122.409463626948 (37.7358820898763, -122.409463626948) 10 7 7 28859 2
82263 231266 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Alemany Blvd 23 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009395.45855 2095915.19224 37.735514360685 -122.409948828285 (37.735514360685, -122.409948828285) 10 7 7 28859 2
98790 231263 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Alemany Blvd 13 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009515.94764 2096021.31203 37.7358124949589 -122.40953973747 (37.7358124949589, -122.40953973747) 10 7 7 28859 2
112401 231265 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Alemany Blvd 19 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009433.4381 2095939.07862 37.7355820760601 -122.40981920362 (37.7355820760601, -122.40981920362) 10 7 7 28859 2
124570 231264 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Alemany Blvd 16 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009459.25817 2095957.04748 37.7356328616542 -122.40973120134 (37.7356328616542, -122.40973120134) 10 7 7 28859 2
172830 47596 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/2002 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555) 10 7 7 28859 2
193457 47591 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/2003 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555) 10 7 7 28859 2
70845 232158 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001447.24844 2107600.26624 37.7671501109056 -122.438265589986 (37.7671501109056, -122.438265589986) 15 5 5 29492 3
167289 231339 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Carmel St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5998244.46792 2105386.51474 37.7608890254153 -122.449183977457 (37.7608890254153, -122.449183977457) 15 5 11 29492 12
174992 64205 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Cerritos Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1987 12:00:00 AM     Permit Number 24992 5992182.20582417 2092942.84430152 37.7263732776196 -122.469244755687 (37.7263732776196, -122.469244755687) 9 8 4 59 40
55701 131489 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6009025.0433 2112895.25798 37.7821169953408 -122.412429349139 (37.7821169953408, -122.412429349139) 7 10 9 28852 36
96013 131492 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Golden Gate Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008958.59126 2112886.74672 37.7820898960759 -122.412658642087 (37.7820898960759, -122.412658642087) 7 10 9 28852 36
102353 131491 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008978.48 2112890.04129 37.7821000584078 -122.412590068788 (37.7821000584078, -122.412590068788) 7 10 9 28852 36
131700 131493 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Golden Gate Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6008941.7983 2112883.38921 37.7820797346415 -122.412716500885 (37.7820797346415, -122.412716500885) 7 10 9 28852 36
156236 131490 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6009003.82793 2112887.67265 37.7820949772497 -122.412502208635 (37.7820949772497, -122.412502208635) 7 10 9 28852 36
171376 131494 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Golden Gate Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008915.6547 2112877.13849 37.7820611042773 -122.412806504136 (37.7820611042773, -122.412806504136) 7 10 9 28852 36
136286 209902 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Lomita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5991457.92061 2104558.57905 37.7582252290246 -122.472595060638 (37.7582252290246, -122.472595060638) 1 8 4 56 12
146201 209901 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Lomita Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5991456.90305 2104561.84637 37.7582341413231 -122.472598817982 (37.7582341413231, -122.472598817982) 1 8 4 56 12
193526 177659 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 Mansell St 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   6011473.42215 2090717.42054 37.7213586009108 -122.402399119539 (37.7213586009108, -122.402399119539) 10 3 7 309 28
153335 140833 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 PARKER AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5996877.2282 2113752.0549 37.7837803328504 -122.454516972191 (37.7837803328504, -122.454516972191) 11 6 1 54 31
190490 140834 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 PARKER AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5996876.2129 2113774.3907 37.7838416028044 -122.454522098809 (37.7838416028044, -122.454522098809) 11 6 1 54 31
49045 108996 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 PORTOLA DR 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999749.8 2101261 37.74964735702 -122.443681331522 (37.74964735702, -122.443681331522) 2 5 5 28862 38
72852 108997 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 PORTOLA DR 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999749.8 2101261 37.74964735702 -122.443681331522 (37.74964735702, -122.443681331522) 2 5 5 28862 38
112186 108998 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 PORTOLA DR 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999749.8 2101261 37.74964735702 -122.443681331522 (37.74964735702, -122.443681331522) 2 5 5 28862 38
8283 19872 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY33 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
3339 19580 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY4 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 8                      
5218 19581 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY4 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 8                      
19559 19579 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY4 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3                      
17847 20000 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100 STAIRWAY46 20 Sidewalk: Curb side : Cutout Tree DPW 1     6 2                      
6635 8146 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1000 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2     90 4X4   6002926.0085 2111351.5233 37.7775341328911 -122.433418880148 (37.7775341328911, -122.433418880148) 15 5 11 29492 41
92306 8150 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1000 Fulton St 6 Sidewalk: Curb side : Cutout Tree Private 2     90 4X4   6002846.3106 2111341.485 37.7775020483312 -122.433693863913 (37.7775020483312, -122.433693863913) 15 5 11 29492 41
170325 245203 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1000 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6001301.7625 2109049.6418 37.7711214604056 -122.438872679375 (37.7711214604056, -122.438872679375) 15 5 11 29492 9
7741 261484 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1000 Portola Dr 12 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
11803 261486 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1000 Portola Dr 13 Median : Yard Tree DPW 1       10x10   5995664 2098286 37.741244865522 -122.457594860017 (37.741244865522, -122.457594860017) 1 8 4 59 40
144030 23044 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1000 Valencia St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/01/1995 12:00:00 AM 18 3x3   6006283.82185 2103690.30475 37.7566881721963 -122.421258895722 (37.7566881721963, -122.421258895722) 2 4 5 28859 19
127941 13381 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1000X Mansell St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 3X3   6008956.7805816 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527) 9 7 7 309 18
132349 13376 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1000X Mansell St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     6 3X3   6008956.7805816 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527) 9 7 7 309 18
147650 13383 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1000X Mansell St 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 3X3   6008956.7805816 2089957.5006014 37.7191312087569 -122.411044830527 (37.7191312087569, -122.411044830527) 9 7 7 309 18
32257 7870 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1001 Franklin St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006017.92474 2113680.12204 37.7841028269903 -122.422888431641 (37.7841028269903, -122.422888431641) 7 9 11 28858 41
78505 249572 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1001 Franklin St 1 : Tree Private 2     11 Width 3ft   6006034.21434 2113636.62941 37.7839843260522 -122.42282898339 (37.7839843260522, -122.42282898339) 7 9 11 28858 41
97462 200208 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1001 Gilman Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6015421.2375 2089569.1115 37.7184251625474 -122.388672388055 (37.7184251625474, -122.388672388055) 10 3 8 58 1
99850 200209 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1001 Gilman Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6015453.5183 2089543.5304 37.7183567108308 -122.388559021136 (37.7183567108308, -122.388559021136) 10 3 8 58 1
142757 200206 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1001 Gilman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6015344.4942 2089624.5372 37.7185730971727 -122.38894152753 (37.7185730971727, -122.38894152753) 10 3 8 58 1
178123 200207 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1001 Gilman Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6015388.3475 2089594.6926 37.7184935803893 -122.388787860953 (37.7184935803893, -122.388787860953) 10 3 8 58 1
185433 200210 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1001 Gilman Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6015479.7085 2089523.431 37.718302973173 -122.38846708965 (37.718302973173, -122.38846708965) 10 3 8 58 1
29017 52022 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1001 Pine St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/14/2005 12:00:00 AM 11   Permit Number 48237 6009069.84074 2115972.98171 37.790570197216 -122.412491992318 (37.790570197216, -122.412491992318) 5 1 10 28858 21
88589 232538 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1007 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 4ft   6001959.83428 2101114.52046 37.7493709610162 -122.436028485037 (37.7493709610162, -122.436028485037) 2 4 5 28862 22
193939 57597 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 1007 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/08/1976 12:00:00 AM     Permit Number 16465 6001956.93021678 2101160.46885236 37.7494969594121 -122.436041814854 (37.7494969594121, -122.436041814854) 2 4 5 28862 22
63338 7007 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1009 Fell St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6002534.6697 2110202.3984 37.7743567123717 -122.434690458817 (37.7743567123717, -122.434690458817) 15 5 11 29492 10
6016 96544 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100@ Front St Pine St 1 Sidewalk: Curb side : Pot Tree Private 2   08/29/2019 12:00:00 AM 3   Permit Number 784583 6013029.74558 2116576.80835 37.7924495959214 -122.398833259061 (37.7924495959214, -122.398833259061) 4 1 10 28860 6
147468 96545 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100@ Front St Pine St 2 Sidewalk: Curb side : Pot Tree Private 2   05/27/2011 12:00:00 AM 2   Permit Number 767720 6012972.08955 2116568.16592 37.7924226531442 -122.399032145021 (37.7924226531442, -122.399032145021) 4 1 10 28860 6
22788 96245 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X 27th St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005866.5 2100251.5 37.7472224703829 -122.422457811013 (37.7472224703829, -122.422457811013) 2 7 5 28859 22
123550 96244 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X 27th St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005866.5 2100251.5 37.7472224703829 -122.422457811013 (37.7472224703829, -122.422457811013) 2 7 5 28859 22
173039 96242 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005866.5 2100251.5 37.7472224703829 -122.422457811013 (37.7472224703829, -122.422457811013) 2 7 5 28859 22
9540 83049 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 5 Sidewalk: Curb side : Cutout Tree Port 6     11     6018864.16071 2097578.25634 37.7406069390666 -122.377326932804 (37.7406069390666, -122.377326932804) 10 3 8 58 1
17391 3602 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 38 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6018187.24152 2098084.44706 37.7419595239099 -122.379702643058 (37.7419595239099, -122.379702643058) 10 3 8 58 1
33186 3613 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 49 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6018003.94992 2098219.94993 37.7423214758653 -122.380345828295 (37.7423214758653, -122.380345828295) 10 3 8 58 1
33883 3629 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 65 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6017712.66324 2098437.04484 37.7429014981049 -122.381368111942 (37.7429014981049, -122.381368111942) 10 3 8 58 1
55609 3587 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 23 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018440.39842 2097892.70026 37.7414469858874 -122.378813986102 (37.7414469858874, -122.378813986102) 10 3 8 58 1
107143 3615 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 51 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6017970.88261 2098244.46459 37.7423869635862 -122.380461869644 (37.7423869635862, -122.380461869644) 10 3 8 58 1
109278 3570 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 5 Sidewalk: Curb side : Cutout Tree Port 6     12 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
140989 3623 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 59 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6017813.51979 2098359.75553 37.7426948446985 -122.38101400211 (37.7426948446985, -122.38101400211) 10 3 8 58 1
146418 3617 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 53 Sidewalk: Curb side : Cutout Tree Port 6   05/01/2017 03:16:00 PM 3 3X3   6017937.25359 2098269.56212 37.7424540206388 -122.380579893948 (37.7424540206388, -122.380579893948) 10 3 8 58 1
24 264941 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Portola Dr 12 Median : Cutout Tree Private 2       3x3   5999749 2101261 37.7496473113918 -122.443684097942 (37.7496473113918, -122.443684097942) 2 5 5 28862 38
147497 177681 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Mansell St 1 Median : Cutout Tree DPW 1     19 Width 0ft   6011509.97843 2090681.5111 37.7212620415847 -122.402270230489 (37.7212620415847, -122.402270230489) 10 3 8 309 28
4401 258690 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
17872 258685 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Whitney Young Cir 2 Sidewalk: Curb side : Yard Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
29453 250347 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 101 26th Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7     5987545.38692 2115709.37275 37.7886149406787 -122.486945017294 (37.7886149406787, -122.486945017294) 11 6 1 55 33
148394 250346 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 101 26th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     9     5987535.97079 2115719.89961 37.7886432954046 -122.486978368669 (37.7886432954046, -122.486978368669) 11 6 1 55 33

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