trees
1,377 rows where qSpecies_id = 61 sorted by PlotSize
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 | |
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 | |||
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 | |
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 | ||
24778 | 115380 | Permitted Site 7 | Tristania conferta :: 61 | 1657X York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.21326 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |
27170 | 68157 | DPW Maintained 1 | Tristania conferta :: 61 | 1515 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/1994 12:00:00 AM | 8 | Permit Number 33474 | 6005184.9642 | 2114742.2338 | 37.7869720870456 | -122.425845804507 | (37.7869720870456, -122.425845804507) | 13 | 9 | 11 | 28858 | 13 | ||
31069 | 50648 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012137.5662 | 2112614.0037 | 37.7815189132409 | -122.401641589024 | (37.7815189132409, -122.401641589024) | 6 | 2 | 9 | 28856 | 34 | ||
32803 | 61380 | DPW Maintained 1 | Tristania conferta :: 61 | 200 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1984 12:00:00 AM | 4 | Permit Number 21292 | 6014918.427 | 2115358.6091 | 37.7892097566572 | -122.392213077943 | (37.7892097566572, -122.392213077943) | 6 | 2 | 9 | 28855 | 6 | ||
32812 | 99009 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 8 | 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 | ||
37850 | 58330 | DPW Maintained 1 | Tristania conferta :: 61 | 61 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 15 | Permit Number 17355 | 5998228.2265 | 2111432.4618 | 37.7774887258067 | -122.449675837748 | (37.7774887258067, -122.449675837748) | 15 | 6 | 2 | 54 | 16 | ||
38204 | 41235 | DPW Maintained 1 | Tristania conferta :: 61 | 270 Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | 14 | Permit Number 41940 | 5998984.5808 | 2112167.7332 | 37.7795508339841 | -122.44711229551 | (37.7795508339841, -122.44711229551) | 15 | 5 | 1 | 54 | 16 | ||
43808 | 115203 | DPW Maintained 1 | Tristania conferta :: 61 | 2056 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2018 12:00:00 AM | 3 | Permit Number 769837 | 6001029.7 | 2112838.5 | 37.7815092255851 | -122.440085481713 | (37.7815092255851, -122.440085481713) | 15 | 5 | 11 | 29490 | 41 | ||
44329 | 54243 | DPW Maintained 1 | Tristania conferta :: 61 | 35 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 26 | Permit Number 9984 | 5997958.8776 | 2111479.5979 | 37.7776027359423 | -122.450610999735 | (37.7776027359423, -122.450610999735) | 15 | 6 | 2 | 54 | 16 | ||
52751 | 58328 | DPW Maintained 1 | Tristania conferta :: 61 | 41 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 18 | Permit Number 17353 | 5998217.1639 | 2111509.8996 | 37.7777007170302 | -122.449719688547 | (37.7777007170302, -122.449719688547) | 15 | 6 | 2 | 54 | 16 | ||
54954 | 62838 | DPW Maintained 1 | Tristania conferta :: 61 | 936 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1986 12:00:00 AM | 12 | Permit Number 23205 | 6001983.1694 | 2111715.7917 | 37.7784807863281 | -122.436706551647 | (37.7784807863281, -122.436706551647) | 15 | 5 | 11 | 29490 | 41 | ||
57279 | 12346 | DPW Maintained 1 | Tristania conferta :: 61 | 1200X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 6004717.664 | 2113030.0107 | 37.7822443298756 | -122.427340540761 | (37.7822443298756, -122.427340540761) | 7 | 9 | 11 | 28858 | 41 | ||||
58736 | 115369 | DPW Maintained 1 | Tristania conferta :: 61 | 720 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777460 | 5993541.3 | 2110551.9 | 37.7748016816289 | -122.465825344597 | (37.7748016816289, -122.465825344597) | 11 | 6 | 2 | 54 | 11 | ||
60498 | 32145 | DPW Maintained 1 | Tristania conferta :: 61 | 563 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | 11 | Permit Number 35498 | 6003116.0093 | 2110209.6426 | 37.7744095893472 | -122.432680016089 | (37.7744095893472, -122.432680016089) | 15 | 9 | 11 | 29492 | 10 | ||
62984 | 107146 | DPW Maintained 1 | Tristania conferta :: 61 | 2466 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5985834.1864 | 2098423.2393 | 37.7410521276716 | -122.491592490194 | (37.7410521276716, -122.491592490194) | 1 | 8 | 3 | 29491 | 35 | ||||
64454 | 10657 | DPW Maintained 1 | Tristania conferta :: 61 | 945 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/1990 12:00:00 AM | 6 | 6003325.2554 | 2110665.5174 | 37.7756731734805 | -122.431988754437 | (37.7756731734805, -122.431988754437) | 15 | 9 | 11 | 29492 | 10 | |||
67678 | 58335 | DPW Maintained 1 | Tristania conferta :: 61 | 22 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 17 | Permit Number 17360 | 5998246.0227 | 2111590.7043 | 37.7779242368219 | -122.449625680736 | (37.7779242368219, -122.449625680736) | 15 | 6 | 2 | 54 | 16 | ||
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 | |
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 | |
70707 | 107145 | DPW Maintained 1 | Tristania conferta :: 61 | 2466 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 5985834.5248 | 2098407.3335 | 37.7410084743792 | -122.491590149603 | (37.7410084743792, -122.491590149603) | 1 | 8 | 3 | 29491 | 35 | ||||
71323 | 59552 | DPW Maintained 1 | Tristania conferta :: 61 | 1602 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1981 12:00:00 AM | 21 | Permit Number 18937 | 6000082.8421 | 2110610.4978 | 37.7753377515139 | -122.443201076984 | (37.7753377515139, -122.443201076984) | 15 | 5 | 11 | 29492 | 16 | ||
73998 | 58329 | DPW Maintained 1 | Tristania conferta :: 61 | 53 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 14 | Permit Number 17354 | 5998224.3786 | 2111460.8397 | 37.7775664240249 | -122.449691194319 | (37.7775664240249, -122.449691194319) | 15 | 6 | 2 | 54 | 16 | ||
74351 | 58327 | DPW Maintained 1 | Tristania conferta :: 61 | 35 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 14 | Permit Number 17352 | 5998213.7971 | 2111534.9106 | 37.7777691981302 | -122.449733138233 | (37.7777691981302, -122.449733138233) | 15 | 6 | 2 | 54 | 16 | ||
74845 | 50647 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012121.5394 | 2112599.3505 | 37.7814777846222 | -122.401696004131 | (37.7814777846222, -122.401696004131) | 6 | 2 | 9 | 28856 | 34 | ||
75392 | 10519 | DPW Maintained 1 | Tristania conferta :: 61 | 1840 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/1990 12:00:00 AM | 50 | 5997331.1413 | 2108490.0928 | 37.7693583785533 | -122.452566739633 | (37.7693583785533, -122.452566739633) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
81198 | 32143 | DPW Maintained 1 | Tristania conferta :: 61 | 563 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | 9 | Permit Number 35498 | 6003111.4815 | 2110262.0358 | 37.774553191336 | -122.432699422008 | (37.774553191336, -122.432699422008) | 15 | 9 | 11 | 29492 | 10 | ||
83144 | 48780 | DPW Maintained 1 | Tristania conferta :: 61 | 1366(REVISED) Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | 5 | Permit Number 46035 | 6003524.5015 | 2112470.6769 | 37.7806409869289 | -122.431428406628 | (37.7806409869289, -122.431428406628) | 15 | 9 | 11 | 29490 | 41 | ||
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 | |
87850 | 54270 | Permitted Site 7 | Tristania conferta :: 61 | 1240 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2015 12:00:00 AM | 3 | Permit Number 10023 | 5993331.28695265 | 2107027.13972063 | 37.7651115096687 | -122.466295599736 | (37.7651115096687, -122.466295599736) | 11 | 8 | 11 | 56 | 12 | ||
89530 | 99869 | DPW Maintained 1 | Tristania conferta :: 61 | 550 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 28969 | 6007604.2335 | 2113225.7913 | 37.7829447244363 | -122.417368152144 | (37.7829447244363, -122.417368152144) | 7 | 9 | 9 | 28852 | 36 | |||
91253 | 99868 | DPW Maintained 1 | Tristania conferta :: 61 | 532 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 28966 | 6007610.0526 | 2113183.9663 | 37.7828302105112 | -122.417345055476 | (37.7828302105112, -122.417345055476) | 7 | 9 | 9 | 28852 | 36 | |||
92273 | 59517 | DPW Maintained 1 | Tristania conferta :: 61 | 1649 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1988 12:00:00 AM | 11 | Permit Number 25365 | 5999918.6069 | 2110540.6202 | 37.7751365191945 | -122.443764181481 | (37.7751365191945, -122.443764181481) | 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 | |
94517 | 94612 | DPW Maintained 1 | Tristania conferta :: 61 | 5668@ Armstrong 03rd St | 1 | Sidewalk: Curb side : | Tree | Private 2 | 10/13/2010 12:00:00 AM | 4 | Permit Number 53777 | 6013990.2772 | 2092621.1644 | 37.7267260802756 | -122.393832179047 | (37.7267260802756, -122.393832179047) | 10 | 3 | 8 | 58 | 1 | ||
95289 | 115299 | Permitted Site 7 | Tristania conferta :: 61 | 177 Lomita Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | 1 | 8 | 4 | 56 | 12 | |||
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 | |
97027 | 115300 | Permitted Site 7 | Tristania conferta :: 61 | 177 Lomita Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | 1 | 8 | 4 | 56 | 12 | |||
97328 | 47567 | DPW Maintained 1 | Tristania conferta :: 61 | 301 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 7 | Permit Number 45427 | 6014670.6192 | 2115035.7393 | 37.7883094680316 | -122.393047869568 | (37.7883094680316, -122.393047869568) | 6 | 2 | 9 | 28855 | 6 | ||
97336 | 59521 | DPW Maintained 1 | Tristania conferta :: 61 | 1669 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1981 12:00:00 AM | 15 | Permit Number 18902 | 5999840.3327 | 2110529.9939 | 37.7751028772107 | -122.444034184766 | (37.7751028772107, -122.444034184766) | 15 | 5 | 11 | 29492 | 16 | ||
97432 | 53100 | DPW Maintained 1 | Tristania conferta :: 61 | 560@ PINE Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 1 | Permit Number 767803 | 5999200.433 | 2114690.2424 | 37.7864893192828 | -122.446547106561 | (37.7864893192828, -122.446547106561) | 15 | 6 | 1 | 29490 | 31 | ||
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 | |
101869 | 107147 | DPW Maintained 1 | Tristania conferta :: 61 | 2466 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5985833.5095 | 2098430.6846 | 37.7410725309134 | -122.491595378553 | (37.7410725309134, -122.491595378553) | 1 | 8 | 3 | 29491 | 35 | ||||
107579 | 114595 | DPW Maintained 1 | Tristania conferta :: 61 | 2584 Sutter St | 2 | 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 | |||
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 | |
122744 | 10510 | DPW Maintained 1 | Tristania conferta :: 61 | 1793 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/1992 12:00:00 AM | 1 | 5997601.0333 | 2108476.5582 | 37.7693366759731 | -122.451632224006 | (37.7693366759731, -122.451632224006) | 15 | 5 | 11 | 29492 | 9 | |||
122959 | 45601 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2001 12:00:00 AM | 10 | Permit Number 44335 | 6003419.3416 | 2112114.1133 | 37.7796559917005 | -122.431766739067 | (37.7796559917005, -122.431766739067) | 15 | 9 | 11 | 29490 | 41 | ||
123256 | 57326 | DPW Maintained 1 | Tristania conferta :: 61 | 750 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 14 | Permit Number 16154 | 5999289.2953 | 2113999.1058 | 37.7845967138408 | -122.446189932846 | (37.7845967138408, -122.446189932846) | 15 | 6 | 1 | 29490 | 31 | ||
128869 | 103963 | DPW Maintained 1 | Tristania conferta :: 61 | 2534 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | 0 | Permit Number 773267 | 6000467 | 2114127 | 37.7850150648369 | -122.442124666784 | (37.7850150648369, -122.442124666784) | 15 | 6 | 1 | 29490 | 27 | ||
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 | ||
133170 | 50650 | DPW Maintained 1 | Tristania conferta :: 61 | 821 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2012 12:00:00 AM | 2 | Permit Number 768661 | 6012184.2732 | 2112660.7106 | 37.7816497657614 | -122.401483287822 | (37.7816497657614, -122.401483287822) | 6 | 2 | 9 | 28856 | 34 | ||
133353 | 22191 | DPW Maintained 1 | Tristania conferta :: 61 | 4011 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3 | 6015646.0862 | 2097696.0967 | 37.7407527004376 | -122.388462117977 | (37.7407527004376, -122.388462117977) | 10 | 3 | 8 | 58 | 1 | |||
138564 | 47574 | DPW Maintained 1 | Tristania conferta :: 61 | 301 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 7 | Permit Number 45427 | 6014716.8904 | 2115082.0105 | 37.7884390883158 | -122.392891016069 | (37.7884390883158, -122.392891016069) | 6 | 2 | 9 | 28855 | 6 | ||
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 | ||
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 | |
141684 | 24306 | DPW Maintained 1 | Tristania conferta :: 61 | 1513 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1994 12:00:00 AM | 3 | 6002219.6394 | 2111892.3425 | 37.7789789862822 | -122.435901149592 | (37.7789789862822, -122.435901149592) | 15 | 5 | 11 | 29490 | 41 | |||
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 | |
149079 | 35644 | DPW Maintained 1 | Tristania conferta :: 61 | 635 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | 9 | Permit Number 38976 | 6004498.2203 | 2110755.6153 | 37.7759869880383 | -122.427937599156 | (37.7759869880383, -122.427937599156) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |
156041 | 58326 | DPW Maintained 1 | Tristania conferta :: 61 | 25 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 10 | Permit Number 17351 | 5998207.5443 | 2111574.8319 | 37.7778784539283 | -122.449757646347 | (37.7778784539283, -122.449757646347) | 15 | 6 | 2 | 54 | 16 | ||
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 | |
158665 | 22490 | DPW Maintained 1 | Tristania conferta :: 61 | 6300 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 6013127.1033 | 2090369.4903 | 37.7204954312128 | -122.396658388199 | (37.7204954312128, -122.396658388199) | 10 | 3 | 8 | 58 | 1 | ||||
160563 | 10310 | DPW Maintained 1 | Tristania conferta :: 61 | 630 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2004 12:00:00 AM | 8 | 6002998.1704 | 2109278.2038 | 37.7718454047065 | -122.433021081698 | (37.7718454047065, -122.433021081698) | 15 | 5 | 11 | 29492 | 9 | |||
161469 | 47570 | DPW Maintained 1 | Tristania conferta :: 61 | 301 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 8 | Permit Number 45427 | 6014687.0712 | 2115049.1066 | 37.788347085442 | -122.392991883527 | (37.788347085442, -122.392991883527) | 6 | 2 | 9 | 28855 | 6 | ||
161583 | 47581 | DPW Maintained 1 | Tristania conferta :: 61 | 301 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 10 | Permit Number 45427 | 6014732.3141 | 2115093.3212 | 37.7884710015858 | -122.392838443698 | (37.7884710015858, -122.392838443698) | 6 | 2 | 9 | 28855 | 6 | ||
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 | ||
168998 | 59519 | DPW Maintained 1 | Tristania conferta :: 61 | 1659 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1981 12:00:00 AM | 12 | Permit Number 18898 | 5999876.6205 | 2110535.3166 | 37.7751195619734 | -122.443909040168 | (37.7751195619734, -122.443909040168) | 15 | 5 | 11 | 29492 | 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 | |||
170430 | 47568 | DPW Maintained 1 | Tristania conferta :: 61 | 301 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 7 | Permit Number 45427 | 6014701.4667 | 2115063.502 | 37.7883874115209 | -122.392943084604 | (37.7883874115209, -122.392943084604) | 6 | 2 | 9 | 28855 | 6 | ||
172069 | 51541 | DPW Maintained 1 | Tristania conferta :: 61 | 672 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2005 12:00:00 AM | 6 | Permit Number 47838 | 6004139.9693 | 2110987.3251 | 37.776602932276 | -122.42919340888 | (37.776602932276, -122.42919340888) | 7 | 9 | 11 | 28852 | 10 | ||
184109 | 47069 | DPW Maintained 1 | Tristania conferta :: 61 | 606 Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | 5 | Permit Number 45052 | 6004039.0188 | 2110889.0487 | 37.7763273741764 | -122.429535615559 | (37.7763273741764, -122.429535615559) | 7 | 9 | 11 | 28852 | 10 | ||
184432 | 58337 | DPW Maintained 1 | Tristania conferta :: 61 | 1593 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 12 | Permit Number 17362 | 6000161.6495 | 2110915.9391 | 37.7761809090553 | -122.442950404096 | (37.7761809090553, -122.442950404096) | 15 | 5 | 11 | 29492 | 16 | ||
184456 | 57431 | DPW Maintained 1 | Tristania conferta :: 61 | 1933 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1991 12:00:00 AM | 8 | Permit Number 30044 | 6003885.286 | 2115132.8962 | 37.7879712148727 | -122.430370279075 | (37.7879712148727, -122.430370279075) | 13 | 9 | 11 | 29490 | 27 | ||
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 | |
189492 | 33674 | DPW Maintained 1 | Tristania conferta :: 61 | 672 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 4 | Permit Number 37756 | 6004147.6576 | 2110988.6622 | 37.7766070388542 | -122.429166908178 | (37.7766070388542, -122.429166908178) | 7 | 9 | 11 | 28852 | 10 | ||
154471 | 22190 | DPW Maintained 1 | Tristania conferta :: 61 | 4011 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1993 12:00:00 AM | 6 | 0 | 6015638.5282 | 2097667.7542 | 37.7406744589074 | -122.388486273101 | (37.7406744589074, -122.388486273101) | 10 | 3 | 8 | 58 | 1 | ||
104677 | 111746 | Permitted Site 7 | Tristania conferta :: 61 | 398X 03rd St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.04718 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | 6 | 2 | 9 | 28856 | 34 |
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) );