6,714 rows where qSpecies_id = 7 sorted by Longitude

View and edit SQL

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)
604 20034 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
1515 31846 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
3055 20039 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
3242 43297 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1501 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2000 12:00:00 AM     Permit Number 43066                    
4991 20043 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 14 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
6396 36746 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 5555 Woodward St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39516                    
7114 20035 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 6 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
7286 33084 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
7976 20040 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 ST                      
9521 35167 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 240 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/1998 12:00:00 AM     Permit Number 38700                    
9968 31847 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
14278 31848 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   3 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
14721 20044 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 15 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
18188 33083 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
18800 20042 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 100 STAIRWAY51 13 Sidewalk: Curb side : Cutout Tree DPW 1     3 ST                      
19322 46857 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2002 12:00:00 AM     Permit Number 44926                    
60321 201520 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 501 Griffith St 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6019241.77344 2094383.32833 37.7318550858427 -122.37579982552 (37.7318550858427, -122.37579982552) 10 3 8 58 1
95785 201519 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 501 Griffith St 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   6019223.74724 2094361.07733 37.7317929966527 -122.375860604396 (37.7317929966527, -122.375860604396) 10 3 8 58 1
161880 201518 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 501 Griffith St 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6019207.67378 2094338.78719 37.7317309074526 -122.375914629362 (37.7317309074526, -122.375914629362) 10 3 8 58 1
16650 40009 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 963 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 5   Permit Number 41262 6018899.57505 2094657.40419 37.7325888031102 -122.377001897143 (37.7325888031102, -122.377001897143) 10 3 8 58 1
190701 196275 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 89 Kiska Rd 4 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   6018699.22943 2093690.01585 37.729921505667 -122.377627436781 (37.729921505667, -122.377627436781) 10 3 8 58 1
127642 196274 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 89 Kiska Rd 3 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   6018690.35337 2093691.67274 37.7299255661145 -122.377658237655 (37.7299255661145, -122.377658237655) 10 3 8 58 1
13333 196273 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 89 Kiska Rd 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 8ft   6018678.54669 2093695.28939 37.7299348462003 -122.377699306103 (37.7299348462003, -122.377699306103) 10 3 8 58 1
189427 196272 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 89 Kiska Rd 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   6018667.18531 2093699.95339 37.7299470266284 -122.377738907749 (37.7299470266284, -122.377738907749) 10 3 8 58 1
141784 201407 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 201 Harbor Rd 2 : Tree Private 2     4 Width 4ft   6018140.98583 2094924.55541 37.7332805364497 -122.379643105252 (37.7332805364497, -122.379643105252) 10 3 8 58 1
77245 6391 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 16 Espanola St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/27/2007 12:00:00 AM 6 3X3   6018056.47068 2094273.68663 37.7314887164161 -122.379890092347 (37.7314887164161, -122.379890092347) 10 3 8 58 1
119531 196271 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 10 Cashmere St 1 : Tree Private 2     31     6017110.31038 2095865.54024 37.7358073912904 -122.383271945238 (37.7358073912904, -122.383271945238) 10 3 8 58 1
55214 196270 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 50x Dedman Ct 3 Median : Yard Tree DPW 1     11     6016861.7614 2096200.30133 37.7367128395304 -122.384154590289 (37.7367128395304, -122.384154590289) 10 3 8 58 1
19870 196269 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 50x Dedman Ct 2 Median : Yard Tree DPW 1     12     6016851.53049 2096187.80946 37.7366779736991 -122.384189093646 (37.7366779736991, -122.384189093646) 10 3 8 58 1
3940 60357 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1265 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1982 12:00:00 AM 9   Permit Number 19935 6016646.4135 2093895.0122 37.7303710665679 -122.384738607351 (37.7303710665679, -122.384738607351) 10 3 8 58 1
181918 1917 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 12 Bell Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 3X3   6016599.62723 2095217.01267 37.7339984292864 -122.384992424754 (37.7339984292864, -122.384992424754) 10 3 8 58 1
127273 38580 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1375 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 6   Permit Number 40540 6016458.6044 2093690.7438 37.729799797257 -122.385373666801 (37.729799797257, -122.385373666801) 10 3 8 58 1
119963 116394 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1351 Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6016395.7433 2093382.8838 37.7289509966751 -122.385569539802 (37.7289509966751, -122.385569539802) 10 3 8 58 1
48744 88051 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1351 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 3 3x3 Permit Number 51061 6016378.6669 2093395.5533 37.7289848397566 -122.385629457357 (37.7289848397566, -122.385629457357) 10 3 8 58 1
107798 87175 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1414 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2008 12:00:00 AM 1 3x3 Permit Number 50143 6016206.1979 2094998.2533 37.7333759901055 -122.386337396865 (37.7333759901055, -122.386337396865) 10 3 8 58 1
187280 11411 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1482 Innes Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/10/1992 12:00:00 AM 6 3X4   6016167.73514 2096777.35021 37.738258902726 -122.386594388046 (37.738258902726, -122.386594388046) 10 3 8 58 1
140251 11414 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1486 Innes Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X4   6016137.01095 2096800.60407 37.738321052161 -122.386702239228 (37.738321052161, -122.386702239228) 10 3 8 58 1
191575 199862 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1455 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6016004.4926 2094023.6514 37.7306887611767 -122.386966805875 (37.7306887611767, -122.386966805875) 10 3 8 58 1
96950 84687 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1514 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2008 12:00:00 AM 4 3x3 Permit Number 50141 6016000.88112 2096896.45557 37.7385767033462 -122.387179597554 (37.7385767033462, -122.387179597554) 10 3 8 58 1
124505 199694 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1350 Underwood Ave 1 Sidewalk: Curb side : Pot Tree Private 2     1 Width 0ft   6015915.704 2092772.4292 37.7272482369677 -122.387186522807 (37.7272482369677, -122.387186522807) 10 3 8 58 1
50728 196276 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1514 Innes Ave 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6015988.30327 2096906.1918 37.7386027405173 -122.387223765075 (37.7386027405173, -122.387223765075) 10 3 8 58 1
11912 38551 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1843 Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 3   Permit Number 40519 6015881.5256 2093201.6545 37.7284249117339 -122.387334607185 (37.7284249117339, -122.387334607185) 10 3 8 58 1
15961 38550 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1843 Jennings St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 4   Permit Number 40519 6015868.3053 2093186.7815 37.7283833412514 -122.387379273723 (37.7283833412514, -122.387379273723) 10 3 8 58 1
193035 26124 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1439 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6015892.5497 2094809.562 37.7328405153421 -122.387408617446 (37.7328405153421, -122.387408617446) 10 3 8 58 1
159779 200751 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1419 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6015822.8195 2094514.1504 37.7320255121303 -122.387629091574 (37.7320255121303, -122.387629091574) 10 3 8 58 1
161257 46630 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1494 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2002 12:00:00 AM 4   Permit Number 44751 6015833.2108 2095276.4238 37.7341191373642 -122.387646329853 (37.7341191373642, -122.387646329853) 10 3 8 58 1
6039 60368 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1423 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1982 12:00:00 AM 6   Permit Number 19946 6015801.9343 2094530.6388 37.7320696291014 -122.387702446866 (37.7320696291014, -122.387702446866) 10 3 8 58 1
111143 38600 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1473 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 7   Permit Number 40551 6015747.1184 2093869.8344 37.7302521558979 -122.387845867418 (37.7302521558979, -122.387845867418) 10 3 8 58 1
12409 60388 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1454 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1982 12:00:00 AM 1   Permit Number 19968 6015694.2103 2094682.8814 37.7324816889757 -122.388085495957 (37.7324816889757, -122.388085495957) 10 3 8 58 1
188070 88044 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1527 Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 4 3x3 Permit Number 51056 6015719.25288 2096684.28804 37.7379785345766 -122.388138539286 (37.7379785345766, -122.388138539286) 10 3 8 58 1
84260 88043 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1527 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 4 3x3 Permit Number 51056 6015705.98557 2096695.57507 37.7380087913713 -122.38818519881 (37.7380087913713, -122.38818519881) 10 3 8 58 1
126351 88047 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1547 Jerrold Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 4 3x3 Permit Number 51057 6015649.6033 2096737.02814 37.7381194889247 -122.388383034362 (37.7381194889247, -122.388383034362) 10 3 8 58 1
50144 196277 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1547 Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015638.97442 2096745.3057 37.7381416284363 -122.388420361625 (37.7381416284363, -122.388420361625) 10 3 8 58 1
80530 88045 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1547 Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 4 3x3 Permit Number 51057 6015625.12405 2096754.45465 37.7381659820759 -122.388468888121 (37.7381659820759, -122.388468888121) 10 3 8 58 1
39617 196082 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 701 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6015721.57305 2103923.07209 37.7578548576382 -122.388635680008 (37.7578548576382, -122.388635680008) 10 3 8 28856 29
30048 81703 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 728 20th St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM   3x3 Permit Number 50044 6015682.09798099 2104903.80699852 37.7605455583769 -122.388840669387 (37.7605455583769, -122.388840669387) 10 3 8 28856 29
96209 81707 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 728 20th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM   3x3 Permit Number 50044 6015682.09798099 2104903.80699852 37.7605455583769 -122.388840669387 (37.7605455583769, -122.388840669387) 10 3 8 28856 29
110110 81708 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 728 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM   3x3 Permit Number 50044 6015682.09798099 2104903.80699852 37.7605455583769 -122.388840669387 (37.7605455583769, -122.388840669387) 10 3 8 28856 29
116918 81706 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 728 20th St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM   3x3 Permit Number 50044 6015682.09798099 2104903.80699852 37.7605455583769 -122.388840669387 (37.7605455583769, -122.388840669387) 10 3 8 28856 29
121847 81709 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 728 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM   3x3 Permit Number 50044 6015682.09798099 2104903.80699852 37.7605455583769 -122.388840669387 (37.7605455583769, -122.388840669387) 10 3 8 28856 29
132299 81705 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 728 20th St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM   3x3 Permit Number 50044 6015682.09798099 2104903.80699852 37.7605455583769 -122.388840669387 (37.7605455583769, -122.388840669387) 10 3 8 28856 29
156589 81704 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 728 20th St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM   3x3 Permit Number 50044 6015682.09798099 2104903.80699852 37.7605455583769 -122.388840669387 (37.7605455583769, -122.388840669387) 10 3 8 28856 29
173350 81702 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 728 20th St 8 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2007 12:00:00 AM   3x3 Permit Number 50044 6015682.09798099 2104903.80699852 37.7605455583769 -122.388840669387 (37.7605455583769, -122.388840669387) 10 3 8 28856 29
166188 200791 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1582 McKinnon Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   6015463.9227 2095899.7229 37.7358101282167 -122.388966588384 (37.7358101282167, -122.388966588384) 10 3 8 58 1
54282 200053 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1555 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6015307.2832 2094192.9021 37.7311148594787 -122.38938900173 (37.7311148594787, -122.38938900173) 10 3 8 58 1
181939 196083 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 899 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6015520.92899 2104914.9427 37.7605672003357 -122.38939886178 (37.7605672003357, -122.38939886178) 10 3 8 28856 29
31100 196084 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 899 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6015520.28243 2104924.05351 37.7605921808173 -122.38940173421 (37.7605921808173, -122.38940173421) 10 3 8 28856 29
64161 196085 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 899 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6015519.48704 2104939.50859 37.7606345730508 -122.389405564436 (37.7606345730508, -122.389405564436) 10 3 8 28856 29
104671 196086 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 899 Tennessee St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6015519.14513 2104949.99214 37.760663339672 -122.389407479081 (37.760663339672, -122.389407479081) 10 3 8 28856 29
133014 196087 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 899 Tennessee St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6015517.7516 2104963.25372 37.7606996758621 -122.389413224845 (37.7606996758621, -122.389413224845) 10 3 8 28856 29
74014 196088 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 899 Tennessee St 8 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6015515.50483 2105016.50834 37.7608457770442 -122.389424714573 (37.7608457770442, -122.389424714573) 10 3 8 28856 29
187513 196089 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 899 Tennessee St 9 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6015514.72199 2105046.29907 37.7609275325861 -122.389429502571 (37.7609275325861, -122.389429502571) 10 3 8 28856 29
59276 81701 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 851 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/06/2012 12:00:00 AM 4   Permit Number 768903 6015512.02282 2105063.44662 37.7609744664228 -122.389440035426 (37.7609744664228, -122.389440035426) 10 3 8 28856 29
16449 81682 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 851 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/06/2012 12:00:00 AM 5   Permit Number 768903 6015510.18333 2105095.74005 37.7610630352539 -122.389448652757 (37.7610630352539, -122.389448652757) 10 3 8 28856 29
136632 199673 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1478 Underwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6015261.6654 2093256.088 37.7285400265271 -122.389481312404 (37.7285400265271, -122.389481312404) 10 3 8 58 1
122362 200782 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1620 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6015278.1538 2096038.7748 37.7361816375316 -122.389618578423 (37.7361816375316, -122.389618578423) 10 3 8 58 1
173294 200046 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1567 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6015241.3298 2094241.268 37.7312440056702 -122.389620392742 (37.7312440056702, -122.389620392742) 10 3 8 58 1
122181 196090 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 888 Tennessee St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6015457.19385 2104954.19153 37.7606714353517 -122.389622035738 (37.7606714353517, -122.389622035738) 10 3 8 28856 29
19250 79912 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 888 Tennessee St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6015455.9807 2104968.54211 37.7607107716933 -122.389627233809 (37.7607107716933, -122.389627233809) 10 3 8 28856 29
1074 80599 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 888 Tennessee St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6015456.30873 2104984.78613 37.7607553924711 -122.389627233831 (37.7607553924711, -122.389627233831) 10 3 8 28856 29
13264 80600 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 888 Tennessee St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6015454.07391 2105001.72353 37.7608017750127 -122.389636146116 (37.7608017750127, -122.389636146116) 10 3 8 28856 29
13510 80601 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 888 Tennessee St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6015453.52186 2105016.91626 37.7608434603734 -122.38963911655 (37.7608434603734, -122.38963911655) 10 3 8 28856 29
19441 80602 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 888 Tennessee St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6015452.48136 2105039.81643 37.7609062816229 -122.389644314657 (37.7609062816229, -122.389644314657) 10 3 8 28856 29
13003 80604 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 888 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6015452.956 2105074.08431 37.7610004001733 -122.389645066492 (37.7610004001733, -122.389645066492) 10 3 8 28856 29
8811 80603 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 888 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6015452.3757 2105055.85533 37.7609503151357 -122.389645800319 (37.7609503151357, -122.389645800319) 10 3 8 28856 29
72891 196079 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1301 Minnesota St 8 Front Yard : Yard Tree Private 2     5     6015395.01764 2102273.41777 37.75330715422 -122.389649840082 (37.75330715422, -122.389649840082) 10 3 8 28856 29
120197 196078 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1301 Minnesota St 7 Front Yard : Yard Tree Private 2     4     6015385.56179 2102265.48112 37.7532848375261 -122.389681986358 (37.7532848375261, -122.389681986358) 10 3 8 28856 29
85672 38577 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1535 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 6   Permit Number 40537 6015234.7344 2094950.5426 37.733191164968 -122.389692714774 (37.733191164968, -122.389692714774) 10 3 8 58 1
33841 38588 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1601 Quesada Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40543 6015225.14493834 2094611.56119995 37.7322598587405 -122.389702200572 (37.7322598587405, -122.389702200572) 10 3 8 58 1
156659 38583 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1601 Quesada Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40543 6015225.14493834 2094611.56119995 37.7322598587405 -122.389702200572 (37.7322598587405, -122.389702200572) 10 3 8 58 1
101748 196081 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1301 Minnesota St 27 Front Yard : Yard Tree Private 2     6     6015382.92285 2102459.87565 37.7538184574574 -122.389704688841 (37.7538184574574, -122.389704688841) 10 3 8 28856 29
33996 196080 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1301 Minnesota St 26 Front Yard : Yard Tree Private 2     4     6015379.26469 2102450.5128 37.7537925462017 -122.389716685804 (37.7537925462017, -122.389716685804) 10 3 8 28856 29
48179 38589 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1606 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 6   Permit Number 40544 6015214.8687 2094687.4678 37.7324677131079 -122.389743028049 (37.7324677131079, -122.389743028049) 10 3 8 58 1
176962 200044 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1600 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6015203.4065 2094586.9741 37.732191142068 -122.389775639203 (37.732191142068, -122.389775639203) 10 3 8 58 1
114213 38584 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1601 Quesada Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 6   Permit Number 40543 6015197.8625 2094625.984 37.7322979479453 -122.389797530007 (37.7322979479453, -122.389797530007) 10 3 8 58 1
106351 200045 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1600 Lane St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015192.9639 2094571.5849 37.732148307342 -122.389810667389 (37.732148307342, -122.389810667389) 10 3 8 58 1
12620 83942 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1118 Fitzgerald Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6015103.3012 2090231.7832 37.7202271035042 -122.389817632552 (37.7202271035042, -122.389817632552) 10 3 8 58 1
182048 49810 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 820 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2003 12:00:00 AM 6   Permit Number 46603 6015372.07913 2103953.65706 37.7579194622409 -122.389846522708 (37.7579194622409, -122.389846522708) 10 3 8 28856 29
38834 38585 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1601 Quesada Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 3   Permit Number 40543 6015181.5104 2094639.0656 37.7323329605685 -122.389854976867 (37.7323329605685, -122.389854976867) 10 3 8 58 1
78506 256036 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1547 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x4   6015167 2093924 37.7303687297494 -122.389855213397 (37.7303687297494, -122.389855213397) 10 3 8 58 1

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