trees

1,521 rows where qSpecies_id = 37 sorted by qSiteInfo

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
9586 191511 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 392 04th St 2 : Tree Private 2   09/27/2001 12:00:00 AM 5 Width 3ft Permit Number 44376 6012652.22642 2112454.21838 37.7811088850041 -122.399849876973 (37.7811088850041, -122.399849876973) 6 2 9 28856 34
23162 250025 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Peter Yorke Way 4 : Tree Private 2     10 Width 4ft   6005592.08729 2114239.19437 37.7856138643192 -122.424401456086 (37.7856138643192, -122.424401456086) 13 9 1 28858 41
23195 250130 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1377 Post St 2 : Tree Private 2     8 Width 4ft   6005624.52501 2114452.88232 37.7862024301534 -122.424304434526 (37.7862024301534, -122.424304434526) 13 9 1 28858 41
36672 177150 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100 Junipero Serra Blvd 13 : Tree Private 2     3 Width 0ft   5991357.87274 2088731.5467 37.7147624226096 -122.471787632218 (37.7147624226096, -122.471787632218) 1 8 4 64 24
51684 217744 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 641 Frederick St 1 : Tree Private 2     14 Width 4ft   5996399.25713 2107269.94525 37.7659547311529 -122.455701855365 (37.7659547311529, -122.455701855365) 15 5 11 29492 12
60254 191513 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 392 04th St 4 : Tree Private 2     4 Width 3ft   6012406.96322 2112689.0006 37.7817398664304 -122.400714869196 (37.7817398664304, -122.400714869196) 6 2 9 28856 34
68045 177148 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100 Junipero Serra Blvd 11 : Tree Private 2     3 Width 0ft   5991345.1062 2088786.27049 37.7149119421181 -122.471835744134 (37.7149119421181, -122.471835744134) 1 8 4 64 24
80005 250029 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1398 Gough St 2 : Tree Private 2     7 Width 4ft   6005499.34318 2114400.53474 37.7860516273342 -122.424733805923 (37.7860516273342, -122.424733805923) 13 9 1 28858 41
95625 191514 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 392 04th St 5 : Tree Private 2     7 Width 3ft   6012567.22578 2112551.0938 37.7813701434666 -122.400150744271 (37.7813701434666, -122.400150744271) 6 2 9 28856 34
96000 250129 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1377 Post St 1 : Tree Private 2     8 Width 4ft   6005609.22184 2114451.02254 37.7861964595327 -122.424357247212 (37.7861964595327, -122.424357247212) 13 9 1 28858 41
111780 191512 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 392 04th St 3 : Tree Private 2     4 Width 3ft   6012624.81518 2112484.97223 37.7811917997912 -122.39994686706 (37.7811917997912, -122.39994686706) 6 2 9 28856 34
116981 250022 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Peter Yorke Way 1 : Tree Private 2     7 Width 3ft   6005626.62253 2114259.1773 37.7856706826127 -122.424283395778 (37.7856706826127, -122.424283395778) 13 9 1 28858 41
119263 250023 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Peter Yorke Way 2 : Tree Private 2     7 Width 3ft   6005617.72798 2114253.53243 37.7856546809565 -122.424313766772 (37.7856546809565, -122.424313766772) 13 9 1 28858 41
123135 246467 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 244 Duncan St 1 : Tree Private 2     8 Width 4ft   6004891.34106 2099910.06364 37.7462299051934 -122.425805538811 (37.7462299051934, -122.425805538811) 2 7 5 63 22
131746 250024 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Peter Yorke Way 3 : Tree Private 2     8 Width 3ft   6005604.61507 2114246.3062 37.7856340990685 -122.424358619563 (37.7856340990685, -122.424358619563) 13 9 1 28858 41
132331 217741 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 683 Frederick St 1 : Tree Private 2     10 Width 3ft   5996265.43539 2107251.80334 37.7658972375023 -122.456163402746 (37.7658972375023, -122.456163402746) 15 5 11 29492 12
139806 177149 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100 Junipero Serra Blvd 12 : Tree Private 2     3 Width 0ft   5991352.53535 2088761.36171 37.7148439785382 -122.471808251863 (37.7148439785382, -122.471808251863) 1 8 4 64 24
157131 250027 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1388 Gough St 2 : Tree Private 2     6 Width 4ft   6005504.43903 2114371.51964 37.7859722468757 -122.424714110791 (37.7859722468757, -122.424714110791) 13 9 1 28858 41
162347 249548 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1398 Gough St 3 : Tree Private 2     7 Width 4ft   6005498.68778 2114410.1852 37.7860780880862 -122.424736760212 (37.7860780880862, -122.424736760212) 13 9 1 28858 41
189847 191133 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 827 Wisconsin St 2 : Tree Private 2     5 Width 3ft   6012775.54197 2103646.67486 37.7569322215662 -122.398804956499 (37.7569322215662, -122.398804956499) 10 3 8 28856 29
9206 114067 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 6 Higuera Ave 1 Front Yard : Cutout Tree Private 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
69512 113042 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 500 Raymond Ave 1 Front Yard : Cutout Tree Private 2   10/06/2015 12:00:00 AM 30 3x3   6008233.87951 2088473.93147 37.7150170728648 -122.413438766187 (37.7150170728648, -122.413438766187) 9 7 8 309 18
9997 104935 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 835 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
10450 114373 Property Tree 8 Liquidambar styraciflua :: American Sweet Gum 37 805 GONZALEZ DR 1 Front Yard : Yard Tree Private 2     18     5988302 2089566 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247) 1 8 4 64 14
22765 191519 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1301 Minnesota St 72 Front Yard : Yard Tree Private 2     7     6015362.35528 2102287.9269 37.7533451820439 -122.38976380757 (37.7533451820439, -122.38976380757) 10 3 8 28856 29
36528 107066 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1758 12th Ave 1 Front Yard : Yard Tree Private 2   07/24/2014 12:00:00 AM     Permit Number 773344 5992506.32742 2103625.79831 37.7557246862805 -122.468901366602 (37.7557246862805, -122.468901366602) 1 8 4 56 12
39757 104892 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 201 Gonzalez Dr   Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
52794 191518 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1301 Minnesota St 71 Front Yard : Yard Tree Private 2     7     6015362.96067 2102295.09834 37.7533649068725 -122.389762214852 (37.7533649068725, -122.389762214852) 10 3 8 28856 29
66594 114103 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 5 ACEVEDO AVE 2 Front Yard : Yard Tree Private 2     15     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
83112 93724 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 415 Belvedere St   Front Yard : Yard Tree Private 2           5998488 2106798 37.7647785355325 -122.448443362436 (37.7647785355325, -122.448443362436) 15 5 11 29492 9
109420 114102 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 7 ACEVEDO AVE 1 Front Yard : Yard Tree Private 2     18     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
113390 104936 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 837 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
126137 104937 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 839 Gonzalez Dr 2 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
138477 104934 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 805 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
149040 114068 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 8 HIGUERA AVE 1 Front Yard : Yard Tree Private 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
1179 251578 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 6 Median : Cutout Tree DPW 1                              
7015 23789 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100X Webster St 4 Median : Cutout Tree DPW 1     20 20   6003791.7059 2112684.1999 37.7812424081927 -122.430519258933 (37.7812424081927, -122.430519258933) 15 9 11 29490 41
7994 200267 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 860x Jamestown Ave 4 Median : Cutout Tree DPW 1     1 Width 5ft   6014763.42943 2089103.48734 37.7171101711671 -122.39091365107 (37.7171101711671, -122.39091365107) 10 3 8 58 1
12842 23729 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 800X Webster St 4 Median : Cutout Tree DPW 1   04/21/2008 12:00:00 AM 3 6   6003943.6522 2111620.2321 37.7783296231018 -122.429917683229 (37.7783296231018, -122.429917683229) 7 9 11 29490 41
19164 208086 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 800x Junipero Serra Blvd 56 Median : Cutout Tree DPW 1     4 Width 0ft   5991357.47228 2092905.45971 37.7262229367261 -122.472093069866 (37.7262229367261, -122.472093069866) 9 8 4 59 40
21240 208084 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 800x Junipero Serra Blvd 53 Median : Cutout Tree DPW 1     4 Width 0ft   5991354.01147 2092835.9648 37.7260319207226 -122.47209997035 (37.7260319207226, -122.47209997035) 9 8 4 59 40
21450 208080 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000x Junipero Serra Blvd 1 Median : Cutout Tree DPW 1     4 Width 0ft   5991162.63824 2089810.37082 37.7177133113937 -122.472541042839 (37.7177133113937, -122.472541042839) 9 8 4 64 24
22634 23923 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1700X Webster St 5 Median : Cutout Tree DPW 1     30 12x1   6003454.8844904 2114845.825423 37.7871586020093 -122.431838884639 (37.7871586020093, -122.431838884639) 13 9 11 29490 27
23627 208082 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000x Junipero Serra Blvd 45 Median : Cutout Tree DPW 1     3 Width 0ft   5991232.00982 2090962.12018 37.7208797469797 -122.47238517505 (37.7208797469797, -122.47238517505) 9 8 4 64 24
23955 23757 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 900X Webster St 3 Median : Cutout Tree DPW 1     25 20   6003900.3372 2111922.0621 37.7791559204238 -122.430089063187 (37.7791559204238, -122.430089063187) 7 9 11 29490 41
25149 200272 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 920x Jamestown Ave 3 Median : Cutout Tree DPW 1     2 Width 5ft   6014501.14248 2089299.14768 37.7176328589541 -122.391833932714 (37.7176328589541, -122.391833932714) 10 3 8 58 1
26304 4719 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 6 Median : Cutout Tree DPW 1     70 3   6008486.129587 2120728.7244 37.803595514004 -122.414848331144 (37.803595514004, -122.414848331144) 5 1 10 308 23
26369 23922 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1700X Webster St 4 Median : Cutout Tree DPW 1   04/21/2008 12:00:00 AM 3 12x1   6003506.5026 2114704.4246 37.7867732770552 -122.431650198179 (37.7867732770552, -122.431650198179) 13 9 11 29490 27
26599 23790 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100X Webster St 5 Median : Cutout Tree DPW 1     20 20   6003786.8931 2112715.8268 37.7813289751352 -122.430538166219 (37.7813289751352, -122.430538166219) 15 9 11 29490 41
27816 23756 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 900X Webster St 2 Median : Cutout Tree DPW 1     25 20   6003937.3073429 2111811.4900601 37.7788544107823 -122.42995327885 (37.7788544107823, -122.42995327885) 7 9 11 29490 41
29036 23709 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 700X Webster St 4 Median : Cutout Tree DPW 1     16 20   6003970.4427 2111382.6873 37.7776789009548 -122.429808057223 (37.7776789009548, -122.429808057223) 7 9 11 28852 10
30780 23787 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100X Webster St 2 Median : Cutout Tree DPW 1   04/21/2008 12:00:00 AM 3 20   6003801.3315 2112607.883 37.7810334062767 -122.430480512141 (37.7810334062767, -122.430480512141) 15 9 11 29490 41
31190 254431 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1400X Junipero Serra Blvd 27 Median : Cutout Tree DPW 1       6X6   5991386.4673518 2088368.501669 37.71376724375 -122.471662357701 (37.71376724375, -122.471662357701) 1 8 4 64 14
32341 4731 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1175X Columbus Ave 2 Median : Cutout Tree DPW 1     14 3x3   6007886.21988 2121257.05551 37.8050124513131 -122.416961809043 (37.8050124513131, -122.416961809043) 5 1 10 308 32
32751 4718 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 5 Median : Cutout Tree DPW 1     80 3   6008205.1504 2120957.4944 37.8042078669522 -122.415836885075 (37.8042078669522, -122.415836885075) 5 1 10 308 23
34184 200271 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 920x Jamestown Ave 2 Median : Cutout Tree DPW 1     2 Width 5ft   6014518.22002 2089293.06186 37.7176170965211 -122.391774477626 (37.7176170965211, -122.391774477626) 10 3 8 58 1
34487 142721 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100x COLUMBUS AVE 1 Median : Cutout Tree DPW 1     17 Width 0ft   6008079.1516 2121077.7294 37.8045309177557 -122.416281435895 (37.8045309177557, -122.416281435895) 5 1 10 308 23
34668 4669 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 600X Columbus Ave 4 Median : Cutout Tree DPW 1   06/25/2014 12:00:00 AM 8 3 Permit Number 769286 6009537.0943 2119751.1708 37.8009703907309 -122.411142309711 (37.8009703907309, -122.411142309711) 3 1 10 308 23
38015 23758 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 900X Webster St 4 Median : Cutout Tree DPW 1     25 20   6003894.1493 2111953.6889 37.7792424093118 -122.430112726472 (37.7792424093118, -122.430112726472) 7 9 11 29490 41
40137 4634 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500X Columbus Ave 1 Median : Cutout Tree DPW 1   08/19/2006 12:00:00 AM 8 3   6010031.5482 2119295.5915 37.799747198685 -122.409399111615 (37.799747198685, -122.409399111615) 3 1 10 308 4
42227 23827 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1200X Webster St 6 Median : Cutout Tree DPW 1     20 20   6003747.0158 2113043.0957 37.7822253147353 -122.430699482992 (37.7822253147353, -122.430699482992) 15 9 11 29490 41
42311 142722 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100x COLUMBUS AVE 2 Median : Cutout Tree DPW 1     11 Width 0ft   6008044.6283 2121108.5348 37.8046135602745 -122.416403090609 (37.8046135602745, -122.416403090609) 5 1 10 308 23
43694 208081 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000x Junipero Serra Blvd 43 Median : Cutout Tree DPW 1     4 Width 0ft   5991233.74878 2090918.35178 37.7207596703961 -122.47237597497 (37.7207596703961, -122.47237597497) 9 8 4 64 24
44386 11765 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 800X Junipero Serra Blvd 3 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991272.34511 2091581.45548 37.7225826231682 -122.47229087392 (37.7225826231682, -122.47229087392) 9 8 4 59 40
46329 200274 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 920x Jamestown Ave 11 Median : Cutout Tree DPW 1     2 Width 5ft   6014408.16267 2089360.68754 37.7177966731557 -122.392159625791 (37.7177966731557, -122.392159625791) 10 3 8 58 1
47997 4675 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 700X Columbus Ave 2 Median : Cutout Tree DPW 1   04/06/2013 12:00:00 AM 3 3x3   6009477.5527626 2119836.3917307 37.8012010470299 -122.41135437342 (37.8012010470299, -122.41135437342) 3 1 10 308 23
49161 28651 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1600X Webster St 13 Median : Cutout Tree DPW 1     12 6   6003605.1476962 2114190.7261663 37.785368381567 -122.431272227533 (37.785368381567, -122.431272227533) 13 9 11 29490 13
49898 140552 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 800x WEBSTER ST 5 Median : Cutout Tree DPW 1     7 Width 0ft   6003932.6516 2111661.4845 37.7784422689986 -122.429958681781 (37.7784422689986, -122.429958681781) 7 9 11 29490 41
54955 23825 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1200X Webster St 4 Median : Cutout Tree DPW 1     30 20   6003756.6414 2112968.1539 37.7820200885965 -122.430660833336 (37.7820200885965, -122.430660833336) 15 9 11 29490 41
55502 200269 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 860x Jamestown Ave 11 Median : Cutout Tree DPW 1     2 Width 5ft   6014632.09061 2089229.78969 37.7174496841459 -122.391376454775 (37.7174496841459, -122.391376454775) 10 3 8 58 1
60062 11784 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 810X Junipero Serra Blvd 16 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 6X6   5991252.992504 2092079.9575241 37.7239502662313 -122.472394094235 (37.7239502662313, -122.472394094235) 9 8 4 64 40
63710 4716 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 3 Median : Cutout Tree DPW 1     70 3   6008306.8566 2120868.0824 37.8039680812692 -122.415478587922 (37.8039680812692, -122.415478587922) 5 1 10 308 23
63732 23791 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100X Webster St 6 Median : Cutout Tree DPW 1     3 20   6003783.4554 2112735.7654 37.7813835268154 -122.430551482109 (37.7813835268154, -122.430551482109) 15 9 11 29490 41
65821 4736 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1100X Columbus Ave 7 Median : Cutout Tree DPW 1     60 3x3   6008154.5819477 2121037.0963081 37.8044235907504 -122.41601752221 (37.8044235907504, -122.41601752221) 5 1 10 308 23
66816 200270 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 860x Jamestown Ave 12 Median : Cutout Tree DPW 1     2 Width 5ft   6014621.84489 2089234.87823 37.7174630876267 -122.39141222532 (37.7174630876267, -122.39141222532) 10 3 8 58 1
72793 4635 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500X Columbus Ave 2 Median : Cutout Tree DPW 1   01/05/1990 12:00:00 AM 35 3   6010009.8735 2119314.4873 37.7997978674726 -122.409475448708 (37.7997978674726, -122.409475448708) 3 1 10 308 4
73122 4679 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 700X Columbus Ave 6 Median : Cutout Tree DPW 1   08/19/2006 12:00:00 AM 6 3x3   6009212.7257 2120043.218 37.8017540838713 -122.412285420728 (37.8017540838713, -122.412285420728) 3 1 10 308 4
73290 4674 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 700X Columbus Ave 1 Median : Cutout Tree DPW 1   09/05/1991 12:00:00 AM 15 3x4   6009400.8826 2119872.8379 37.8012968187356 -122.411622263241 (37.8012968187356, -122.411622263241) 3 1 10 308 23
74458 4670 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 610X Columbus Ave 5 Median : Cutout Tree DPW 1   02/13/2003 12:00:00 AM 12 3   6009783.7006387 2119558.1544154 37.8004542419844 -122.41027530759 (37.8004542419844, -122.41027530759) 3 1 10 308 23
79315 4668 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 600X Columbus Ave 3 Median : Cutout Tree DPW 1     60 3   6009590.6555 2119701.3035 37.8008364710267 -122.410953440286 (37.8008364710267, -122.410953440286) 3 1 10 308 23
79376 208089 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500x Junipero Serra Blvd 42 Median : Cutout Tree DPW 1     3 Width 0ft   5991450.70341 2094361.73246 37.7302268929437 -122.471876866532 (37.7302268929437, -122.471876866532) 9 8 4 59 40
81793 140551 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 800x WEBSTER ST 3 Median : Cutout Tree DPW 1     9 Width 0ft   6003947.0899 2111598.2308 37.7782694076565 -122.42990422118 (37.7782694076565, -122.42990422118) 7 9 11 29490 41
81901 4714 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 1 Median : Cutout Tree DPW 1     80 3   6008373.9156 2120808.2881 37.8038076701269 -122.415242289828 (37.8038076701269, -122.415242289828) 5 1 10 308 23
82281 23879 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1500X Webster St 2 Median : Cutout Tree DPW 1     20 4   6003644.6262703 2113904.6308207 37.7845850728987 -122.431115216253 (37.7845850728987, -122.431115216253) 13 9 11 29490 41
85192 200264 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 828x Jamestown Ave 6 Median : Cutout Tree DPW 1     2 Width 5ft   6014856.83731 2088987.16565 37.71679595705 -122.390582658263 (37.71679595705, -122.390582658263) 10 3 8 58 1
85327 29978 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 610X Junipero Serra Blvd 5 Median : Cutout Tree DPW 1   04/01/2007 12:00:00 AM 3 3x3   5991336.00972369 2093444.32433125 37.7277012826104 -122.47220652658 (37.7277012826104, -122.47220652658) 9 8 4 64 40
86277 137952 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1700x WEBSTER ST 3 Median : Cutout Tree DPW 1     13 Width 0ft   6003511.8133 2114663.5551 37.7866613607529 -122.431628905483 (37.7866613607529, -122.431628905483) 13 9 11 29490 27
87852 208088 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500x Junipero Serra Blvd 40 Median : Cutout Tree DPW 1     3 Width 0ft   5991446.48536 2094319.42031 37.7301104703116 -122.471888366152 (37.7301104703116, -122.471888366152) 9 8 4 64 40
88022 200266 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 860x Jamestown Ave 3 Median : Cutout Tree DPW 1     2 Width 5ft   6014773.14657 2089094.60205 37.7170863130726 -122.39087944265 (37.7170863130726, -122.39087944265) 10 3 8 58 1
88815 208083 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000x Junipero Serra Blvd 46 Median : Cutout Tree DPW 1     3 Width 0ft   5991231.05658 2090980.0304 37.7209288688539 -122.472389775075 (37.7209288688539, -122.472389775075) 9 8 4 64 24
89021 23828 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1200X Webster St 7 Median : Cutout Tree DPW 1     20 20   6003742.203 2113074.035 37.7823099936559 -122.430718341656 (37.7823099936559, -122.430718341656) 15 9 11 29490 41
89974 23731 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 800X Webster St 6 Median : Cutout Tree DPW 1     6 20   6003929.9014 2111682.7982 37.7785006353915 -122.429969716521 (37.7785006353915, -122.429969716521) 7 9 11 29490 41
91716 254432 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1400X Junipero Serra Blvd 28 Median : Cutout Tree DPW 1       6X6   5991386.4673518 2088368.501669 37.71376724375 -122.471662357701 (37.71376724375, -122.471662357701) 1 8 4 64 14
95326 4717 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1000X Columbus Ave 4 Median : Cutout Tree DPW 1   08/19/2006 12:00:00 AM 6 3   6008242.0329 2120925.0825 37.804120945419 -122.415706953629 (37.804120945419, -122.415706953629) 5 1 10 308 23
99812 29979 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 610X Junipero Serra Blvd 6 Median : Cutout Tree DPW 1   04/01/2007 12:00:00 AM 3 3x3   5991336.00972369 2093444.32433125 37.7277012826104 -122.47220652658 (37.7277012826104, -122.47220652658) 9 8 4 64 40
101357 23727 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 800X Webster St 2 Median : Cutout Tree DPW 1   04/21/2008 12:00:00 AM 3 6   6003949.8401 2111575.542 37.7782072655707 -122.429893088415 (37.7782072655707, -122.429893088415) 7 9 11 29490 41
102116 29580 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500X Junipero Serra Blvd 2 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991386.6913 2093344.77478 37.7274308773069 -122.47202406848 (37.7274308773069, -122.47202406848) 9 8 4 59 40
102451 200263 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 828x Jamestown Ave 2 Median : Cutout Tree DPW 1     2 Width 5ft   6014881.06262 2088948.3619 37.7166907534629 -122.390496212748 (37.7166907534629, -122.390496212748) 10 3 8 58 1
103852 208087 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500x Junipero Serra Blvd 5 Median : Cutout Tree DPW 1     3 Width 0ft   5991392.30049 2093421.51137 37.7276419014288 -122.472010268365 (37.7276419014288, -122.472010268365) 9 8 4 59 40
104796 4667 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 600X Columbus Ave 2 Median : Cutout Tree DPW 1   10/03/2012 12:00:00 AM 12 3 Permit Number 769286 6009690.8519 2119608.7257 37.8005878932088 -122.410600176031 (37.8005878932088, -122.410600176031) 3 1 10 308 23

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