trees
1,377 rows where qSpecies_id = 61 sorted by qCareAssistant descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1224 | 81614 | DPW Maintained 1 | Tristania conferta :: 61 | 1450@ Shafter Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6017097.2029 | 2092677.3305 | 37.7270524726432 | -122.383095431375 | (37.7270524726432, -122.383095431375) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
4086 | 69819 | DPW Maintained 1 | Tristania conferta :: 61 | 3521 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983899.4988 | 2104926.7311 | 37.7587956653789 | -122.498762161048 | (37.7587956653789, -122.498762161048) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
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 | ||
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 | |||
5852 | 83783 | DPW Maintained 1 | Tristania conferta :: 61 | 606 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6004048.7127 | 2110839.5763 | 37.7761920840099 | -122.429498552699 | (37.7761920840099, -122.429498552699) | 7 | 9 | 11 | 28852 | 10 | |||
8843 | 57906 | DPW Maintained 1 | Tristania conferta :: 61 | 643 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 13 | Permit Number 20197 | 6000071.8454 | 2111132.0779 | 37.7767692506982 | -122.443276587526 | (37.7767692506982, -122.443276587526) | 15 | 5 | 11 | 29492 | 16 | |
8910 | 74145 | DPW Maintained 1 | Tristania conferta :: 61 | 499 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6005875.6011 | 2111298.5777 | 37.7775556573861 | -122.423211476089 | (37.7775556573861, -122.423211476089) | 7 | 9 | 11 | 28852 | 10 | |||
10761 | 60596 | DPW Maintained 1 | Tristania conferta :: 61 | 1773 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 18 | Permit Number 20216 | 6000702.1439 | 2111336.8084 | 37.7773673101232 | -122.441110894469 | (37.7773673101232, -122.441110894469) | 15 | 5 | 11 | 29492 | 41 | |
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 | |||
13435 | 71273 | DPW Maintained 1 | Tristania conferta :: 61 | 2480 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6000737.6791 | 2114169.5665 | 37.7851473635462 | -122.441191260636 | (37.7851473635462, -122.441191260636) | 15 | 6 | 1 | 29490 | 27 | |||
14129 | 71258 | DPW Maintained 1 | Tristania conferta :: 61 | 923 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 3x3 | 6001950.0126 | 2111666.817 | 37.778344429762 | -122.436817746544 | (37.778344429762, -122.436817746544) | 15 | 5 | 11 | 29490 | 41 | ||
14541 | 65945 | DPW Maintained 1 | Tristania conferta :: 61 | 528 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 12 | Permit Number 28966 | 6007615.5081 | 2113146.6876 | 37.7827281591619 | -122.417323539063 | (37.7827281591619, -122.417323539063) | 7 | 9 | 9 | 28852 | 36 | |
15026 | 60579 | DPW Maintained 1 | Tristania conferta :: 61 | 556 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 13 | Permit Number 20193 | 6000143.5821 | 2110857.5211 | 37.7760194779825 | -122.443008707696 | (37.7760194779825, -122.443008707696) | 15 | 5 | 11 | 29492 | 16 | |
17454 | 55475 | DPW Maintained 1 | Tristania conferta :: 61 | 1290 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1972 12:00:00 AM | 9 | Permit Number 11427 | 6001668.0931 | 2110827.7285 | 37.7760244773884 | -122.437732898122 | (37.7760244773884, -122.437732898122) | 15 | 5 | 11 | 29492 | 10 | |
18547 | 41551 | DPW Maintained 1 | Tristania conferta :: 61 | 627 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 11 | Permit Number 42073 | 6000076.2449 | 2111080.2993 | 37.7766273307268 | -122.443257648559 | (37.7766273307268, -122.443257648559) | 15 | 5 | 11 | 29492 | 16 | |
26593 | 65948 | DPW Maintained 1 | Tristania conferta :: 61 | 550 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 12 | Permit Number 28969 | 6007606.7794 | 2113206.8791 | 37.7828929393541 | -122.417358003683 | (37.7828929393541, -122.417358003683) | 7 | 9 | 9 | 28852 | 36 | |
27028 | 68142 | DPW Maintained 1 | Tristania conferta :: 61 | 2532 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 1 | Permit Number 31896 | 6000452.2737 | 2114128.7986 | 37.785019164077 | -122.442175744115 | (37.785019164077, -122.442175744115) | 15 | 6 | 1 | 29490 | 27 | |
48284 | 158174 | Permitted Site 7 | Tristania conferta :: 61 | 134 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781228 | 6004059.11028 | 2096889.51678 | 37.7378891113908 | -122.428468031191 | (37.7378891113908, -122.428468031191) | 2 | 7 | 5 | 63 | 7 |
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 | ||
68479 | 61323 | DPW Maintained 1 | Tristania conferta :: 61 | 1662 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/1984 12:00:00 AM | 14 | Permit Number 21226 | 5999808.8917 | 2110918.1953 | 37.7761669857267 | -122.444170847057 | (37.7761669857267, -122.444170847057) | 15 | 5 | 11 | 29492 | 16 | |
69119 | 96027 | DPW Maintained 1 | Tristania conferta :: 61 | 724 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2016 12:00:00 AM | 1 | 3x3 | Permit Number 773631 | 6007519.56601 | 2113828.09623 | 37.7845937435516 | -122.41770377222 | (37.7845937435516, -122.41770377222) | 7 | 9 | 9 | 28858 | 36 |
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 | |
75375 | 158175 | Permitted Site 7 | Tristania conferta :: 61 | 300 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781228 | 6004086.99843 | 2096830.17567 | 37.7377277523181 | -122.428367379954 | (37.7377277523181, -122.428367379954) | 2 | 7 | 5 | 63 | 7 |
76664 | 109151 | Permitted Site 7 | Tristania conferta :: 61 | 727 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769036 | 5986896.6 | 2110966.4 | 37.7755542438819 | -122.48884090533 | (37.7755542438819, -122.48884090533) | 11 | 6 | 2 | 55 | 26 |
84708 | 32805 | DPW Maintained 1 | Tristania conferta :: 61 | 1690 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 18 | Permit Number 37166 | 5999795.9625 | 2110223.9545 | 37.774260039648 | -122.444165674595 | (37.774260039648, -122.444165674595) | 15 | 5 | 11 | 29492 | 16 | |
92375 | 61330 | DPW Maintained 1 | Tristania conferta :: 61 | 1660 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/1984 12:00:00 AM | 17 | Permit Number 21234 | 5999839.3496 | 2110922.2564 | 37.7761798740273 | -122.444065777165 | (37.7761798740273, -122.444065777165) | 15 | 5 | 11 | 29492 | 16 | |
92855 | 57971 | DPW Maintained 1 | Tristania conferta :: 61 | 535 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 16 | Permit Number 19405 | 5999675.0078 | 2110381.8765 | 37.7746867521579 | -122.444595430155 | (37.7746867521579, -122.444595430155) | 15 | 5 | 11 | 29492 | 16 | |
95409 | 68141 | DPW Maintained 1 | Tristania conferta :: 61 | 2528 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 14 | Permit Number 31895 | 6000471.2962 | 2114132.7617 | 37.7850311298137 | -122.442110217066 | (37.7850311298137, -122.442110217066) | 15 | 6 | 1 | 29490 | 27 | |
100073 | 68137 | DPW Maintained 1 | Tristania conferta :: 61 | 2786 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 9 | Permit Number 31889 | 6000193.313 | 2114445.5102 | 37.7858740103556 | -122.443094416733 | (37.7858740103556, -122.443094416733) | 13 | 6 | 1 | 29490 | 27 | |
110624 | 68143 | DPW Maintained 1 | Tristania conferta :: 61 | 2540 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 14 | Permit Number 31897 | 6000418.1917 | 2114124.8356 | 37.7850063402866 | -122.442293372082 | (37.7850063402866, -122.442293372082) | 15 | 6 | 1 | 29490 | 27 | |
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 | |
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 |
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 | |
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 | |
148527 | 119142 | Permitted Site 7 | Tristania conferta :: 61 | 583 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781376 | 5981295.16505 | 2111765.56723 | 37.7774200299425 | -122.508276611938 | (37.7774200299425, -122.508276611938) | 11 | 6 | 2 | 55 | 26 |
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 | |
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 | |
187147 | 38128 | DPW Maintained 1 | Tristania conferta :: 61 | 2817 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 6 | Permit Number 40292 | 5986952.8937 | 2107070.8859 | 37.7648615361674 | -122.488359826673 | (37.7648615361674, -122.488359826673) | 1 | 8 | 3 | 56 | 35 | |
49136 | 42633 | DPW Maintained 1 | Tristania conferta :: 61 | 1651 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2016 02:56:00 PM | 3 | 5x5 | Permit Number 45045 | 6005048.16251 | 2118816.23898 | 37.7981505449739 | -122.426609321383 | (37.7981505449739, -122.426609321383) | 13 | 9 | 1 | 57 | 17 |
83005 | 93014 | DPW Maintained 1 | Tristania conferta :: 61 | 2395 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001021.4146 | 2119265.9756 | 37.7991569323377 | -122.440575294128 | (37.7991569323377, -122.440575294128) | 13 | 9 | 1 | 57 | 17 |
129116 | 93015 | DPW Maintained 1 | Tristania conferta :: 61 | 2395 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001036.8533 | 2119267.6007 | 37.7991622735558 | -122.440521987709 | (37.7991622735558, -122.440521987709) | 13 | 9 | 1 | 57 | 17 |
173655 | 200921 | DPW Maintained 1 | Tristania conferta :: 61 | 4040 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 01/18/2008 12:00:00 AM | 5 | Width 0ft | 6015547.5959 | 2097647.2059 | 37.7406129979736 | -122.388799250904 | (37.7406129979736, -122.388799250904) | 10 | 3 | 8 | 58 | 1 | |
130 | 13128 | DPW Maintained 1 | Tristania conferta :: 61 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.429850711739 | (37.8007374433085, -122.429850711739) | 13 | 9 | 1 | 57 | 17 | |||
209 | 138219 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998675.4325 | 2112652.6916 | 37.7808647356786 | -122.448216697429 | (37.7808647356786, -122.448216697429) | 15 | 6 | 2 | 54 | 16 | |||
303 | 87474 | DPW Maintained 1 | Tristania conferta :: 61 | 6290 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x5 | 6013182.5276 | 2090518.895 | 37.7209087510834 | -122.39647726989 | (37.7209087510834, -122.39647726989) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
788 | 200933 | DPW Maintained 1 | Tristania conferta :: 61 | 4210 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6015403.5213 | 2097186.1672 | 37.7393390938031 | -122.389265224086 | (37.7393390938031, -122.389265224086) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
2490 | 195264 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 771659 | 6011775.98455 | 2114888.82062 | 37.7877448438967 | -122.403052549837 | (37.7877448438967, -122.403052549837) | 12 | 2 | 9 | 28855 | 6 | |
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 | ||
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 | ||
3625 | 22438 | DPW Maintained 1 | Tristania conferta :: 61 | 6025 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6013608.4406 | 2091403.3166 | 37.7233608886837 | -122.395066921688 | (37.7233608886837, -122.395066921688) | 10 | 3 | 8 | 58 | 1 | |||
3754 | 261321 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.440065245785 | (37.7992300540772, -122.440065245785) | 13 | 9 | 1 | 57 | 17 | ||||
3757 | 29485 | DPW Maintained 1 | Tristania conferta :: 61 | 1608 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016787.6638 | 2093383.8729 | 37.7289753898862 | -122.38421469762 | (37.7289753898862, -122.38421469762) | 10 | 3 | 8 | 58 | 1 | ||
4020 | 22395 | DPW Maintained 1 | Tristania conferta :: 61 | 5700 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/2011 12:00:00 AM | 6 | 3x3 | 6013894.8509 | 2092365.7305 | 37.7260194067343 | -122.394144192498 | (37.7260194067343, -122.394144192498) | 10 | 3 | 8 | 58 | 1 | ||
4029 | 138227 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998554.9543 | 2112632.7248 | 37.7808030238066 | -122.448632050181 | (37.7808030238066, -122.448632050181) | 15 | 6 | 2 | 54 | 16 | |||
4210 | 29504 | DPW Maintained 1 | Tristania conferta :: 61 | 1800X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016442.8409 | 2092919.0689 | 37.7276800583286 | -122.385374410624 | (37.7276800583286, -122.385374410624) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 | |||
4874 | 143132 | DPW Maintained 1 | Tristania conferta :: 61 | 2435 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000754.0798 | 2119231.0352 | 37.7990457686205 | -122.441497852636 | (37.7990457686205, -122.441497852636) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
5423 | 138217 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998640.9134 | 2112646.2616 | 37.7808451071221 | -122.448335652205 | (37.7808451071221, -122.448335652205) | 15 | 6 | 2 | 54 | 16 | |||
5658 | 6307 | DPW Maintained 1 | Tristania conferta :: 61 | 1804 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6002139.3488 | 2112974.3616 | 37.781945376326 | -122.436256362281 | (37.781945376326, -122.436256362281) | 15 | 5 | 11 | 29490 | 41 | |||
5894 | 29427 | DPW Maintained 1 | Tristania conferta :: 61 | 2501X Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.388965539304 | (37.7234697537221, -122.388965539304) | 10 | 3 | 8 | 58 | 1 | ||
5979 | 137873 | DPW Maintained 1 | Tristania conferta :: 61 | 1805 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005262.4155 | 2115445.1649 | 37.7889065369741 | -122.425627888461 | (37.7889065369741, -122.425627888461) | 13 | 9 | 11 | 28858 | 27 | |||
6244 | 138902 | DPW Maintained 1 | Tristania conferta :: 61 | 518 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004070.6412 | 2110683.9615 | 37.7757660455959 | -122.42941159626 | (37.7757660455959, -122.42941159626) | 7 | 9 | 11 | 28852 | 10 | |||
6267 | 200934 | DPW Maintained 1 | Tristania conferta :: 61 | 4220 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6015398.3252 | 2097166.7998 | 37.7392856268198 | -122.389281837998 | (37.7392856268198, -122.389281837998) | 10 | 3 | 8 | 58 | 1 | |||
6338 | 141477 | DPW Maintained 1 | Tristania conferta :: 61 | 25 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5997952.6249 | 2111528.1769 | 37.777735763362 | -122.450636133087 | (37.777735763362, -122.450636133087) | 15 | 6 | 2 | 54 | 16 | |||
6704 | 13114 | DPW Maintained 1 | Tristania conferta :: 61 | 1618 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2005 12:00:00 AM | 12 | 3x3 | 6004576.6984 | 2119842.3294 | 37.800941260536 | -122.428313896065 | (37.800941260536, -122.428313896065) | 13 | 9 | 1 | 57 | 17 | ||
6717 | 138911 | DPW Maintained 1 | Tristania conferta :: 61 | 723 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004266.8521 | 2110794.1209 | 37.776079623036 | -122.428740708053 | (37.776079623036, -122.428740708053) | 7 | 9 | 11 | 28852 | 10 | |||
6940 | 140679 | DPW Maintained 1 | Tristania conferta :: 61 | 1303 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004187.9883 | 2112981.79 | 37.7820819575387 | -122.429169542785 | (37.7820819575387, -122.429169542785) | 7 | 9 | 11 | 29490 | 41 | |||
7492 | 138882 | DPW Maintained 1 | Tristania conferta :: 61 | 510 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004088.2198 | 2110564.2595 | 37.7754383685459 | -122.429342249625 | (37.7754383685459, -122.429342249625) | 7 | 9 | 11 | 28852 | 10 | |||
7542 | 247487 | DPW Maintained 1 | Tristania conferta :: 61 | 312 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002757.5424 | 2109611.6714 | 37.772747372498 | -122.433877269198 | (37.772747372498, -122.433877269198) | 15 | 5 | 11 | 29492 | 9 | |||
7868 | 140649 | DPW Maintained 1 | Tristania conferta :: 61 | 109 Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997299.8022 | 2110011.7822 | 37.7735347493893 | -122.452784984309 | (37.7735347493893, -122.452784984309) | 15 | 5 | 2 | 29492 | 16 | |||
8629 | 29437 | DPW Maintained 1 | Tristania conferta :: 61 | 2307X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015612.318 | 2091732.5629 | 37.7243761643823 | -122.388162796666 | (37.7243761643823, -122.388162796666) | 10 | 3 | 8 | 58 | 1 | ||
8657 | 6306 | DPW Maintained 1 | Tristania conferta :: 61 | 1804 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002160.6694 | 2112978.761 | 37.7819586673159 | -122.436182917866 | (37.7819586673159, -122.436182917866) | 15 | 5 | 11 | 29490 | 41 | |||
8686 | 199711 | DPW Maintained 1 | Tristania conferta :: 61 | 1510 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015245.4888 | 2092572.1176 | 37.7266610833371 | -122.389489489481 | (37.7266610833371, -122.389489489481) | 10 | 3 | 8 | 58 | 1 | |||
8845 | 21605 | DPW Maintained 1 | Tristania conferta :: 61 | 1521 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6005164.0288 | 2114740.1913 | 37.7869652957353 | -122.425918090858 | (37.7869652957353, -122.425918090858) | 13 | 9 | 11 | 28858 | 13 | |||
9366 | 13179 | DPW Maintained 1 | Tristania conferta :: 61 | 1976 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6002902.1538 | 2119607.7128 | 37.8002021701058 | -122.434091743886 | (37.8002021701058, -122.434091743886) | 13 | 9 | 1 | 57 | 17 | ||
10009 | 141171 | DPW Maintained 1 | Tristania conferta :: 61 | 1804 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002115.9977 | 2112972.331 | 37.7819384740439 | -122.436337000836 | (37.7819384740439, -122.436337000836) | 15 | 5 | 11 | 29490 | 41 | |||
10110 | 13676 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011822.15902 | 2114934.32739 | 37.7878723731553 | -122.402895995877 | (37.7878723731553, -122.402895995877) | 12 | 2 | 9 | 28855 | 6 | |
10876 | 13180 | DPW Maintained 1 | Tristania conferta :: 61 | 1990 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 15 | 3X3 | 6002882.226 | 2119605.2218 | 37.8001941994801 | -122.434160523596 | (37.8001941994801, -122.434160523596) | 13 | 9 | 1 | 57 | 17 | ||
10885 | 13675 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011805.84433 | 2114919.40836 | 37.7878304980227 | -122.402951392291 | (37.7878304980227, -122.402951392291) | 12 | 2 | 9 | 28855 | 6 | |
10938 | 28832 | DPW Maintained 1 | Tristania conferta :: 61 | 1500 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016972.3335 | 2093632.2976 | 37.7296677240114 | -122.383593562534 | (37.7296677240114, -122.383593562534) | 10 | 3 | 8 | 58 | 1 | ||
11077 | 141992 | DPW Maintained 1 | Tristania conferta :: 61 | 818 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/31/1991 12:00:00 AM | 9 | Width 0ft | 6003994.291 | 2111559.6951 | 37.7781662710742 | -122.429738185966 | (37.7781662710742, -122.429738185966) | 7 | 9 | 11 | 29490 | 41 | ||
11372 | 121012 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6015178.5737 | 2115521.0723 | 37.7896702844128 | -122.391324356251 | (37.7896702844128, -122.391324356251) | 6 | 2 | 9 | 28855 | 6 | |||
11870 | 245936 | DPW Maintained 1 | Tristania conferta :: 61 | 188 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997210.9895 | 2107777.1744 | 37.76739400269 | -122.452930870305 | (37.76739400269, -122.452930870305) | 15 | 5 | 11 | 29492 | 9 | |||
11906 | 13674 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011788.8197 | 2114903.8104 | 37.787786719038 | -122.403009197144 | (37.787786719038, -122.403009197144) | 12 | 2 | 9 | 28855 | 6 | |
12207 | 6322 | DPW Maintained 1 | Tristania conferta :: 61 | 1864 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6001909.5604 | 2112942.2115 | 37.7818440417219 | -122.43704902047 | (37.7818440417219, -122.43704902047) | 15 | 5 | 11 | 29490 | 41 | |||
12388 | 6901 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/14/2015 12:30:00 PM | 3 | 3x3 | 6005680.1943 | 2110643.4354 | 37.775745766228 | -122.423840858061 | (37.775745766228, -122.423840858061) | 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) );