trees

2,180 rows where qSpecies_id = 57 sorted by Fire Prevention Districts

✎ 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)
110045 183625 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1431 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5983375.6866 2105398.8736 37.7600612994594 -122.500608628087 (37.7600612994594, -122.500608628087) 1 8 3 56 35
110206 92942 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 377 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9     5992043 2096735 37.73677754441 -122.470001973507 (37.73677754441, -122.470001973507) 1 8 4 59 40
110588 207400 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 148 Lomita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5991365.09994 2104283.83195 37.7574654727801 -122.472896037642 (37.7574654727801, -122.472896037642) 1 8 4 56 12
110802 101266 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 2126 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989175 2106519 37.7634756077712 -122.480633814056 (37.7634756077712, -122.480633814056) 1 8 3 56 35
113912 207962 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 70 Woodside Ave 7 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5995734.92484 2100251.73667 37.7466463650506 -122.45749181559 (37.7466463650506, -122.45749181559) 1 5 4 59 40
115293 92932 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 329 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12     5992099 2097070 37.7377006069055 -122.469832741501 (37.7377006069055, -122.469832741501) 1 8 4 59 40
116449 183926 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1595 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5988583.1369 2101004.688 37.7483003735732 -122.482276819356 (37.7483003735732, -122.482276819356) 1 8 3 29491 35
117442 101265 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 2034 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989459.10715 2106523.86109 37.7635054630097 -122.47965154526 (37.7635054630097, -122.47965154526) 1 8 3 56 35
117494 207391 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1748 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5993754.432 2103596.68035 37.7557167662226 -122.464582942975 (37.7557167662226, -122.464582942975) 1 8 4 56 12
117498 207388 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 337 Judah St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5993451.68275 2105929.50616 37.7621046417451 -122.465799426225 (37.7621046417451, -122.465799426225) 1 8 11 56 12
121128 207952 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2101 09th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5993588.02577 2101347.20495 37.7495306895917 -122.464995058183 (37.7495306895917, -122.464995058183) 1 8 4 29491 40
121474 207871 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1541 12th Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5992427.77388 2104765.50377 37.7588494808325 -122.469255976794 (37.7588494808325, -122.469255976794) 1 8 4 56 12
121768 207926 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1630 Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5991910.04045 2096405.2401 37.7358644199941 -122.470437659868 (37.7358644199941, -122.470437659868) 1 8 4 59 40
121946 217633 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 362 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5992003.7966 2096898.1347 37.7372232047665 -122.470149391099 (37.7372232047665, -122.470149391099) 1 8 4 59 40
124680 46971 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1686 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/2002 12:00:00 AM 2   Permit Number 44991 5982549.6238 2103640.11 37.7551837030962 -122.50333530778 (37.7551837030962, -122.50333530778) 1 8 3 56 35
126405 65909 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 1371 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM     Permit Number 28918 5994237.48770801 2106190.93763502 37.7628677616586 -122.463100618919 (37.7628677616586, -122.463100618919) 1 5 11 56 12
129359 183931 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1595 Quintara St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5988739.7309 2101009.2638 37.7483220449634 -122.481735662973 (37.7483220449634, -122.481735662973) 1 8 3 29491 35
129378 46972 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1686 44th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/2002 12:00:00 AM 2   Permit Number 44991 5982549.0126 2103652.333 37.755217228082 -122.50333832645 (37.755217228082, -122.50333832645) 1 8 3 56 35
132341 217638 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 329 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5992227.5338 2097006.9607 37.7375349456478 -122.46938375516 (37.7375349456478, -122.46938375516) 1 8 4 59 40
132875 207870 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1541 12th Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5992427.18816 2104766.73387 37.7588528245185 -122.469258092 (37.7588528245185, -122.469258092) 1 8 4 56 12
134830 177095 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 0 Serrano Dr 2 Sidewalk: Curb side : Yard Tree Private 2     48     5989637.49515 2090738.06528 37.720172132515 -122.47788049948 (37.720172132515, -122.47788049948) 1 8 4 64 14
134848 207912 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 125 Montalvo Ave 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5993750.78708 2099620.00908 37.744797631403 -122.464306847495 (37.744797631403, -122.464306847495) 1 8 4 29491 40
135768 207389 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1726 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993749.76813 2103720.2567 37.7560558061474 -122.464608044838 (37.7560558061474, -122.464608044838) 1 8 4 56 12
136416 207925 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 275 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5994659.0424 2100279.18449 37.7466598719728 -122.461214068202 (37.7466598719728, -122.461214068202) 1 8 4 29491 40
137556 217644 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 345 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5992091.2536 2096871.5297 37.7371552098209 -122.469845078504 (37.7371552098209, -122.469845078504) 1 8 4 59 40
138357 207898 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 450 Wawona St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5991548.15864 2097071.69595 37.7376734080929 -122.471737369979 (37.7376734080929, -122.471737369979) 1 8 4 29491 40
139439 207933 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1 Merced Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5995331.00373 2100187.61073 37.746447081563 -122.458883881613 (37.746447081563, -122.458883881613) 1 8 4 59 40
139627 183299 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1286 42nd Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5983077.483 2106392.3859 37.7627716918826 -122.501713459776 (37.7627716918826, -122.501713459776) 1 8 3 56 35
141811 207396 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 347 Noriega St 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5992865.43172 2103190.17438 37.754549316717 -122.467627800978 (37.754549316717, -122.467627800978) 1 8 4 56 12
141850 92910 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 312 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12     5992168 2097141 37.7378995431122 -122.469599344661 (37.7378995431122, -122.469599344661) 1 8 4 59 40
142314 54212 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 1301X 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/1972 12:00:00 AM     Permit Number 9950 5993618.71802201 2106620.31797794 37.7640110640874 -122.465271900961 (37.7640110640874, -122.465271900961) 1 8 11 56 12
142475 217640 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 339 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5992167.8139 2096949.2221 37.7373729586648 -122.469586031225 (37.7373729586648, -122.469586031225) 1 8 4 59 40
144134 207901 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 450 Wawona St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991520.05038 2097071.77928 37.7376720105541 -122.471834558838 (37.7376720105541, -122.471834558838) 1 8 4 29491 40
148570 183930 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1595 Quintara St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5988704.6498 2101009.2638 37.748320004874 -122.481856971083 (37.748320004874, -122.481856971083) 1 8 3 29491 35
148922 207382 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1375 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5994239.66326 2106176.74738 37.7628289242333 -122.463092064846 (37.7628289242333, -122.463092064846) 1 5 11 56 12
149805 207961 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 70 Woodside Ave 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5995740.66413 2100249.86529 37.7466415563731 -122.457471834475 (37.7466415563731, -122.457471834475) 1 5 4 59 40
149901 256348 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 3000X Sunset Blvd 27 Median : Yard Tree Private 2       3x3   5985361 2095009 37.7316498716246 -122.492977136553 (37.7316498716246, -122.492977136553) 1 8 4 64 35
151518 207864 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2545 Ocean Ave 1 : Tree Private 2     8 Width 3ft   5991142.22279 2094819.87718 37.7314669887904 -122.472976710428 (37.7314669887904, -122.472976710428) 1 8 4 64 40
153318 114098 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 219x VIDAL DR 1 Front Yard : Cutout Tree Private 2     40     5987664 2090565 37.7195822022131 -122.484689437364 (37.7195822022131, -122.484689437364) 1 8 4 64 14
153735 207408 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2115 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5992555.83637 2101029.49101 37.7485987581251 -122.468541255881 (37.7485987581251, -122.468541255881) 1 8 4 29491 40
156040 217705 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 200 West Portal Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5992558.2572 2097459.9542 37.7387978584587 -122.468273243142 (37.7387978584587, -122.468273243142) 1 8 4 59 40
156629 92938 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 345 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10     5992182.7 2096880.8 37.7371859491769 -122.469529584198 (37.7371859491769, -122.469529584198) 1 8 4 59 40
158628 37203 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1574 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM 5   Permit Number 39770 5986243.4033 2104539.0139 37.7578682946863 -122.490627442767 (37.7578682946863, -122.490627442767) 1 8 3 56 35
159278 207892 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2119 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5990666.05125 2100929.33737 37.7482144184726 -122.475068731353 (37.7482144184726, -122.475068731353) 1 8 4 29491 40
159968 217649 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 16 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5993175.955 2098123.9228 37.7406566062821 -122.466185789707 (37.7406566062821, -122.466185789707) 1 8 4 59 40
160233 207395 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 347 Noriega St 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5992873.15724 2103191.67776 37.7545538906601 -122.467601193643 (37.7545538906601, -122.467601193643) 1 8 4 56 12
160404 207955 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 10 Woodside Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   5996262.83861 2100050.55871 37.7461242897204 -122.455651816179 (37.7461242897204, -122.455651816179) 1 5 4 59 40
161118 217653 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 32 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5993135.2441 2098070.7272 37.7405081956368 -122.466322686161 (37.7405081956368, -122.466322686161) 1 8 4 59 40
162317 207911 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1201 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5992447.46376 2098370.00525 37.7412902286696 -122.46872251336 (37.7412902286696, -122.46872251336) 1 8 4 59 40
162592 207867 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1350 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5994282.22065 2106308.08088 37.7631919832571 -122.462954403835 (37.7631919832571, -122.462954403835) 1 5 11 56 12
163900 207945 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2300 09th Ave 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5992693.35222 2100498.87072 37.7471497533695 -122.468027140435 (37.7471497533695, -122.468027140435) 1 8 4 29491 40
164718 207386 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1462 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5993383.76255 2105531.43008 37.7610077107512 -122.466005406938 (37.7610077107512, -122.466005406938) 1 8 11 56 12
165346 217625 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 312 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5992220.3164 2097118.9001 37.7378418858944 -122.469416854682 (37.7378418858944, -122.469416854682) 1 8 4 59 40
165636 101683 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 16 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993140 2098173 37.7407892854016 -122.466313673169 (37.7407892854016, -122.466313673169) 1 8 4 59 40
165770 186910 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2700 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985181.9251 2096700.884 37.7362848611965 -122.49372085207 (37.7362848611965, -122.49372085207) 1 8 3 29491 35
169260 207868 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1541 12th Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5992426.05558 2104800.10163 37.7589443781928 -122.46926443762 (37.7589443781928, -122.46926443762) 1 8 4 56 12
169571 207910 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 272 Wawona St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5992257.40464 2097504.13559 37.7389017884968 -122.46931665586 (37.7389017884968, -122.46931665586) 1 8 4 59 40
171591 207863 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 40 Lagunitas Dr 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   5991134.49125 2095574.87688 37.7335395798715 -122.47305847768 (37.7335395798715, -122.47305847768) 1 8 4 64 40
171767 207402 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 136 Lomita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991386.74911 2104341.46071 37.7576249594532 -122.472825368893 (37.7576249594532, -122.472825368893) 1 8 4 56 12
175127 68799 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 2459 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1993 12:00:00 AM     Permit Number 32738 5992323.72089278 2098718.16784221 37.742239045273 -122.469175702533 (37.742239045273, -122.469175702533) 1 8 4 29491 40
179718 207948 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2300 09th Ave 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5992690.99199 2100498.58562 37.7471488342554 -122.468035281115 (37.7471488342554, -122.468035281115) 1 8 4 29491 40
179979 207944 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2300 09th Ave 7 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5992687.64397 2100499.32584 37.7471506733621 -122.468046912034 (37.7471506733621, -122.468046912034) 1 8 4 29491 40
180656 207405 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2692 16th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5991464.74563 2097109.88885 37.7377734495898 -122.472028548905 (37.7377734495898, -122.472028548905) 1 8 4 29491 40
181135 33186 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 10 Hernandez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37395 5996266.46691621 2100062.84329994 37.7461582283752 -122.45564015783 (37.7461582283752, -122.45564015783) 1 5 4 59 40
181372 217652 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 28 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5993152.0713 2098090.8113 37.7405643124274 -122.466265963968 (37.7405643124274, -122.466265963968) 1 8 4 59 40
182995 207890 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1585 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991722.66057 2104556.34539 37.7582344164913 -122.47167932057 (37.7582344164913, -122.47167932057) 1 8 4 56 12
183576 207390 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1730 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5993751.42285 2103698.23694 37.7559954409591 -122.464600723458 (37.7559954409591, -122.464600723458) 1 8 4 56 12
183763 207383 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1313 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5993603.85534 2106592.86022 37.7639348151617 -122.465321311525 (37.7639348151617, -122.465321311525) 1 8 11 56 12
184249 207949 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2300 09th Ave 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5992678.23044 2100499.52384 37.7471506733823 -122.468079477383 (37.7471506733823, -122.468079477383) 1 8 4 29491 40
186317 111081 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 2811 14TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992341 2097126 37.7378683540452 -122.469000113007 (37.7378683540452, -122.469000113007) 1 8 4 59 40
188215 207905 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2319 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5991984.0362 2099641.46865 37.7447545592881 -122.470417443113 (37.7447545592881, -122.470417443113) 1 8 4 29491 40
189252 207387 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 337 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5993441.47974 2105930.81218 37.7621076391783 -122.465834809125 (37.7621076391783, -122.465834809125) 1 8 11 56 12
189563 207906 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2459 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992324.52797 2098726.3849 37.7422616538593 -122.46917350985 (37.7422616538593, -122.46917350985) 1 8 4 29491 40
190600 207956 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 70 Woodside Ave 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5995766.68193 2100244.56754 37.7466285044959 -122.457381484986 (37.7466285044959, -122.457381484986) 1 5 4 59 40
190925 92919 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 362 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9     5991957 2096928 37.7373025018195 -122.470313361151 (37.7373025018195, -122.470313361151) 1 8 4 59 40
191231 101261 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 1945 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989742 2106485 37.7634151902649 -122.478670277794 (37.7634151902649, -122.478670277794) 1 8 3 56 35
192319 207913 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 100 Merced Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5994687.05198 2099628.96292 37.7448761386401 -122.461070093006 (37.7448761386401, -122.461070093006) 1 8 4 59 40
193853 256349 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 3000X Sunset Blvd 28 Median : Yard Tree Private 2       3x3   5985361 2095009 37.7316498716246 -122.492977136553 (37.7316498716246, -122.492977136553) 1 8 4 64 35
194043 207958 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 70 Woodside Ave 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5995753.89015 2100245.58551 37.7466305648554 -122.457425790981 (37.7466305648554, -122.457425790981) 1 5 4 59 40
4136 247842 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 74 Nevada St 1 Sidewalk: Property side : Yard Tree Private 2     18 Width 6ft   6009022.44109 2098193.50191 37.7417491904794 -122.411399399688 (37.7417491904794, -122.411399399688) 10 7 7 28859 2
4363 227340 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 3915 Folsom St 7 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6008451 2096866 37.7380720936745 -122.413281406339 (37.7380720936745, -122.413281406339) 10 7 7 28859 2
5324 177073 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 250 Blanken Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6012250.9341 2087164.61689 37.7116466881279 -122.399462161252 (37.7116466881279, -122.399462161252) 10 3 8 309 1
5567 6767 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1275 Fairfax Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/1992 12:00:00 AM 12 3x3   6017316.52552 2096883.88974 37.7386149694956 -122.382629809543 (37.7386149694956, -122.382629809543) 10 3 8 58 1
5650 101145 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 450 Connecticut St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 2x2   6013204.93498 2104939.92488 37.7605071193183 -122.397410636789 (37.7605071193183, -122.397410636789) 10 3 8 28856 29
9097 74222 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2030 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6012358.62681 2102848.31202 37.7547168532055 -122.400190745215 (37.7547168532055, -122.400190745215) 10 3 8 28856 29
10089 83062 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1375 Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6016802.22624 2097268.63088 37.7396429656544 -122.384434818109 (37.7396429656544, -122.384434818109) 10 3 8 58 1
11890 72130 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2030 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6012329.14835 2102847.44399 37.7547128260461 -122.400292629422 (37.7547128260461, -122.400292629422) 10 3 8 28856 29
12497 11955 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1469 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X4   6015772.6789286 2096311.6012512 37.7369581722856 -122.387927819023 (37.7369581722856, -122.387927819023) 10 3 8 58 1
14969 191498 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1198 La Salle Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     8 Width 4ft   6016692.24365 2094766.72457 37.7327671503753 -122.384640862701 (37.7327671503753, -122.384640862701) 10 3 8 58 1
17977 61561 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2018 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/23/1984 12:00:00 AM 13   Permit Number 21521 6012372.92464 2102851.20002 37.754725580248 -122.400141501934 (37.754725580248, -122.400141501934) 10 3 8 28856 29
18778 1705 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 70 Baldwin Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017900.5576644 2093604.0676713 37.729641471652 -122.380382597634 (37.729641471652, -122.380382597634) 10 3 8 58 1
19574 261987 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1599x Armstrong Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014919 2092067 37.7252560234082 -122.390582878929 (37.7252560234082, -122.390582878929) 10 3 8 58 1
20725 12209 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1365X La Salle Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016707.244956 2094751.5031778 37.7327261850679 -122.384587939042 (37.7327261850679, -122.384587939042) 10 3 8 58 1
21555 200575 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1447 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6016348.7367 2095270.7725 37.7341321622018 -122.385863584669 (37.7341321622018, -122.385863584669) 10 3 8 58 1
21862 191445 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1451 19th St 3 : Tree Private 2     4 Width 4ft   6013335.75988 2105192.04749 37.7612066758622 -122.396975847857 (37.7612066758622, -122.396975847857) 10 3 8 28856 29
22254 199896 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1231 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6017188.7375 2093143.079 37.728336384515 -122.382811392019 (37.728336384515, -122.382811392019) 10 3 8 58 1
23720 107959 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 2299X 25TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012136 2101880 37.7520456635859 -122.400892625965 (37.7520456635859, -122.400892625965) 10 3 8 28856 29
23799 62094 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 415 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1985 12:00:00 AM 10   Permit Number 22183 6013254.03052 2105108.1707 37.7609718188263 -122.397252634924 (37.7609718188263, -122.397252634924) 10 3 8 28856 29
23984 12171 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 1421X La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1993 12:00:00 AM 9 3X3   6016344.6880818 2095251.8114423 37.7340798748876 -122.385876260938 (37.7340798748876, -122.385876260938) 10 3 8 58 1
24245 12204 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1365X La Salle Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016707.244956 2094751.5031778 37.7327261850679 -122.384587939042 (37.7327261850679, -122.384587939042) 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)
);