trees
78 rows where qSpecies_id = 55 sorted by Zip Codes
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker_id, PlantDate, PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||||
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 | ||||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );