trees
1,377 rows where qSpecies_id = 61 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
130363 | 18103 | DPW Maintained 1 | Tristania conferta :: 61 | 3042 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999290.1369 | 2114664.7113 | 37.7864243409392 | -122.446234917327 | (37.7864243409392, -122.446234917327) | 15 | 6 | 1 | 29490 | 31 | |||
133120 | 137791 | DPW Maintained 1 | Tristania conferta :: 61 | 1711 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005267.8978 | 2115649.4507 | 37.7894677644364 | -122.425623465766 | (37.7894677644364, -122.425623465766) | 13 | 9 | 1 | 28858 | 27 | |||
133803 | 108697 | DPW Maintained 1 | Tristania conferta :: 61 | 2414 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774621 | 6000824.14262 | 2119316.97174 | 37.7992857188841 | -122.441261581656 | (37.7992857188841, -122.441261581656) | 13 | 9 | 1 | 57 | 17 |
135029 | 138709 | DPW Maintained 1 | Tristania conferta :: 61 | 2699 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000638.3668 | 2114451.2211 | 37.7859150568787 | -122.441555068262 | (37.7859150568787, -122.441555068262) | 15 | 6 | 1 | 29490 | 27 | |||
138156 | 13182 | DPW Maintained 1 | Tristania conferta :: 61 | 2001 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x4 | 6002733.3901 | 2119504.96 | 37.7999104584024 | -122.434668379841 | (37.7999104584024, -122.434668379841) | 13 | 9 | 1 | 57 | 17 | |||
138386 | 13218 | DPW Maintained 1 | Tristania conferta :: 61 | 2230 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 20 | 3X3 | 6001666.6293 | 2119436.4581 | 37.7996617521403 | -122.438354855973 | (37.7996617521403, -122.438354855973) | 13 | 9 | 1 | 57 | 17 | ||
139070 | 13213 | DPW Maintained 1 | Tristania conferta :: 61 | 2199 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6001911.9905 | 2119390.9978 | 37.799550882806 | -122.437502561002 | (37.799550882806, -122.437502561002) | 13 | 9 | 1 | 57 | 17 | |||
141557 | 34684 | DPW Maintained 1 | Tristania conferta :: 61 | 1863 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 4 | Permit Number 38349 | 6003454.9512 | 2119604.4954 | 37.8002246935596 | -122.432178620621 | (37.8002246935596, -122.432178620621) | 13 | 9 | 1 | 57 | 17 | |
141669 | 143237 | DPW Maintained 1 | Tristania conferta :: 61 | 1550 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004970.9437 | 2119896.9045 | 37.8011134097543 | -122.426953528407 | (37.8011134097543, -122.426953528407) | 13 | 9 | 1 | 57 | 17 | |||
142641 | 137788 | DPW Maintained 1 | Tristania conferta :: 61 | 1711 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005258.2038 | 2115760.6088 | 37.789772428971 | -122.425664920751 | (37.789772428971, -122.425664920751) | 13 | 9 | 1 | 28858 | 27 | |||
143898 | 13243 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001148.9876 | 2119284.6646 | 37.7992155110357 | -122.440135189953 | (37.7992155110357, -122.440135189953) | 13 | 9 | 1 | 57 | 17 | |||
143985 | 143114 | DPW Maintained 1 | Tristania conferta :: 61 | 1463 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005363.4287 | 2119869.54 | 37.8010604586698 | -122.425593410805 | (37.8010604586698, -122.425593410805) | 13 | 9 | 1 | 57 | 17 | |||
144729 | 13241 | DPW Maintained 1 | Tristania conferta :: 61 | 2352 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1994 12:00:00 AM | 30 | 3X3 | 6001099.421 | 2119356.9831 | 37.7994112565419 | -122.440311896156 | (37.7994112565419, -122.440311896156) | 13 | 9 | 1 | 57 | 17 | ||
144882 | 138582 | DPW Maintained 1 | Tristania conferta :: 61 | 2780 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000598.8856 | 2114847.063 | 37.7869996869349 | -122.44172008067 | (37.7869996869349, -122.44172008067) | 13 | 6 | 1 | 29490 | 27 | |||
146929 | 14445 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 5998940.7552 | 2112468.0825 | 37.7803730113246 | -122.447285529358 | (37.7803730113246, -122.447285529358) | 15 | 5 | 1 | 54 | 16 | |||
147431 | 138789 | DPW Maintained 1 | Tristania conferta :: 61 | 1630 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000633.226 | 2114285.0435 | 37.7854584832062 | -122.441560924539 | (37.7854584832062, -122.441560924539) | 15 | 6 | 1 | 29490 | 27 | |||
147566 | 14452 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Masonic Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3x3 | 5998927.5567 | 2112628.8329 | 37.7808136360807 | -122.44734276226 | (37.7808136360807, -122.44734276226) | 15 | 5 | 1 | 54 | 16 | |||
150999 | 38089 | DPW Maintained 1 | Tristania conferta :: 61 | 2516 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 11 | Permit Number 40261 | 6000533.912 | 2114143.0655 | 37.7850629895885 | -122.44189432664 | (37.7850629895885, -122.44189432664) | 15 | 6 | 1 | 29490 | 27 | |
151088 | 14450 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Masonic Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 5998930.2641 | 2112586.1918 | 37.7806967093816 | -122.447330326113 | (37.7806967093816, -122.447330326113) | 15 | 5 | 1 | 54 | 16 | |||
151498 | 143149 | DPW Maintained 1 | Tristania conferta :: 61 | 2200 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6001799.8965 | 2119455.7632 | 37.7997223379978 | -122.437895087221 | (37.7997223379978, -122.437895087221) | 13 | 9 | 1 | 57 | 17 | |||
153584 | 143123 | DPW Maintained 1 | Tristania conferta :: 61 | 1999 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002882.226 | 2119527.3787 | 37.7999804626368 | -122.4341549557 | (37.7999804626368, -122.4341549557) | 13 | 9 | 1 | 57 | 17 | |||
154379 | 26165 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | 10 | 3x3 | 6003705.1408 | 2119642.0239 | 37.8003419189704 | -122.431315547527 | (37.8003419189704, -122.431315547527) | 13 | 9 | 1 | 57 | 17 | ||
156559 | 143384 | DPW Maintained 1 | Tristania conferta :: 61 | 1650 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004460.6831 | 2119822.6068 | 37.8008805420914 | -122.428713951546 | (37.8008805420914, -122.428713951546) | 13 | 9 | 1 | 57 | 17 | |||
156933 | 138812 | DPW Maintained 1 | Tristania conferta :: 61 | 2918 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999941.4309 | 2114752.8886 | 37.7867036265991 | -122.443987949455 | (37.7867036265991, -122.443987949455) | 15 | 6 | 1 | 29490 | 31 | |||
160202 | 13162 | DPW Maintained 1 | Tristania conferta :: 61 | 1901 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/1997 12:00:00 AM | 6 | 3X3 | 6003171.1793 | 2119566.6116 | 37.8001045813382 | -122.433157873196 | (37.8001045813382, -122.433157873196) | 13 | 9 | 1 | 57 | 17 | ||
161326 | 138199 | DPW Maintained 1 | Tristania conferta :: 61 | 180 Masonic Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998946.8467 | 2112434.5788 | 37.7802813669123 | -122.447262044085 | (37.7802813669123, -122.447262044085) | 15 | 5 | 1 | 54 | 16 | |||
161373 | 255639 | Undocumented 4 | Tristania conferta :: 61 | 200 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | ||||
162341 | 138231 | DPW Maintained 1 | Tristania conferta :: 61 | 260 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998978.8276 | 2112205.6364 | 37.7796545776567 | -122.447134926754 | (37.7796545776567, -122.447134926754) | 15 | 5 | 1 | 54 | 16 | |||
162409 | 141091 | DPW Maintained 1 | Tristania conferta :: 61 | 194 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996268.2382 | 2112980.2839 | 37.7816263087743 | -122.456568006554 | (37.7816263087743, -122.456568006554) | 11 | 6 | 1 | 54 | 31 | |||
162433 | 99007 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
164145 | 141092 | DPW Maintained 1 | Tristania conferta :: 61 | 192 Jordan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5996267.8998 | 2112993.8208 | 37.7816634580812 | -122.456570156481 | (37.7816634580812, -122.456570156481) | 11 | 6 | 1 | 54 | 31 | |||
167297 | 137924 | DPW Maintained 1 | Tristania conferta :: 61 | 1901 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003382.683 | 2115264.2206 | 37.7883033159478 | -122.432118575792 | (37.7883033159478, -122.432118575792) | 13 | 9 | 1 | 29490 | 27 | |||
167340 | 138201 | DPW Maintained 1 | Tristania conferta :: 61 | 100 MASONIC AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5998933.3099 | 2112544.5659 | 37.7805825894916 | -122.447316792413 | (37.7805825894916, -122.447316792413) | 15 | 5 | 1 | 54 | 16 | |||
170156 | 114594 | DPW Maintained 1 | Tristania conferta :: 61 | 2584 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.7850072942162 | -122.442863075731 | (37.7850072942162, -122.442863075731) | 15 | 6 | 1 | 29490 | 27 | |||
171319 | 13253 | DPW Maintained 1 | Tristania conferta :: 61 | 2400 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6000858.2681 | 2119325.515 | 37.7993111202698 | -122.441144109229 | (37.7993111202698, -122.441144109229) | 13 | 9 | 1 | 57 | 17 | |||
173902 | 143131 | DPW Maintained 1 | Tristania conferta :: 61 | 2425 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000792.2705 | 2119235.098 | 37.7990590996693 | -122.44136599201 | (37.7990590996693, -122.44136599201) | 13 | 9 | 1 | 57 | 17 | |||
174651 | 14444 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5998945.1546 | 2112453.5304 | 37.7803333064109 | -122.447269262196 | (37.7803333064109, -122.447269262196) | 15 | 5 | 1 | 54 | 16 | |||
174986 | 13169 | DPW Maintained 1 | Tristania conferta :: 61 | 1929 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6003141.2876 | 2119559.1387 | 37.8000823670196 | -122.433260775641 | (37.8000823670196, -122.433260775641) | 13 | 9 | 1 | 57 | 17 | ||
176628 | 138449 | DPW Maintained 1 | Tristania conferta :: 61 | 1700 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002092.4131 | 2114399.0626 | 37.7858545762691 | -122.436520742323 | (37.7858545762691, -122.436520742323) | 13 | 6 | 1 | 29490 | 27 | |||
176684 | 93016 | DPW Maintained 1 | Tristania conferta :: 61 | 2395 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; Tree #1 on the Scott St frontage | 6000962.9097 | 2119261.1002 | 37.7991402141254 | -122.440777390622 | (37.7991402141254, -122.440777390622) | 13 | 9 | 1 | 57 | 17 | |
177527 | 143386 | DPW Maintained 1 | Tristania conferta :: 61 | 1662 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004406.1559 | 2119815.6459 | 37.8008583431077 | -122.428902142117 | (37.8008583431077, -122.428902142117) | 13 | 9 | 1 | 57 | 17 | |||
179984 | 13141 | DPW Maintained 1 | Tristania conferta :: 61 | 1790 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003874.0187 | 2119744.4452 | 37.8006327105148 | -122.430738476202 | (37.8006327105148, -122.430738476202) | 13 | 9 | 1 | 57 | 17 | |||
181310 | 13233 | DPW Maintained 1 | Tristania conferta :: 61 | 2301X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001245.6832 | 2119299.2908 | 37.7992611751931 | -122.439801639901 | (37.7992611751931, -122.439801639901) | 13 | 9 | 1 | 57 | 17 | |||
184775 | 138598 | DPW Maintained 1 | Tristania conferta :: 61 | 1951 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001454.5399 | 2115120.9706 | 37.7878004824405 | -122.43877935082 | (37.7878004824405, -122.43877935082) | 13 | 6 | 1 | 29490 | 27 | |||
186310 | 143385 | DPW Maintained 1 | Tristania conferta :: 61 | 1658 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004429.3589 | 2119821.4466 | 37.8008755836208 | -122.428822263738 | (37.8008755836208, -122.428822263738) | 13 | 9 | 1 | 57 | 17 | |||
188720 | 13174 | DPW Maintained 1 | Tristania conferta :: 61 | 1950 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6003011.134 | 2119622.0359 | 37.8002476819942 | -122.43371565452 | (37.8002476819942, -122.43371565452) | 13 | 9 | 1 | 57 | 17 | ||
191173 | 13094 | DPW Maintained 1 | Tristania conferta :: 61 | 1450 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1995 12:00:00 AM | 12 | 3X3 | 6005349.3555 | 2119944.5969 | 37.801265750478 | -122.425647455227 | (37.801265750478, -122.425647455227) | 13 | 9 | 1 | 57 | 17 | ||
191788 | 141089 | DPW Maintained 1 | Tristania conferta :: 61 | 100x JORDAN AVE | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 5996248.2713 | 2112978.5918 | 37.7816205163369 | -122.456636959709 | (37.7816205163369, -122.456636959709) | 11 | 6 | 1 | 54 | 31 | |||
193522 | 13279 | DPW Maintained 1 | Tristania conferta :: 61 | 2525 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2008 12:00:00 AM | 6 | 3X3 | 6000265.7268 | 2119165.2172 | 37.7988372159853 | -122.443182983285 | (37.7988372159853, -122.443182983285) | 13 | 9 | 1 | 57 | 17 | ||
1715 | 122822 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010044.5984 | 2120081.0225 | 37.8019045299018 | -122.409409413578 | (37.8019045299018, -122.409409413578) | 3 | 1 | 10 | 308 | 23 | |||
4257 | 4614 | DPW Maintained 1 | Tristania conferta :: 61 | 347 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1991 12:00:00 AM | 30 | 3x3 | 6010525.6854 | 2118803.2675 | 37.7984230708943 | -122.407654474652 | (37.7984230708943, -122.407654474652) | 3 | 1 | 10 | 308 | 4 | ||
4802 | 65984 | DPW Maintained 1 | Tristania conferta :: 61 | 1520 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1990 12:00:00 AM | 14 | Permit Number 29013 | 6010137.4433 | 2119339.4921 | 37.7998736715658 | -122.409035773182 | (37.7998736715658, -122.409035773182) | 3 | 1 | 10 | 308 | 23 | |
5348 | 72411 | DPW Maintained 1 | Tristania conferta :: 61 | 475 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6x6 | 6010101.0381 | 2120567.585 | 37.8032436723817 | -122.409248460006 | (37.8032436723817, -122.409248460006) | 3 | 1 | 10 | 308 | 23 | ||
11172 | 82387 | DPW Maintained 1 | Tristania conferta :: 61 | 615 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010004.402 | 2119511.4587 | 37.8003383958996 | -122.409508291437 | (37.8003383958996, -122.409508291437) | 3 | 1 | 10 | 308 | 23 | |||
21423 | 143427 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010650.0101 | 2116903.247 | 37.7932130339503 | -122.407090272453 | (37.7932130339503, -122.407090272453) | 3 | 1 | 10 | 28857 | 4 | |||
21708 | 30437 | DPW Maintained 1 | Tristania conferta :: 61 | 567 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 12 | Permit Number 90 | 6010234.0616 | 2119544.2672 | 37.8004413456091 | -122.40871589046 | (37.8004413456091, -122.40871589046) | 3 | 1 | 10 | 308 | 23 | ||
39132 | 143429 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010687.6362 | 2116910.2621 | 37.7932344012545 | -122.406960577759 | (37.7932344012545, -122.406960577759) | 3 | 1 | 10 | 28857 | 4 | |||
49007 | 142626 | DPW Maintained 1 | Tristania conferta :: 61 | 735 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6009290.0663 | 2119929.1695 | 37.8014452745633 | -122.412009721134 | (37.8014452745633, -122.412009721134) | 3 | 1 | 10 | 308 | 4 | |||
51824 | 142500 | DPW Maintained 1 | Tristania conferta :: 61 | 629 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6009964.6425 | 2119505.3419 | 37.8003193727849 | -122.409645443683 | (37.8003193727849, -122.409645443683) | 3 | 1 | 10 | 308 | 23 | |||
55003 | 142704 | DPW Maintained 1 | Tristania conferta :: 61 | 540 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6008680.9196 | 2121106.7911 | 37.804644533379 | -122.414201013023 | (37.804644533379, -122.414201013023) | 3 | 1 | 10 | 308 | 23 | |||
56029 | 142485 | DPW Maintained 1 | Tristania conferta :: 61 | 1501 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010091.845 | 2119435.9713 | 37.8001360252908 | -122.409200372911 | (37.8001360252908, -122.409200372911) | 3 | 1 | 10 | 308 | 23 | |||
56090 | 143431 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010731.6396 | 2116914.7262 | 37.7932491208157 | -122.406808637133 | (37.7932491208157, -122.406808637133) | 3 | 1 | 10 | 28857 | 4 | |||
58162 | 142689 | DPW Maintained 1 | Tristania conferta :: 61 | 554 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008629.0451 | 2121101.0906 | 37.8046259673251 | -122.414380126753 | (37.8046259673251, -122.414380126753) | 3 | 1 | 10 | 308 | 23 | |||
59790 | 142498 | DPW Maintained 1 | Tristania conferta :: 61 | 535 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6009947.0726 | 2119329.9097 | 37.7998366945829 | -122.409693853229 | (37.7998366945829, -122.409693853229) | 3 | 1 | 10 | 308 | 4 | |||
60842 | 143430 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010708.6813 | 2116911.5375 | 37.7932390808025 | -122.406887849913 | (37.7932390808025, -122.406887849913) | 3 | 1 | 10 | 28857 | 4 | |||
65594 | 98674 | DPW Maintained 1 | Tristania conferta :: 61 | 1520 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6010134.1069 | 2119364.7936 | 37.7999429563689 | -122.409049104677 | (37.7999429563689, -122.409049104677) | 3 | 1 | 10 | 308 | 23 | |||
66530 | 122823 | Permitted Site 7 | Tristania conferta :: 61 | 1736 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 4x4 | 6010043.2132 | 2120098.5684 | 37.8019526289989 | -122.409415446027 | (37.8019526289989, -122.409415446027) | 3 | 1 | 10 | 308 | 23 | ||
68806 | 142719 | DPW Maintained 1 | Tristania conferta :: 61 | 1150 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008016.4786 | 2121177.0503 | 37.8048001035106 | -122.416505361905 | (37.8048001035106, -122.416505361905) | 5 | 1 | 10 | 308 | 23 | |||
69266 | 64367 | DPW Maintained 1 | Tristania conferta :: 61 | 545 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 10 | Permit Number 25206 | 6010276.1583 | 2120241.7062 | 37.8023586991127 | -122.408619445814 | (37.8023586991127, -122.408619445814) | 3 | 1 | 10 | 308 | 23 | |
74581 | 143104 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010039.5193 | 2120117.0378 | 37.8020031344426 | -122.409429532928 | (37.8020031344426, -122.409429532928) | 3 | 1 | 10 | 308 | 23 | |||
75868 | 28074 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008638.4319 | 2120527.3912 | 37.8030512599832 | -122.414307026238 | (37.8030512599832, -122.414307026238) | 3 | 1 | 10 | 308 | 32 | ||
76380 | 50978 | DPW Maintained 1 | Tristania conferta :: 61 | 807REVISED Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2004 12:00:00 AM | 11 | Permit Number 47464 | 6008954.8893 | 2120241.9921 | 37.8022853965169 | -122.413191720991 | (37.8022853965169, -122.413191720991) | 3 | 1 | 10 | 308 | 32 | ||
105426 | 142501 | DPW Maintained 1 | Tristania conferta :: 61 | 601 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6010024.9768 | 2119514.2391 | 37.8003471830213 | -122.409437290498 | (37.8003471830213, -122.409437290498) | 3 | 1 | 10 | 308 | 23 | |||
112653 | 28076 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2003 12:00:00 AM | 25 | 3X3 | 6008674.8876 | 2120493.8068 | 37.8029610933815 | -122.414178492558 | (37.8029610933815, -122.414178492558) | 3 | 1 | 10 | 308 | 32 | ||
117314 | 64341 | DPW Maintained 1 | Tristania conferta :: 61 | 1736 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1988 12:00:00 AM | 11 | Permit Number 25170 | 6010046.9071 | 2120063.9383 | 37.8018577502609 | -122.409400217983 | (37.8018577502609, -122.409400217983) | 3 | 1 | 10 | 308 | 23 | |
129700 | 32359 | DPW Maintained 1 | Tristania conferta :: 61 | 1660 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 8 | Permit Number 36912 | 6010078.2473 | 2119834.5139 | 37.8012295633542 | -122.409275566389 | (37.8012295633542, -122.409275566389) | 3 | 1 | 10 | 308 | 23 | |
130647 | 32360 | DPW Maintained 1 | Tristania conferta :: 61 | 1660 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | 12 | Permit Number 36912 | 6010075.9386 | 2119846.6344 | 37.8012627139137 | -122.409284411348 | (37.8012627139137, -122.409284411348) | 3 | 1 | 10 | 308 | 23 | ||
138915 | 38378 | DPW Maintained 1 | Tristania conferta :: 61 | 2027 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/1998 12:00:00 AM | 11 | Permit Number 40437 | 6009441.5117 | 2120654.7585 | 37.8034460574359 | -122.411536943543 | (37.8034460574359, -122.411536943543) | 3 | 1 | 10 | 308 | 23 | ||
143756 | 65429 | DPW Maintained 1 | Tristania conferta :: 61 | 679 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/1989 12:00:00 AM | 9 | Permit Number 28288 | 6010678.2615 | 2116199.1916 | 37.7912814481387 | -122.406942874303 | (37.7912814481387, -122.406942874303) | 5 | 1 | 10 | 28857 | 6 | |
158633 | 64370 | DPW Maintained 1 | Tristania conferta :: 61 | 525 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 7 | Permit Number 25209 | 6010332.9517 | 2120250.0174 | 37.8023847002257 | -122.408423498481 | (37.8023847002257, -122.408423498481) | 3 | 1 | 10 | 308 | 23 | |
163692 | 12987 | DPW Maintained 1 | Tristania conferta :: 61 | 318 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6010766.7048 | 2120702.1725 | 37.8036504876245 | -122.406954379692 | (37.8036504876245, -122.406954379692) | 3 | 1 | 10 | 308 | 23 | ||
169804 | 26540 | DPW Maintained 1 | Tristania conferta :: 61 | 530 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008777.828 | 2121123.8926 | 37.8046969326474 | -122.413866861434 | (37.8046969326474, -122.413866861434) | 3 | 1 | 10 | 308 | 23 | |||
179871 | 28075 | DPW Maintained 1 | Tristania conferta :: 61 | 915 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008651.5543 | 2120512.2278 | 37.8030103621977 | -122.414260542242 | (37.8030103621977, -122.414260542242) | 3 | 1 | 10 | 308 | 32 | ||
183503 | 142654 | DPW Maintained 1 | Tristania conferta :: 61 | 1188 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6007961.2413 | 2121229.1008 | 37.8049399144717 | -122.416700206529 | (37.8049399144717, -122.416700206529) | 5 | 1 | 10 | 308 | 23 | |||
193240 | 143432 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010753.9601 | 2116917.9148 | 37.7932591248157 | -122.406731631165 | (37.7932591248157, -122.406731631165) | 3 | 1 | 10 | 28857 | 4 | |||
193951 | 142653 | DPW Maintained 1 | Tristania conferta :: 61 | 1188 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6007975.5818 | 2121216.8848 | 37.8049071789669 | -122.416649713579 | (37.8049071789669, -122.416649713579) | 5 | 1 | 10 | 308 | 23 | |||
369 | 138522 | Undocumented 4 | Tristania conferta :: 61 | 1602 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001658.1955 | 2114019.9111 | 37.7847888393579 | -122.437995843174 | (37.7847888393579, -122.437995843174) | 13 | 6 | 11 | 29490 | 13 | |||
899 | 9520 | DPW Maintained 1 | Tristania conferta :: 61 | 1046 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004532.0878 | 2112270.4724 | 37.7801483287397 | -122.427928412048 | (37.7801483287397, -122.427928412048) | 7 | 9 | 11 | 29490 | 41 | ||
1099 | 138916 | DPW Maintained 1 | Tristania conferta :: 61 | 707 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004396.0968 | 2110813.5411 | 37.7761402601039 | -122.428295000541 | (37.7761402601039, -122.428295000541) | 7 | 9 | 11 | 28852 | 10 | |||
1178 | 7095 | DPW Maintained 1 | Tristania conferta :: 61 | 1970 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1994 12:00:00 AM | 18 | 3X3 | 5998027.6156 | 2109626.606 | 37.7725188329855 | -122.45023961224 | (37.7725188329855, -122.45023961224) | 15 | 5 | 11 | 29492 | 16 | ||
1445 | 140697 | DPW Maintained 1 | Tristania conferta :: 61 | 859 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999231.335 | 2109939.9835 | 37.7734481000077 | -122.446098386426 | (37.7734481000077, -122.446098386426) | 15 | 5 | 11 | 29492 | 16 | |||
2931 | 6985 | DPW Maintained 1 | Tristania conferta :: 61 | 819 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6003479.628 | 2110333.4443 | 37.7747701331995 | -122.431431030712 | (37.7747701331995, -122.431431030712) | 15 | 9 | 11 | 29492 | 10 | ||
3148 | 24262 | DPW Maintained 1 | Tristania conferta :: 61 | 600X Willow St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2004 12:00:00 AM | 3 | 3X3 | 6004514.0905 | 2113119.5269 | 37.7824786038336 | -122.428051195433 | (37.7824786038336, -122.428051195433) | 7 | 9 | 11 | 29490 | 41 | ||
3420 | 79436 | DPW Maintained 1 | Tristania conferta :: 61 | 606 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004047.0413 | 2110853.2815 | 37.7762296204821 | -122.429505312147 | (37.7762296204821, -122.429505312147) | 7 | 9 | 11 | 28852 | 10 | |||
3600 | 23929 | DPW Maintained 1 | Tristania conferta :: 61 | 1715 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/1992 12:00:00 AM | 20 | 4X4 | 6003463.555 | 2114659.6298 | 37.7866478474124 | -122.431795587112 | (37.7866478474124, -122.431795587112) | 13 | 9 | 11 | 29490 | 27 | ||
4598 | 140349 | DPW Maintained 1 | Tristania conferta :: 61 | 1314 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004502.4614 | 2113302.7614 | 37.7829810622913 | -122.428104489199 | (37.7829810622913, -122.428104489199) | 7 | 9 | 11 | 29490 | 41 | |||
4786 | 70866 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005878.7494 | 2111261.8484 | 37.7774549853258 | -122.423197973584 | (37.7774549853258, -122.423197973584) | 7 | 9 | 11 | 28852 | 10 | |||
4880 | 10701 | DPW Maintained 1 | Tristania conferta :: 61 | 1290 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001704.3359 | 2110485.9297 | 37.7750880443133 | -122.437583041692 | (37.7750880443133, -122.437583041692) | 15 | 5 | 11 | 29492 | 10 | |||
5148 | 247454 | DPW Maintained 1 | Tristania conferta :: 61 | 563 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003114.7156 | 2110238.7499 | 37.7744894374273 | -122.432686570898 | (37.7744894374273, -122.432686570898) | 15 | 9 | 11 | 29492 | 10 | |||
5368 | 73913 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6005876.1258 | 2111280.7378 | 37.7775067029674 | -122.423208392543 | (37.7775067029674, -122.423208392543) | 7 | 9 | 11 | 28852 | 10 |
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) );