Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63651 | 63651 | 109426 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 132 Locust St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2015 12:00:00 AM | 3 | 5997544.3 | 2115966.4 | 37.7898985728773 | -122.452369007612 | (37.7898985728773, -122.452369007612) | ||||
| 83315 | 83315 | 88823 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 110 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51710 | 5998275.0 | 2110294.0 | 37.7743654794888 | -122.44943198445 | (37.7743654794888, -122.44943198445) | ||||
| 85969 | 85969 | 86887 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 56 Casa Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49816 | 6001536.6 | 2121651.4 | 37.8057359986938 | -122.43896362504499 | (37.8057359986938, -122.438963625045) | ||||
| 102905 | 102905 | 88602 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 370 Parnassus Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51547 | 5996151.9 | 2106560.1 | 37.7639914803102 | -122.45650607155001 | (37.7639914803102, -122.45650607155) | |||
| 116342 | 116342 | 88989 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1696 McAllister St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51741 | 5997688.0 | 2111682.0 | 37.7781429711136 | -122.451562655149 | (37.7781429711136, -122.451562655149) | ||||
| 122594 | 122594 | 104809 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 685 Marina Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 770974 | 5999736.8 | 2121509.8 | 37.8052446370698 | -122.445181890463 | (37.8052446370698, -122.445181890463) | ||||
| 145878 | 145878 | 89262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Polk St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||||
| 58 | 58 | 4749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1255 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 8 | 3X3 | 6007516.58505 | 2121541.63395 | 37.805773032263296 | -122.41826116482599 | (37.8057730322633, -122.418261164826) | ||
| 670 | 670 | 13108 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1557 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6004929.5061 | 2119810.12 | 37.80087277869679 | -122.427090735634 | (37.8008727786968, -122.427090735634) | |||
| 940 | 940 | 51496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.44012948036101 | (37.773809648853, -122.440129480361) | |||
| 2194 | 2194 | 23455 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2240 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6005973.83981 | 2118127.35599 | 37.796311335142995 | -122.423357203778 | (37.796311335143, -122.423357203778) | |||
| 2354 | 2354 | 18870 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2269 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003913.0 | 2115924.0 | 37.790144955549394 | -122.430330857904 | (37.7901449555494, -122.430330857904) | |||
| 2778 | 2778 | 246114 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1418 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 13 | Width 0ft | Permit Number 47096 | 5998969.2151 | 2108370.2652 | 37.769123080801 | -122.44689211719 | (37.769123080801, -122.44689211719) | |
| 2779 | 2779 | 246118 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1420 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 6 | Width 0ft | Permit Number 31980 | 5998892.5994 | 2108357.8492 | 37.769084612317705 | -122.44715623175301 | (37.7690846123177, -122.447156231753) | |
| 3571 | 3571 | 39975 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 3621 | 3621 | 249566 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005942.163819999 | 2114329.62673 | 37.7858819315591 | -122.42319672154899 | (37.7858819315591, -122.423196721549) | |||
| 3860 | 3860 | 30022 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1659 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2016 10:15:00 AM | 3 | 3x3 | 5998115.9942 | 2108549.9942 | 37.76956778996521 | -122.449856300055 | (37.7695677899652, -122.449856300055) | ||
| 3903 | 3903 | 220233 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Ashbury St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/23/1987 12:00:00 AM | 39 | Width 4ft | Permit Number 12054 | 5999170.85741 | 2106639.03394 | 37.764381073148705 | -122.44607010996201 | (37.7643810731487, -122.446070109962) | |
| 3914 | 3914 | 23457 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2249 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5x5 | 6005866.883230001 | 2118164.3475 | 37.7964068674367 | -122.42372992781901 | (37.7964068674367, -122.423729927819) | |||
| 4155 | 4155 | 203731 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2342 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2004 12:00:00 AM | 16 | Width 4ft | Permit Number 47446 | 5992657.79242 | 2099436.17889 | 37.7442298192534 | -122.468072813407 | (37.7442298192534, -122.468072813407) | |
| 4840 | 4840 | 64237 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 557 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779942 | 5987180.23832 | 2112140.30179 | 37.778793995563895 | -122.48794601676599 | (37.7787939955639, -122.487946016766) | |
| 5765 | 5765 | 23561 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2930 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005650.5577 | 2120458.20498 | 37.8026930017358 | -122.424641718951 | (37.8026930017358, -122.424641718951) | |||
| 6078 | 6078 | 31879 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2135 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 18 | 4x4 | Permit Number 35317 | 6002171.6748 | 2119433.3444 | 37.7996819159911 | -122.43660699413 | (37.7996819159911, -122.43660699413) | |
| 6364 | 6364 | 13127 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004182.8465 | 2119787.4466 | 37.8007682730329 | -122.42967287413 | (37.8007682730329, -122.42967287413) | |||
| 6449 | 6449 | 7072 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1652 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999508.2617 | 2109836.0506 | 37.7731785369509 | -122.44513298700899 | (37.7731785369509, -122.445132987009) | |||
| 6667 | 6667 | 17874 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2158 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003619.9977 | 2115267.4707 | 37.7883256917387 | -122.4312977384 | (37.7883256917387, -122.4312977384) | |||
| 6886 | 6886 | 55233 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2900 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1983 12:00:00 AM | 24 | 4x5 | Permit Number 20974 | 6001057.82109 | 2118342.00896 | 37.7966220365405 | -122.440383014983 | (37.7966220365405, -122.440383014983) | |
| 6921 | 6921 | 53479 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3600 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/1969 12:00:00 AM | 36 | 6x12 | Permit Number 6388 | 5997506.20792 | 2115767.61462 | 37.7893505789022 | -122.45248645079201 | (37.7893505789022, -122.452486450792) | |
| 7251 | 7251 | 67295 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2021 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2015 12:00:00 AM | 3 | Permit Number 775844 | 5999878.81667 | 2115908.61359 | 37.7898733737087 | -122.444287662668 | (37.7898733737087, -122.444287662668) | ||
| 7305 | 7305 | 7157 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 719 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6003511.3637 | 2110856.3338 | 37.776207657227204 | -122.431358584421 | (37.7762076572272, -122.431358584421) | |||
| 7745 | 7745 | 13062 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2000 12:00:00 AM | 6 | 2X2 | 6009500.6409 | 2120545.5727 | 37.8031495768645 | -122.41132460578899 | (37.8031495768645, -122.411324605789) | ||
| 8478 | 8478 | 23520 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2725 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6005647.500080001 | 2119771.5564099997 | 37.800807467849395 | -122.424603426707 | (37.8008074678494, -122.424603426707) | |||
| 8491 | 8491 | 67001 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 840X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1992 12:00:00 AM | 3 | Permit Number 30356 | 6009653.005480001 | 2118469.06923 | 37.7974565552432 | -122.410650614256 | (37.7974565552432, -122.410650614256) | ||
| 9241 | 9241 | 27374 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1702 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999207.4594 | 2109789.3959999997 | 37.773033261646496 | -122.44617014115101 | (37.7730332616465, -122.446170141151) | |||
| 10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
| 14058 | 14058 | 6836 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1475 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2015 12:00:00 AM | 3 | 3X3 | 6016046.71071 | 2097829.88517 | 37.7411422488076 | -122.387086226361 | (37.7411422488076, -122.387086226361) | ||
| 14068 | 14068 | 30309 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
| 14181 | 14181 | 24141 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6016711.43718 | 2095116.50195 | 37.733728630852795 | -122.38459886076001 | (37.7337286308528, -122.38459886076) | |||
| 17458 | 17458 | 10319 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 739 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6002579.70252 | 2109173.84871 | 37.7715351260824 | -122.434461126791 | (37.7715351260824, -122.434461126791) | |||
| 17561 | 17561 | 22565 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 231 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6001358.74635 | 2097645.7360799997 | 37.7398123322633 | -122.437858639569 | (37.7398123322633, -122.437858639569) | |||
| 18193 | 18193 | 39379 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1354 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40920 | 6007143.93712268 | 2107602.08417603 | 37.7674774616365 | -122.41856167807501 | (37.7674774616365, -122.418561678075) | |||
| 19250 | 19250 | 7648 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3303 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1999 12:00:00 AM | 3 | 4x4 | 6008513.3556 | 2099374.88287 | 37.7449644349621 | -122.413243176241 | (37.7449644349621, -122.413243176241) | ||
| 19684 | 19684 | 50106 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672002 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | ||
| 20368 | 20368 | 22570 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 285 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6001210.73338 | 2097821.1569 | 37.7402855789128 | -122.438382969513 | (37.7402855789128, -122.438382969513) | |||
| 20504 | 20504 | 10495 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1701 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5997835.7259 | 2108510.475 | 37.7694432404816 | -122.450822883239 | (37.7694432404816, -122.450822883239) | |||
| 20602 | 20602 | 14575 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1134 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1997 12:00:00 AM | 18 | 4X4 | 5999433.6283 | 2108924.6352 | 37.770671761343706 | -122.445325609236 | (37.7706717613437, -122.445325609236) | ||
| 21846 | 21846 | 5476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 635 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6005015.06111 | 2104677.01858 | 37.7593258454205 | -122.425716962778 | (37.7593258454205, -122.425716962778) | |||
| 22181 | 22181 | 9403 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 461 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1998 12:00:00 AM | 6 | 3x3 | 6001657.4794 | 2097610.8780099996 | 37.7397336029134 | -122.43682325371599 | (37.7397336029134, -122.436823253716) | ||
| 22305 | 22305 | 68937 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 518 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2017 12:00:00 AM | 3 | Permit Number 779489 | 5992539.41235 | 2111890.04765 | 37.7784180283155 | -122.46938847408998 | (37.7784180283155, -122.46938847409) | |
| 23512 | 23512 | 49013 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2450 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | 12 | Permit Number 46199 | 5999595.37201 | 2119840.2569999998 | 37.8006524480994 | -122.44555118855601 | (37.8006524480994, -122.445551188556) | ||
| 23976 | 23976 | 68013 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2245 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 21 | Permit Number 770742 | 5999478.9581699995 | 2120820.4060400003 | 37.803337026932894 | -122.446024564694 | (37.8033370269329, -122.446024564694) | ||
| 24674 | 24674 | 7916 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1225 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6005951.06937 | 2114267.1292 | 37.785710831353896 | -122.423161466763 | (37.7857108313539, -122.423161466763) | |||
| 24716 | 24716 | 47878 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 41X 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45624 | 5990495.13219 | 2114853.7022700002 | 37.786437050562704 | -122.476676909352 | (37.7864370505627, -122.476676909352) | |
| 27654 | 27654 | 30297 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2734 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1956 12:00:00 AM | 9 | Permit Number 140 | 6003569.97515 | 2117774.33074 | 37.7952060548567 | -122.43164985595 | (37.7952060548567, -122.43164985595) | ||
| 30134 | 30134 | 34162 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1321 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1997 12:00:00 AM | Permit Number 37995 | 6002005.24557776 | 2100252.01136141 | 37.747005294912896 | -122.435809748575 | (37.7470052949129, -122.435809748575) | |||
| 33086 | 33086 | 59887 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 21 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 23 | Permit Number 19353 | 5998815.1407 | 2110971.0405 | 37.776255342115604 | -122.447612291383 | (37.7762553421156, -122.447612291383) | |
| 35852 | 35852 | 97089 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2756 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6002122.15814 | 2117670.11356 | 37.7948377303266 | -122.43665205875601 | (37.7948377303266, -122.436652058756) | |||
| 36213 | 36213 | 87049 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 139 Welsh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 13 | 3x3 | Permit Number 49986 | 6013117.93675 | 2111529.65612 | 37.7785962007824 | -122.398173856333 | (37.7785962007824, -122.398173856333) | |
| 36388 | 36388 | 87087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | ||
| 38645 | 38645 | 32303 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 750 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 36880 | 5990706.9497 | 2110266.1077900003 | 37.773853068141605 | -122.47560897417699 | (37.7738530681416, -122.475608974177) | |||
| 39721 | 39721 | 49030 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2763 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2003 12:00:00 AM | 5 | Permit Number 46206 | 5999822.18303 | 2117741.39677 | 37.7949024824292 | -122.444615393602 | (37.7949024824292, -122.444615393602) | ||
| 39815 | 39815 | 38562 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1620 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40527 | 6015255.0701 | 2096054.7136 | 37.736224122234205 | -122.389699501807 | (37.7362241222342, -122.389699501807) | |
| 41597 | 41597 | 102629 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 168 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 769953 | 5988063.8153 | 2114882.99878 | 37.7863761669029 | -122.485090700066 | (37.7863761669029, -122.485090700066) | |||
| 42619 | 42619 | 91061 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2475 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2008 12:00:00 AM | 15 | 3x3 | Permit Number 51968 | 6001778.15599 | 2117308.9761 | 37.793826585689104 | -122.43781647395299 | (37.7938265856891, -122.437816473953) | |
| 43180 | 43180 | 40179 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1724 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1999 12:00:00 AM | 24 | Permit Number 41370 | 6002078.2803 | 2114497.9921 | 37.786125408317396 | -122.43657672143499 | (37.7861254083174, -122.436576721435) | ||
| 43203 | 43203 | 54713 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1972 12:00:00 AM | 14 | Permit Number 11467 | 6001165.76206 | 2116883.2589 | 37.7926228359235 | -122.43990487063999 | (37.7926228359235, -122.43990487064) | ||
| 45050 | 45050 | 51789 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1238 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2005 12:00:00 AM | 13 | Permit Number 48038 | 5987411.1576 | 2106813.4078 | 37.7641812994666 | -122.486755921101 | (37.7641812994666, -122.486755921101) | ||
| 45398 | 45398 | 58302 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3233 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1978 12:00:00 AM | 16 | Permit Number 17321 | 5998757.69678 | 2116224.86065 | 37.7906776778817 | -122.44818940014 | (37.7906776778817, -122.44818940014) | ||
| 45591 | 45591 | 115721 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3530 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x5 | 5999222.11492 | 2120952.1000200002 | 37.8036839530115 | -122.44692285883 | (37.8036839530115, -122.44692285883) | |||
| 45647 | 45647 | 95675 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2207 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6x6 | 6001981.9652 | 2114296.4072 | 37.785566433956795 | -122.43689550902398 | (37.7855664339568, -122.436895509024) | |||
| 48064 | 48064 | 105092 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3150 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4X4 | 5999125.32302 | 2116324.31891 | 37.7909717732653 | -122.44692459810301 | (37.7909717732653, -122.446924598103) | |||
| 48911 | 48911 | 68331 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2338 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32146 | 5991366.81812 | 2112033.7901 | 37.778744872635606 | -122.473455364804 | (37.7787448726356, -122.473455364804) | ||
| 49151 | 49151 | 51005 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 674 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 14 | Permit Number 47484 | 5995056.39173 | 2110967.50064 | 37.776030092024 | -122.460614488586 | (37.776030092024, -122.460614488586) | ||
| 51035 | 51035 | 68988 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3336 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 15 | Permit Number 32980 | 6000849.989680001 | 2119837.16995 | 37.8007155175595 | -122.441209485631 | (37.8007155175595, -122.441209485631) | |
| 52209 | 52209 | 55630 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 836 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1985 12:00:00 AM | 17 | Permit Number 22564 | 6011707.80627 | 2118223.6548200003 | 37.7968976958139 | -122.40352314977699 | (37.7968976958139, -122.403523149777) | ||
| 52657 | 52657 | 56020 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2580 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1973 12:00:00 AM | 11 | Permit Number 12105 | 5996803.4076 | 2110776.9649 | 37.7756072847096 | -122.454557365701 | (37.7756072847096, -122.454557365701) | ||
| 54385 | 54385 | 57519 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1360 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 20 | Permit Number 16376 | 6008935.4598199995 | 2117576.8667900003 | 37.7949665312373 | -122.41307040029301 | (37.7949665312373, -122.413070400293) | ||
| 56042 | 56042 | 58355 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1340 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1978 12:00:00 AM | 8 | Permit Number 17382 | 6008945.8597800005 | 2117518.1337200003 | 37.7948058484612 | -122.41303025994301 | (37.7948058484612, -122.413030259943) | ||
| 62537 | 62537 | 62749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3757 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1988 12:00:00 AM | 12 | Permit Number 25749 | 5996846.35998 | 2115630.8360599997 | 37.7889371947488 | -122.454759549329 | (37.7889371947488, -122.454759549329) | ||
| 63499 | 63499 | 104422 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2362 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x3 | 5999509.01294 | 2120174.0716 | 37.8015640827681 | -122.445874046945 | (37.8015640827681, -122.445874046945) | |||
| 64542 | 64542 | 32423 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2641 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36950 | 6000352.62092 | 2118166.6035700003 | 37.796100241774894 | -122.44281055586599 | (37.7961002417749, -122.442810555866) | ||
| 65553 | 65553 | 62408 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 479 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1985 12:00:00 AM | 17 | 6x9 | Permit Number 22584 | 6011214.75353 | 2118984.34931 | 37.798958825936 | -122.405282833437 | (37.798958825936, -122.405282833437) | |
| 66181 | 66181 | 64574 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2872 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1988 12:00:00 AM | 25 | Permit Number 25468 | 5995849.04615 | 2111058.0388 | 37.776324256889296 | -122.45787905836 | (37.7763242568893, -122.45787905836) | ||
| 67457 | 67457 | 43163 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 222 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 42973 | 6005640.84958 | 2092540.2669400002 | 37.7260364164322 | -122.42269019099301 | (37.7260364164322, -122.422690190993) | |
| 67679 | 67679 | 65983 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2147 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1990 12:00:00 AM | 10 | 3x4 | Permit Number 29011 | 5999343.04127 | 2116289.27507 | 37.7908879879486 | -122.44616878266001 | (37.7908879879486, -122.44616878266) | |
| 67804 | 67804 | 51571 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 47868 | 5984728.581040001 | 2112539.46721 | 37.779746669398 | -122.4964565965 | (37.779746669398, -122.4964565965) | ||
| 71789 | 71789 | 50877 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2601on STEINER Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2004 12:00:00 AM | 14 | Permit Number 47387 | 6002325.5669599995 | 2115734.74753 | 37.789535271782 | -122.43580969708599 | (37.789535271782, -122.435809697086) | ||
| 72087 | 72087 | 42958 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2243 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | 13 | Permit Number 42847 | 6002313.59628 | 2115979.02805 | 37.7902053233739 | -122.435868599962 | (37.7902053233739, -122.435868599962) | ||
| 72223 | 72223 | 87002 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | 3x3 | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | ||
| 72364 | 72364 | 50989 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3880 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 47473 | 5996269.10887 | 2115596.09858 | 37.7888086870176 | -122.45675423481899 | (37.7888086870176, -122.456754234819) | |||
| 73211 | 73211 | 64087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 474 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1987 12:00:00 AM | 19 | Permit Number 24849 | 6010630.0202 | 2119988.0407 | 37.801682008022496 | -122.407377010865 | (37.8016820080225, -122.407377010865) | ||
| 73295 | 73295 | 52034 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2960 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Permit Number 48246 | 6002027.71863 | 2118348.63065 | 37.7966953942316 | -122.437027433096 | (37.7966953942316, -122.437027433096) | |||
| 74534 | 74534 | 30341 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/1956 12:00:00 AM | 10 | Permit Number 27 | 6001954.75028 | 2121707.36831 | 37.8059134550954 | -122.437520567314 | (37.8059134550954, -122.437520567314) | ||
| 77928 | 77928 | 40094 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2249 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/1999 12:00:00 AM | Permit Number 41318 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | |||
| 77970 | 77970 | 12741 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1638 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5990321.4540800005 | 2114762.4147099997 | 37.786176325151295 | -122.47727111168899 | (37.7861763251513, -122.477271111689) | |||
| 80803 | 80803 | 47791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 415 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45915 | 5995369.31891331 | 2098249.44976906 | 37.741127575703004 | -122.45861111062 | (37.741127575703, -122.45861111062) | ||
| 80818 | 80818 | 12743 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1641 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5990285.065780001 | 2114712.64103 | 37.7860375492525 | -122.477393365207 | (37.7860375492525, -122.477393365207) | |||
| 81857 | 81857 | 53099 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 370@HILL WAY Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | Permit Number 49061 | 5996124.75088045 | 2106531.46709728 | 37.763911303006296 | -122.45659790095199 | (37.7639113030063, -122.456597900952) | |||
| 81922 | 81922 | 3865 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 220 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X4 | 6016069.3729239 | 2096169.6764515 | 37.7365849077155 | -122.386892111244 | (37.7365849077155, -122.386892111244) | |||
| 82012 | 82012 | 38955 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1322 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40750 | 5999535.03970594 | 2108258.16543211 | 37.768847591977796 | -122.44492690983 | (37.7688475919778, -122.44492690983) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");