trees
835 rows where qSpecies_id = 122 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 942 | 67185 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 154 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | 12 | Permit Number 30632 | 5998076.31886872 | 2105384.33640813 | 37.7608734252807 | -122.449765371246 | (37.7608734252807, -122.449765371246) | 15 | 5 | 11 | 29492 | 12 | |
| 1329 | 124750 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 566 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004650.035 | 2110687.35997 | 37.7758081630602 | -122.42740756863 | (37.7758081630602, -122.42740756863) | 7 | 9 | 11 | 28852 | 10 | |||
| 1353 | 203642 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 349x Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 5ft | 5993150.97673 | 2103877.75625 | 37.7564537210662 | -122.466690296437 | (37.7564537210662, -122.466690296437) | 1 | 8 | 4 | 56 | 12 | |||
| 1889 | 259158 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
| 2035 | 68350 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 535 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32169 | 5989368.29935 | 2111675.70215 | 37.7776457288828 | -122.48034272561 | (37.7776457288828, -122.48034272561) | 11 | 6 | 2 | 55 | 26 | |
| 2461 | 73754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1815 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009969.6946 | 2120303.1237 | 37.8025101678048 | -122.409684302662 | (37.8025101678048, -122.409684302662) | 3 | 1 | 10 | 308 | 23 | |||
| 2542 | 32891 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1515 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.7603305839468 | -122.462923499947 | (37.7603305839468, -122.462923499947) | 1 | 5 | 4 | 56 | 12 | ||
| 2756 | 39703 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.4472036828 | (37.7318275120035, -122.4472036828) | 9 | 7 | 4 | 59 | 40 | ||
| 2860 | 78000 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2804 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5985608.4149 | 2096224.5025 | 37.735001786065 | -122.492211254352 | (37.735001786065, -122.492211254352) | 1 | 8 | 3 | 29491 | 35 | |||
| 3138 | 71805 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2451 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987333.5642 | 2098599.3879 | 37.7416232962242 | -122.486421183565 | (37.7416232962242, -122.486421183565) | 1 | 8 | 3 | 29491 | 35 | |||
| 3232 | 20054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 3321 | 220066 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002537.11463 | 2102291.14962 | 37.7526344847082 | -122.434116340213 | (37.7526344847082, -122.434116340213) | 2 | 4 | 5 | 28862 | 22 | |||
| 3985 | 69145 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2419 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 6 | Permit Number 33179 | 5983608.7607 | 2098659.5816 | 37.741570751884 | -122.499304541285 | (37.741570751884, -122.499304541285) | 1 | 8 | 3 | 29491 | 35 | |
| 4729 | 38050 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2700 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2005 12:00:00 AM | 3 | Permit Number 47797 | 6000529.6397 | 2114492.1859 | 37.7860213405762 | -122.441934174319 | (37.7860213405762, -122.441934174319) | 13 | 6 | 1 | 29490 | 27 | |
| 5047 | 37814 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003977.37565 | 2090552.2455 | 37.720483755714 | -122.428299091747 | (37.720483755714, -122.428299091747) | 9 | 7 | 6 | 28861 | 5 |
| 5516 | 248395 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1655 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | 8 | Width 0ft | Permit Number 41881 | 5997659.0251 | 2108142.2349 | 37.7684220306889 | -122.451407517669 | (37.7684220306889, -122.451407517669) | 15 | 5 | 11 | 29492 | 9 | |
| 5666 | 81675 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013305 | 2104816 | 37.7601724196148 | -122.397055866002 | (37.7601724196148, -122.397055866002) | 10 | 3 | 8 | 28856 | 29 | |||
| 5685 | 245867 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 419 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005023.743 | 2110457.4751 | 37.7751980841556 | -122.426098447818 | (37.7751980841556, -122.426098447818) | 7 | 9 | 11 | 28852 | 10 | |||
| 6049 | 35103 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 786 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38645 | 6001885.65115289 | 2089265.94057695 | 37.7168332689419 | -122.435437534334 | (37.7168332689419, -122.435437534334) | 9 | 7 | 6 | 28861 | 5 | ||
| 6360 | 83538 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 243 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004140.21383 | 2089715.70651 | 37.7181960153187 | -122.427676641269 | (37.7181960153187, -122.427676641269) | 9 | 7 | 6 | 28861 | 5 | |||
| 6554 | 51248 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47625 | 6007471.15651424 | 2105682.67696043 | 37.7622256337552 | -122.417293833991 | (37.7622256337552, -122.417293833991) | 8 | 4 | 7 | 28859 | 19 | ||
| 6622 | 124083 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3434 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5992631.55645 | 2110040.63137 | 37.7733453553708 | -122.468935093468 | (37.7733453553708, -122.468935093468) | 11 | 6 | 2 | 54 | 11 | |||
| 6630 | 30591 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 253 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34560 | |||||||||||||
| 7013 | 220677 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3625 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 3ft | 6006108.91147 | 2104316.67896 | 37.758398187544 | -122.421908293434 | (37.758398187544, -122.421908293434) | 2 | 4 | 5 | 28859 | 19 | ||
| 7229 | 73391 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 237 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001816.88591 | 2094039.23102 | 37.7299357428343 | -122.43601658702 | (37.7299357428343, -122.43601658702) | 9 | 7 | 6 | 28861 | 25 | |||
| 7303 | 220693 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3873 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004694.52758 | 2100732.52355 | 37.7484770663623 | -122.426544650217 | (37.7484770663623, -122.426544650217) | 2 | 4 | 5 | 63 | 22 | |||
| 8595 | 66640 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2620 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32335 | 6010387.14006944 | 2103433.53881978 | 37.7562136300125 | -122.407049963033 | (37.7562136300125, -122.407049963033) | 10 | 4 | 7 | 28859 | 19 | ||
| 8738 | 44456 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 5 | Permit Number 43779 | 6002571.72829 | 2086874.98861 | 37.7103071803111 | -122.432895389109 | (37.7103071803111, -122.432895389109) | 9 | 7 | 6 | 28861 | 5 | |
| 9025 | 30594 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
| 9936 | 203633 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 458 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997727.84983 | 2094119.15999 | 37.7299220605503 | -122.450158563772 | (37.7299220605503, -122.450158563772) | 9 | 7 | 4 | 28861 | 40 | |||
| 10486 | 38055 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2779 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 5 | Permit Number 40250 | 6000228.6146 | 2114392.8852 | 37.7857315284908 | -122.442968502827 | (37.7857315284908, -122.442968502827) | 15 | 6 | 1 | 29490 | 27 | |
| 11302 | 34144 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1754 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39666 | 6003955.69985192 | 2098004.27278913 | 37.7409441243389 | -122.428905023889 | (37.7409441243389, -122.428905023889) | 2 | 7 | 5 | 63 | 7 | ||
| 11891 | 38044 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1523 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 11 | Permit Number 40245 | 6000092.6356 | 2114341.0582 | 37.7855814713487 | -122.443435225951 | (37.7855814713487, -122.443435225951) | 15 | 6 | 1 | 29490 | 31 | |
| 11908 | 220089 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Ord Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6000884.7117 | 2105729.84303 | 37.7619823797984 | -122.440077179831 | (37.7619823797984, -122.440077179831) | 15 | 5 | 5 | 28862 | 3 | |||
| 12666 | 48033 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 61 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2002 12:00:00 AM | Permit Number 45754 | 6001724.06677399 | 2105480.90222389 | 37.7613465972478 | -122.437156358638 | (37.7613465972478, -122.437156358638) | 15 | 4 | 5 | 28862 | 3 | |||
| 12702 | 32557 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3822 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | Permit Number 770192 | 6002956.41958884 | 2103022.59282687 | 37.7546666427143 | -122.432718557235 | (37.7546666427143, -122.432718557235) | 2 | 4 | 5 | 28862 | 22 | |||
| 13093 | 54840 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 236 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1972 12:00:00 AM | 6 | 3x3 | Permit Number 10695 | 5998822.5685 | 2109866.5256 | 37.7732230519388 | -122.447507074191 | (37.7732230519388, -122.447507074191) | 15 | 5 | 11 | 29492 | 16 |
| 13307 | 37952 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1308 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40191 | 6013419.73141926 | 2106176.98186548 | 37.7639157629311 | -122.396754475262 | (37.7639157629311, -122.396754475262) | 14 | 3 | 8 | 28856 | 29 | ||
| 13458 | 37949 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40189 | 6013245.07108 | 2104267.20859 | 37.7586622221997 | -122.397224649796 | (37.7586622221997, -122.397224649796) | 10 | 3 | 8 | 28856 | 29 | |
| 13642 | 78061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 107 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6006671.07774 | 2094291.78297 | 37.7309037694737 | -122.419252940787 | (37.7309037694737, -122.419252940787) | 9 | 3 | 7 | 309 | 28 | |||
| 14412 | 71308 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1949 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000243.5 | 2111616.6716 | 37.7781096083019 | -122.442717588877 | (37.7781096083019, -122.442717588877) | 15 | 5 | 11 | 29490 | 16 | |||
| 15280 | 124754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2077 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784537 | 6003727.74275 | 2117577.18944 | 37.7946736966861 | -122.431089877801 | (37.7946736966861, -122.431089877801) | 13 | 9 | 1 | 29490 | 27 | |
| 15282 | 220063 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003095.90411 | 2102839.48353 | 37.7541717777287 | -122.432223106309 | (37.7541717777287, -122.432223106309) | 2 | 4 | 5 | 28862 | 22 | |||
| 15287 | 40295 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 48 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41439 | 6005981.28847445 | 2102313.08870522 | 37.7528895951686 | -122.422207325088 | (37.7528895951686, -122.422207325088) | 2 | 4 | 5 | 28859 | 19 | ||
| 15295 | 220081 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 780 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003049.24321 | 2103668.76893 | 37.7564461523878 | -122.432443698342 | (37.7564461523878, -122.432443698342) | 2 | 4 | 5 | 28862 | 3 | |||
| 15606 | 174964 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1645 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006075.21093 | 2092385.59149 | 37.7256362082245 | -122.421177650028 | (37.7256362082245, -122.421177650028) | 9 | 7 | 7 | 309 | 5 | |||
| 16325 | 38333 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40387 | 6006701.38591008 | 2112874.96361955 | 37.7819305989802 | -122.420466726707 | (37.7819305989802, -122.420466726707) | 7 | 9 | 9 | 28852 | 36 | |||
| 16365 | 203647 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 70 Manor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993596.72892 | 2093377.09996 | 37.7276472749004 | -122.464386369131 | (37.7276472749004, -122.464386369131) | 9 | 8 | 4 | 59 | 40 | |||
| 16553 | 75408 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 De Long St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994441.08765 | 2086786.63151 | 37.7096000577555 | -122.460989960739 | (37.7096000577555, -122.460989960739) | 9 | 8 | 6 | 28861 | 25 | |||
| 17237 | 123125 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 798 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2019 12:00:00 AM | 3 | Width 4ft | 5992603.0812 | 2110069.8115 | 37.7734238309341 | -122.469035716481 | (37.7734238309341, -122.469035716481) | 11 | 6 | 2 | 54 | 11 | ||
| 17907 | 70572 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 421 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5999717.91 | 2110099.0732 | 37.773912694204 | -122.444426694754 | (37.773912694204, -122.444426694754) | 15 | 5 | 11 | 29492 | 16 | |||
| 19563 | 261622 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1281x Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012916 | 2101714 | 37.7516333407735 | -122.398183607514 | (37.7516333407735, -122.398183607514) | 10 | 3 | 8 | 28856 | 29 | ||||
| 20170 | 137728 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1989 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999638.3271 | 2111189.948 | 37.7769034171043 | -122.444780412241 | (37.7769034171043, -122.444780412241) | 15 | 5 | 11 | 29492 | 16 | |||
| 20408 | 39701 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 625 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41086 | 5998544.21434681 | 2094768.39031032 | 37.7317513769747 | -122.447383017512 | (37.7317513769747, -122.447383017512) | 9 | 7 | 4 | 59 | 40 | ||
| 20429 | 220024 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4273 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002125.33793 | 2101175.24323 | 37.749547092337 | -122.435460513693 | (37.749547092337, -122.435460513693) | 2 | 4 | 5 | 28862 | 22 | |||
| 20553 | 68132 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1526 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 0 | Permit Number 31884 | 6000696.86081651 | 2113890.04393367 | 37.7843775414062 | -122.44131241544 | (37.7843775414062, -122.44131241544) | 15 | 6 | 11 | 29490 | 13 | |
| 20868 | 10688 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1221 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/1991 12:00:00 AM | 6 | 3X3 | 6002001.6656 | 2110480.73 | 37.7750906677438 | -122.43655414222 | (37.7750906677438, -122.43655414222) | 15 | 5 | 11 | 29492 | 10 | ||
| 20938 | 33356 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 200 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37493 | 5994058.57591139 | 2093537.34847989 | 37.7281138896418 | -122.462801390817 | (37.7281138896418, -122.462801390817) | 9 | 8 | 4 | 59 | 40 | ||
| 21427 | 49185 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 220 Palo Alto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46291 | 5997532.34805472 | 2103898.27952644 | 37.7567619489163 | -122.451539524782 | (37.7567619489163, -122.451539524782) | 15 | 5 | 4 | 63 | 38 | |||
| 22337 | 43381 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 706 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43129 | 6001854.12345529 | 2102032.01903245 | 37.7518841875031 | -122.436459694241 | (37.7518841875031, -122.436459694241) | 2 | 4 | 5 | 28862 | 22 | ||
| 22663 | 50046 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4086 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46777 | 6002595.036724 | 2102416.46621438 | 37.7529818614653 | -122.433924992434 | (37.7529818614653, -122.433924992434) | 2 | 4 | 5 | 28862 | 22 |
| 22711 | 81348 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 561 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774387 | 6002774.12023878 | 2102081.98215915 | 37.7520736087499 | -122.433281789286 | (37.7520736087499, -122.433281789286) | 2 | 4 | 5 | 28862 | 22 | |
| 22960 | 54500 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31133 | 6013270.33865 | 2104862.70543 | 37.760298732933 | -122.397179019096 | (37.760298732933, -122.397179019096) | 10 | 3 | 8 | 28856 | 29 | |
| 23876 | 60312 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 545 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/1982 12:00:00 AM | 10 | Permit Number 19882 | 5999669.64 | 2110412.2941 | 37.774769964844 | -122.444616185093 | (37.774769964844, -122.444616185093) | 15 | 5 | 11 | 29492 | 16 | ||
| 24531 | 43380 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 700 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43128 | 6001853.17321705 | 2102048.95584272 | 37.751930637944 | -122.436464192392 | (37.751930637944, -122.436464192392) | 2 | 4 | 5 | 28862 | 22 | ||
| 24541 | 43172 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 370 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 2 | Permit Number 42981 | 6005806.0739 | 2092004.68571 | 37.7245751476096 | -122.422080988441 | (37.7245751476096, -122.422080988441) | 9 | 7 | 7 | 309 | 5 | |
| 24732 | 219998 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 60 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005981.24616 | 2097649.70039 | 37.7400849896219 | -122.421876240696 | (37.7400849896219, -122.421876240696) | 2 | 7 | 7 | 28859 | 2 | |||
| 24848 | 63851 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24548 | 6001965.88884277 | 2110471.51360831 | 37.775063328726 | -122.43667724184 | (37.775063328726, -122.43667724184) | 15 | 5 | 11 | 29492 | 10 | ||
| 25189 | 251472 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780012 | 6001589 | 2096875 | 37.7377091611847 | -122.437007355935 | (37.7377091611847, -122.437007355935) | 2 | 7 | 5 | 63 | 7 | |
| 25315 | 33658 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 575 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37746 | 6004659.15076187 | 2110673.58419475 | 37.7757708537128 | -122.427375053318 | (37.7757708537128, -122.427375053318) | 7 | 9 | 11 | 28852 | 10 | |||
| 26074 | 220045 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 160 Marview Way | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5998323.68704 | 2103258.27383 | 37.755049936933 | -122.448756699664 | (37.755049936933, -122.448756699664) | 1 | 5 | 4 | 63 | 38 | |||
| 26802 | 37051 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 364 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39656 | 6003583.41460965 | 2098669.49042288 | 37.7427495797017 | -122.430239695512 | (37.7427495797017, -122.430239695512) | 2 | 7 | 5 | 63 | 22 | ||
| 27101 | 52597 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 421@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/2006 12:00:00 AM | Permit Number 48691 | 6005029.01915461 | 2110416.12997637 | 37.7750848587198 | -122.426077252438 | (37.7750848587198, -122.426077252438) | 7 | 9 | 11 | 28852 | 10 | ||
| 27735 | 38526 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3031 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/1998 12:00:00 AM | 9 | Permit Number 40508 | 6001945.50794 | 2118614.30712 | 37.797420199241 | -122.437330933595 | (37.797420199241, -122.437330933595) | 13 | 9 | 1 | 57 | 17 | ||
| 27905 | 220056 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1424 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009277.43373 | 2100868.30065 | 37.7491078976199 | -122.410706569176 | (37.7491078976199, -122.410706569176) | 2 | 4 | 7 | 28859 | 19 | |||
| 28414 | 36508 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 584 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.7361990307601 | -122.415517981354 | (37.7361990307601, -122.415517981354) | 2 | 7 | 7 | 28859 | 2 | ||
| 28426 | 33399 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 300 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37517 | 5992600.35501271 | 2094892.48894855 | 37.7317506732587 | -122.467940993296 | (37.7317506732587, -122.467940993296) | 9 | 8 | 4 | 59 | 40 | ||
| 28491 | 220050 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 301 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006755.51813 | 2098027.45978 | 37.741165867704 | -122.419225908968 | (37.741165867704, -122.419225908968) | 2 | 7 | 7 | 28859 | 2 | |||
| 30127 | 68814 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 125 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32757 | 6002131.57604717 | 2095277.55167817 | 37.7333537609923 | -122.435017196532 | (37.7333537609923, -122.435017196532) | 9 | 7 | 5 | 63 | 40 | ||
| 30776 | 67143 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 303 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 30573 | 6006940.4062177 | 2097313.36453869 | 37.7392155318486 | -122.418536006241 | (37.7392155318486, -122.418536006241) | 2 | 7 | 7 | 28859 | 2 | ||
| 30880 | 220070 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 410 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003569.73703 | 2105814.1279 | 37.762366296796 | -122.43079674288 | (37.762366296796, -122.43079674288) | 15 | 4 | 5 | 28862 | 3 | |||
| 31049 | 66174 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 70 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29247 | 6009314.15806324 | 2097044.09702117 | 37.7386095323365 | -122.410309598587 | (37.7386095323365, -122.410309598587) | 10 | 7 | 7 | 28859 | 2 | ||
| 32263 | 67530 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | 12 | Permit Number 31068 | 6013998.45944 | 2106956.61768 | 37.7660886653923 | -122.394807417822 | (37.7660886653923, -122.394807417822) | 14 | 3 | 8 | 28856 | 20 | |
| 32638 | 203223 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 25 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994463.96401 | 2093754.28831 | 37.7287328942013 | -122.461415680898 | (37.7287328942013, -122.461415680898) | 9 | 8 | 4 | 59 | 40 | |||
| 32905 | 220062 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 430 College Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6005376.5701 | 2095055.52961 | 37.7329278583224 | -122.423782556133 | (37.7329278583224, -122.423782556133) | 2 | 7 | 7 | 28861 | 2 | |||
| 33013 | 51076 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 232 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2006 12:00:00 AM | Permit Number 47538 | 6006664.07662334 | 2104758.9078781 | 37.7596437391075 | -122.420019665049 | (37.7596437391075, -122.420019665049) | 2 | 4 | 7 | 28859 | 19 | ||
| 33276 | 219990 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 151 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999384.54447 | 2107324.60583 | 37.766275682101 | -122.445380326357 | (37.766275682101, -122.445380326357) | 15 | 5 | 5 | 29492 | 9 | |||
| 33995 | 245838 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 423 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005012.6195 | 2110528.7961 | 37.7753932855436 | -122.426142005084 | (37.7753932855436, -122.426142005084) | 7 | 9 | 11 | 28852 | 10 | |||
| 34029 | 10690 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6001959.267 | 2110474.8139 | 37.7750720141838 | -122.436700384498 | (37.7750720141838, -122.436700384498) | 15 | 5 | 11 | 29492 | 10 | |||
| 34736 | 35252 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 7 | Permit Number 38738 | 6006246.10083 | 2119680.0646 | 37.8005900423666 | -122.422525509838 | (37.8005900423666, -122.422525509838) | 13 | 9 | 1 | 28858 | 32 | |
| 35036 | 215287 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | Permit Number 780412 | 5992944.71929 | 2103190.50616 | 37.7545548052666 | -122.467353630083 | (37.7545548052666, -122.467353630083) | 1 | 8 | 4 | 56 | 12 | ||
| 36194 | 140102 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1720 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999455.5793 | 2110868.7857 | 37.7760111570338 | -122.445389492297 | (37.7760111570338, -122.445389492297) | 15 | 5 | 11 | 29492 | 16 | |||
| 36595 | 220077 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4160 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002637.75275 | 2104169.99099 | 37.7577990456928 | -122.433902601035 | (37.7577990456928, -122.433902601035) | 2 | 4 | 5 | 28862 | 3 | |||
| 37455 | 220026 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 685 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001902.38031 | 2102621.8344 | 37.753506421492 | -122.436335023459 | (37.753506421492, -122.436335023459) | 2 | 4 | 5 | 28862 | 22 | |||
| 37768 | 43179 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2299 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42985 | 6001635.1083 | 2114240.3384 | 37.7853927633961 | -122.438091512505 | (37.7853927633961, -122.438091512505) | 13 | 6 | 11 | 29490 | 13 |
| 38389 | 220690 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 330 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003721.78604 | 2099258.64688 | 37.7443751038286 | -122.42980326002 | (37.7443751038286, -122.42980326002) | 2 | 7 | 5 | 63 | 22 | |||
| 38603 | 32274 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 623 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39911 | 6007825.97257693 | 2096019.31993336 | 37.7357121847697 | -122.415382520688 | (37.7357121847697, -122.415382520688) | 2 | 7 | 7 | 28859 | 2 | ||
| 39232 | 1377 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 65 Amethyst Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1998 12:00:00 AM | 3 | 1X1 | 5998937.99517 | 2100006.33795 | 37.7461560249957 | -122.44639832203 | (37.7461560249957, -122.44639832203) | 2 | 7 | 5 | 63 | 22 | ||
| 40042 | 220092 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 24 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006394.36568 | 2110096.52086 | 37.774284361671 | -122.421331508756 | (37.774284361671, -122.421331508756) | 7 | 9 | 11 | 28852 | 10 | |||
| 40096 | 32740 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 139 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37123 | 5995564.95354615 | 2088674.66529796 | 37.7148487646576 | -122.457242200681 | (37.7148487646576, -122.457242200681) | 9 | 8 | 6 | 28861 | 24 |
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) );