trees

1,521 rows where qSpecies_id = 37 sorted by PlotSize 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)
55461 98269 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 2700 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   within landscape plot Permit Number 768491 6009963 2103401 37.7561005415225 -122.40851449565 (37.7561005415225, -122.40851449565) 2 4 7 28859 19
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
93196 227940 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2814 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 8ft   6009799.68867 2100909.26557 37.7492496460683 -122.40890348783 (37.7492496460683, -122.40890348783) 2 4 7 28859 19
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
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
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
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
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
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
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
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
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
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
165061 227948 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 998 York St 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 7ft   6009941.19062 2103487.16009 37.7563358964054 -122.40859599791 (37.7563358964054, -122.40859599791) 2 4 7 28859 19
183252 227947 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2700 22nd St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 7ft   6009924.71933 2103404.59086 37.7561082572986 -122.408647136979 (37.7561082572986, -122.408647136979) 2 4 7 28859 19
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
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
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
57628 227543 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2 Trainor St 7 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 6ft   6008303.69339 2108185.76376 37.7691453333233 -122.414591532495 (37.7691453333233, -122.414591532495) 8 4 7 28853 19
87439 177153 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 701 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6002643.53653 2087345.72166 37.7116037832707 -122.432680809094 (37.7116037832707, -122.432680809094) 9 7 6 28861 5
93989 227985 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 222 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 6ft   6004405.37253 2099591.374 37.7453273824517 -122.427463259139 (37.7453273824517, -122.427463259139) 2 7 5 63 22
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
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
146645 227999 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1227 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 6ft   5997427.0236 2105612.47787 37.7614626741762 -122.452027445805 (37.7614626741762, -122.452027445805) 15 5 11 29492 12
2898 191530 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016138.64503 2107209.62915 37.7669021444474 -122.387422526024 (37.7669021444474, -122.387422526024) 14 3 9 310 20
3180 191527 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016025.61335 2107205.30438 37.7668840087222 -122.387813186138 (37.7668840087222, -122.387813186138) 14 3 9 310 20
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
8331 191528 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2017 12:00:00 AM 3 Width 5ft   6016052.47786 2107208.19392 37.76689343092 -122.387720466935 (37.76689343092, -122.387720466935) 14 3 9 310 20
10235 191533 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016236.27796 2107216.03359 37.7669251365154 -122.387085273085 (37.7669251365154, -122.387085273085) 14 3 9 310 20
11397 191531 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016181.25153 2107212.70143 37.7669129399083 -122.387275369984 (37.7669129399083, -122.387275369984) 14 3 9 310 20
18111 191532 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6016209.16515 2107214.5091 37.766919449199 -122.38717894647 (37.766919449199, -122.38717894647) 14 3 9 310 20
18958 191526 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015996.43331 2107204.26168 37.7668795291963 -122.387914043316 (37.7668795291963, -122.387914043316) 14 3 9 310 20
19392 191529 Private 9 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6016082.02245 2107209.57323 37.7668988547309 -122.387618372283 (37.7668988547309, -122.387618372283) 14 3 9 310 20
20496 227860 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 25 Vicksburg St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6004105.03193 2102887.37623 37.7543604446946 -122.428736707235 (37.7543604446946, -122.428736707235) 2 4 5 28862 22
20548 227945 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2291 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6009688.46278 2104079.31961 37.7579476757639 -122.409511813513 (37.7579476757639, -122.409511813513) 2 4 7 28859 19
22486 129699 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2970 Washington St 8 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6000522.03452 2116191.05959 37.7906855730291 -122.442082476442 (37.7906855730291, -122.442082476442) 13 6 1 29490 27
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
26220 227861 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 21 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6004103.93841 2102899.42438 37.7543934641903 -122.428741347735 (37.7543934641903, -122.428741347735) 2 4 5 28862 22
30121 227958 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 3627 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6005410.51247 2104865.85603 37.7598666869207 -122.424362729462 (37.7598666869207, -122.424362729462) 2 4 5 28859 19
32347 228000 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1229 Stanyan St 2 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 5ft   5997430.92734 2105573.73546 37.7613565209159 -122.452011149197 (37.7613565209159, -122.452011149197) 15 5 11 29492 12
34101 191534 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 201 16th St 9 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6016265.97367 2107216.92727 37.7669292347089 -122.386982621765 (37.7669292347089, -122.386982621765) 14 3 9 310 20
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
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
41039 129710 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2384 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6002133.54538 2117765.5714 37.7951004798686 -122.43661949341 (37.7951004798686, -122.43661949341) 13 9 1 57 17
43192 227994 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1306 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6003859.66621 2100626.63224 37.7481390813628 -122.42942403481 (37.7481390813628, -122.42942403481) 2 4 5 63 22
44261 227818 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 221 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 5ft   6006782.14401 2097820.33251 37.7405986419274 -122.419119157627 (37.7405986419274, -122.419119157627) 2 7 7 28859 2
45026 129708 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2800 Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6002098.95319 2117845.28879 37.7953173972439 -122.43674489666 (37.7953173972439, -122.43674489666) 13 9 1 57 17
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
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
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
56543 129692 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2970 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6000656.11857 2116207.75576 37.7907390566157 -122.441619752742 (37.7907390566157, -122.441619752742) 13 6 1 29490 27
61421 129700 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2970 Washington St 9 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6000509.65087 2116188.56402 37.7906780151192 -122.442125143875 (37.7906780151192, -122.442125143875) 13 6 1 29490 27
61715 227954 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 19 Oakwood St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6005250.78391 2105379.80731 37.7612688550002 -122.424951719761 (37.7612688550002, -122.424951719761) 2 4 5 28859 19
65194 191557 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 401 Rhode Island St 7 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6011781.42001 2106326.42405 37.7642347759329 -122.40243144478 (37.7642347759329, -122.40243144478) 8 3 8 28856 29
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
67009 129695 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2970 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6000588.35894 2116200.69282 37.7907158028324 -122.441853689821 (37.7907158028324, -122.441853689821) 13 6 1 29490 27
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
79473 227797 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 78 Woodland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   5997131.78555 2106048.44481 37.762642813136 -122.453080018655 (37.762642813136, -122.453080018655) 15 5 11 29492 12
80940 227946 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2368 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6009653.02559 2103553.74233 37.756502573159 -122.409597276095 (37.756502573159, -122.409597276095) 2 4 7 28859 19
83656 227856 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 165 Vicksburg St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6004139.46574 2102214.32779 37.7525143604498 -122.428569653674 (37.7525143604498, -122.428569653674) 2 4 5 28862 22
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
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
92128 227859 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 25 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6004104.47801 2102871.35306 37.7543164174892 -122.428737480655 (37.7543164174892, -122.428737480655) 2 4 5 28862 22
95820 129693 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2970 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6000643.07515 2116204.21556 37.7907285930009 -122.441664628017 (37.7907285930009, -122.441664628017) 13 6 1 29490 27
97928 227854 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 165 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6004142.14587 2102192.44756 37.7524544341373 -122.428558825827 (37.7524544341373, -122.428558825827) 2 4 5 28862 22
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
103129 227962 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 8 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6005350.15285 2103584.35946 37.7563445892338 -122.42448033022 (37.7563445892338, -122.42448033022) 2 4 5 28859 19
107925 129696 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2970 Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6000569.36942 2116197.48764 37.7907059201805 -122.441919162241 (37.7907059201805, -122.441919162241) 13 6 1 29490 27
109229 129701 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2970 Washington St 10 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 5ft   6000500.44634 2116185.5793 37.7906692952944 -122.442156776619 (37.7906692952944, -122.442156776619) 13 6 1 29490 27
112023 227857 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 165 Vicksburg St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6004140.06884 2102221.88721 37.7525351509765 -122.428568106848 (37.7525351509765, -122.428568106848) 2 4 5 28862 22
116199 123796 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1550 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   5993793.84449 2112124.03486 37.7791329069537 -122.465065956135 (37.7791329069537, -122.465065956135) 11 6 2 54 11
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
120399 129698 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2970 Washington St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6000533.7718 2116193.14508 37.7906919681164 -122.442042015953 (37.7906919681164, -122.442042015953) 13 6 1 29490 27
120608 227953 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 19 Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6005251.70429 2105361.18332 37.7612177699112 -122.424947211467 (37.7612177699112, -122.424947211467) 2 4 5 28859 19
122764 227855 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 165 Vicksburg St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6004140.81956 2102204.05539 37.7524862314611 -122.428564239772 (37.7524862314611, -122.428564239772) 2 4 5 28862 22
122946 200268 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 860x Jamestown Ave 10 Median : Cutout Tree DPW 1     2 Width 5ft   6014637.95874 2089223.70519 37.7174333029868 -122.391355746088 (37.7174333029868, -122.391355746088) 10 3 8 58 1
127849 208136 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 255x San Marcos Ave 5 Median : Cutout Tree DPW 1     5 Width 5ft   5993099.62509 2100246.71576 37.746480853819 -122.466603967821 (37.746480853819, -122.466603967821) 1 8 4 29491 40
128400 191117 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 699 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 5ft   6014453.67904 2103916.00921 37.7577651160975 -122.393020127695 (37.7577651160975, -122.393020127695) 10 3 8 28856 29
141515 227941 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2501 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 5ft   6009766.69353 2102694.57253 37.7541498540377 -122.409143546554 (37.7541498540377, -122.409143546554) 2 4 7 28859 19
146473 227798 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 78 Woodland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     32 Width 5ft   5997129.95127 2106058.68083 37.7626708135226 -122.453087101682 (37.7626708135226, -122.453087101682) 15 5 11 29492 12
147054 191559 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 401 Rhode Island St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6011776.16151 2106411.778 37.7644688451864 -122.402455634714 (37.7644688451864, -122.402455634714) 8 3 8 28856 29
148000 200273 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 920x Jamestown Ave 10 Median : Cutout Tree DPW 1     3 Width 5ft   6014418.93045 2089354.50359 37.7177802911084 -122.392121973844 (37.7177802911084, -122.392121973844) 10 3 8 58 1
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
149459 129712 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2015 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6004384.23212 2117333.61452 37.7940420803335 -122.428800964717 (37.7940420803335, -122.428800964717) 13 9 1 28858 27
150585 227942 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2498 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6009691.34242 2102846.16459 37.7545618703378 -122.409414827954 (37.7545618703378, -122.409414827954) 2 4 7 28859 19
151763 200265 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 860x Jamestown Ave 2 Median : Cutout Tree DPW 1     2 Width 5ft   6014784.79531 2089078.09549 37.7170416356268 -122.390838025257 (37.7170416356268, -122.390838025257) 10 3 8 58 1
153293 227922 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 66 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6004271.33635 2097814.43726 37.7404407398594 -122.427800146055 (37.7404407398594, -122.427800146055) 2 7 5 63 7
155038 227864 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 12 Vicksburg St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6004060.23994 2102916.80485 37.7544387135775 -122.428893707302 (37.7544387135775, -122.428893707302) 2 4 5 28862 22
155175 191558 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 401 Rhode Island St 8 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 5ft   6011780.39682 2106372.4113 37.7643609894929 -122.402438217563 (37.7643609894929, -122.402438217563) 8 3 8 28856 29
158979 123795 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1550 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   5993809.03734 2112124.45692 37.7791349418605 -122.465013428941 (37.7791349418605, -122.465013428941) 11 6 2 54 11
164026 129697 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2970 Washington St 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6000546.57197 2116195.20818 37.7906983622821 -122.441997876317 (37.7906983622821, -122.441997876317) 13 6 1 29490 27
164260 227944 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2598 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6009724.54487 2102254.83469 37.7529400707269 -122.409258278447 (37.7529400707269, -122.409258278447) 2 4 7 28859 19
164591 227880 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 3841 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6003992.09135 2104786.97969 37.759569913329 -122.429262730611 (37.759569913329, -122.429262730611) 2 4 5 28862 3
165284 227862 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 21 Vicksburg St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6004103.96264 2102911.44983 37.7544264846179 -122.428742121152 (37.7544264846179, -122.428742121152) 2 4 5 28862 22
165435 191129 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 1136 De Haro St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6012185.62091 2103105.89638 37.7554144753107 -122.400807145928 (37.7554144753107, -122.400807145928) 10 3 8 28856 29
175387 129694 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2970 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6000599.2332 2116202.16116 37.7907204541334 -122.44181617098 (37.7907204541334, -122.44181617098) 13 6 1 29490 27
178193 129711 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2015 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6004372.94608 2117332.24552 37.7940376826321 -122.428839917937 (37.7940376826321, -122.428839917937) 13 9 1 28858 27
183782 227863 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 12 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6004062.73699 2102929.44749 37.7544735686269 -122.42888597313 (37.7544735686269, -122.42888597313) 2 4 5 28862 22

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