78 rows where qSpecies_id = 55

View and edit SQL

Suggested facets: SiteOrder, qCareAssistant, Fire Prevention Districts, Supervisor Districts, Neighborhoods (old)

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)
123 221263 DPW Maintained 1 Betula spp :: Birch 55 1 Church St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 6ft   6004132.36771 2108477.00924 37.7697097883113 -122.429040680782 (37.7697097883113, -122.429040680782) 7 9 5 29492 10
3272 31452 DPW Maintained 1 Betula spp :: Birch 55 622 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1995 12:00:00 AM 5   Permit Number 35025 6001186.85258 2102758.41703 37.753840762463 -122.438819254003 (37.753840762463, -122.438819254003) 2 4 5 28862 22
11349 81192 DPW Maintained 1 Betula spp :: Birch 55 1190 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2 3x3   6017151.2328 2092548.3474 37.7267012956658 -122.382899676448 (37.7267012956658, -122.382899676448) 10 3 8 58 1
11698 175561 DPW Maintained 1 Betula spp :: Birch 55 280 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003661.86049 2092085.64478 37.7246762727695 -122.429499024773 (37.7246762727695, -122.429499024773) 9 7 6 28861 5
13299 221203 DPW Maintained 1 Betula spp :: Birch 55 822 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001261.98607 2101410.13099 37.7501429669369 -122.438462832014 (37.7501429669369, -122.438462832014) 2 4 5 28862 22
20619 205615 DPW Maintained 1 Betula spp :: Birch 55 828 Foerster St 4 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5998298.69367 2096485.63858 37.7364524992737 -122.448355446446 (37.7364524992737, -122.448355446446) 9 7 4 59 40
23912 221224 DPW Maintained 1 Betula spp :: Birch 55 263 Upper Ter 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5999333.94712 2105953.73296 37.7625087197167 -122.445456749829 (37.7625087197167, -122.445456749829) 15 5 5 29492 3
27557 205616 DPW Maintained 1 Betula spp :: Birch 55 828 Foerster St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5998292.51855 2096480.52961 37.7364381182138 -122.44837642855 (37.7364381182138, -122.44837642855) 9 7 4 59 40
29610 205636 DPW Maintained 1 Betula spp :: Birch 55 20 Belmont Ave 5 Sidewalk: Curb side : Yard Tree Private 2     2     5996780.32273 2106155.81029 37.7629174624857 -122.454303351113 (37.7629174624857, -122.454303351113) 15 5 11 29492 12
30123 91524 DPW Maintained 1 Betula spp :: Birch 55 350 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/12/2009 12:00:00 AM 2 3x3 Permit Number 52129 6011423.59595 2106768.9844 37.7654299650425 -122.403700204704 (37.7654299650425, -122.403700204704) 8 3 8 28853 20
32953 188834 DPW Maintained 1 Betula spp :: Birch 55 301 Kansas St 12 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6011480.0271 2106736.73681 37.7653445726241 -122.403502752245 (37.7653445726241, -122.403502752245) 8 3 8 28853 20
34997 221211 DPW Maintained 1 Betula spp :: Birch 55 522 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007835.28715 2104887.50229 37.7600627472247 -122.415978127013 (37.7600627472247, -122.415978127013) 2 4 7 28859 19
38383 221205 DPW Maintained 1 Betula spp :: Birch 55 4206 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6001130.27143 2102915.9336 37.7542700457401 -122.439026212304 (37.7542700457401, -122.439026212304) 2 4 5 28862 22
41018 91525 DPW Maintained 1 Betula spp :: Birch 55 350 Kansas St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/12/2009 12:00:00 AM 3 3x3 Permit Number 52129 6011425.5779 2106742.38308 37.7653570345305 -122.403691477679 (37.7653570345305, -122.403691477679) 8 3 8 28853 20
43454 125727 DPW Maintained 1 Betula spp :: Birch 55 2700 Lyon St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 7ft   5999203.82111 2118107.76086 37.7958731162137 -122.446781380165 (37.7958731162137, -122.446781380165) 13 9 1 57 17
44533 221201 DPW Maintained 1 Betula spp :: Birch 55 84 Richland Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 2ft   6005032.52935 2096155.14672 37.7359277331662 -122.425050206297 (37.7359277331662, -122.425050206297) 2 7 5 28859 2
47530 122921 DPW Maintained 1 Betula spp :: Birch 55 166 11th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5992451.52232 2114364.20539 37.7852063091564 -122.469872700188 (37.7852063091564, -122.469872700188) 11 6 2 54 11
49645 48392 DPW Maintained 1 Betula spp :: Birch 55 350& 17th ST Rhode Island St 11 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2002 12:00:00 AM 9   Permit Number 45774 6011703.58885 2106764.88061 37.7654343339536 -122.4027314793 (37.7654343339536, -122.4027314793) 8 3 8 28853 20
54172 188830 DPW Maintained 1 Betula spp :: Birch 55 301 Kansas St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011482.20897 2106712.26593 37.7652775029714 -122.403493483843 (37.7652775029714, -122.403493483843) 8 3 8 28853 20
55333 188828 DPW Maintained 1 Betula spp :: Birch 55 301 Kansas St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6011482.39579 2106701.17788 37.7652470681189 -122.403492057514 (37.7652470681189, -122.403492057514) 8 3 8 28853 20
57080 221212 DPW Maintained 1 Betula spp :: Birch 55 328 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6007777.41212 2105974.0918 37.7630430168564 -122.41625524948 (37.7630430168564, -122.41625524948) 8 4 7 28859 19
59002 251322 DPW Maintained 1 Betula spp :: Birch 55 828 Foerster St 6 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   5998302.82159 2096489.58159 37.7364635618398 -122.448341458403 (37.7364635618398, -122.448341458403) 9 7 4 59 40
59311 205617 DPW Maintained 1 Betula spp :: Birch 55 828 Foerster St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5998289.57026 2096474.95059 37.7364226309944 -122.448386220344 (37.7364226309944, -122.448386220344) 9 7 4 59 40
60070 221269 DPW Maintained 1 Betula spp :: Birch 55 1 Church St 10 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6004124.2935 2108618.32017 37.7700973367576 -122.429078686141 (37.7700973367576, -122.429078686141) 7 9 5 29492 10
63774 221215 DPW Maintained 1 Betula spp :: Birch 55 350 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004049.2112 2102175.65559 37.7524030675729 -122.428879012372 (37.7524030675729, -122.428879012372) 2 4 5 28862 22
64725 221207 DPW Maintained 1 Betula spp :: Birch 55 144 Prospect Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006793.72845 2098662.88692 37.7429127603125 -122.419138852776 (37.7429127603125, -122.419138852776) 2 7 7 28859 2
65611 221266 DPW Maintained 1 Betula spp :: Birch 55 1 Church St 6 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6004128.33059 2108547.6647 37.7699035625247 -122.429059683463 (37.7699035625247, -122.429059683463) 7 9 5 29492 10
67686 221204 DPW Maintained 1 Betula spp :: Birch 55 37 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6000608.65808 2102668.83107 37.7535618692103 -122.440812353132 (37.7535618692103, -122.440812353132) 2 4 5 28862 22
70515 221265 DPW Maintained 1 Betula spp :: Birch 55 1 Church St 4 Sidewalk: Property side : Yard Tree Private 2     6 Width 6ft   6004128.71864 2108513.19121 37.7698089286584 -122.429055882918 (37.7698089286584, -122.429055882918) 7 9 5 29492 10
74803 188832 DPW Maintained 1 Betula spp :: Birch 55 301 Kansas St 10 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011480.82779 2106725.43091 37.7653135738934 -122.40349918734 (37.7653135738934, -122.40349918734) 8 3 8 28853 20
75323 221262 DPW Maintained 1 Betula spp :: Birch 55 114 Belgrave Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5998017.16767 2104924.02089 37.7596061299462 -122.449936772062 (37.7596061299462, -122.449936772062) 15 5 11 29492 12
83980 188836 DPW Maintained 1 Betula spp :: Birch 55 1900 19th St 9 Front Yard : Yard Tree Private 2     1     6012010.98976 2105148.33268 37.7610128126145 -122.401554618346 (37.7610128126145, -122.401554618346) 10 3 8 28856 29
88099 114049 DPW Maintained 1 Betula spp :: Birch 55 1190 Shafter Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2 3x3   6017122.5886 2092569.8305 37.7267587013694 -122.383000194048 (37.7267587013694, -122.383000194048) 10 3 8 58 1
88417 59160 Permitted Site 7 Betula spp :: Birch 55 3961 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 770967 6004101.77882738 2101279.18641822 37.7499445479885 -122.428633327116 (37.7499445479885, -122.428633327116) 2 4 5 28862 22
90255 221261 DPW Maintained 1 Betula spp :: Birch 55 110 Belgrave Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5998034.78247 2104925.59903 37.7596114710027 -122.449875965302 (37.7596114710027, -122.449875965302) 15 5 11 29492 12
94356 221202 DPW Maintained 1 Betula spp :: Birch 55 612 Douglass St 5 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   6001183.09453 2102793.98455 37.7539382084898 -122.438834798788 (37.7539382084898, -122.438834798788) 2 4 5 28862 22
94462 188833 DPW Maintained 1 Betula spp :: Birch 55 301 Kansas St 11 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6011480.96553 2106732.20207 37.7653321736669 -122.40349918735 (37.7653321736669, -122.40349918735) 8 3 8 28853 20
94862 221272 DPW Maintained 1 Betula spp :: Birch 55 112 27th St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 8ft   6005715.93681 2100246.19015 37.7471993959433 -122.422978070306 (37.7471993959433, -122.422978070306) 2 7 5 28859 22
97593 221219 DPW Maintained 1 Betula spp :: Birch 55 274 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002058.8805 2104265.20711 37.7580276192018 -122.4359113915 (37.7580276192018, -122.4359113915) 2 4 5 28862 3
97834 199978 DPW Maintained 1 Betula spp :: Birch 55 1176 Shafter Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6017205.7669 2092508.1354 37.7265938943307 -122.382708354896 (37.7265938943307, -122.382708354896) 10 3 8 58 1
101837 48376 DPW Maintained 1 Betula spp :: Birch 55 350& 17th ST Rhode Island St 6 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2002 12:00:00 AM 8   Permit Number 45774 6011702.20298 2106790.88809 37.765505667266 -122.402738101908 (37.765505667266, -122.402738101908) 8 3 8 28853 20
102105 221210 DPW Maintained 1 Betula spp :: Birch 55 239 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007933.08994 2100297.95889 37.7474664010656 -122.415314968738 (37.7474664010656, -122.415314968738) 2 7 7 28859 2
102245 48379 DPW Maintained 1 Betula spp :: Birch 55 350& 17th ST Rhode Island St 9 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2002 12:00:00 AM 7   Permit Number 45774 6011703.29446 2106773.94344 37.7654592020097 -122.402733134944 (37.7654592020097, -122.402733134944) 8 3 8 28853 20
102363 221221 DPW Maintained 1 Betula spp :: Birch 55 568 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002627.37644 2103877.09879 37.756994245114 -122.433917551359 (37.756994245114, -122.433917551359) 2 4 5 28862 3
103611 48378 DPW Maintained 1 Betula spp :: Birch 55 350& 17th ST Rhode Island St 8 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2002 12:00:00 AM 9   Permit Number 45774 6011702.68345 2106779.19961 37.7654736001554 -122.40273561798 (37.7654736001554, -122.40273561798) 8 3 8 28853 20
103641 188835 DPW Maintained 1 Betula spp :: Birch 55 1900 19th St 8 Front Yard : Yard Tree Private 2     5     6012016.74382 2105147.80568 37.7610116866594 -122.401534680397 (37.7610116866594, -122.401534680397) 10 3 8 28856 29
105024 221271 DPW Maintained 1 Betula spp :: Birch 55 1 Church St 15 Sidewalk: Property side : Yard Tree Private 2     6 Width 6ft   6004119.92385 2108672.84338 37.7702467968906 -122.429097688827 (37.7702467968906, -122.429097688827) 7 9 5 29492 10
105596 221216 DPW Maintained 1 Betula spp :: Birch 55 350 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004036.63734 2102173.24246 37.7523957299838 -122.428922322819 (37.7523957299838, -122.428922322819) 2 4 5 28862 22
106139 205618 DPW Maintained 1 Betula spp :: Birch 55 400x Marietta Dr 26 Median : Cutout Tree DPW 1     5 Width 3ft   5999201.98821 2097029.00805 37.7379960650707 -122.445271442731 (37.7379960650707, -122.445271442731) 9 7 4 59 40
108131 175569 DPW Maintained 1 Betula spp :: Birch 55 639 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5998680.87315 2086652.8571 37.7094758038379 -122.44632696624 (37.7094758038379, -122.44632696624) 9 7 6 28861 5
110345 221217 DPW Maintained 1 Betula spp :: Birch 55 350 Elizabeth St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004021.19424 2102172.66993 37.7523932838256 -122.428975686774 (37.7523932838256, -122.428975686774) 2 4 5 28862 22
110381 188829 DPW Maintained 1 Betula spp :: Birch 55 301 Kansas St 7 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6011482.08375 2106706.1106 37.7652605948275 -122.40349348386 (37.7652605948275, -122.40349348386) 8 3 8 28853 20
112458 221206 DPW Maintained 1 Betula spp :: Birch 55 144 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006807.09402 2098682.83773 37.7429682934411 -122.419094053065 (37.7429682934411, -122.419094053065) 2 7 7 28859 2
122100 221214 DPW Maintained 1 Betula spp :: Birch 55 367 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004009.66703 2102145.13724 37.7523170330249 -122.429013586916 (37.7523170330249, -122.429013586916) 2 4 5 28862 22
123470 221225 DPW Maintained 1 Betula spp :: Birch 55 233 Hermann St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6004131.6241 2108689.19753 37.7702923637227 -122.429058383936 (37.7702923637227, -122.429058383936) 7 9 5 29492 10
124008 48377 DPW Maintained 1 Betula spp :: Birch 55 350& 17th ST Rhode Island St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2002 12:00:00 AM 6   Permit Number 45774 6011703.03883 2106784.91236 37.7654893059242 -122.402734790587 (37.7654893059242, -122.402734790587) 8 3 8 28853 20
127563 221208 DPW Maintained 1 Betula spp :: Birch 55 53 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007634.82349 2099989.12367 37.7466016408642 -122.416324486486 (37.7466016408642, -122.416324486486) 2 7 7 28859 2
130580 221270 DPW Maintained 1 Betula spp :: Birch 55 1 Church St 12 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   6004122.63808 2108644.61348 37.7701694380901 -122.429086287217 (37.7701694380901, -122.429086287217) 7 9 5 29492 10
133501 55829 DPW Maintained 1 Betula spp :: Birch 55 166 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1973 12:00:00 AM 10   Permit Number 11878 5992451.31952 2114354.57213 37.7851798471539 -122.469872700187 (37.7851798471539, -122.469872700187) 11 6 2 54 11
134466 221213 DPW Maintained 1 Betula spp :: Birch 55 381 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003933.59101 2102143.29739 37.752307674663 -122.429276538783 (37.752307674663, -122.429276538783) 2 4 5 28862 22
135755 221222 DPW Maintained 1 Betula spp :: Birch 55 263 Upper Ter 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   5999326.53392 2105947.62074 37.7624915138827 -122.445481949759 (37.7624915138827, -122.445481949759) 15 5 5 29492 3
137931 221260 DPW Maintained 1 Betula spp :: Birch 55 100 Belgrave Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5998087.26041 2104928.39629 37.7596221540622 -122.44969467277 (37.7596221540622, -122.44969467277) 15 5 11 29492 12
140164 34517 DPW Maintained 1 Betula spp :: Birch 55 1640 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/1997 12:00:00 AM 7   Permit Number 38228 6005490.1304 2118232.72074 37.7965733283445 -122.425038441378 (37.7965733283445, -122.425038441378) 13 9 1 28858 17
147652 199976 DPW Maintained 1 Betula spp :: Birch 55 1176 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6017220.6398 2092498.2202 37.7265674907894 -122.382656249663 (37.7265674907894, -122.382656249663) 10 3 8 58 1
151417 221218 DPW Maintained 1 Betula spp :: Birch 55 350 Elizabeth St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004007.55767 2102172.95105 37.7523932838249 -122.429022864307 (37.7523932838249, -122.429022864307) 2 4 5 28862 22
151433 48380 DPW Maintained 1 Betula spp :: Birch 55 350& 17th ST Rhode Island St 10 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2002 12:00:00 AM 7   Permit Number 45774 6011703.67121 2106768.9308 37.7654454594629 -122.402731479294 (37.7654454594629, -122.402731479294) 8 3 8 28853 20
152808 205614 DPW Maintained 1 Betula spp :: Birch 55 828 Foerster St 5 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5998302.82159 2096489.58159 37.7364635618398 -122.448341458403 (37.7364635618398, -122.448341458403) 9 7 4 59 40
154164 221223 DPW Maintained 1 Betula spp :: Birch 55 263 Upper Ter 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5999330.89237 2105950.16873 37.762498758842 -122.445467058755 (37.762498758842, -122.445467058755) 15 5 5 29492 3
154608 205635 DPW Maintained 1 Betula spp :: Birch 55 20 Belmont Ave 4 Sidewalk: Curb side : Yard Tree Private 2     4     5996782.71205 2106151.65083 37.7629061786881 -122.454294786868 (37.7629061786881, -122.454294786868) 15 5 11 29492 12
158589 221209 DPW Maintained 1 Betula spp :: Birch 55 740 Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008349.60861 2097665.71648 37.7402622469036 -122.413688516938 (37.7402622469036, -122.413688516938) 2 7 7 28859 2
160413 221267 DPW Maintained 1 Betula spp :: Birch 55 1 Church St 7 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6004128.17602 2108566.81538 37.7699561368912 -122.429061583748 (37.7699561368912, -122.429061583748) 7 9 5 29492 10
167250 221220 DPW Maintained 1 Betula spp :: Birch 55 270 Cumberland St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003890.13554 2104532.5709 37.7588655949011 -122.429597200168 (37.7588655949011, -122.429597200168) 2 4 5 28862 3
169301 122566 DPW Maintained 1 Betula spp :: Birch 55 378 Sweeny St 1 Sidewalk: Property side : Cutout Tree Private 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 779091 6008597.7357 2094518.65936 37.7316350418457 -122.412608176508 (37.7316350418457, -122.412608176508) 9 3 7 309 28
174786 199979 DPW Maintained 1 Betula spp :: Birch 55 1180 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6017182.0803 2092524.1101 37.7266364491103 -122.382791350615 (37.7266364491103, -122.382791350615) 10 3 8 58 1
176819 188831 DPW Maintained 1 Betula spp :: Birch 55 301 Kansas St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011481.94285 2106719.4557 37.7652972295958 -122.403494910169 (37.7652972295958, -122.403494910169) 8 3 8 28853 20
181186 221264 DPW Maintained 1 Betula spp :: Birch 55 1 Church St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6004131.74855 2108500.27281 37.7697736293789 -122.429044481338 (37.7697736293789, -122.429044481338) 7 9 5 29492 10
182413 221268 DPW Maintained 1 Betula spp :: Birch 55 1 Church St 9 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6004125.63652 2108603.52146 37.7700567791189 -122.42907298535 (37.7700567791189, -122.42907298535) 7 9 5 29492 10
191271 48371 DPW Maintained 1 Betula spp :: Birch 55 350& 17th ST Rhode Island St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2002 12:00:00 AM 8   Permit Number 45774 6011702.8268 2106798.02538 37.7655252994892 -122.402736446227 (37.7655252994892, -122.402736446227) 8 3 8 28853 20

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