trees
1,069 rows where qSpecies_id = 93 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77377 | 62793 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1759 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23150 | 6000967.03927329 | 2093906.16285207 | 37.7295220513987 | -122.438945068917 | (37.7295220513987, -122.438945068917) | 9 | 7 | 6 | 28861 | 25 | ||
77400 | 247279 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 403 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998855.5655 | 2109315.1105 | 37.7717108924434 | -122.447353237783 | (37.7717108924434, -122.447353237783) | 15 | 5 | 11 | 29492 | 9 | |||
77584 | 240559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 981 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003807.83193 | 2102569.21574 | 37.7534700259438 | -122.42974180935 | (37.7534700259438, -122.42974180935) | 2 | 4 | 5 | 28862 | 22 | |||
78267 | 240528 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1206 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997448.87335 | 2105784.7399 | 37.7619369136818 | -122.451964305322 | (37.7619369136818, -122.451964305322) | 15 | 5 | 11 | 29492 | 9 | |||
78374 | 40569 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1750 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.7984424358323 | -122.41375022293 | (37.7984424358323, -122.41375022293) | 3 | 1 | 10 | 308 | 21 | |||
78808 | 48868 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 351 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | Permit Number 46076 | 5992826.30636272 | 2094323.11375055 | 37.7302003556086 | -122.467118458519 | (37.7302003556086, -122.467118458519) | 9 | 8 | 4 | 59 | 40 | |||
79502 | 179456 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 39 Melra Ct | 1 | : | Tree | Private 2 | 18 | Width 4ft | 6008986.48136 | 2086460.78308 | 37.7095316094729 | -122.410695358215 | (37.7095316094729, -122.410695358215) | 9 | 7 | 8 | 309 | 39 | |||
79942 | 35125 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 766 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 5 | Permit Number 38660 | 6001731.36417 | 2089519.53162 | 37.7175208097275 | -122.43598896344 | (37.7175208097275, -122.43598896344) | 9 | 7 | 6 | 28861 | 5 | |
79980 | 10424 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1417 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 5999343.5805 | 2108720.18711 | 37.7701052580123 | -122.445622380313 | (37.7701052580123, -122.445622380313) | 15 | 5 | 11 | 29492 | 9 | |||
80174 | 239691 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3591 21st St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 17 | Width 4ft | 6004486.51598 | 2103644.80101 | 37.756461738522 | -122.427471393514 | (37.756461738522, -122.427471393514) | 2 | 4 | 5 | 28862 | 22 | |||
80568 | 30967 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1904 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34758 | 6002512.7183 | 2114848.7346 | 37.7871131358628 | -122.435098778488 | (37.7871131358628, -122.435098778488) | 13 | 9 | 11 | 29490 | 27 | |
80921 | 34505 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1x GUY PL | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462 | 2114376 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | 6 | 2 | 9 | 28855 | 6 | |||
80954 | 26316 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2049 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999538.37389 | 2091931.2083 | 37.7240178943838 | -122.443742263404 | (37.7240178943838, -122.443742263404) | 9 | 7 | 6 | 28861 | 25 | |||
81254 | 214179 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 247 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5994052.93286 | 2098838.27918 | 37.742668608777 | -122.46320538032 | (37.742668608777, -122.46320538032) | 1 | 8 | 4 | 59 | 40 | |||
81264 | 123747 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 4ft | 5995457.51702 | 2110823.60741 | 37.7756580685065 | -122.459216477329 | (37.7756580685065, -122.459216477329) | 11 | 6 | 2 | 54 | 11 | |||
81367 | 62611 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2262 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/1986 12:00:00 AM | Permit Number 22921 | 5989510.16412079 | 2099957.30856958 | 37.7454784240667 | -122.478994620655 | (37.7454784240667, -122.478994620655) | 1 | 8 | 3 | 29491 | 35 | ||
81476 | 214997 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 324 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5995789.64183 | 2091235.70598 | 37.721893680423 | -122.456650690488 | (37.721893680423, -122.456650690488) | 9 | 8 | 4 | 28861 | 24 | |||
81823 | 62229 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 107 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 9 | Permit Number 22354 | 6001481.45016 | 2093645.47099 | 37.7288355059294 | -122.437148044757 | (37.7288355059294, -122.437148044757) | 9 | 7 | 6 | 28861 | 25 | |
81850 | 1676 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 251 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/1991 12:00:00 AM | 12 | 3X3 | 5994751.99718 | 2111422.13569 | 37.7772608818646 | -122.461700433178 | (37.7772608818646, -122.461700433178) | 11 | 6 | 2 | 54 | 11 | ||
82261 | 68986 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1990 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 18 | Permit Number 32976 | 5999758.99431 | 2121250.9256 | 37.8045351046614 | -122.44508646209 | (37.8045351046614, -122.44508646209) | 13 | 9 | 1 | 57 | 17 | |
82674 | 123736 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 398 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5994542.01129 | 2110789.2592 | 37.7755110818004 | -122.462380922286 | (37.7755110818004, -122.462380922286) | 11 | 6 | 2 | 54 | 11 | |||
82956 | 239718 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4818 25th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 10ft | 5999936.37047 | 2101089.09136 | 37.7491859767553 | -122.443023822014 | (37.7491859767553, -122.443023822014) | 2 | 4 | 5 | 28862 | 22 | |||
83824 | 240593 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 73 Digby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002622.32078 | 2097674.93204 | 37.7399642691366 | -122.433491822189 | (37.7399642691366, -122.433491822189) | 2 | 7 | 5 | 63 | 7 | |||
83828 | 43760 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 8 | Permit Number 43395 | 5990536.37641 | 2113724.23454 | 37.7833382397577 | -122.476451677446 | (37.7833382397577, -122.476451677446) | 11 | 6 | 2 | 55 | 26 | |
83999 | 240562 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3818 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004117.0123 | 2105424.98126 | 37.761328784908 | -122.428876176805 | (37.761328784908, -122.428876176805) | 8 | 4 | 5 | 28862 | 3 | |||
84021 | 49096 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 550 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2003 12:00:00 AM | 3 | Permit Number 46244 | 6013227.23366 | 2118310.02974 | 37.7972196135456 | -122.398271600054 | (37.7972196135456, -122.398271600054) | 3 | 1 | 10 | 28860 | 6 | ||
84700 | 197537 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 266 Bridgeview Dr | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6012934.68235 | 2095259.36475 | 37.7339113173389 | -122.397666323936 | (37.7339113173389, -122.397666323936) | 10 | 3 | 8 | 58 | 1 | |||
84963 | 141901 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004790.1275 | 2111962.5056 | 37.7793173224289 | -122.427013793928 | (37.7793173224289, -122.427013793928) | 7 | 9 | 11 | 29490 | 41 | |||
85000 | 68407 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32242 | 5993958.38777264 | 2093823.43780185 | 37.7288936500159 | -122.463168491943 | (37.7288936500159, -122.463168491943) | 9 | 8 | 4 | 59 | 40 | ||
85140 | 240531 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 519 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006332.59246 | 2096216.27511 | 37.7361689313428 | -122.420559700687 | (37.7361689313428, -122.420559700687) | 2 | 7 | 7 | 28859 | 2 | |||
85248 | 69541 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 643 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38636 | 6002429.0315791 | 2090033.16165602 | 37.7189707335787 | -122.43361413687 | (37.7189707335787, -122.43361413687) | 9 | 7 | 6 | 28861 | 5 | ||
85542 | 10223 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1377X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6005871.04446 | 2100967.56548 | 37.7491888788632 | -122.42249296967 | (37.7491888788632, -122.42249296967) | 2 | 4 | 5 | 28859 | 19 | |||
85546 | 32233 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1588 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 16 | Permit Number 35549 | 6008740.58515 | 2099494.10229 | 37.7453045396752 | -122.412465880499 | (37.7453045396752, -122.412465880499) | 2 | 7 | 7 | 28859 | 2 | |
86102 | 219588 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98x Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005256 | 2109297 | 37.7720248250001 | -122.42521242385 | (37.7720248250001, -122.42521242385) | 7 | 9 | 11 | 28852 | 10 | ||||
88114 | 179444 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 50 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6006641.4754 | 2087068.60877 | 37.7110688134384 | -122.418843195273 | (37.7110688134384, -122.418843195273) | 9 | 7 | 8 | 309 | 39 | |||
88229 | 246195 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 44 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999308.8379 | 2108061.5309 | 37.7682947708765 | -122.445695180439 | (37.7682947708765, -122.445695180439) | 15 | 5 | 11 | 29492 | 9 | |||
88591 | 239685 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1601x Alabama St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6009289.0171 | 2100045.3572 | 37.7468489265392 | -122.410608407252 | (37.7468489265392, -122.410608407252) | 2 | 7 | 7 | 28859 | 2 | |||
88665 | 5559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 984 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005041.33516 | 2102650.51852 | 37.7537630358578 | -122.425481873703 | (37.7537630358578, -122.425481873703) | 2 | 4 | 5 | 28862 | 22 | |||
88925 | 52283 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 176 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48441 | 6006024.37896521 | 2099203.00634212 | 37.7443524500258 | -122.421837411698 | (37.7443524500258, -122.421837411698) | 2 | 7 | 5 | 28859 | 2 | ||
89421 | 50433 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 403 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2004 12:00:00 AM | Permit Number 47583 | 5998845.21508396 | 2109355.09330434 | 37.7718200835759 | -122.447391918702 | (37.7718200835759, -122.447391918702) | 15 | 5 | 11 | 29492 | 9 | |||
89839 | 40607 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2756 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/1999 12:00:00 AM | 9 | Permit Number 41618 | 5996431.87496 | 2111290.71055 | 37.7769965796048 | -122.45587972743 | (37.7769965796048, -122.45587972743) | 11 | 6 | 2 | 54 | 16 | ||
90324 | 239708 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 34 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5998365.05928 | 2106580.5131 | 37.7641743414968 | -122.448852913637 | (37.7641743414968, -122.448852913637) | 15 | 5 | 11 | 29492 | 9 | |||
90936 | 68409 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 175 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32245 | 5993925.68682399 | 2093845.21689491 | 37.7289515662137 | -122.463283120302 | (37.7289515662137, -122.463283120302) | 9 | 8 | 4 | 59 | 40 | ||
91371 | 54495 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 582 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/1972 12:00:00 AM | 9 | Permit Number 10288 | 5983824.99898 | 2111865.78484 | 37.7778439571052 | -122.499532631055 | (37.7778439571052, -122.499532631055) | 11 | 6 | 2 | 55 | 26 | ||
91572 | 10522 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1855 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2017 12:00:00 AM | 14 | 3X3 | 5997273.9779 | 2108433.2536 | 37.7691990373323 | -122.452760361188 | (37.7691990373323, -122.452760361188) | 15 | 5 | 11 | 29492 | 9 | ||
91787 | 239683 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3681 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 7ft | 6005263.58065 | 2101933.28194 | 37.7518062252985 | -122.424662279246 | (37.7518062252985, -122.424662279246) | 2 | 4 | 5 | 28859 | 19 | |||
91855 | 197531 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2006 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6012046.11634 | 2103763.76948 | 37.7572130681337 | -122.401335827695 | (37.7572130681337, -122.401335827695) | 10 | 3 | 8 | 28856 | 29 | |||
92069 | 239729 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 601 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002586.38248 | 2099734.9254 | 37.745618492099 | -122.433763278079 | (37.745618492099, -122.433763278079) | 2 | 7 | 5 | 63 | 22 | |||
92494 | 215014 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 158 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994270.18976 | 2095584.01107 | 37.7337457098893 | -122.462218211614 | (37.7337457098893, -122.462218211614) | 9 | 8 | 4 | 59 | 40 | |||
92768 | 138487 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1850 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002041.5919 | 2114791.6986 | 37.786929766345 | -122.436724685254 | (37.786929766345, -122.436724685254) | 13 | 6 | 11 | 29490 | 27 | |||
93783 | 179490 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 117 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6002435.0144 | 2087009.10974 | 37.7106676924198 | -122.433377477905 | (37.7106676924198, -122.433377477905) | 9 | 7 | 6 | 28861 | 5 | |||
93911 | 123698 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 198 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995066.49877 | 2111490.37862 | 37.7774663576481 | -122.460617425181 | (37.7774663576481, -122.460617425181) | 11 | 6 | 2 | 54 | 11 | |||
93955 | 214188 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 358 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1972 12:00:00 AM | 21 | Width 3ft | Permit Number 9461 | 5992780.99407 | 2094319.49866 | 37.7301878137975 | -122.467274844971 | (37.7301878137975, -122.467274844971) | 9 | 8 | 4 | 59 | 40 | |
94247 | 179474 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 279 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009762.57781 | 2088424.36617 | 37.7149666919301 | -122.408151417155 | (37.7149666919301, -122.408151417155) | 9 | 7 | 8 | 309 | 39 | |||
94455 | 46476 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 454 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2002 12:00:00 AM | 6 | Permit Number 44671 | 5991902.97979 | 2112323.35635 | 37.7795709761183 | -122.471621696685 | (37.7795709761183, -122.471621696685) | 11 | 6 | 2 | 54 | 11 | ||
94609 | 240585 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 334 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999374.09078 | 2105029.48188 | 37.7599732475924 | -122.445251453514 | (37.7599732475924, -122.445251453514) | 15 | 5 | 5 | 28862 | 3 | |||
94617 | 38649 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
94623 | 239735 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1449 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003316.0935 | 2099809.08635 | 37.7458635007156 | -122.431245341826 | (37.7458635007156, -122.431245341826) | 2 | 7 | 5 | 63 | 22 | |||
94787 | 240583 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 60 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000828.16342 | 2106033.71202 | 37.7628135098535 | -122.440294550454 | (37.7628135098535, -122.440294550454) | 15 | 5 | 5 | 28862 | 3 | |||
95412 | 239742 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 832 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6000856.10408 | 2102607.88191 | 37.75340860674 | -122.439952263112 | (37.75340860674, -122.439952263112) | 2 | 4 | 5 | 28862 | 22 | |||
95430 | 215007 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 226 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5994166.81469 | 2098811.63729 | 37.7426020166841 | -122.462809680445 | (37.7426020166841, -122.462809680445) | 1 | 8 | 4 | 59 | 40 | |||
96467 | 117877 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 734 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5983242.29307 | 2110782.48705 | 37.7748353295228 | -122.501468223794 | (37.7748353295228, -122.501468223794) | 11 | 6 | 2 | 55 | 26 | |||
97410 | 179475 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 245 Wilson St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5994292.07601 | 2086663.34927 | 37.7092529779255 | -122.461496035314 | (37.7092529779255, -122.461496035314) | 9 | 8 | 6 | 28861 | 25 | ||||
97849 | 62802 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1975 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23159 | 5999892.27432069 | 2092450.57844744 | 37.7254641444646 | -122.442556160778 | (37.7254641444646, -122.442556160778) | 9 | 7 | 6 | 28861 | 25 | ||
97960 | 14745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 910 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | 7 | 9 | 11 | 29490 | 41 | |||
98297 | 30941 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1101 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 10 | Permit Number 34750 | 5995913.71268 | 2091275.1809 | 37.7220091920614 | -122.456224664532 | (37.7220091920614, -122.456224664532) | 9 | 8 | 4 | 28861 | 24 | |
98773 | 35173 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4545 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1998 12:00:00 AM | 12 | Permit Number 38711 | 5984612.32858 | 2111732.91994 | 37.7775253123971 | -122.496799216616 | (37.7775253123971, -122.496799216616) | 11 | 6 | 2 | 55 | 26 | |
99948 | 47471 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2950 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 4 | Permit Number 45372 | 5999383.7039 | 2114336.8457 | 37.7855294507074 | -122.445887611108 | (37.7855294507074, -122.445887611108) | 15 | 6 | 1 | 29490 | 31 | |
100452 | 240545 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4390 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001366.11149 | 2101175.74148 | 37.749505311641 | -122.438085972914 | (37.749505311641, -122.438085972914) | 2 | 4 | 5 | 28862 | 22 | |||
100719 | 184134 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3240 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5984156.0453 | 2104307.189 | 37.757109619352 | -122.497829171247 | (37.757109619352, -122.497829171247) | 1 | 8 | 3 | 56 | 35 | |||
100799 | 14523 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 625 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 4x4 | 5999129.3058 | 2110654.1301 | 37.7754031370148 | -122.446502707181 | (37.7754031370148, -122.446502707181) | 15 | 5 | 11 | 29492 | 16 | |||
100878 | 62344 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 16 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22486 | 6005809.69914418 | 2099671.2694643 | 37.7456260851044 | -122.422612999068 | (37.7456260851044, -122.422612999068) | 2 | 7 | 5 | 28859 | 22 | ||
101282 | 215002 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995954.15999 | 2091115.97449 | 37.7215743707347 | -122.456073344621 | (37.7215743707347, -122.456073344621) | 9 | 8 | 6 | 28861 | 24 | |||
101349 | 103464 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 543 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6x9 | 6003223.19269 | 2090290.89193 | 37.7197234328838 | -122.430887417037 | (37.7197234328838, -122.430887417037) | 9 | 7 | 6 | 28861 | 5 | |||
102044 | 179480 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5989599 | 2090767 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | 1 | 8 | 4 | 64 | 14 | ||||
102509 | 197554 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200 Kansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 4ft | 6011382.26351 | 2107407.34025 | 37.7671804369461 | -122.403888089262 | (37.7671804369461, -122.403888089262) | 8 | 2 | 8 | 28853 | 20 | |||
102585 | 214200 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 145 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994280.88933 | 2095617.06263 | 37.7338370774039 | -122.462183616499 | (37.7338370774039, -122.462183616499) | 9 | 8 | 4 | 59 | 40 | |||
102826 | 239681 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3616 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6005642.96525 | 2101995.98753 | 37.7519998196473 | -122.423354771113 | (37.7519998196473, -122.423354771113) | 2 | 4 | 5 | 28859 | 19 | |||
102954 | 2747 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 26 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5995511.83348 | 2110826.68765 | 37.7756696485776 | -122.459028807619 | (37.7756696485776, -122.459028807619) | 11 | 6 | 2 | 54 | 11 | |||
104142 | 5261 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1234 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001382.11052 | 2112701.66304 | 37.7811535623212 | -122.438856504476 | (37.7811535623212, -122.438856504476) | 15 | 5 | 11 | 29490 | 41 | |||
105212 | 32424 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 275 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 36952 | 5994490.2461397 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | 9 | 8 | 4 | 59 | 40 | ||||
105423 | 138335 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1799 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002013.7611 | 2114612.8977 | 37.7864372431223 | -122.436808168929 | (37.7864372431223, -122.436808168929) | 13 | 6 | 1 | 29490 | 27 | |||
105968 | 46548 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3042 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2005 12:00:00 AM | 7 | Permit Number 47880 | 5999598.88033 | 2116387.07823 | 37.7911711367754 | -122.445290628875 | (37.7911711367754, -122.445290628875) | 13 | 6 | 1 | 29490 | 27 | ||
106436 | 26279 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1866 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000327.26475 | 2093225.38093 | 37.7276163597935 | -122.441108004333 | (37.7276163597935, -122.441108004333) | 9 | 7 | 6 | 28861 | 25 | |||
106600 | 5405 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 381 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2016 12:00:00 AM | 3X3 | 6004938.1878622 | 2106152.8168866 | 37.7633736936511 | -122.426087889681 | (37.7633736936511, -122.426087889681) | 8 | 4 | 5 | 28859 | 19 | |||
106799 | 62237 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 61 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | Permit Number 22363 | 6001374.44401127 | 2093790.00837779 | 37.7292262892939 | -122.437528318003 | (37.7292262892939, -122.437528318003) | 9 | 7 | 6 | 28861 | 25 | ||
107694 | 239690 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1521 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003983.46456 | 2099388.15936 | 37.7447455300908 | -122.428907662057 | (37.7447455300908, -122.428907662057) | 2 | 7 | 5 | 63 | 22 | |||
108020 | 47787 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 445 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2002 12:00:00 AM | 7 | Permit Number 45558 | 6009109.534 | 2121122.2501 | 37.8047110457521 | -122.412718839471 | (37.8047110457521, -122.412718839471) | 3 | 1 | 10 | 308 | 23 | ||
108178 | 12645 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 944 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5992509.49668 | 2114843.34604 | 37.7865252483142 | -122.469707022996 | (37.7865252483142, -122.469707022996) | 11 | 6 | 1 | 54 | 11 | |||
108226 | 239714 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 872 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000978.62192 | 2099691.67862 | 37.745408384388 | -122.43931955855 | (37.745408384388, -122.43931955855) | 2 | 4 | 5 | 63 | 22 | |||
108442 | 67011 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 319 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30366 | 5995876.19861024 | 2091190.26348134 | 37.7217738754672 | -122.456348203392 | (37.7217738754672, -122.456348203392) | 9 | 8 | 6 | 28861 | 24 | ||
108695 | 67438 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2910 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/1992 12:00:00 AM | 8 | 4x4 | Permit Number 30940 | 5989610.64145 | 2111971.49615 | 37.7784719767097 | -122.479526038454 | (37.7784719767097, -122.479526038454) | 11 | 6 | 2 | 55 | 26 |
109902 | 62343 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 14 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22485 | 6005822.8575705 | 2099672.01958419 | 37.7456288871148 | -122.422567552448 | (37.7456288871148, -122.422567552448) | 2 | 7 | 5 | 28859 | 22 | ||
109955 | 95070 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2165 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989059 | 2106465 | 37.7633205959205 | -122.481031062121 | (37.7633205959205, -122.481031062121) | 1 | 8 | 3 | 56 | 35 | ||||
110275 | 51012 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 85 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2016 12:00:00 AM | 3 | Permit Number 778086 | 6001486.35916374 | 2107715.14620283 | 37.7674677672856 | -122.438138542404 | (37.7674677672856, -122.438138542404) | 15 | 5 | 5 | 29492 | 3 | ||
110587 | 62804 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1999 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23161 | 5999778.16418017 | 2092287.72080324 | 37.7250104697039 | -122.442938938279 | (37.7250104697039, -122.442938938279) | 9 | 7 | 6 | 28861 | 25 | ||
111364 | 62348 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 57 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22491 | 6005543.85080152 | 2099604.02987317 | 37.745426458533 | -122.423527484038 | (37.745426458533, -122.423527484038) | 2 | 7 | 5 | 28859 | 22 | ||
111820 | 10490 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1687 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 5997959.93364 | 2108479.83355 | 37.7693662163265 | -122.450391046811 | (37.7693662163265, -122.450391046811) | 15 | 5 | 11 | 29492 | 9 | |||
112112 | 66607 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | 1 | 8 | 4 | 64 | 14 | ||
112860 | 240566 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 111 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6000512.65205 | 2104881.02417 | 37.759630543828 | -122.441303078972 | (37.759630543828, -122.441303078972) | 2 | 4 | 5 | 28862 | 3 |
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) );