7,322 rows where qSpecies_id = 1 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)
90 259864 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1398x Brussels St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
1095 255202 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
1138 260594 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3090x Jennings St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
2475 259866 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 101x Desmond St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
4112 255223 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1051 Silver Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
6640 255204 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 5 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
6981 259867 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 101x Desmond St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
7570 36838 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
7587 259089 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1201 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2019 12:00:00 AM 3                        
7844 36854 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
8196 255225 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 400 Bacon St 6 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
8832 260593 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3090x Jennings St 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
10581 260591 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3090x Jennings St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
11185 98268 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 401X Esmeralda Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3                      
11245 255201 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
11633 259865 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 101x Desmond St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
11767 255200 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
12758 260592 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 3090x Jennings St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
13636 36840 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   6 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
13881 255222 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1051 Silver Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
14357 36839 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   5 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
14394 36837 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   3 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
15903 255203 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 301X Burrows St 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
18459 36836 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
47671 201529 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 718 Innes Ave 1 : Tree Private 2     5 Width 3ft   6020227.99181 2093752.40727 37.7301769329099 -122.372346575457 (37.7301769329099, -122.372346575457) 10 3 8 58 1
179713 201531 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 724 Innes Ave 3 : Tree Private 2     5 Width 3ft   6020190.28523 2093779.82824 37.7302501539023 -122.372478830631 (37.7302501539023, -122.372478830631) 10 3 8 58 1
121044 201654 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 744 Innes Ave 2 : Tree Private 2     3 Width 3ft   6020169.84192 2093795.17741 37.73029117649 -122.372550568669 (37.73029117649, -122.372550568669) 10 3 8 58 1
135620 201482 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 801 Arelious Walker Dr 1 : Tree Private 2     4 Width 3ft   6019833.06925 2094138.86397 37.7312163630497 -122.373738644125 (37.7312163630497, -122.373738644125) 10 3 8 58 1
190629 201483 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 801 Arelious Walker Dr 2 : Tree Private 2     5 Width 3ft   6019824.35428 2094127.54266 37.7311847977227 -122.373767989919 (37.7311847977227, -122.373767989919) 10 3 8 58 1
145414 201484 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 801 Arelious Walker Dr 3 : Tree Private 2     4 Width 3ft   6019815.12004 2094115.72508 37.731151841174 -122.37379909656 (37.731151841174, -122.37379909656) 10 3 8 58 1
170863 201485 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 801 Arelious Walker Dr 4 : Tree Private 2     4 Width 3ft   6019804.87091 2094104.0965 37.7311193477698 -122.373833724951 (37.7311193477698, -122.373833724951) 10 3 8 58 1
80105 50769 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 800 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2004 12:00:00 AM 5   Permit Number 47301 6019759.98299 2094100.60005 37.7311072788765 -122.373988670067 (37.7311072788765, -122.373988670067) 10 3 8 58 1
91149 50770 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 800 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2004 12:00:00 AM 5   Permit Number 47301 6019742.9176 2094113.11365 37.7311407003688 -122.374048535228 (37.7311407003688, -122.374048535228) 10 3 8 58 1
116756 50768 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 800 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2004 12:00:00 AM 5   Permit Number 47301 6019728.52002 2094123.20714 37.7311676233867 -122.374099009669 (37.7311676233867, -122.374099009669) 10 3 8 58 1
70973 44524 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 828 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2001 12:00:00 AM 7   Permit Number 43824 6019592.36733 2094224.82973 37.73143917097 -122.374576757438 (37.73143917097, -122.374576757438) 10 3 8 58 1
29584 44522 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 828 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2001 12:00:00 AM 7   Permit Number 43824 6019580.98035 2094232.66529 37.7314600595298 -122.374616667546 (37.7314600595298, -122.374616667546) 10 3 8 58 1
101103 44521 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 828 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2001 12:00:00 AM 7   Permit Number 43824 6019557.73451 2094250.20491 37.731506941191 -122.37469824865 (37.731506941191, -122.37469824865) 10 3 8 58 1
175923 44523 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 828 Innes Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2001 12:00:00 AM 6   Permit Number 43824 6019546.1676 2094257.53708 37.7315264375989 -122.374738746021 (37.7315264375989, -122.374738746021) 10 3 8 58 1
120267 39997 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 871 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 5   Permit Number 41255 6019390.138 2094293.55208 37.7316167430098 -122.375280672083 (37.7316167430098, -122.375280672083) 10 3 8 58 1
130172 201486 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 934 Innes Ave 1 : Tree Private 2     6 Width 3ft   6019032.21192 2094642.96183 37.7325564518085 -122.376542332772 (37.7325564518085, -122.376542332772) 10 3 8 58 1
114163 198240 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 8 Navy Rd 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6018392.06905 2093389.29244 37.7290788489885 -122.378668465002 (37.7290788489885, -122.378668465002) 10 3 8 58 1
109812 198241 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 8 Navy Rd 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6018372.24066 2093404.16555 37.7291185945476 -122.37873804643 (37.7291185945476, -122.37873804643) 10 3 8 58 1
17664 198242 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 8 Navy Rd 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6018274.99402 2093475.43151 37.7293089153583 -122.379079187167 (37.7293089153583, -122.379079187167) 10 3 8 58 1
116511 198243 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 8 Navy Rd 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6018259.02203 2093487.44362 37.7293410175719 -122.379135238328 (37.7293410175719, -122.379135238328) 10 3 8 58 1
66635 198244 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 8 Navy Rd 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6018235.60587 2093504.61605 37.7293868784964 -122.37921738328 (37.7293868784964, -122.37921738328) 10 3 8 58 1
101478 198253 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1000 Oakdale Ave 1 Sidewalk: Property side : Yard Tree Private 2     2     6018226.96048 2093133.19997 37.7283665652516 -122.3792214842 (37.7283665652516, -122.3792214842) 10 3 8 58 1
33307 40025 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 201 Middle Point Rd 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM     Permit Number 41269 6018237.8883759 2095348.52577329 37.7344500201686 -122.379337522448 (37.7344500201686, -122.379337522448) 10 3 8 58 1
23029 40024 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 201 Middle Point Rd 1 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1999 12:00:00 AM 5   Permit Number 41269 6018160.1485 2095159.94367 37.7339279233224 -122.379593200966 (37.7339279233224, -122.379593200966) 10 3 8 58 1
42592 198245 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 8 Navy Rd 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6018124.21492 2093586.99661 37.7296069363141 -122.379608197172 (37.7296069363141, -122.379608197172) 10 3 8 58 1
7732 198246 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 8 Navy Rd 7 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6018108.95866 2093601.24715 37.7296452240452 -122.379661929856 (37.7296452240452, -122.379661929856) 10 3 8 58 1
79368 198247 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 8 Navy Rd 8 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6018027.1823 2093649.37702 37.7297728684077 -122.379947985316 (37.7297728684077, -122.379947985316) 10 3 8 58 1
140754 198252 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 9 Navy Rd 8 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6018004.94787 2093626.47377 37.729708753948 -122.380023262182 (37.729708753948, -122.380023262182) 10 3 8 58 1
70847 198248 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 8 Navy Rd 9 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6018004.07949 2093668.21342 37.7298233149865 -122.380029163529 (37.7298233149865, -122.380029163529) 10 3 8 58 1
137571 198251 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 9 Navy Rd 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6017988.84232 2093636.41123 37.7297351517574 -122.380079631679 (37.7297351517574, -122.380079631679) 10 3 8 58 1
54859 198249 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 8 Navy Rd 10 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6017983.9946 2093684.20523 37.7298661173183 -122.380099710848 (37.7298661173183, -122.380099710848) 10 3 8 58 1
186767 198250 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 9 Navy Rd 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6017965.73277 2093650.12136 37.7297715221359 -122.380160477146 (37.7297715221359, -122.380160477146) 10 3 8 58 1
81925 10776 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1120X Hudson Ave 50 Sidewalk: Property side : Cutout Tree DPW 1   10/26/2011 12:00:00 AM 3 3x4   6017909.652863 2094654.0666341 37.7325250651963 -122.380424102302 (37.7325250651963, -122.380424102302) 10 3 8 58 1
135373 10773 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1120X Hudson Ave 46 Sidewalk: Curb side : Cutout Tree DPW 1   08/06/2014 12:00:00 AM 3 3x4   6017909.652863 2094654.0666341 37.7325250651963 -122.380424102302 (37.7325250651963, -122.380424102302) 10 3 8 58 1
140386 10816 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1139X Hudson Ave 23 Sidewalk: Curb side : Cutout Tree DPW 1   05/26/2016 12:00:00 AM 3 3X4   6017660.05601 2094705.99201 37.7326538662851 -122.381290636609 (37.7326538662851, -122.381290636609) 10 3 8 58 1
150455 198204 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017617.61765 2094076.09309 37.7309219447941 -122.381393571762 (37.7309219447941, -122.381393571762) 10 3 8 58 1
32444 198205 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017610.72061 2094103.62702 37.7309971667896 -122.381419330162 (37.7309971667896, -122.381419330162) 10 3 8 58 1
177471 198206 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017603.66847 2094123.45902 37.7310512322275 -122.381445089439 (37.7310512322275, -122.381445089439) 10 3 8 58 1
104498 11987 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 14 Sidewalk: Curb side : Cutout Tree DPW 1   03/10/2007 12:00:00 AM 8 3X3   6017600.71436 2094154.15579 37.7311353564368 -122.381457436259 (37.7311353564368, -122.381457436259) 10 3 8 58 1
117592 198207 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017596.20961 2094137.30678 37.7310888436561 -122.381471838877 (37.7310888436561, -122.381471838877) 10 3 8 58 1
104447 198208 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017595.32178 2094150.16595 37.731124103395 -122.381475802191 (37.731124103395, -122.381475802191) 10 3 8 58 1
58758 198210 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017591.47203 2094158.23368 37.7311460432509 -122.381489672414 (37.7311460432509, -122.381489672414) 10 3 8 58 1
34830 198209 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017589.5812 2094149.71082 37.7311225367566 -122.381495616943 (37.7311225367566, -122.381495616943) 10 3 8 58 1
125714 198211 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017584.56283 2094156.6603 37.7311413415942 -122.381513449601 (37.7311413415942, -122.381513449601) 10 3 8 58 1
52826 198213 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017583.92738 2094182.07075 37.7312110786156 -122.381517412923 (37.7312110786156, -122.381517412923) 10 3 8 58 1
117666 198212 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017582.25427 2094170.11891 37.7311781688352 -122.381522366373 (37.7311781688352, -122.381522366373) 10 3 8 58 1
120722 198214 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017573.17419 2094188.8506 37.7312291010462 -122.381555060321 (37.7312291010462, -122.381555060321) 10 3 8 58 1
154434 198215 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 18 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017571.31227 2094196.02188 37.7312486891707 -122.381561995911 (37.7312486891707, -122.381561995911) 10 3 8 58 1
54079 198216 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 19 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017566.99818 2094195.2528 37.7312463392341 -122.381576857185 (37.7312463392341, -122.381576857185) 10 3 8 58 1
111493 198217 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 21 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017560.86831 2094203.93694 37.7312698457244 -122.381598653182 (37.7312698457244, -122.381598653182) 10 3 8 58 1
165565 198218 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 23 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017554.24593 2094216.62614 37.7313043221245 -122.38162243034 (37.7313043221245, -122.38162243034) 10 3 8 58 1
96480 198219 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 24 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017539.02456 2094243.47133 37.7313771932863 -122.381676920275 (37.7313771932863, -122.381676920275) 10 3 8 58 1
108393 251275 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1175x Hudson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 09/16/2011 12:00:00 AM   3x3   6017547 2094834 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626) 10 3 8 58 1
112603 251276 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1175X Hudson Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1 Private 03/09/1998 12:00:00 AM   3x3   6017547 2094834 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626) 10 3 8 58 1
60837 10870 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1175X Hudson Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   09/16/2011 12:00:00 AM 3 3x4   6017544.4990408 2094830.7506973 37.7329900490522 -122.381698823278 (37.7329900490522, -122.381698823278) 10 3 8 58 1
99317 10868 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1175X Hudson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/16/2011 12:00:00 AM 3 3x3   6017544.4990408 2094830.7506973 37.7329900490522 -122.381698823278 (37.7329900490522, -122.381698823278) 10 3 8 58 1
125500 10869 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1175X Hudson Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/16/2011 12:00:00 AM 3 3X4   6017544.4990408 2094830.7506973 37.7329900490522 -122.381698823278 (37.7329900490522, -122.381698823278) 10 3 8 58 1
21398 198220 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1189 La Salle Ave 25 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017527.03397 2094259.97838 37.7314218563182 -122.381719522035 (37.7314218563182, -122.381719522035) 10 3 8 58 1
36773 198221 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1195 La Salle Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017501.61868 2094293.31317 37.731511983695 -122.381809706051 (37.731511983695, -122.381809706051) 10 3 8 58 1
167033 198222 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1195 La Salle Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017496.04751 2094298.34465 37.7315254915072 -122.381829316683 (37.7315254915072, -122.381829316683) 10 3 8 58 1
168876 198203 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1194 La Salle Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017493.49527 2094230.97474 37.7313403660485 -122.381833456249 (37.7313403660485, -122.381833456249) 10 3 8 58 1
148380 198223 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1195 La Salle Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017491.0802 2094306.09719 37.7315465041574 -122.381847028833 (37.7315465041574, -122.381847028833) 10 3 8 58 1
128887 198224 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1195 La Salle Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017481.22582 2094316.49879 37.7315745207288 -122.381881820907 (37.7315745207288, -122.381881820907) 10 3 8 58 1
30815 11993 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 20 Sidewalk: Curb side : Cutout Tree DPW 1   11/08/2011 12:00:00 AM 3 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
67403 11984 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
86089 11996 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 23 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
103053 11982 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
116344 11994 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 21 Sidewalk: Curb side : Cutout Tree DPW 1   03/10/2007 12:00:00 AM 3 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
120023 11980 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   03/10/2007 12:00:00 AM 8 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
120067 11990 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 17 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
123614 11975 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/28/2016 02:52:00 PM 3 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
133973 11989 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 16 Sidewalk: Curb side : Cutout Tree DPW 1   03/10/2007 12:00:00 AM 8 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
140794 11986 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
146427 11998 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 25 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
158677 11997 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 24 Sidewalk: Curb side : Cutout Tree DPW 1   03/10/2007 12:00:00 AM 3 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 10 3 8 58 1
161946 26533 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1200X La Salle Ave 27 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6017464.4799176 2094331.6246005 37.7316151284675 -122.381940767084 (37.7316151284675, -122.381940767084) 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)
);