trees

336 rows where Police Districts = 7 and qLegalStatus_id = 6 sorted by qSpecies_id

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
11129 236516 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 63 Bronte St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6009359.84862 2097078.24448 37.7387058549889 -122.410154031979 (37.7387058549889, -122.410154031979) 10 7 7 28859 2
184595 187668 Significant Tree 6 Eriobotrya deflexa :: Bronze Loquat 8 100x OGDEN AVE 4 Back Yard : Yard Tree Private 2           6007659 2096105 37.7359380573488 -122.41596587682 (37.7359380573488, -122.41596587682) 2 7 7 28859 2
37139 98289 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 5 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
71809 96274 Significant Tree 6 Olea europaea :: Olive Tree 9 55@ Alemany Trumbull St 2 Back Yard : Yard Tree Private 2     2     6004001.3006 2094332.00643 37.7308634942567 -122.428485665086 (37.7308634942567, -122.428485665086) 9 7 6 28861 5
143852 98290 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 6 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
150154 96278 Significant Tree 6 Olea europaea :: Olive Tree 9 55@ Alemany Trumbull St 6 Back Yard : Yard Tree Private 2     2     6003898.31997 2094328.29867 37.7308474854131 -122.428841421596 (37.7308474854131, -122.428841421596) 9 7 6 28861 5
165161 98288 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 4 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
1377 262327 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
1679 262328 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
14780 262330 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 4 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
18601 262329 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 10X Sickles Ave 3 Sidewalk: Property side : Cutout Tree Private 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
61015 113741 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1580 Valencia St 1 Front Yard : Yard Tree Private 2     18     6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
109570 114194 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 555x SAN JOSE AVE 2 Front Yard : Yard Tree Private 2   11/23/2015 12:00:00 AM 30 3x3 Permit Number 777057 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
194276 262536 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 65 Ocean Ave 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 785586 6001004.64572 2091720.9184 37.7235240092161 -122.438658540667 (37.7235240092161, -122.438658540667) 9 7 6 28861 25
4724 262586 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2 Byron Ct 1 Front Yard : Yard Tree Private 2   08/19/2020 12:00:00 AM 3 8x8 Permit Number 781313 5999459.72778 2086749.57445 37.7097858201455 -122.443642066205 (37.7097858201455, -122.443642066205) 9 7 6 28861 5
100865 96279 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 55@ Alemany Trumbull St 7 Back Yard : Yard Tree Private 2           6004020.1 2094407.4 37.7310715719205 -122.428426044208 (37.7310715719205, -122.428426044208) 9 7 6 28861 5
873 113043 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 2 Front Yard : Cutout Tree Private 2   10/06/2015 12:00:00 AM   3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
4898 211279 Significant Tree 6 Pinus radiata :: Monterey Pine 15 350 Joost Ave 1 Sidewalk: Property side : Yard Tree Private 2     28 Width 10ft   5999756.13451 2094992.8184 37.7324367835174 -122.443209289192 (37.7324367835174, -122.443209289192) 9 7 4 63 40
6334 104866 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Holladay Ave 1 Front Yard : Yard Tree Private 2           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
7000 251607 Significant Tree 6 Pinus radiata :: Monterey Pine 15 52 Amber Dr 2 Back Yard : Yard Tree Private 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
7196 251612 Significant Tree 6 Pinus radiata :: Monterey Pine 15 60R Amber Dr 1 Back Yard : Yard Tree Private 2           5999394 2100048 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752) 2 7 5 63 22
7631 256540 Significant Tree 6 Pinus radiata :: Monterey Pine 15 379X Cresta Vista Dr 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997117 2096261 37.7357680647268 -122.452424833384 (37.7357680647268, -122.452424833384) 9 7 4 59 40
8163 82435 Significant Tree 6 Pinus radiata :: Monterey Pine 15 51 Peralta Ave 1 Front Yard : Yard Tree Private 2   04/02/2005 12:00:00 AM 20     6010636.52703341 2100363.58782589 37.7477981742678 -122.405971235802 (37.7477981742678, -122.405971235802) 2 7 7 28859 2
9862 114526 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 2 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
12289 254085 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Lansdale Ave 1 Front Yard : Cutout Tree Private 2       6x6   5995707 2096451 37.7362088759349 -122.457313463895 (37.7362088759349, -122.457313463895) 9 7 4 59 40
18320 261763 Significant Tree 6 Pinus radiata :: Monterey Pine 15 315 Montcalm St 1 Front Yard : Yard Tree Private 2       3x3   6009577 2099558 37.7455268923792 -122.409578193595 (37.7455268923792, -122.409578193595) 2 7 7 28859 2
22273 106336 Significant Tree 6 Pinus radiata :: Monterey Pine 15 112 EUGENIA AVE 1 Front Yard : Yard Tree Private 2     18     6006345.6 2098165.7 37.7415223501304 -122.420653072553 (37.7415223501304, -122.420653072553) 2 7 7 28859 2
23065 98547 Significant Tree 6 Pinus radiata :: Monterey Pine 15 555@Rio Teresita Blvd 3 Front Yard : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
30591 105422 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5827 DIAMOND HEIGHTS BLVD 1 Front Yard : Yard Tree Private 2     36     6000844.1 2096795.2 37.7374476811542 -122.439577108095 (37.7374476811542, -122.439577108095) 2 7 5 63 7
32937 178336 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 2 Sidewalk: Property side : Yard Tree MTA 3     29 Width 8ft   5998664.9682 2091522.93582 37.7228470175482 -122.44673211619 (37.7228470175482, -122.44673211619) 9 7 6 28861 25
34428 251636 Significant Tree 6 Pinus radiata :: Monterey Pine 15 22R Amethyst Way 1 Back Yard : Yard Tree Private 2           5999148 2100052 37.7462933941297 -122.445675437709 (37.7462933941297, -122.445675437709) 2 7 5 63 22
34770 251426 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5020 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
34790 105768 Significant Tree 6 Pinus radiata :: Monterey Pine 15 98X GOLD MINE DR 3 Front Yard : Yard Tree Private 2     16     6001350 2099153 37.7439504273559 -122.437996817375 (37.7439504273559, -122.437996817375) 2 7 5 63 22
35918 109061 Significant Tree 6 Pinus radiata :: Monterey Pine 15 36 ARBOR ST   Front Yard : Yard Tree Private 2         Permit Number 774913 6002094.4 2096943.6 37.7379262346414 -122.435264853151 (37.7379262346414, -122.435264853151) 2 7 5 63 7
39032 251604 Significant Tree 6 Pinus radiata :: Monterey Pine 15 48R Amber Dr 1 Back Yard : Yard Tree Private 2           5999482 2100041 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345) 2 7 5 63 22
39321 120597 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 5 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
44800 120594 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
49109 104146 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1710-1738 Diamond St 1 Front Yard : Yard Tree Private 2     40     6001979.7 2099047.6 37.7436968136687 -122.435811922611 (37.7436968136687, -122.435811922611) 2 7 5 63 22
50063 105765 Significant Tree 6 Pinus radiata :: Monterey Pine 15 95 ORA WAY 1 Front Yard : Yard Tree Private 2     18     6001454.9 2097857 37.7403978808149 -122.437541306682 (37.7403978808149, -122.437541306682) 2 7 5 63 7
54303 178335 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 1 Sidewalk: Property side : Yard Tree MTA 3     33 Width 8ft   5998656.04486 2091523.12147 37.7228470175503 -122.446762975526 (37.7228470175503, -122.446762975526) 9 7 6 28861 25
59395 114525 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 1 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
85195 98151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 850 Rockdale Dr 3 Front Yard : Yard Tree Private 2         Permit Number 768501 5996729.9 2098301.3 37.7413480470066 -122.453910481227 (37.7413480470066, -122.453910481227) 9 7 4 59 40
89599 98156 Significant Tree 6 Pinus radiata :: Monterey Pine 15 149x Chaves Ave 1 Front Yard : Yard Tree Private 2           5996703.5 2098396.7 37.7416084783757 -122.454008650942 (37.7416084783757, -122.454008650942) 9 7 4 59 40
94002 113187 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3340 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6008444 2099179 37.7444226899799 -122.413469145285 (37.7444226899799, -122.413469145285) 2 7 7 28859 2
100356 113045 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 4 Front Yard : Cutout Tree Private 2       3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
104414 120596 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 1 Sidewalk: Curb side : Cutout Tree MTA 3     36 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
104794 115276 Significant Tree 6 Pinus radiata :: Monterey Pine 15 598X PORTOLA DR 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997411 2099824 37.7455680371271 -122.451665301061 (37.7455680371271, -122.451665301061) 1 7 4 59 40
110541 113044 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 3 Front Yard : Cutout Tree Private 2       3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
114550 178337 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 3 Sidewalk: Property side : Yard Tree MTA 3     29     5998676.28102 2091524.00797 37.7228506076618 -122.446693087413 (37.7228506076618, -122.446693087413) 9 7 6 28861 25
116578 120595 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 3 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
119122 251575 Significant Tree 6 Pinus radiata :: Monterey Pine 15 300 Sussex St 1 Sidewalk: Curb side : Yard Tree Private 2   08/02/2017 12:00:00 AM 3 3x3 Permit Number 780395 6001194 2096647 37.7370606668352 -122.438356728037 (37.7370606668352, -122.438356728037) 2 7 5 63 7
123534 104868 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Holladay Ave 3 Front Yard : Yard Tree Private 2           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
143508 256539 Significant Tree 6 Pinus radiata :: Monterey Pine 15 379X Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997117 2096261 37.7357680647268 -122.452424833384 (37.7357680647268, -122.452424833384) 9 7 4 59 40
149707 108978 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 MIGUEL ST 1 Front Yard : Yard Tree Private 2     44     6003334.2 2097391.9 37.7392274919289 -122.431010244874 (37.7392274919289, -122.431010244874) 2 7 5 63 7
166166 120598 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 6 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
168346 251480 Significant Tree 6 Pinus radiata :: Monterey Pine 15 51 Peralta Ave 1 Front Yard : Yard Tree Private 2       3x3   6010641 2100362 37.7477940646116 -122.405955656592 (37.7477940646116, -122.405955656592) 2 7 7 28859 2
169643 251606 Significant Tree 6 Pinus radiata :: Monterey Pine 15 52R Amber Dr 1 Back Yard : Yard Tree Private 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
177640 103084 Significant Tree 6 Pinus radiata :: Monterey Pine 15 30X Zircon Pl 1 Back Yard : Yard Tree Private 2           6002309.6 2098789.5 37.7430068656447 -122.434652757436 (37.7430068656447, -122.434652757436) 2 7 5 63 7
178584 108144 Significant Tree 6 Pinus radiata :: Monterey Pine 15 140x TOPAZ WAY 2 Front Yard : Yard Tree Private 2     30   Permit Number 775551 6001767 2098265 37.7415358930081 -122.436491384585 (37.7415358930081, -122.436491384585) 2 7 5 63 7
183500 98157 Significant Tree 6 Pinus radiata :: Monterey Pine 15 149x Chaves Ave 2 Front Yard : Yard Tree Private 2           5996703.5 2098396.7 37.7416084783757 -122.454008650942 (37.7416084783757, -122.454008650942) 9 7 4 59 40
63382 177743 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 401 Ocean Ave 4 Sidewalk: Property side : Yard Tree MTA 3     37     5998700.41574 2091522.98281 37.7228491714484 -122.446609585371 (37.7228491714484, -122.446609585371) 9 7 6 28861 25
95104 120593 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 499x Ocean Ave 4 Sidewalk: Curb side : Cutout Tree MTA 3     34 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
115 121173 Significant Tree 6 Tree(s) :: 17 950 Duncan St 2 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
3313 262482 Significant Tree 6 Tree(s) :: 17 45 Delta St 1 Front Yard : Yard Tree Private 2       3x3   6010254 2089941 37.7191585615903 -122.406559656354 (37.7191585615903, -122.406559656354) 10 7 8 309 39
5702 121171 Significant Tree 6 Tree(s) :: 17 900x Duncan St 4 Front Yard : Yard Tree Private 2       3x3   6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
9495 261033 Significant Tree 6 Tree(s) :: 17 551 Los Palmos Dr 1 Front Yard : Yard Tree Private 2   01/14/2020 12:00:00 AM 3 10x10 Permit Number 784596 5996615 2095626 37.7339957349096 -122.454114584985 (37.7339957349096, -122.454114584985) 9 7 4 59 40
9889 116075 Significant Tree 6 Tree(s) :: 17 88 MONTCALM ST 1 Front Yard : Yard Tree Private 2           6010492 2099980 37.7467368416425 -122.406443980671 (37.7467368416425, -122.406443980671) 2 7 7 28859 2
10910 120918 Significant Tree 6 Tree(s) :: 17 555x SAN JOSE AVE 2 Front Yard : Yard Tree Private 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 778877 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
27545 115090 Significant Tree 6 Tree(s) :: 17 121 Topaz Way 1 Front Yard : Yard Tree Private 2   01/11/2016 12:00:00 AM     Permit Number 776934 6001846.4 2098050 37.7409500647868 -122.436201464472 (37.7409500647868, -122.436201464472) 2 7 5 63 7
32555 121168 Significant Tree 6 Tree(s) :: 17 900x Duncan St 1 Front Yard : Yard Tree Private 2       3x3   6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
51717 115446 Significant Tree 6 Tree(s) :: 17 546 FRANCONIA ST 2 Back Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931 2098208 37.7418399166086 -122.408258912238 (37.7418399166086, -122.408258912238) 10 7 7 28859 2
62334 87240 Significant Tree 6 Tree(s) :: 17 233 Arbor St 2 Sidewalk: Curb side : Yard Tree Private 2   02/14/2008 12:00:00 AM     Permit Number 50269 6001330 2096776 37.7374226054152 -122.437895752709 (37.7374226054152, -122.437895752709) 2 7 5 63 7
64560 87191 Significant Tree 6 Tree(s) :: 17 640 Miramar Ave 1 Front Yard : Yard Tree Private 2   01/29/2008 12:00:00 AM     Permit Number 50212 5995439 2093622 37.7284257331327 -122.458035371987 (37.7284257331327, -122.458035371987) 9 7 4 28861 40
71176 87239 Significant Tree 6 Tree(s) :: 17 233 Arbor St 1 Sidewalk: Property side : Yard Tree Private 2   02/14/2008 12:00:00 AM     Permit Number 50269 6001330 2096776 37.7374226054152 -122.437895752709 (37.7374226054152, -122.437895752709) 2 7 5 63 7
74590 115445 Significant Tree 6 Tree(s) :: 17 546 FRANCONIA ST 1 Back Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931 2098208 37.7418399166086 -122.408258912238 (37.7418399166086, -122.408258912238) 10 7 7 28859 2
77320 116457 Significant Tree 6 Tree(s) :: 17 412 Nevada St 1 Front Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3   Permit Number 777591 6008890.4 2096365.2 37.736721665261 -122.41172680033 (37.736721665261, -122.41172680033) 10 7 7 28859 2
87807 113732 Significant Tree 6 Tree(s) :: 17 1580 Valencia St 9 Front Yard : Yard Tree Private 2   10/08/2015 12:00:00 AM     Permit Number 775128 6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
87873 121174 Significant Tree 6 Tree(s) :: 17 950 Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
92659 85428 Significant Tree 6 Tree(s) :: 17 43 Ora Way 1 Front Yard : Cutout Tree Private 2   08/23/2007 12:00:00 AM     Permit Number 49665 6001553.3 2098294.6 37.7416050219872 -122.437232403771 (37.7416050219872, -122.437232403771) 2 7 5 63 7
95045 121170 Significant Tree 6 Tree(s) :: 17 900x Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
98953 114193 Significant Tree 6 Tree(s) :: 17 555x SAN JOSE AVE 1 Front Yard : Yard Tree Private 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 778877 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
103941 57910 Significant Tree 6 Tree(s) :: 17 446 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/10/1977 12:00:00 AM     Permit Number 16868 6003019.35193275 2099229.53580249 37.7442553690473 -122.432230049776 (37.7442553690473, -122.432230049776) 2 7 5 63 22
108135 108305 Significant Tree 6 Tree(s) :: 17 360 GAMBIER ST 1 Front Yard : Yard Tree Private 2   02/06/2015 12:00:00 AM 3   Permit Number 774454 6006059.9 2092154.5 37.725000818071 -122.421214176486 (37.725000818071, -122.421214176486) 9 7 7 309 5
111801 121175 Significant Tree 6 Tree(s) :: 17 950 Duncan St 4 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
116917 104149 Significant Tree 6 Tree(s) :: 17 1710-1738 Diamond St 3 Front Yard : Yard Tree Private 2         Permit Number 768304 6001979.7 2099047.6 37.7436968136687 -122.435811922611 (37.7436968136687, -122.435811922611) 2 7 5 63 22
126350 101810 Significant Tree 6 Tree(s) :: 17 38 Nebraska St 1 Front Yard : Tree Private 2   11/22/2012 12:00:00 AM     Permit Number 769374 6009268.6 2097830.3 37.740765720819 -122.41052261909 (37.740765720819, -122.41052261909) 10 7 7 28859 2
130286 253951 Significant Tree 6 Tree(s) :: 17 431 Yerba Buena Ave 2 Front Yard : Cutout Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780852 5995366 2094904 37.7319416000564 -122.458380491445 (37.7319416000564, -122.458380491445) 9 7 4 59 40
135671 121172 Significant Tree 6 Tree(s) :: 17 950 Duncan St 1 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
142943 104150 Significant Tree 6 Tree(s) :: 17 1710-1738 Diamond St 4 Front Yard : Yard Tree Private 2         Permit Number 768304 6001979.7 2099047.6 37.7436968136687 -122.435811922611 (37.7436968136687, -122.435811922611) 2 7 5 63 22
151159 107322 Significant Tree 6 Tree(s) :: 17 68 ROSENKRANZ ST 1 Front Yard : Yard Tree Private 2   09/29/2014 12:00:00 AM 3   Permit Number 773942 6009212 2098349 37.7421867844178 -122.410754944355 (37.7421867844178, -122.410754944355) 10 7 7 28859 2
166995 115091 Significant Tree 6 Tree(s) :: 17 121 Topaz Way 2 Front Yard : Yard Tree Private 2   01/11/2016 12:00:00 AM     Permit Number 776934 6001846.4 2098050 37.7409500647868 -122.436201464472 (37.7409500647868, -122.436201464472) 2 7 5 63 7
168357 104148 Significant Tree 6 Tree(s) :: 17 1710-1738 Diamond St 2 Front Yard : Yard Tree Private 2         Permit Number 768304 6001979.7 2099047.6 37.7436968136687 -122.435811922611 (37.7436968136687, -122.435811922611) 2 7 5 63 22
169778 255656 Significant Tree 6 Tree(s) :: 17 5827 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2   12/28/2018 12:00:00 AM 3 12x12 Permit Number 781981 6000844 2096795 37.7374471263095 -122.439577439508 (37.7374471263095, -122.439577439508) 2 7 5 63 7
177119 114191 Significant Tree 6 Tree(s) :: 17 201 Delano Ave 7 Back Yard : Yard Tree Private 2     20   Permit Number 776814 6000172.52130735 2092388.14283689 37.7253086814057 -122.44158289611 (37.7253086814057, -122.44158289611) 9 7 6 28861 25
178454 96779 Significant Tree 6 Tree(s) :: 17 555 Melrose Ave 1 Back Yard : Yard Tree Private 2   07/18/2011 12:00:00 AM     Permit Number 767966 5996882.6 2095364.1 37.7332919614683 -122.45317051412 (37.7332919614683, -122.45317051412) 9 7 4 59 40
182728 102583 Significant Tree 6 Tree(s) :: 17 22 Gennessee St 1 Front Yard : Yard Tree Private 2   02/27/2013 12:00:00 AM     Permit Number 769949 5997479.4 2093692.8 37.7287371564084 -122.450986747444 (37.7287371564084, -122.450986747444) 9 7 4 28861 40
185143 113737 Significant Tree 6 Tree(s) :: 17 1580 Valencia St 14 Front Yard : Yard Tree Private 2   10/08/2015 12:00:00 AM     Permit Number 775128 6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
185504 113729 Significant Tree 6 Tree(s) :: 17 1580 Valencia St 6 Front Yard : Yard Tree Private 2   10/08/2015 12:00:00 AM     Permit Number 775128 6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
185684 121176 Significant Tree 6 Tree(s) :: 17 950 Duncan St 5 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
190141 100043 Significant Tree 6 Tree(s) :: 17 50 Bronte St 1 Front Yard : Yard Tree Private 2   07/12/2012 12:00:00 AM     Permit Number 769001 6009337 2097155 37.7389153282678 -122.410238449764 (37.7389153282678, -122.410238449764) 10 7 7 28859 2

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