trees

1,521 rows where qSpecies_id = 37 sorted by qSiteInfo descending

✎ 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)
8954 208076 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 442 Hearst Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 10ft   5998485.7432 2094410.13539 37.7307643520895 -122.447559384561 (37.7307643520895, -122.447559384561) 9 7 4 59 40
19211 208158 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 137 Staples Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   5999136.82993 2093762.64441 37.7290236809976 -122.445261947704 (37.7290236809976, -122.445261947704) 9 7 4 28861 40
20104 208150 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 210 Baden St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 2ft   6000776.72095 2094702.62319 37.7316981172754 -122.439660093143 (37.7316981172754, -122.439660093143) 9 7 4 63 40
23885 100248 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 15 Castenada Ave 2 Sidewalk: Property side : Yard Tree Private 2   07/31/2012 12:00:00 AM     Permit Number 768792 5994535.8 2101777 37.750765401507 -122.461748809074 (37.750765401507, -122.461748809074) 1 8 4 29491 40
34422 208149 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 137 Hamerton Ave 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6001382.20466 2095404.65674 37.7336601834577 -122.43761707629 (37.7336601834577, -122.43761707629) 9 7 5 63 40
36249 246617 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 179 Ripley St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   6009150.09993 2099139.59949 37.7443541262592 -122.411024805947 (37.7443541262592, -122.411024805947) 2 7 7 28859 2
40317 227544 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 288 Bemis St 1 Sidewalk: Property side : Yard Tree Private 2     10     6002936.87727 2096251.7785 37.7360744584526 -122.432302602791 (37.7360744584526, -122.432302602791) 2 7 5 63 7
46132 208154 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 523 Mangels Ave 2 Sidewalk: Property side : Yard Tree Private 2     5     5997951.24674 2095236.71061 37.7330033708131 -122.449466749514 (37.7330033708131, -122.449466749514) 9 7 4 59 40
49079 191124 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 601 Carolina St 6 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   6012423.59359 2105049.63029 37.760764811978 -122.400120660154 (37.760764811978, -122.400120660154) 10 3 8 28856 29
53629 246620 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 171 Ripley St 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6009078.77753 2099136.29589 37.7443410554863 -122.411271191437 (37.7443410554863, -122.411271191437) 2 7 7 28859 2
55576 208160 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 366 Judson Ave 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   5997663.54941 2093590.68698 37.7284673190039 -122.450342776414 (37.7284673190039, -122.450342776414) 9 7 4 28861 40
57928 100247 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 15 Castenada Ave 1 Sidewalk: Property side : Yard Tree Private 2   07/31/2012 12:00:00 AM     Permit Number 768792 5994535.8 2101777 37.750765401507 -122.461748809074 (37.750765401507, -122.461748809074) 1 8 4 29491 40
60848 208157 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 201 Joost Ave 3 Sidewalk: Property side : Yard Tree Private 2     14     6000676.4727 2094919.47544 37.7322878369069 -122.440022214175 (37.7322878369069, -122.440022214175) 9 7 4 63 40
78633 191135 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 651 Arthur Ave 1 Sidewalk: Property side : Yard Tree Private 2     9     6015829.29207 2099737.97336 37.7463694242077 -122.387971104383 (37.7463694242077, -122.387971104383) 10 3 8 58 1
109469 208155 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 523 Mangels Ave 3 Sidewalk: Property side : Yard Tree Private 2     4     5997950.37159 2095226.75519 37.7329759855362 -122.449469058051 (37.7329759855362, -122.449469058051) 9 7 4 59 40
113789 118454 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 8350 Geary Blvd 1 Sidewalk: Property side : Yard Tree Private 2     7     5981044.43167 2112373.02077 37.7790731383894 -122.509189086454 (37.7790731383894, -122.509189086454) 11 6 2 55 26
117977 120011 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 886 29th Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   5987003.60348 2109935.62097 37.7727302588392 -122.48839498846 (37.7727302588392, -122.48839498846) 11 6 2 55 26
121469 177152 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 649 Hamilton St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   6009816.38769 2091371.81115 37.7230627793063 -122.408173178961 (37.7230627793063, -122.408173178961) 10 3 7 309 28
125200 102105 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2104 Castro St 1 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 769122 6002645 2099438 37.7448065304391 -122.433539371895 (37.7448065304391, -122.433539371895) 2 7 5 63 22
129273 208153 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 435 Joost Ave 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   5999203.01227 2094950.22534 37.7322882775877 -122.445118495046 (37.7322882775877, -122.445118495046) 9 7 4 59 40
140735 191123 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 601 Carolina St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   6012425.58055 2105029.27463 37.7607090306229 -122.400112358502 (37.7607090306229, -122.400112358502) 10 3 8 28856 29
142456 227767 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 4475 24th St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 8ft   6000143.14107 2101645.63574 37.7507259002966 -122.442348757612 (37.7507259002966, -122.442348757612) 2 4 5 28862 22
148088 246619 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 171 Ripley St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6009083.01922 2099139.18453 37.7443492249476 -122.411256728527 (37.7443492249476, -122.411256728527) 2 7 7 28859 2
163589 227768 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 4475 24th St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6000154.6428 2101646.40611 37.7507286710937 -122.442309039053 (37.7507286710937, -122.442309039053) 2 4 5 28862 22
171614 208156 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 201 Joost Ave 1 Sidewalk: Property side : Yard Tree Private 2     15     6000658.62955 2094922.81838 37.732296000053 -122.440084141493 (37.732296000053, -122.440084141493) 9 7 4 63 40
172452 227822 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 146 Elsie St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 3ft   6007069.8584 2098388.70244 37.7421754574342 -122.418164635198 (37.7421754574342, -122.418164635198) 2 7 7 28859 2
174510 191137 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 651 Arthur Ave 3 Sidewalk: Property side : Yard Tree Private 2     11     6015869.60508 2099707.91773 37.7462891309579 -122.387829608652 (37.7462891309579, -122.387829608652) 10 3 8 58 1
181603 191136 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 651 Arthur Ave 2 Sidewalk: Property side : Yard Tree Private 2     7     6015849.43406 2099722.22691 37.7463273035772 -122.387900356534 (37.7463273035772, -122.387900356534) 10 3 8 58 1
187705 129722 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 998 Chestnut St 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 3ft   6007108.76695 2120556.67401 37.8030456187175 -122.419602556719 (37.8030456187175, -122.419602556719) 5 1 1 28858 32
187964 191142 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 3 Bryant St 2 Sidewalk: Property side : Yard Tree Private 2     16 Width 10ft   6015882.39445 2114438.56847 37.7867370114514 -122.388813583003 (37.7867370114514, -122.388813583003) 6 2 9 28855 6
190809 191141 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 3 Bryant St 1 Sidewalk: Property side : Yard Tree Private 2     15 Width 10ft   6015816.86409 2114381.01819 37.7865753592109 -122.389036284815 (37.7865753592109, -122.389036284815) 6 2 9 28855 6
41224 258232 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 1 Sidewalk: Property side : Cutout Tree Private 2   04/24/2019 12:00:00 AM 3 3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
53621 258239 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 8 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
67916 258235 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
71526 258236 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
103945 258237 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 6 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
120900 258240 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 9 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
138832 258234 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
155172 258233 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
160060 258238 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
2525 261765 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 301 Funston Ave 8 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   5991822 2113404 37.7825334415324 -122.471980622767 (37.7825334415324, -122.471980622767) 11 6 2 54 11
5179 261766 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 301 Funston Ave 7 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   5991822 2113404 37.7825334415324 -122.471980622767 (37.7825334415324, -122.471980622767) 11 6 2 54 11
9374 124022 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 301 Funston Ave 6 Sidewalk: Curb side : Yard Tree Private 2     18 Width 3ft   5991822 2113404 37.7825334415324 -122.471980622767 (37.7825334415324, -122.471980622767) 11 6 2 54 11
12974 191523 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1060 Tennessee St 3 Sidewalk: Curb side : Yard Tree Private 2     10 Width 7ft   6015501.46651 2104207.8933 37.7586247150714 -122.389416796942 (37.7586247150714, -122.389416796942) 10 3 8 28856 29
15728 208067 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 99 Marcela Ave 2 Sidewalk: Curb side : Yard Tree Private 2     18 Width 6ft   5994528.34567 2100501.93042 37.7472639537695 -122.461682148211 (37.7472639537695, -122.461682148211) 1 8 4 29491 40
18352 208066 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 99 Marcela Ave 3 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   5994517.25257 2100489.12784 37.7472281625491 -122.461719578921 (37.7472281625491, -122.461719578921) 1 8 4 29491 40
22293 218388 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 50 San Marcos Ave 10 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5993887.93086 2100247.90665 37.7465295835701 -122.463878201824 (37.7465295835701, -122.463878201824) 1 8 4 29491 40
24300 208134 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 55 Linares Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5993988.16475 2102163.97452 37.7517963948082 -122.463670648202 (37.7517963948082, -122.463670648202) 1 8 4 29491 40
25671 208132 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 55 Linares Ave 4 Sidewalk: Curb side : Yard Tree Private 2     16 Width 3ft   5994015.17426 2102138.30951 37.7517274815396 -122.46357538391 (37.7517274815396, -122.46357538391) 1 8 4 29491 40
29443 218332 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 490 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 0ft   5992960.68129 2099942.11399 37.7456364758511 -122.46706227402 (37.7456364758511, -122.46706227402) 1 8 4 29491 40
33076 227951 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 998 York St 7 Sidewalk: Curb side : Yard Tree Private 2     1 Width 7ft   6009943.61678 2103443.63273 37.7562165159053 -122.408584536948 (37.7562165159053, -122.408584536948) 2 4 7 28859 19
36906 208031 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1639 08th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5993679.79049 2104335.94155 37.7577422831841 -122.464894760398 (37.7577422831841, -122.464894760398) 1 8 4 56 12
38076 208105 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2339 Funston Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5992296.97523 2099528.1746 37.7444615718506 -122.469327124863 (37.7444615718506, -122.469327124863) 1 8 4 29491 40
38843 208104 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2349 Funston Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5992300.54287 2099449.80078 37.7442465835224 -122.469309085355 (37.7442465835224, -122.469309085355) 1 8 4 29491 40
39301 191549 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 880 Pennsylvania Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3     6014417.54899 2103314.92047 37.7561126486868 -122.393103023604 (37.7561126486868, -122.393103023604) 10 3 8 28856 29
42594 129704 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 3000 Washington St 3 Sidewalk: Curb side : Yard Tree Private 2     22 Width 3ft   6000269.52308 2116153.9558 37.7905693023891 -122.442953484235 (37.7905693023891, -122.442953484235) 13 6 1 29490 27
43452 208124 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Pacheco St 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994815.96906 2099777.31016 37.7452908807659 -122.460635072962 (37.7452908807659, -122.460635072962) 1 8 4 59 40
46851 208128 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 40 Alton Ave 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5994282.9508 2101575.27711 37.7501969631249 -122.462608546171 (37.7501969631249, -122.462608546171) 1 8 4 29491 40
47046 208127 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1980 08th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 3ft   5993803.24893 2102010.84689 37.7513652885894 -122.464298991018 (37.7513652885894, -122.464298991018) 1 8 4 29491 12
47564 208121 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Pacheco St 7 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5994733.18466 2099795.52601 37.7453361337673 -122.460922645565 (37.7453361337673, -122.460922645565) 1 8 4 59 40
53337 129702 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 3000 Washington St 1 Sidewalk: Curb side : Yard Tree Private 2     18 Width 3ft   6000294.26409 2116157.67676 37.7905809297121 -122.442868149367 (37.7905809297121, -122.442868149367) 13 6 1 29490 27
58293 208071 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 85 Marcela Ave 2 Sidewalk: Curb side : Yard Tree Private 2     20 Width 4ft   5994586.62981 2100556.35867 37.7474167548908 -122.461484552764 (37.7474167548908, -122.461484552764) 1 8 4 29491 40
64153 218321 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 414 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5993266.67171 2099966.5931 37.7457213466715 -122.466005992402 (37.7457213466715, -122.466005992402) 1 8 4 29491 40
64158 208139 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 15 Santa Rita Ave 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5993922.55414 2100955.02652 37.7484731507208 -122.463809795788 (37.7484731507208, -122.463809795788) 1 8 4 29491 40
65495 208046 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2356 Funston Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5992347.94359 2099384.54976 37.744070159914 -122.469140437284 (37.744070159914, -122.469140437284) 1 8 4 29491 40
70936 208117 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 210 Magellan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5994935.49087 2100588.28306 37.7475244846715 -122.460280535917 (37.7475244846715, -122.460280535917) 1 8 4 29491 40
74700 227939 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2706 Bryant St 2 Sidewalk: Curb side : Yard Tree Private 2     16 Width 5ft   6009765.64243 2101530.20177 37.7509526922342 -122.409065028537 (37.7509526922342, -122.409065028537) 2 4 7 28859 19
78933 208103 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2353 Funston Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5992301.03573 2099420.10379 37.7441650716512 -122.469305220056 (37.7441650716512, -122.469305220056) 1 8 4 29491 40
80454 191524 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1060 Tennessee St 4 Sidewalk: Curb side : Yard Tree Private 2     14 Width 7ft   6015503.99036 2104179.13483 37.7585458903883 -122.389406059945 (37.7585458903883, -122.389406059945) 10 3 8 28856 29
83334 208064 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 275 Pacheco St 5 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5994455.63892 2100507.88466 37.7472761170959 -122.461933992563 (37.7472761170959, -122.461933992563) 1 8 4 29491 40
83586 227786 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 399 Miguel St 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   6004409.26315 2096492.33537 37.7368183497736 -122.427229097246 (37.7368183497736, -122.427229097246) 2 7 5 63 7
93241 191550 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 880 Pennsylvania Ave 19 Sidewalk: Curb side : Yard Tree Private 2     4     6014425.29285 2102980.53312 37.7551949229254 -122.393052846823 (37.7551949229254, -122.393052846823) 10 3 8 28856 29
94938 208131 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 55 Linares Ave 6 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5994041.4329 2102104.78116 37.7516369342059 -122.463482145784 (37.7516369342059, -122.463482145784) 1 8 4 29491 40
97414 208130 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 45 Linares Ave 2 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   5994048.17405 2102062.90676 37.7515223461842 -122.463455795661 (37.7515223461842, -122.463455795661) 1 8 4 29491 40
101351 227909 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Mars St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5999636.04073 2105688.52616 37.7617977687831 -122.44439286176 (37.7617977687831, -122.44439286176) 15 5 5 28862 3
101935 208125 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5994834.63211 2099779.39133 37.7452976688552 -122.460570690481 (37.7452976688552, -122.460570690481) 1 8 4 59 40
102590 208126 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Merced Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5994854.63064 2099785.9766 37.7453169008687 -122.460502016464 (37.7453169008687, -122.460502016464) 1 8 4 59 40
103105 218235 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 359 Wawona St 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 2ft   5991961.59976 2097124.91171 37.7378434375183 -122.470311793456 (37.7378434375183, -122.470311793456) 1 8 4 59 40
104013 208070 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 85 Marcela Ave 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 4ft   5994562.00658 2100534.56463 37.7473554966651 -122.461568117774 (37.7473554966651, -122.461568117774) 1 8 4 29491 40
109019 208063 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 459 Pacheco St 4 Sidewalk: Curb side : Yard Tree Private 2     9 Width 6ft   5993844.11289 2101701.56795 37.7505184428887 -122.464135229877 (37.7505184428887, -122.464135229877) 1 8 4 29491 40
110659 208030 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1635 08th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     17 Width 4ft   5993680.60393 2104352.02929 37.7577865028534 -122.464893115536 (37.7577865028534, -122.464893115536) 1 8 4 56 12
110795 208129 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 14 Ventura Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5994035.37291 2102011.52015 37.7513805141114 -122.463496334396 (37.7513805141114, -122.463496334396) 1 8 4 29491 40
112654 227910 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Mars St 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5999624.8091 2105673.33115 37.7617554062204 -122.444430615295 (37.7617554062204, -122.444430615295) 15 5 5 28862 3
112901 191525 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1060 Tennessee St 5 Sidewalk: Curb side : Yard Tree Private 2     16 Width 7ft   6015505.26646 2104138.41993 37.7584341667224 -122.389398803331 (37.7584341667224, -122.389398803331) 10 3 8 28856 29
114908 227882 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 289 Cumberland St 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   6003790.18719 2104485.1298 37.7587296731616 -122.429939483918 (37.7587296731616, -122.429939483918) 2 4 5 28862 3
115798 208123 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Pacheco St 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994792.79131 2099776.97175 37.7452886180713 -122.460715192672 (37.7452886180713, -122.460715192672) 1 8 4 59 40
116593 208102 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2357 Funston Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5992303.47716 2099394.44752 37.7440947671662 -122.469294911154 (37.7440947671662, -122.469294911154) 1 8 4 29491 40
116829 208054 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1 San Fernando Way 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 8ft   5992102.39322 2096463.50196 37.736035512423 -122.46977686683 (37.736035512423, -122.46977686683) 1 8 4 59 40
118993 227785 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 399 Miguel St 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   6004415.35308 2096483.81995 37.7367953127564 -122.427207435297 (37.7367953127564, -122.427207435297) 2 7 5 63 7
119140 129705 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 3000 Washington St 4 Sidewalk: Curb side : Yard Tree Private 2     22 Width 3ft   6000256.311 2116152.53646 37.7905646519773 -122.442999095143 (37.7905646519773, -122.442999095143) 13 6 1 29490 27
120788 122999 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 42 07th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5993659.38134 2115213.58534 37.7876082185318 -122.465755648457 (37.7876082185318, -122.465755648457) 11 6 1 54 11
121463 218391 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 285 Castenada Ave 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5993948.05034 2100272.54982 37.7466007118532 -122.463672105083 (37.7466007118532, -122.463672105083) 1 8 4 29491 40
121698 227949 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 998 York St 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 7ft   6009941.58696 2103473.27819 37.7562978020158 -122.408593647988 (37.7562978020158, -122.408593647988) 2 4 7 28859 19
123489 208029 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1635 08th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     16 Width 4ft   5993680.14998 2104375.72277 37.7578515328401 -122.464896406148 (37.7578515328401, -122.464896406148) 1 8 4 56 12
125412 227950 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 998 York St 6 Sidewalk: Curb side : Yard Tree Private 2     2 Width 7ft   6009943.9384 2103453.89323 37.7562447069523 -122.408584148445 (37.7562447069523, -122.408584148445) 2 4 7 28859 19
130404 208068 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 99 Marcela Ave 4 Sidewalk: Curb side : Yard Tree Private 2     16 Width 6ft   5994541.71354 2100515.18677 37.7473011218565 -122.461636884428 (37.7473011218565, -122.461636884428) 1 8 4 29491 40
131148 208069 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 99 Marcela Ave 5 Sidewalk: Curb side : Yard Tree Private 2     16 Width 4ft   5994554.01203 2100525.45715 37.7473300296505 -122.461595101959 (37.7473300296505, -122.461595101959) 1 8 4 29491 40
132786 129703 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 3000 Washington St 2 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   6000282.93865 2116154.94774 37.790572790856 -122.442907138554 (37.790572790856, -122.442907138554) 13 6 1 29490 27
133321 227881 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 289 Cumberland St 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   6003777.05939 2104484.05048 37.7587259661441 -122.429984808871 (37.7587259661441, -122.429984808871) 2 4 5 28862 3
134757 208110 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 500 Cortes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     27 Width 3ft   5993194.87968 2099514.97531 37.7444771768975 -122.466221422307 (37.7444771768975, -122.466221422307) 1 8 4 29491 40

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