trees

Custom SQL query returning 81 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
71809 96274 6 9 55@ Alemany Trumbull St 2 Back Yard : Yard Tree 2     2     6004001.3006 2094332.00643 37.7308634942567 -122.428485665086 (37.7308634942567, -122.428485665086) 9 7 6 28861 5
150154 96278 6 9 55@ Alemany Trumbull St 6 Back Yard : Yard Tree 2     2     6003898.31997 2094328.29867 37.7308474854131 -122.428841421596 (37.7308474854131, -122.428841421596) 9 7 6 28861 5
1377 262327 6 11 10X Sickles Ave 1 Sidewalk: Property side : Cutout Tree 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
1679 262328 6 11 10X Sickles Ave 2 Sidewalk: Property side : Cutout Tree 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
14780 262330 6 11 10X Sickles Ave 4 Sidewalk: Property side : Cutout Tree 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
18601 262329 6 11 10X Sickles Ave 3 Sidewalk: Property side : Cutout Tree 2       3x10   5996833 2086575 37.709156314989 -122.452707876493 (37.709156314989, -122.452707876493) 9 7 6 28861 25
194276 262536 6 11 65 Ocean Ave 1 Sidewalk: Property side : Yard Tree 2         Permit Number 785586 6001004.64572 2091720.9184 37.7235240092161 -122.438658540667 (37.7235240092161, -122.438658540667) 9 7 6 28861 25
4724 262586 6 13 2 Byron Ct 1 Front Yard : Yard Tree 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 6 14 55@ Alemany Trumbull St 7 Back Yard : Yard Tree 2           6004020.1 2094407.4 37.7310715719205 -122.428426044208 (37.7310715719205, -122.428426044208) 9 7 6 28861 5
32937 178336 6 15 401 Ocean Ave 2 Sidewalk: Property side : Yard Tree 3     29 Width 8ft   5998664.9682 2091522.93582 37.7228470175482 -122.44673211619 (37.7228470175482, -122.44673211619) 9 7 6 28861 25
39321 120597 6 15 499x Ocean Ave 5 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
44800 120594 6 15 499x Ocean Ave 2 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
54303 178335 6 15 401 Ocean Ave 1 Sidewalk: Property side : Yard Tree 3     33 Width 8ft   5998656.04486 2091523.12147 37.7228470175503 -122.446762975526 (37.7228470175503, -122.446762975526) 9 7 6 28861 25
104414 120596 6 15 499x Ocean Ave 1 Sidewalk: Curb side : Cutout Tree 3     36 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
114550 178337 6 15 401 Ocean Ave 3 Sidewalk: Property side : Yard Tree 3     29     5998676.28102 2091524.00797 37.7228506076618 -122.446693087413 (37.7228506076618, -122.446693087413) 9 7 6 28861 25
116578 120595 6 15 499x Ocean Ave 3 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
166166 120598 6 15 499x Ocean Ave 6 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
63382 177743 6 16 401 Ocean Ave 4 Sidewalk: Property side : Yard Tree 3     37     5998700.41574 2091522.98281 37.7228491714484 -122.446609585371 (37.7228491714484, -122.446609585371) 9 7 6 28861 25
95104 120593 6 16 499x Ocean Ave 4 Sidewalk: Curb side : Cutout Tree 3     34 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
1773 116537 6 17 598x MOUNT VERNON AVE 6 Back Yard : Yard Tree 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
15657 259657 6 17 132 Sagamore St 1 Front Yard : Yard Tree 2       3x3   5995545 2087474 37.7115508726991 -122.457224363425 (37.7115508726991, -122.457224363425) 9 8 6 28861 24
64560 87191 6 17 640 Miramar Ave 1 Front Yard : Yard Tree 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
81780 206842 6 17 218 Sadowa St 3 Sidewalk: Property side : Cutout Tree 2   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994803.1874 2087784.4983 37.712360795684 -122.45981072288 (37.712360795684, -122.45981072288) 9 8 6 28861 24
84393 116534 6 17 598x MOUNT VERNON AVE 3 Back Yard : Yard Tree 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
105492 116536 6 17 598x MOUNT VERNON AVE 5 Back Yard : Yard Tree 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
143694 116535 6 17 598x MOUNT VERNON AVE 4 Back Yard : Yard Tree 2   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754 2090179 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005) 9 8 6 28861 24
177119 114191 6 17 201 Delano Ave 7 Back Yard : Yard Tree 2     20   Permit Number 776814 6000172.52130735 2092388.14283689 37.7253086814057 -122.44158289611 (37.7253086814057, -122.44158289611) 9 7 6 28861 25
182728 102583 6 17 22 Gennessee St 1 Front Yard : Yard Tree 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
181560 256493 6 36 400 Rolph St 1 Front Yard : Yard Tree 2       3x3   6002004 2087744 37.7126610773499 -122.434919679914 (37.7126610773499, -122.434919679914) 9 7 6 28861 5
194262 262537 6 36 65 Ocean Ave 2 Sidewalk: Property side : Yard Tree 2         Permit Number 785586 6001004.64572 2091720.9184 37.7235240092161 -122.438658540667 (37.7235240092161, -122.438658540667) 9 7 6 28861 25
8751 262427 6 41 1 Avalon Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
11014 262425 6 41 1 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
15980 262426 6 41 1 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
137083 106962 6 41 218 SADOWA ST 3 Sidewalk: Property side : Cutout Tree 2     22     5994814 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106) 9 8 6 28861 24
15224 264691 6 46 1560 Plymouth Ave 1 Front Yard : Yard Tree 2       10x10   5995798 2094356 37.730461740667 -122.45684736471 (37.730461740667, -122.45684736471) 9 7 4 28861 40
9908 215094 6 51 218 Sadowa St 1 Sidewalk: Curb side : Cutout Tree 2   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994821.63014 2087784.20309 37.7123610457095 -122.459746958272 (37.7123610457095, -122.459746958272) 9 8 6 28861 24
36628 177109 6 57 401 Ocean Ave 16 Sidewalk: Property side : Yard Tree 3     6 Width 5ft   5998958.08532 2091518.52367 37.7228516427597 -122.445718558684 (37.7228516427597, -122.445718558684) 9 7 6 28861 25
47041 177110 6 57 401 Ocean Ave 17 Sidewalk: Property side : Yard Tree 3     6 Width 5ft   5998978.57855 2091518.53644 37.722852847868 -122.445647719081 (37.722852847868, -122.445647719081) 9 7 6 28861 25
49633 177105 6 57 401 Ocean Ave 12 Sidewalk: Property side : Yard Tree 3     4 Width 5ft   5998924.5969 2091518.78116 37.7228504376811 -122.445834339179 (37.7228504376811, -122.445834339179) 9 7 6 28861 25
57339 177108 6 57 401 Ocean Ave 15 Sidewalk: Property side : Yard Tree 3     5 Width 5ft   5998950.80755 2091518.23612 37.7228504376851 -122.44574369564 (37.7228504376851, -122.44574369564) 9 7 6 28861 25
80257 122411 6 57 499x Ocean Ave 8 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
92548 122410 6 57 499x Ocean Ave 7 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
102801 122418 6 57 499x Ocean Ave 15 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
136955 122414 6 57 499x Ocean Ave 11 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
141801 122417 6 57 499x Ocean Ave 14 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
148884 122413 6 57 499x Ocean Ave 10 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
149548 122416 6 57 499x Ocean Ave 13 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
156105 122412 6 57 499x Ocean Ave 9 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
162950 122415 6 57 499x Ocean Ave 12 Sidewalk: Curb side : Cutout Tree 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
173815 177104 6 57 401 Ocean Ave 11 Sidewalk: Property side : Yard Tree 3     4 Width 5ft   5998921.08183 2091519.29315 37.7228516427808 -122.445846526795 (37.7228516427808, -122.445846526795) 9 7 6 28861 25
176521 177106 6 57 401 Ocean Ave 13 Sidewalk: Property side : Yard Tree 3     7 Width 5ft   5998933.17773 2091518.16383 37.7228492325857 -122.445804632792 (37.7228492325857, -122.445804632792) 9 7 6 28861 25
142556 256880 6 59 2701 Alemany Blvd 1 Side Yard : Yard Tree 2       10x10   5997600 2087902 37.7128438731446 -122.450152604107 (37.7128438731446, -122.450152604107) 9 7 6 28861 25
3096 100121 6 62 690 Miramar Ave 1 Front Yard : Yard Tree 2           5995444.4 2093941.6 37.7293035878447 -122.458039824042 (37.7293035878447, -122.458039824042) 9 7 4 28861 40
119037 112769 6 62 1X HOWTH ST 1 Sidewalk: Property side : Yard Tree 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
133887 112770 6 62 1X HOWTH ST 2 Sidewalk: Property side : Yard Tree 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
136074 112773 6 62 1X HOWTH ST 5 Sidewalk: Property side : Yard Tree 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
137248 112771 6 62 1X HOWTH ST 3 Sidewalk: Property side : Yard Tree 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
140130 112774 6 62 1X HOWTH ST 6 Sidewalk: Property side : Yard Tree 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
165386 112772 6 62 1X HOWTH ST 4 Sidewalk: Property side : Yard Tree 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
10229 264894 6 63 56 Keystone Way 1 Back Yard : Yard Tree 2       3x3   5994156 2093086 37.7268802074189 -122.462431871086 (37.7268802074189, -122.462431871086) 9 8 4 28861 40
29379 254551 6 64 1433 Cayuga Ave 1 Front Yard : Cutout Tree 2       6x6   5999129 2089595 37.7175798453783 -122.444989533853 (37.7175798453783, -122.444989533853) 9 7 6 28861 25
194273 263629 6 70 1985X Alemany Blvd 1 Side Yard : Yard Tree 2       10x10 Permit Number 785142 6000955 2090559 37.7203308201534 -122.438746936552 (37.7203308201534, -122.438746936552) 9 7 6 28861 25
125248 106038 6 72 230 Lakeview Ave   Front Yard : Yard Tree 2         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743) 9 8 6 28861 24
120908 96277 6 84 55@ Alemany Trumbull St 5 Back Yard : Yard Tree 2     2     6003933.28624 2094328.99121 37.7308513660015 -122.428720586902 (37.7308513660015, -122.428720586902) 9 7 6 28861 5
159825 96276 6 84 55@ Alemany Trumbull St 4 Back Yard : Yard Tree 2     2     6003946.78636 2094329.77315 37.7308542770831 -122.428673970523 (37.7308542770831, -122.428673970523) 9 7 6 28861 5
165425 96275 6 84 55@ Alemany Trumbull St 3 Back Yard : Yard Tree 2     3     6003967.55773 2094330.40491 37.73085718729 -122.428602205549 (37.73085718729, -122.428602205549) 9 7 6 28861 5
16429 262110 6 87 25 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6002200 2092574 37.7259343081174 -122.434587389509 (37.7259343081174, -122.434587389509) 9 7 6 28861 25
48765 98082 6 100 525 Grafton Ave 1 Sidewalk: Property side : Cutout Tree 2           5995193.7 2090526.9 37.7199132334677 -122.45865940878 (37.7199132334677, -122.45865940878) 9 8 6 28861 24
106382 116072 6 113 388 POLARIS WAY 1 Sidewalk: Property side : Cutout Tree 2       3x3   6000586 2086414 37.7089285790833 -122.439725431133 (37.7089285790833, -122.439725431133) 9 7 6 28861 5
180754 96273 6 155 55@ Alemany Trumbull St 1 Back Yard : Yard Tree 2           6004020.1 2094407.4 37.7310715719205 -122.428426044208 (37.7310715719205, -122.428426044208) 9 7 6 28861 5
7288 264692 6 172 1500 Plymouth Ave 1 Side Yard : Yard Tree 2       10x10   5995893.6658 2094152.61505 37.7299087874515 -122.456501934539 (37.7299087874515, -122.456501934539) 9 7 4 28861 40
39767 254934 6 208 755 Ocean Ave 1 Sidewalk: Property side : Cutout Tree 2       3x6   5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
56399 254401 6 208 755 Ocean Ave 1 Sidewalk: Property side : Cutout Tree 2       3x3 Permit Number 779678 5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
168489 254935 6 208 755 Ocean Ave 2 Sidewalk: Property side : Cutout Tree 2       3x6 Permit Number 779678 5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
124365 116951 6 238 299 Tara St 1 Front Yard : Yard Tree 2           5997754 2090179.6 37.7191064490611 -122.449784366221 (37.7191064490611, -122.449784366221) 9 8 6 28861 24
27222 258201 6 262 598X Alemany Blvd 5 Sidewalk: Property side : Cutout Tree 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
33311 258200 6 262 598X Alemany Blvd 4 Sidewalk: Property side : Cutout Tree 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
163996 258199 6 262 598X Alemany Blvd 3 Sidewalk: Property side : Cutout Tree 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
3842 109772 6 268 2200x SAN JOSE AVE 11 Sidewalk: Curb side : Cutout Tree 2     30 3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
21762 100124 6 394 40@ San Ramon Eastwood Dr 1 Front Yard : Yard Tree 2           5995635 2092781 37.7261278087338 -122.457296979484 (37.7261278087338, -122.457296979484) 9 7 4 28861 40
157806 95777 6 550 30 Onondaga Ave   Front Yard : Yard Tree 2   03/11/2011 12:00:00 AM     Permit Number 767524 6001190.6 2091111.6 37.7218615356817 -122.437972107548 (37.7218615356817, -122.437972107548) 9 7 6 28861 25