trees
3,247 rows where qSpecies_id = 22 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17962 | 37394 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 260 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 9 | Permit Number 39876 | 6000430.23445 | 2087496.65427 | 37.7118924395572 | -122.440341369156 | (37.7118924395572, -122.440341369156) | 9 | 7 | 6 | 28861 | 5 | |
| 18037 | 7422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/1991 12:00:00 AM | 8 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | |||
| 18490 | 34599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3200 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 4 | Permit Number 38292 | 5999320.20166 | 2116021.69073 | 37.7901519674937 | -122.446228549814 | (37.7901519674937, -122.446228549814) | 13 | 6 | 1 | 29490 | 31 | |
| 18798 | 71245 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1732 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006396.12471 | 2117006.83983 | 37.7932585028357 | -122.421816375523 | (37.7932585028357, -122.421816375523) | 13 | 9 | 10 | 28858 | 32 | |||
| 18848 | 54010 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1537 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/06/1972 12:00:00 AM | 5 | Permit Number 9729 | 6012988.89964 | 2105636.75215 | 37.7624084228186 | -122.398206698706 | (37.7624084228186, -122.398206698706) | 10 | 3 | 8 | 28856 | 29 | |
| 18980 | 48384 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011713.07765 | 2106631.21617 | 37.7650678512362 | -122.402689258803 | (37.7650678512362, -122.402689258803) | 8 | 3 | 8 | 28853 | 20 | ||
| 19265 | 44239 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 317 Harriet St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43677 | 6011781.7513621 | 2110406.95147967 | 37.7754389967998 | -122.402717284978 | (37.7754389967998, -122.402717284978) | 14 | 2 | 9 | 28853 | 34 | |||
| 19320 | 33230 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2740 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | Permit Number 37416 | 6000651.12195 | 2117750.428 | 37.7949745459919 | -122.441747802734 | (37.7949745459919, -122.441747802734) | 13 | 9 | 1 | 57 | 27 | ||
| 19360 | 80805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 991 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015535.39126 | 2104617.20142 | 37.7597504684343 | -122.389328050963 | (37.7597504684343, -122.389328050963) | 10 | 3 | 8 | 28856 | 29 | |||
| 19756 | 100780 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | |||
| 19891 | 61244 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3974 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1984 12:00:00 AM | Permit Number 21116 | 6003854.92098549 | 2104240.14481817 | 37.7580606684354 | -122.429698131841 | (37.7580606684354, -122.429698131841) | 2 | 4 | 5 | 28862 | 3 | ||
| 20649 | 87351 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3374 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2008 12:00:00 AM | Permit Number 50337 | 5998108 | 2116175 | 37.7905036111085 | -122.450433709576 | (37.7905036111085, -122.450433709576) | 13 | 6 | 1 | 54 | 31 | |||
| 20653 | 67417 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 787 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/1992 12:00:00 AM | 4 | Permit Number 30916 | 5990669.84727 | 2110037.89934 | 37.7732243191199 | -122.475720648254 | (37.7732243191199, -122.475720648254) | 11 | 6 | 2 | 55 | 26 | ||
| 20976 | 49996 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 247@ 18TH ST Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 3 | Permit Number 46739 | 6013491.30508 | 2105926.86406 | 37.7632329779416 | -122.396489388368 | (37.7632329779416, -122.396489388368) | 14 | 3 | 8 | 28856 | 29 | |
| 21059 | 30335 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1956 12:00:00 AM | 2 | Permit Number 24 | 6002625.81177 | 2098862.65496 | 37.743225678518 | -122.433564611513 | (37.743225678518, -122.433564611513) | 2 | 7 | 5 | 63 | 7 | ||
| 21207 | 33596 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 224 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1996 12:00:00 AM | Permit Number 37704 | 6006764.88220944 | 2097872.66772056 | 37.7407413706298 | -122.419182553853 | (37.7407413706298, -122.419182553853) | 2 | 7 | 7 | 28859 | 2 | ||
| 21646 | 44771 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
| 21892 | 50870 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Permit Number 47381 | 6001002.60746 | 2117608.08082 | 37.7946037186291 | -122.440521399949 | (37.7946037186291, -122.440521399949) | 13 | 9 | 1 | 57 | 27 | |||
| 22441 | 35507 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3460 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38910 | 6005335.59882734 | 2103155.12631958 | 37.7551651932954 | -122.42450013257 | (37.7551651932954, -122.42450013257) | 2 | 4 | 5 | 28859 | 19 | ||
| 22665 | 67038 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 140 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1994 12:00:00 AM | Permit Number 30414 | 6004243.51306572 | 2101045.11693078 | 37.7493098678885 | -122.4281265241 | (37.7493098678885, -122.4281265241) | 2 | 4 | 5 | 28862 | 22 | ||
| 22948 | 63826 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 801 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24514 | 6008974.10291824 | 2096930.94751017 | 37.7382797803205 | -122.411477359627 | (37.7382797803205, -122.411477359627) | 10 | 7 | 7 | 28859 | 2 | ||
| 23050 | 63859 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 573 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24560 | 6002112.91730611 | 2110421.71062272 | 37.7749349366141 | -122.436165074208 | (37.7749349366141, -122.436165074208) | 15 | 5 | 11 | 29492 | 10 | ||
| 23444 | 48373 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011696.05112 | 2106912.09 | 37.7658381169537 | -122.402767904509 | (37.7658381169537, -122.402767904509) | 8 | 3 | 8 | 28853 | 20 | ||
| 23454 | 63811 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 397 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24498 | 6008814.87080902 | 2096945.70760042 | 37.7383113756234 | -122.41202895062 | (37.7383113756234, -122.41202895062) | 10 | 7 | 7 | 28859 | 2 | ||
| 23520 | 51660 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
| 23797 | 94990 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 48 Leland Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.404779818423 | (37.7116594240627, -122.404779818423) | 9 | 7 | 8 | 309 | 39 | ||||
| 24058 | 34407 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 151 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38155 | 6004576.44969274 | 2097521.36031941 | 37.7396532725762 | -122.426724317666 | (37.7396532725762, -122.426724317666) | 2 | 7 | 5 | 63 | 7 | ||
| 24870 | 44098 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 692 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2000 12:00:00 AM | 2 | Permit Number 43610 | 6012077.83882 | 2105236.36448 | 37.7612582582864 | -122.401329601683 | (37.7612582582864, -122.401329601683) | 10 | 3 | 8 | 28856 | 29 | ||
| 24939 | 37321 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 445 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41123 | 6003410.55922166 | 2103870.78228446 | 37.7570213149701 | -122.431208559798 | (37.7570213149701, -122.431208559798) | 2 | 4 | 5 | 28862 | 3 | ||
| 25123 | 50152 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 215 REVISED Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.7890845068427 | -122.3948355307 | (37.7890845068427, -122.3948355307) | 6 | 2 | 9 | 28855 | 6 | |||
| 25287 | 48366 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
| 25476 | 59994 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 331 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1982 12:00:00 AM | 7 | Permit Number 19478 | 5997127.59055 | 2115197.55495 | 37.7877636478193 | -122.453755234125 | (37.7877636478193, -122.453755234125) | 11 | 6 | 1 | 54 | 31 | |
| 26417 | 66310 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29425 | 6001332.72327258 | 2095407.42415394 | 37.7336649686266 | -122.43778834571 | (37.7336649686266, -122.43778834571) | 9 | 7 | 5 | 63 | 40 | ||
| 27069 | 31476 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 282 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 7 | Permit Number 35042 | 6001438.63779 | 2104181.90614 | 37.7577636411886 | -122.438050483837 | (37.7577636411886, -122.438050483837) | 2 | 4 | 5 | 28862 | 3 | |
| 27240 | 68167 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1131 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1993 12:00:00 AM | 12 | Permit Number 31936 | 6011528.02794 | 2119216.24888 | 37.7996130755308 | -122.404215124131 | (37.7996130755308, -122.404215124131) | 3 | 1 | 10 | 308 | 23 | ||
| 27248 | 42307 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 245 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42530 | 5998732.16654968 | 2093631.30703212 | 37.7286399521282 | -122.446651448677 | (37.7286399521282, -122.446651448677) | 9 | 7 | 4 | 28861 | 40 | ||
| 27284 | 32001 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1100 Brazil Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1995 12:00:00 AM | Permit Number 35398 | 6004626.44544717 | 2090517.44642515 | 37.7204249107717 | -122.426052988126 | (37.7204249107717, -122.426052988126) | 9 | 7 | 6 | 28861 | 5 | ||
| 27288 | 33750 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 845 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38932 | 6005705.24449579 | 2104057.07564242 | 37.7576626039009 | -122.42328590054 | (37.7576626039009, -122.42328590054) | 2 | 4 | 5 | 28859 | 19 | ||
| 28328 | 45196 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3379 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2001 12:00:00 AM | Permit Number 44041 | 6005846.47654917 | 2103129.45360257 | 37.7551235392216 | -122.422731541054 | (37.7551235392216, -122.422731541054) | 2 | 4 | 5 | 28859 | 19 | ||
| 28464 | 64369 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 522 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 5 | Permit Number 25208 | 6010359.9072 | 2120301.2434 | 37.8025268636696 | -122.408333834018 | (37.8025268636696, -122.408333834018) | 3 | 1 | 10 | 308 | 23 | |
| 28893 | 68505 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1957 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32383 | 5992830.56457156 | 2102309.10574943 | 37.752128116881 | -122.467684306461 | (37.752128116881, -122.467684306461) | 1 | 8 | 4 | 29491 | 12 | ||
| 29797 | 61370 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1984 12:00:00 AM | Permit Number 21280 | 6005657.12364045 | 2109394.65582136 | 37.772315616937 | -122.423831849588 | (37.772315616937, -122.423831849588) | 7 | 9 | 11 | 28852 | 10 | |||
| 29912 | 55609 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 142 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/1972 12:00:00 AM | 1 | Permit Number 11586 | 5992448.32925563 | 2114520.13069232 | 37.7856342525233 | -122.469895103767 | (37.7856342525233, -122.469895103767) | 11 | 6 | 2 | 54 | 11 | ||
| 29930 | 39397 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
| 30397 | 31035 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300 Bennington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2015 12:00:00 AM | 1 | Permit Number 771782 | 6007054.85561 | 2096718.77749 | 37.7375893700518 | -122.418098149219 | (37.7375893700518, -122.418098149219) | 2 | 7 | 7 | 28859 | 2 | ||
| 30897 | 64364 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 562 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | Permit Number 25203 | 6010163.25374355 | 2120275.04561468 | 37.8024439169341 | -122.409012506441 | (37.8024439169341, -122.409012506441) | 3 | 1 | 10 | 308 | 23 | ||
| 31468 | 33116 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000083.68486 | 2118474.07473 | 37.7969291406212 | -122.443763225693 | (37.7969291406212, -122.443763225693) | 13 | 9 | 1 | 57 | 17 | |
| 31594 | 54908 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1025 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2001 12:00:00 AM | Permit Number 10774 | 5997625.73992568 | 2107028.28129343 | 37.7653614921753 | -122.451442291891 | (37.7653614921753, -122.451442291891) | 15 | 5 | 11 | 29492 | 9 | ||
| 31615 | 121559 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 400X Alvarado St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6003675 | 2102779 | 37.7540385213778 | -122.430216135756 | (37.7540385213778, -122.430216135756) | 2 | 4 | 5 | 28862 | 22 | |||
| 31706 | 63513 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1918 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | 5 | Permit Number 24122 | 6000219.0504 | 2111671.3437 | 37.7782583301141 | -122.442806095474 | (37.7782583301141, -122.442806095474) | 15 | 5 | 11 | 29490 | 16 | |
| 31726 | 51306 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 87 McLea Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | 2 | Permit Number 47673 | 6010064.68289 | 2109219.48748 | 37.7720824777545 | -122.408573272949 | (37.7720824777545, -122.408573272949) | 14 | 2 | 9 | 28853 | 34 | ||
| 31830 | 58810 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3199 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | Permit Number 772746 | 6002363.40081 | 2119107.04088 | 37.7987968652491 | -122.435920192279 | (37.7987968652491, -122.435920192279) | 13 | 9 | 1 | 57 | 17 | |
| 32020 | 59995 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 311 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1982 12:00:00 AM | 5 | Permit Number 19480 | 5997122.00089 | 2115229.93413 | 37.7878522319536 | -122.453776912276 | (37.7878522319536, -122.453776912276) | 11 | 6 | 1 | 54 | 31 | |
| 32736 | 30601 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 140 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34568 | 6007766.12041799 | 2109892.83524287 | 37.7738023323227 | -122.416571913724 | (37.7738023323227, -122.416571913724) | 8 | 2 | 9 | 28853 | 19 | ||
| 32954 | 47044 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 360 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | 2 | Permit Number 45034 | 6005453.66309184 | 2101611.26078785 | 37.7509327630895 | -122.423982050287 | (37.7509327630895, -122.423982050287) | 2 | 4 | 5 | 28859 | 19 | ||
| 33131 | 38706 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1700 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | 1 | Permit Number 40613 | 6000969.5195 | 2111424.3561 | 37.7776229198936 | -122.440192236927 | (37.7776229198936, -122.440192236927) | 15 | 5 | 11 | 29490 | 41 | |
| 33532 | 44053 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3100 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43582 | 6001974.87365527 | 2118765.4026711 | 37.7978367374605 | -122.437240145023 | (37.7978367374605, -122.437240145023) | 13 | 9 | 1 | 57 | 17 | |||
| 33632 | 48389 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
| 33644 | 64488 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3371 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1988 12:00:00 AM | Permit Number 25483 | 6005878.34510819 | 2103716.54334908 | 37.7567373492627 | -122.422663048235 | (37.7567373492627, -122.422663048235) | 2 | 4 | 5 | 28859 | 19 | ||
| 33742 | 48382 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | 6 | Permit Number 45774 | 6011708.87985 | 2106683.73701 | 37.7652118272854 | -122.402707471892 | (37.7652118272854, -122.402707471892) | 8 | 3 | 8 | 28853 | 20 | ||
| 33987 | 64366 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 8 | Permit Number 25205 | 6010278.2434 | 2120287.8996 | 37.802485651571 | -122.408615490868 | (37.802485651571, -122.408615490868) | 3 | 1 | 10 | 308 | 23 | |
| 34023 | 48387 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | Permit Number 45774 | 6011708.83412888 | 2106755.94348957 | 37.7654100874921 | -122.402712708416 | (37.7654100874921, -122.402712708416) | 8 | 3 | 8 | 28853 | 20 | |||
| 34230 | 85315 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 668 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2007 12:00:00 AM | Permit Number 49595 | 6002374 | 2104313 | 37.7581767429847 | -122.434824993161 | (37.7581767429847, -122.434824993161) | 2 | 4 | 5 | 28862 | 3 | |||
| 34519 | 64597 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3376 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1988 12:00:00 AM | Permit Number 25498 | 6005858.20323886 | 2103182.11056337 | 37.7552687846383 | -122.422694728513 | (37.7552687846383, -122.422694728513) | 2 | 4 | 5 | 28859 | 19 | ||
| 34760 | 100212 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Permit Number 769013 | 6011854.68115 | 2105077.88991 | 37.7608106693075 | -122.402090272569 | (37.7608106693075, -122.402090272569) | 10 | 3 | 8 | 28856 | 29 | |||
| 34825 | 129006 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Fallon Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008915.40705 | 2118578.41421 | 37.7977154080083 | -122.413210643283 | (37.7977154080083, -122.413210643283) | 3 | 1 | 10 | 308 | 21 | ||||
| 35123 | 52586 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 179@ GEARY Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2006 12:00:00 AM | 4 | Permit Number 48679 | 5996210.09335 | 2113138.79265 | 37.7820581932657 | -122.456780626288 | (37.7820581932657, -122.456780626288) | 11 | 6 | 1 | 54 | 31 | ||
| 35138 | 49968 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 250 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2016 12:00:00 AM | 3 | Permit Number 773269 | 6007921.55804 | 2112390.20722 | 37.7806682603601 | -122.416211138647 | (37.7806682603601, -122.416211138647) | 7 | 10 | 9 | 28852 | 36 | |
| 35203 | 33014 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3625 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37305 | 6005620.98142938 | 2101949.23575785 | 37.7518702093111 | -122.423427471135 | (37.7518702093111, -122.423427471135) | 2 | 4 | 5 | 28859 | 19 | |||
| 35491 | 34605 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3201 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38293 | 5999288.97599 | 2115969.52307 | 37.7900069454997 | -122.446332833392 | (37.7900069454997, -122.446332833392) | 13 | 6 | 1 | 29490 | 31 | ||
| 36124 | 49342 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Clifford Ter | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2003 12:00:00 AM | Permit Number 46332 | 5999646.98705896 | 2106515.41862964 | 37.7640688343052 | -122.444414431135 | (37.7640688343052, -122.444414431135) | 15 | 5 | 5 | 29492 | 9 | |||
| 36550 | 47212 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 6200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2005 12:00:00 AM | Permit Number 45162 | 5987813.93606219 | 2112607.0787223 | 37.7801125787533 | -122.48578810365 | (37.7801125787533, -122.48578810365) | 11 | 6 | 2 | 55 | 26 | ||
| 36558 | 31408 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 4305 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 4 | Permit Number 34997 | 6002027.08714 | 2104088.44576 | 37.7575404690417 | -122.436008698139 | (37.7575404690417, -122.436008698139) | 2 | 4 | 5 | 28862 | 3 | |
| 36702 | 44350 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 50 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2001 12:00:00 AM | Permit Number 43730 | 6001421.82068247 | 2107945.22005196 | 37.7680958224652 | -122.438378257061 | (37.7680958224652, -122.438378257061) | 15 | 5 | 5 | 29492 | 3 | |||
| 37140 | 41087 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2307 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2005 12:00:00 AM | 2 | Permit Number 48267 | 6001281.43208 | 2116413.73631 | 37.7913402327106 | -122.439470976529 | (37.7913402327106, -122.439470976529) | 13 | 6 | 1 | 29490 | 27 | ||
| 37510 | 30602 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 140 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34568 | 6007766.12041799 | 2109892.83524287 | 37.7738023323227 | -122.416571913724 | (37.7738023323227, -122.416571913724) | 8 | 2 | 9 | 28853 | 19 | ||
| 37589 | 30334 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1956 12:00:00 AM | 4 | Permit Number 24 | 6002605.63749 | 2098861.8554 | 37.7432223384343 | -122.433634311668 | (37.7432223384343, -122.433634311668) | 2 | 7 | 5 | 63 | 7 | ||
| 37647 | 44195 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
| 38267 | 67385 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 600 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1992 12:00:00 AM | Permit Number 30881 | 5992563.12604508 | 2111350.67725686 | 37.776938433872 | -122.469267171865 | (37.776938433872, -122.469267171865) | 11 | 6 | 2 | 54 | 11 | ||
| 38722 | 32054 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3380 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 6 | Permit Number 35432 | 6004357.87691 | 2106622.24388 | 37.7646298121474 | -122.428128452562 | (37.7646298121474, -122.428128452562) | 8 | 4 | 5 | 28862 | 3 | |
| 39201 | 48395 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 72 Mars St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45777 | 5999572.80170185 | 2105370.51265234 | 37.7609209742541 | -122.444588722127 | (37.7609209742541, -122.444588722127) | 15 | 5 | 5 | 28862 | 3 | ||||
| 39885 | 253067 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 420 Innes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.00752 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | 10 | 3 | 8 | 58 | 1 | ||
| 40476 | 85221 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1414 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011703 | 2101780 | 37.7517469232523 | -122.40238298191 | (37.7517469232523, -122.40238298191) | 10 | 3 | 8 | 28856 | 29 | |||||
| 41174 | 129013 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 150 Francisco St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6010602.08919 | 2121361.05101 | 37.8054503923804 | -122.407570525278 | (37.8054503923804, -122.407570525278) | 3 | 1 | 10 | 308 | 23 | ||||
| 41278 | 66312 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 143 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29427 | 6001377.41574875 | 2095374.46813255 | 37.7335770202313 | -122.437631471673 | (37.7335770202313, -122.437631471673) | 9 | 7 | 5 | 63 | 40 | ||
| 41458 | 87301 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 3 | Back Yard : Yard | Tree | DPW 1 | 5 | Permit Number 50312 | 6011915.6161 | 2100899.61614 | 37.7493414470685 | -122.401585851825 | (37.7493414470685, -122.401585851825) | 10 | 3 | 8 | 58 | 1 | |||
| 42158 | 43568 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2000 12:00:00 AM | Permit Number 43230 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 | |||
| 42164 | 44189 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
| 42425 | 37323 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 465 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39836 | 6003319.75877795 | 2103865.74575839 | 37.7570023398617 | -122.431522222437 | (37.7570023398617, -122.431522222437) | 2 | 4 | 5 | 28862 | 3 | |||
| 42924 | 36915 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 514 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39561 | 6001810.86453824 | 2102841.54122149 | 37.7541044834193 | -122.43666722972 | (37.7541044834193, -122.43666722972) | 2 | 4 | 5 | 28862 | 22 | ||
| 43066 | 57165 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2616 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42848 | 6003634.5143762 | 2117314.3321902 | 37.7939466747915 | -122.431393686963 | (37.7939466747915, -122.431393686963) | 13 | 9 | 1 | 29490 | 27 | |||
| 43130 | 48464 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1900only Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2005 12:00:00 AM | Permit Number 45826 | 6001339.4267527 | 2112520.04944092 | 37.7806524690374 | -122.438991149316 | (37.7806524690374, -122.438991149316) | 15 | 5 | 11 | 29490 | 41 | ||
| 43709 | 63415 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 278 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1987 12:00:00 AM | Permit Number 23998 | 6001429.88159377 | 2104210.13980699 | 37.757840666022 | -122.438082788745 | (37.757840666022, -122.438082788745) | 2 | 4 | 5 | 28862 | 3 | ||
| 43772 | 66761 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 80 Elgin Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 2 | Permit Number 769935 | 6005803.50133393 | 2108610.80958475 | 37.7701716256342 | -122.423269785266 | (37.7701716256342, -122.423269785266) | 8 | 2 | 5 | 28853 | 19 | ||
| 44172 | 124187 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 40 Almaden Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5995896.10311 | 2112493.62876 | 37.7802687106807 | -122.45782018279 | (37.7802687106807, -122.45782018279) | 11 | 6 | 2 | 54 | 16 | ||||
| 44799 | 84752 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 170 King St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851 | 2111791 | 37.7794101710037 | -122.392196759897 | (37.7794101710037, -122.392196759897) | 6 | 2 | 9 | 28856 | 6 | |||
| 44959 | 44241 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 317 Harriet St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43677 | 6011781.7513621 | 2110406.95147967 | 37.7754389967998 | -122.402717284978 | (37.7754389967998, -122.402717284978) | 14 | 2 | 9 | 28853 | 34 | |||
| 45608 | 40433 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 101 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1999 12:00:00 AM | Permit Number 41526 | 6007627.96125429 | 2098166.4451197 | 37.7415965860949 | -122.416219146331 | (37.7415965860949, -122.416219146331) | 2 | 7 | 7 | 28859 | 2 | ||
| 46077 | 67375 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 925 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | Permit Number 30870 | 5992766.01724048 | 2111352.45754002 | 37.7769550441549 | -122.468565444785 | (37.7769550441549, -122.468565444785) | 11 | 6 | 2 | 54 | 11 | ||
| 46097 | 51658 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 |
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) );