Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83341 | 83341 | 99397 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 162913 | 162913 | 207589 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 451 Hearst Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998517.2369 | 2094367.8013 | 37.730649912447795 | -122.44744746032801 | (37.7306499124478, -122.447447460328) | |||
| 111018 | 111018 | 99396 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 137271 | 137271 | 191088 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 01st St | 19 | : Yard 23 | Tree 1 | Private 1 | 18 | 6014455.34951 | 2105889.6924799997 | 37.7631845152826 | -122.393152451232 | (37.7631845152826, -122.393152451232) | ||||
| 148327 | 148327 | 191668 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013300.95519 | 2111099.53181 | 37.7774253698298 | -122.397510546978 | (37.7774253698298, -122.397510546978) | |||
| 25410 | 25410 | 46998 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 83456 | 83456 | 99392 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 150748 | 150748 | 191667 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013269.51559 | 2111071.49251 | 37.7773466296777 | -122.39761734056101 | (37.7773466296777, -122.397617340561) | |||
| 169333 | 169333 | 223642 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006690.611819999 | 2102567.7442400004 | 37.753628804832 | -122.419772415291 | (37.753628804832, -122.419772415291) | |||
| 4465 | 4465 | 253081 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2849X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:35:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 19100 | 19100 | 99391 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 47846 | 47846 | 207531 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1325 18th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5990492.61494 | 2106135.1233599996 | 37.76249807624271 | -122.476048615548 | (37.7624980762427, -122.476048615548) | |||
| 68650 | 68650 | 94761 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010473.71758 | 2097978.74448 | 37.741240805519396 | -122.406366213439 | (37.7412408055194, -122.406366213439) | ||
| 87209 | 87209 | 35084 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 102725 | 102725 | 46997 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 123165 | 123165 | 99040 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
| 172025 | 172025 | 191679 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 604 Keith St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6017194.35691 | 2096452.8116900001 | 37.7374245657007 | -122.383022220618 | (37.7374245657007, -122.383022220618) | |||
| 175177 | 175177 | 223641 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006696.02527 | 2102542.97279 | 37.753561093073 | -122.419751936808 | (37.753561093073, -122.419751936808) | |||
| 4458 | 4458 | 253080 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2849X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 11:00:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 32578 | 32578 | 189248 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1575 Bay Shore Blvd | 13 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011796.69629 | 2092248.5093 | 37.7255806984826 | -122.401389189886 | (37.7255806984826, -122.401389189886) | |||
| 74306 | 74306 | 94760 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010454.10107 | 2097938.95969 | 37.7411304676923 | -122.406431238013 | (37.7411304676923, -122.406431238013) | ||
| 80275 | 80275 | 26143 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 86122 | 86122 | 46996 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 93814 | 93814 | 35075 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 109823 | 109823 | 99390 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 117970 | 117970 | 96201 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2000X Bay Shore Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.715357222040005 | -122.399324379639 | (37.71535722204, -122.399324379639) | ||
| 150389 | 150389 | 223640 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006698.01233 | 2102508.6219599997 | 37.7534668855122 | -122.41974262792601 | (37.7534668855122, -122.419742627926) | |||
| 157036 | 157036 | 141631 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1801 GROVE ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999039.9097 | 2110417.3474 | 37.774747885862205 | -122.446794906704 | (37.7747478858622, -122.446794906704) | |||
| 183787 | 183787 | 191666 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013244.57038 | 2111045.61556 | 37.777274188396795 | -122.397701819284 | (37.7772741883968, -122.397701819284) | |||
| 3991 | 3991 | 44420 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 859 Prague St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 08:03:00 AM | 3 | Permit Number 43768 | 6002331.23577 | 2087017.31055 | 37.710684321803896 | -122.433736745364 | (37.7106843218039, -122.433736745364) | |
| 5159 | 5159 | 242086 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4185 25th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002948.22198 | 2101215.85126 | 37.7497052929799 | -122.432617857444 | (37.7497052929799, -122.432617857444) | |||
| 68437 | 68437 | 94759 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010436.494630001 | 2097901.6693599997 | 37.7410270915281 | -122.406489488003 | (37.7410270915281, -122.406489488003) | ||
| 86662 | 86662 | 35073 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 89501 | 89501 | 26142 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/21/2006 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 113976 | 113976 | 46995 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 117269 | 117269 | 99038 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
| 127191 | 127191 | 99389 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 146739 | 146739 | 200658 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1522 Oakdale Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015268.8104 | 2095344.6145 | 37.7342750961819 | -122.38960241665801 | (37.7342750961819, -122.389602416658) | |||
| 164595 | 164595 | 223639 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006697.50598 | 2102457.70308 | 37.7533270454234 | -122.41974076632401 | (37.7533270454234, -122.419740766324) | |||
| 1861 | 1861 | 251780 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1219 Naples St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001110.0 | 2087312.0 | 37.7114241006266 | -122.437978695611 | (37.7114241006266, -122.437978695611) | ||||
| 27273 | 27273 | 138750 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 POST ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001227.9034 | 2113893.9374 | 37.7844184685956 | -122.439475475851 | (37.7844184685956, -122.439475475851) | |||
| 29873 | 29873 | 223638 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006702.0078300005 | 2102414.72297 | 37.753209285497704 | -122.41972214857799 | (37.7532092854977, -122.419722148578) | |||
| 33540 | 33540 | 200657 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1520 Oakdale Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015286.397999999 | 2095330.3246 | 37.734236834204395 | -122.389540612503 | (37.7342368342044, -122.389540612503) | |||
| 35080 | 35080 | 191665 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6013224.690669999 | 2111029.2007400002 | 37.7772280099979 | -122.39776943840799 | (37.7772280099979, -122.397769438408) | |||
| 52017 | 52017 | 141629 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1801 GROVE ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999005.9913 | 2110412.5019 | 37.7747326436678 | -122.446911888169 | (37.7747326436678, -122.446911888169) | |||
| 75029 | 75029 | 181341 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2500 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985179.8406 | 2097655.4564 | 37.738905739718795 | -122.49379838145501 | (37.7389057397188, -122.493798381455) | |||
| 81609 | 81609 | 99037 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
| 86456 | 86456 | 46994 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 94687 | 94687 | 35076 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 96370 | 96370 | 113818 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4101x 25TH ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 02/16/2016 05:57:00 AM | 3 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |
| 102647 | 102647 | 26141 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/21/2006 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 107105 | 107105 | 99388 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 147140 | 147140 | 94758 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010421.02997 | 2097863.75043 | 37.740922109156706 | -122.40654028802601 | (37.7409221091567, -122.406540288026) | ||
| 14946 | 14946 | 26611 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1485 Bay Shore Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1998 12:00:00 AM | 12 | 3X3 | 6011726.3053 | 2092603.41849 | 37.7265512783073 | -122.401657461237 | (37.7265512783073, -122.401657461237) | ||
| 41581 | 41581 | 200656 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1518 Oakdale Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015329.8173 | 2095300.0959 | 37.734156239682 | -122.389388386574 | (37.734156239682, -122.389388386574) | |||
| 57552 | 57552 | 94757 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010407.95479 | 2097827.7335900003 | 37.7408224831747 | -122.406582959945 | (37.7408224831747, -122.406582959945) | ||
| 94059 | 94059 | 113817 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4101x 25TH ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 02/16/2016 06:00:00 AM | 3 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |
| 100669 | 100669 | 99036 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
| 109812 | 109812 | 117145 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 121549 | 121549 | 103923 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 128161 | 128161 | 35077 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 128673 | 128673 | 46993 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 132325 | 132325 | 223637 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006705.76334 | 2102387.84087 | 37.7531356849695 | -122.419707254007 | (37.7531356849695, -122.419707254007) | |||
| 174184 | 174184 | 207646 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 Funston Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992160.47929 | 2104938.30605 | 37.7593085011052 | -122.47019298042 | (37.7593085011052, -122.47019298042) | |||
| 2540 | 2540 | 141909 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 900 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004576.1236 | 2111931.0419 | 37.779218827498205 | -122.427751880486 | (37.7792188274982, -122.427751880486) | |||
| 38275 | 38275 | 191664 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6013199.96962 | 2111004.76664 | 37.777159542827704 | -122.397853242637 | (37.7771595428277, -122.397853242637) | |||
| 53616 | 53616 | 35078 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 79816 | 79816 | 99035 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
| 88887 | 88887 | 52809 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 25@ TEXAS Sierra St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | |||
| 91474 | 91474 | 46992 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 109483 | 109483 | 1769 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2000X Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 118904 | 118904 | 26139 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11/05/2005 12:00:00 AM | 4 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 133813 | 133813 | 223636 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006708.59634 | 2102368.48305 | 37.7530826924205 | -122.419696083521 | (37.7530826924205, -122.419696083521) | |||
| 139017 | 139017 | 117144 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 147410 | 147410 | 94756 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010397.45691 | 2097793.22458 | 37.7407271415462 | -122.406616826609 | (37.7407271415462, -122.406616826609) | ||
| 147839 | 147839 | 200655 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1516 Oakdale Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015384.228999999 | 2095258.3254 | 37.7340445629032 | -122.389197350847 | (37.7340445629032, -122.389197350847) | |||
| 166638 | 166638 | 114655 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001302.3779 | 2113905.5111 | 37.7844544851842 | -122.43921865019199 | (37.7844544851842, -122.439218650192) | |||
| 168758 | 168758 | 207645 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 Funston Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992161.381519999 | 2104923.06164 | 37.759266696124 | -122.470188750009 | (37.759266696124, -122.470188750009) | |||
| 176015 | 176015 | 223496 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007971.83825 | 2103118.56148 | 37.755213316757704 | -122.415380629129 | (37.7552133167577, -122.415380629129) | |||
| 176926 | 176926 | 223431 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 357 Precita Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009008.57649 | 2100230.6631 | 37.747342008624 | -122.41159123855199 | (37.747342008624, -122.411591238552) | |||
| 3953 | 3953 | 44431 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 859 Prague St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2017 11:19:00 AM | 3 | Permit Number 43768 | 6002228.37284 | 2086951.06128 | 37.71049657842789 | -122.434087529513 | (37.7104965784279, -122.434087529513) | |
| 10216 | 10216 | 173911 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 36133 | 36133 | 223495 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007975.84228 | 2103064.94118 | 37.75506631266121 | -122.41536298621901 | (37.7550663126612, -122.415362986219) | |||
| 61972 | 61972 | 223430 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 357 Precita Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008988.98291 | 2100229.74181 | 37.7473383798694 | -122.411658926928 | (37.7473383798694, -122.411658926928) | |||
| 79218 | 79218 | 99026 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351X 23rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | Permit Number 41415 | 6006571.0 | 2102346.4 | 37.753014305467794 | -122.420170352411 | (37.7530143054678, -122.420170352411) | |
| 84121 | 84121 | 117143 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 88901 | 88901 | 52808 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 25@ TEXAS Sierra St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | |||
| 98549 | 98549 | 99034 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
| 99849 | 99849 | 46991 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 102788 | 102788 | 6738 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2016 12:00:00 AM | 1 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 106339 | 106339 | 102645 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1800 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/2015 12:33:00 PM | 3 | 3x3 | 6013980.4 | 2096382.2 | 37.7370525675082 | -122.394129514082 | (37.7370525675082, -122.394129514082) | ||
| 117343 | 117343 | 98974 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
| 118877 | 118877 | 35079 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 129837 | 129837 | 94755 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010386.24454 | 2097752.48777 | 37.740614659735705 | -122.40665272486 | (37.7406146597357, -122.40665272486) | ||
| 138101 | 138101 | 223649 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1812 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008605.946830001 | 2107884.1672900002 | 37.768334196103794 | -122.413524717993 | (37.7683341961038, -122.413524717993) | |||
| 138966 | 138966 | 103921 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 149946 | 149946 | 207644 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 Funston Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992160.10563 | 2104906.0361 | 37.7592198747043 | -122.470191922822 | (37.7592198747043, -122.470191922822) | |||
| 156025 | 156025 | 223510 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 23rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006653.24947 | 2102596.28503 | 37.7537050664578 | -122.419903647955 | (37.7537050664578, -122.419903647955) | |||
| 158063 | 158063 | 224110 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006506.1757 | 2109285.6019900003 | 37.7720640758221 | -122.42088715194599 | (37.7720640758221, -122.420887151946) | |||
| 182754 | 182754 | 223635 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006712.94406 | 2102318.00043 | 37.752944323627204 | -122.41967746664 | (37.7529443236272, -122.41967746664) |
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");