trees
953 rows where qSpecies_id = 60 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
128 | 110722 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
1130 | 54772 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1446 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1972 12:00:00 AM | 4x5 | Permit Number 10621 | 5994307.43834186 | 2105670.05162948 | 37.7614415732371 | -122.462820895269 | (37.7614415732371, -122.462820895269) | 1 | 5 | 11 | 56 | 12 | ||
2627 | 44717 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1991 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | Permit Number 43839 | 5989704.86545465 | 2101822.42727681 | 37.7506108546658 | -122.478457743126 | (37.7506108546658, -122.478457743126) | 1 | 8 | 3 | 29491 | 35 | ||
5626 | 52490 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.5363144 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | 2 | 7 | 7 | 28859 | 2 | ||
5780 | 261485 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3608 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005560 | 2104915 | 37.760010064893 | -122.423849219023 | (37.760010064893, -122.423849219023) | 2 | 4 | 5 | 28859 | 19 | ||||
6670 | 48442 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
10865 | 260932 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 249 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001134 | 2098325 | 37.7416646487467 | -122.438684376046 | (37.7416646487467, -122.438684376046) | 2 | 7 | 5 | 63 | 7 | ||||
11233 | 112393 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4127 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002153 | 2105221 | 37.7606573415981 | -122.435654265974 | (37.7606573415981, -122.435654265974) | 2 | 4 | 5 | 28862 | 3 | ||||
11282 | 258111 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1647 23rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5989010.97347 | 2104127.32105 | 37.756899168939 | -122.481025994257 | (37.756899168939, -122.481025994257) | 1 | 8 | 3 | 56 | 35 | ||||||
12100 | 96019 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
12444 | 260536 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5983685.38782 | 2106695.21091 | 37.7636388518254 | -122.499633347112 | (37.7636388518254, -122.499633347112) | 1 | 8 | 3 | 56 | 35 | ||||
15317 | 261202 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 699x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007339 | 2095419 | 37.7340364554683 | -122.417023656077 | (37.7340364554683, -122.417023656077) | 2 | 7 | 7 | 28859 | 2 | ||||
16961 | 261483 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3608 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005560 | 2104915 | 37.760010064893 | -122.423849219023 | (37.760010064893, -122.423849219023) | 2 | 4 | 5 | 28859 | 19 | ||||
19637 | 116726 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180X PERALTA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009777 | 2100122 | 37.7470867174475 | -122.408926407614 | (37.7470867174475, -122.408926407614) | 2 | 7 | 7 | 28859 | 2 | ||||
23509 | 44343 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 233 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2001 12:00:00 AM | Permit Number 43727 | 5991164.04904901 | 2113857.0036857 | 37.7837391697575 | -122.474289891692 | (37.7837391697575, -122.474289891692) | 11 | 6 | 2 | 54 | 26 | |||
25373 | 110420 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
26486 | 47221 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
26513 | 39670 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
27376 | 35610 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 325 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38967 | 5992638.71984217 | 2094691.8038829 | 37.7312018573426 | -122.467793768821 | (37.7312018573426, -122.467793768821) | 9 | 8 | 4 | 59 | 40 | |||
30618 | 97004 | Property Tree 8 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195A Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
32163 | 116349 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
33218 | 34342 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 12661268 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38099 | 6010039 | 2101826 | 37.7517801982502 | -122.408140586549 | (37.7517801982502, -122.408140586549) | 2 | 4 | 7 | 28859 | 19 | ||
34147 | 110720 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
34591 | 251286 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/09/1998 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
34811 | 109380 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 725X BURNETT AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5999257.1 | 2101645.9 | 37.7506760851616 | -122.445412771855 | (37.7506760851616, -122.445412771855) | 2 | 5 | 5 | 63 | 38 | |||||
37405 | 258000 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
37840 | 96018 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
37894 | 45238 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 871 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2001 12:00:00 AM | Permit Number 44088 | 6008421.36689101 | 2115188.65226849 | 37.7883802062735 | -122.414680152021 | (37.7883802062735, -122.414680152021) | 5 | 1 | 10 | 28858 | 21 | |||
39187 | 33577 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 190 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37685 | 6007025.08907683 | 2097945.62097714 | 37.7409563345382 | -122.418288026055 | (37.7409563345382, -122.418288026055) | 2 | 7 | 7 | 28859 | 2 | |||
40222 | 87642 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1002X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004813.344433 | 2112300.663017 | 37.7802471321724 | -122.426957567511 | (37.7802471321724, -122.426957567511) | 7 | 9 | 11 | 28852 | 41 | |||||
40426 | 47227 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | 10 | 3 | 7 | 309 | 28 | ||
40666 | 110721 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
40733 | 46346 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/2002 12:00:00 AM | Permit Number 44592 | 6005461.4442402 | 2101476.38644964 | 37.7505628685682 | -122.423945552398 | (37.7505628685682, -122.423945552398) | 2 | 4 | 5 | 28859 | 19 | ||
40880 | 39219 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 347 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1998 12:00:00 AM | Permit Number 40862 | 5993215.94072133 | 2089494.769314 | 37.7169653816902 | -122.465420843024 | (37.7169653816902, -122.465420843024) | 9 | 8 | 6 | 64 | 24 | |||
41380 | 39674 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 510 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41060 | 5994056.62807806 | 2090013.39911729 | 37.7184378644924 | -122.462552614145 | (37.7184378644924, -122.462552614145) | 9 | 8 | 6 | 28861 | 24 | ||
42114 | 40737 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 163 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41716 | 6009144.8463962 | 2096601.1649491 | 37.737383844528 | -122.410863725513 | (37.737383844528, -122.410863725513) | 10 | 7 | 7 | 28859 | 2 | ||
42932 | 49808 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1546ARKANSAS 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46602 | 6013062.18652198 | 2105692.25425348 | 37.7625649012206 | -122.397957118424 | (37.7625649012206, -122.397957118424) | 14 | 3 | 8 | 28856 | 29 | ||
42933 | 38322 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1303 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40379 | 6006986.09982569 | 2107885.23558278 | 37.7682460414156 | -122.419127704144 | (37.7682460414156, -122.419127704144) | 8 | 4 | 7 | 28853 | 19 | ||
43658 | 116348 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
45162 | 100793 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Recently planted by FUF. | 6008363 | 2103862 | 37.7572766073656 | -122.414080464335 | (37.7572766073656, -122.414080464335) | 2 | 4 | 7 | 28859 | 19 | ||||
45337 | 251284 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 06/21/1996 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
46708 | 37017 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39630 | 6008600.86286293 | 2102426.42877225 | 37.7533482108195 | -122.413156329636 | (37.7533482108195, -122.413156329636) | 2 | 4 | 7 | 28859 | 19 | ||
47264 | 256155 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 80X Peralta Ave | 4 | Median : Cutout | Tree | Private 2 | 3x3 | 6010428 | 2100359 | 37.747773912222 | -122.406691992098 | (37.747773912222, -122.406691992098) | 2 | 7 | 7 | 28859 | 2 | ||||
47496 | 45707 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 188 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2001 12:00:00 AM | Permit Number 44380 | 5999327.0354809 | 2103995.03426473 | 37.7571302242183 | -122.445339815815 | (37.7571302242183, -122.445339815815) | 2 | 5 | 5 | 28862 | 3 | |||
48513 | 36468 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1469 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39366 | 5995883.06149021 | 2093810.4895036 | 37.7289687842477 | -122.456513863949 | (37.7289687842477, -122.456513863949) | 9 | 7 | 4 | 28861 | 40 | ||
51152 | 108581 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1X GARDENSIDE DR | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5999463 | 2102872 | 37.7540544083949 | -122.44478887768 | (37.7540544083949, -122.44478887768) | 2 | 5 | 5 | 63 | 38 | |||||
53155 | 46798 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 151 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44888 | 5994310.21524684 | 2095607.50798883 | 37.7338125312017 | -122.462081536077 | (37.7338125312017, -122.462081536077) | 9 | 8 | 4 | 59 | 40 | ||
53307 | 257999 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
54152 | 48439 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
54184 | 56623 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001932.70639357 | 2100631.3679946 | 37.7480427977008 | -122.43608772435 | (37.7480427977008, -122.43608772435) | 2 | 4 | 5 | 28862 | 22 | |||||
54578 | 99239 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | 1 | 8 | 4 | 59 | 40 | ||||
57042 | 109185 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 198x JUDSON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998796 | 2093546 | 37.7284093651166 | -122.446424638984 | (37.7284093651166, -122.446424638984) | 9 | 7 | 4 | 28861 | 40 | ||||
58507 | 109186 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 198x JUDSON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998796 | 2093546 | 37.7284093651166 | -122.446424638984 | (37.7284093651166, -122.446424638984) | 9 | 7 | 4 | 28861 | 40 | ||||
58561 | 39663 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
60638 | 116949 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 123 WEST PORTAL AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992936 | 2097647 | 37.7393332491746 | -122.466980791321 | (37.7393332491746, -122.466980791321) | 1 | 8 | 4 | 59 | 40 | ||||
62751 | 121683 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1645 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993978 | 2104308 | 37.7576827524199 | -122.463861408714 | (37.7576827524199, -122.463861408714) | 1 | 8 | 4 | 56 | 12 | ||||
62828 | 39705 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 El Verano Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | 9 | 8 | 4 | 59 | 40 | ||
66804 | 48736 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1633 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2002 12:00:00 AM | Permit Number 46017 | 6015017.13579754 | 2095815.21126112 | 37.7355533009373 | -122.39050541553 | (37.7355533009373, -122.39050541553) | 10 | 3 | 8 | 58 | 1 | ||
69275 | 253221 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 148 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.7296754160783 | -122.406227307752 | (37.7296754160783, -122.406227307752) | 10 | 3 | 7 | 309 | 28 | ||||
69488 | 111230 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1113 SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001842 | 2112262 | 37.7799725127801 | -122.4372340286 | (37.7799725127801, -122.4372340286) | 15 | 5 | 11 | 29490 | 41 | ||||
70462 | 173881 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1245 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996703 | 2107106 | 37.7655220059747 | -122.454639431756 | (37.7655220059747, -122.454639431756) | 15 | 5 | 11 | 29492 | 12 | ||||
70980 | 96020 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
71072 | 257997 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
72542 | 39664 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
72634 | 104807 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2069 GREEN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003141.4 | 2118171.7 | 37.7962728265697 | -122.433161198258 | (37.7962728265697, -122.433161198258) | 13 | 9 | 1 | 57 | 17 | ||||||
74296 | 94146 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1715 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53554 | 5992756.7 | 2103771.7 | 37.7561397565087 | -122.468046118338 | (37.7561397565087, -122.468046118338) | 1 | 8 | 4 | 56 | 12 | ||
74586 | 113271 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1321 Revere Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260 | 37.7286210040554 | -122.385097187433 | (37.7286210040554, -122.385097187433) | 10 | 3 | 8 | 58 | 1 | ||||
77285 | 114570 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 366 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014008 | 2105399 | 37.7618123194661 | -122.394665331171 | (37.7618123194661, -122.394665331171) | 10 | 3 | 8 | 28856 | 29 | ||||
77330 | 37234 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
77849 | 54369 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1444 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 4x6 | Permit Number 10135 | 5994306.99010384 | 2105683.08083554 | 37.76147732224 | -122.462823390787 | (37.76147732224, -122.462823390787) | 1 | 5 | 11 | 56 | 12 | ||
78077 | 37236 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
78214 | 258004 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
79831 | 102872 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 173 Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.447738107529 | (37.7272185530423, -122.447738107529) | 9 | 7 | 4 | 28861 | 40 | ||||
80142 | 254940 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2472 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998935 | 2088868 | 37.7155725951533 | -122.445607850995 | (37.7155725951533, -122.445607850995) | 9 | 7 | 6 | 28861 | 25 | ||||
80877 | 39671 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
81616 | 45782 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 243 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2001 12:00:00 AM | Permit Number 44422 | 5992531.14944144 | 2097322.97472388 | 37.7384201816637 | -122.468357005493 | (37.7384201816637, -122.468357005493) | 1 | 8 | 4 | 59 | 40 | |||
82760 | 47226 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | 10 | 3 | 7 | 309 | 28 | ||
83418 | 251282 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/07/2016 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
84422 | 95534 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3725 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767323 | 6004904 | 2102501 | 37.7533447323081 | -122.425946167651 | (37.7533447323081, -122.425946167651) | 2 | 4 | 5 | 28862 | 22 | |
85373 | 32334 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 150 Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | Permit Number 36897 | 6000779.60429895 | 2103438.99609434 | 37.7556862897816 | -122.440276412657 | (37.7556862897816, -122.440276412657) | 2 | 4 | 5 | 63 | 38 | |||
86699 | 98541 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4016 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002873 | 2105350 | 37.7610524139222 | -122.433173330823 | (37.7610524139222, -122.433173330823) | 15 | 4 | 5 | 28862 | 3 | ||||
87233 | 82031 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 471 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49837 | 5998319.05661716 | 2095227.73962292 | 37.7329997723608 | -122.448194494208 | (37.7329997723608, -122.448194494208) | 9 | 7 | 4 | 59 | 40 | ||
87948 | 116353 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
88465 | 38107 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1295 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | 1 | 8 | 3 | 56 | 35 | ||
89668 | 39704 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 El Verano Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | 9 | 8 | 4 | 59 | 40 | ||
90113 | 43897 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 714 Tehama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2000 12:00:00 AM | Permit Number 43499 | 6009277.55531704 | 2110532.12490079 | 37.7756425583487 | -122.411388770124 | (37.7756425583487, -122.411388770124) | 8 | 2 | 9 | 28853 | 34 | |||
91299 | 42943 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2517 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42837 | 6008896.6043096 | 2103802.00203994 | 37.7571418228984 | -122.412230804785 | (37.7571418228984, -122.412230804785) | 2 | 4 | 7 | 28859 | 19 | ||
96280 | 258008 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
96910 | 114307 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 595 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008020 | 2113749 | 37.7844047125189 | -122.415966831143 | (37.7844047125189, -122.415966831143) | 7 | 10 | 9 | 28858 | 36 | ||||
97204 | 33534 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 199 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37644 | 6007201.13991539 | 2097799.25218884 | 37.7405643467581 | -122.417668933754 | (37.7405643467581, -122.417668933754) | 2 | 7 | 7 | 28859 | 2 | |||
98450 | 33575 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 166 Bonview St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37683 | 6007091.70402672 | 2098068.82881396 | 37.7412983853712 | -122.418066427995 | (37.7412983853712, -122.418066427995) | 2 | 7 | 7 | 28859 | 2 | |||
98600 | 257994 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
99347 | 41261 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 136 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41948 | 6003783.84120513 | 2096452.6287084 | 37.73667393521 | -122.429388624637 | (37.73667393521, -122.429388624637) | 2 | 7 | 5 | 63 | 7 | |||
99448 | 47220 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
99767 | 52421 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3987 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2005 12:00:00 AM | Permit Number 48541 | 6003110.11516472 | 2104732.93493797 | 37.7593715494171 | -122.432309181209 | (37.7593715494171, -122.432309181209) | 2 | 4 | 5 | 28862 | 3 | |||
100401 | 116352 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
103073 | 38105 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1295 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | 1 | 8 | 3 | 56 | 35 | ||
103570 | 257998 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
104793 | 33501 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 121 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37595 | 6006663.30728315 | 2098959.97627538 | 37.7437211553943 | -122.41961088786 | (37.7437211553943, -122.41961088786) | 2 | 7 | 7 | 28859 | 2 | ||
104810 | 258003 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 |
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) );