trees
2,306 rows where qSpecies_id = 15 sorted by Zip Codes descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 228 | 256437 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 3001 Sunset Blvd | 25 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 230 | 114428 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 34x HIGUERA AVE | 2 | Median : Yard | Tree | Private 2 | 56 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
| 256 | 254254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 430 | 121151 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Payson St | 1 | Side Yard : Yard | Tree | DPW 1 | 25 | 3x3 | 5992041 | 2087761 | 37.7121370380572 | -122.469355880776 | (37.7121370380572, -122.469355880776) | 9 | 8 | 4 | 64 | 24 | |||
| 451 | 114938 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 14 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
| 515 | 262251 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
| 724 | 178311 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | 10x10 | 5989003 | 2090507 | 37.7195008394357 | -122.480056810171 | (37.7195008394357, -122.480056810171) | 1 | 8 | 4 | 64 | 14 | |||
| 748 | 259270 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 932 | 111099 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 480X LAKESHORE DR | 20 | Median : Cutout | Tree | DPW 1 | 30x200 | 5984942 | 2095282 | 37.7323749444343 | -122.494445798495 | (37.7323749444343, -122.494445798495) | 1 | 8 | 4 | 64 | 35 | ||||
| 1038 | 259268 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 1378 | 95407 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2X Cranleigh Dr | 9 | Median : Yard | Tree | DPW 1 | 80 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | ||||
| 2067 | 211204 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 150 | : | Tree | Private 2 | 8 | Width 0ft | 5991184.95958 | 2091479.43645 | 37.7222974463483 | -122.472585508941 | (37.7222974463483, -122.472585508941) | 9 | 8 | 4 | 64 | 40 | |||
| 2174 | 173658 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
| 2512 | 99518 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | |||
| 3872 | 262252 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
| 4737 | 261021 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
| 4918 | 104883 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990322.1 | 2090011.1 | 37.7182157760013 | -122.475461023549 | (37.7182157760013, -122.475461023549) | 1 | 8 | 4 | 64 | 14 | |||||
| 6044 | 259265 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 8370 | 264916 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 744 Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5991301 | 2092678 | 37.7255951208098 | -122.472271716 | (37.7255951208098, -122.472271716) | 9 | 8 | 4 | 64 | 40 | ||||
| 8847 | 110165 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 129x GARCES DR | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||||
| 8965 | 261020 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
| 9033 | 254440 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 501X Brotherhood Way | 20 | Median : Yard | Tree | DPW 1 | 10x10 | 5992686 | 2087818 | 37.7123307991194 | -122.467130733446 | (37.7123307991194, -122.467130733446) | 9 | 8 | 4 | 64 | 24 | ||||
| 9803 | 262258 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 Everglade Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 10159 | 262253 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
| 10560 | 178279 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Brotherhood Way | 6 | Front Yard : Yard | Tree | DPW 1 | 4 | Width 0ft | 5987917.15522 | 2088760.91322 | 37.7146433748779 | -122.483682180705 | (37.7146433748779, -122.483682180705) | 1 | 8 | 4 | 64 | 14 | |||
| 10808 | 262250 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
| 11182 | 261019 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3450X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784867 | 5990575 | 2092822 | 37.725948465298 | -122.47479191789 | (37.725948465298, -122.47479191789) | 9 | 8 | 4 | 64 | 14 | |||
| 11878 | 104919 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 732 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990421 | 2090607 | 37.719857702396 | -122.475162650507 | (37.719857702396, -122.475162650507) | 1 | 8 | 4 | 64 | 40 | |||||
| 12739 | 30076 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 11 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
| 13538 | 178318 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 5988183.85887 | 2090397.25913 | 37.7191518903345 | -122.482880208457 | (37.7191518903345, -122.482880208457) | 1 | 8 | 4 | 64 | 14 | ||||
| 15991 | 262259 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 Everglade Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 17333 | 259266 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 18587 | 178281 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Brotherhood Way | 8 | : | Tree | Private 2 | 23 | Width 0ft | 5988022.78245 | 2088756.97622 | 37.7146387127707 | -122.483316805926 | (37.7146387127707, -122.483316805926) | 1 | 8 | 4 | 64 | 14 | |||
| 18723 | 95885 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Ocean Sloat Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 18957 | 259263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 19601 | 95883 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Everglade Sloat Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
| 19616 | 262407 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 300 Font Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x5 | 5990018 | 2089729 | 37.7174235665943 | -122.476491559856 | (37.7174235665943, -122.476491559856) | 1 | 8 | 4 | 64 | 14 | ||||
| 19844 | 254259 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
| 21587 | 30086 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 22 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
| 21774 | 2295 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Brotherhood Way | 10 | Median : Cutout | Tree | DPW 1 | 45 | 14M | 5990276.2096462 | 2088591.5343604 | 37.7143153385926 | -122.475516051132 | (37.7143153385926, -122.475516051132) | 1 | 8 | 4 | 64 | 14 | |||
| 22568 | 211184 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300 Junipero Serra Blvd | 39 | : | Tree | Private 2 | 34 | Width 0ft | 5991386.34298 | 2094392.08332 | 37.7303065045205 | -122.472101578341 | (37.7303065045205, -122.472101578341) | 9 | 8 | 4 | 64 | 40 | |||
| 22607 | 254291 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 110 Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 3x3 | 5991396 | 2095383 | 37.7330278715114 | -122.472140394325 | (37.7330278715114, -122.472140394325) | 1 | 8 | 4 | 64 | 40 | ||||
| 23427 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 4 | Back Yard : Yard | Tree | Private 2 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||||
| 24612 | 99521 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | |||
| 26007 | 178282 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Brotherhood Way | 11 | : | Tree | Private 2 | 2 | Width 0ft | 5988239.02421 | 2088743.05539 | 37.7146130722195 | -122.482568375746 | (37.7146130722195, -122.482568375746) | 1 | 8 | 4 | 64 | 14 | |||
| 26583 | 108044 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2901X SUNSET BLVD OFF RAMP | 2 | Median : Yard | Tree | DPW 1 | 99 | 5985539 | 2095817 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | 1 | 8 | 4 | 64 | 35 | ||||
| 26584 | 104941 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 133X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
| 26929 | 178314 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | 5989006.41886 | 2090486.32798 | 37.7194442778983 | -122.480043480515 | (37.7194442778983, -122.480043480515) | 1 | 8 | 4 | 64 | 14 | ||||
| 27183 | 178301 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 654 Brotherhood Way | 24 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5989693.78349 | 2088724.55965 | 37.7146468129717 | -122.477538839844 | (37.7146468129717, -122.477538839844) | 1 | 8 | 4 | 64 | 14 | |||
| 27687 | 211197 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 76 | : | Tree | Private 2 | 5 | Width 0ft | 5991242.1316 | 2092244.3777 | 37.7244010946151 | -122.472443619271 | (37.7244010946151, -122.472443619271) | 9 | 8 | 4 | 64 | 40 | |||
| 28156 | 114119 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 28176 | 114157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200x JUNIPERO SERRA BLVD | 18 | Front Yard : Yard | Tree | Private 2 | 32 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 28551 | 178275 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1100 Junipero Serra Blvd | 5 | : | Tree | Private 2 | 22 | Width 0ft | 5991262.89229 | 2089084.03836 | 37.7157247826357 | -122.472141599051 | (37.7157247826357, -122.472141599051) | 1 | 8 | 4 | 64 | 24 | |||
| 28773 | 114213 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 230 SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 60 | 5988981 | 2090766 | 37.7202107101289 | -122.480151800691 | (37.7202107101289, -122.480151800691) | 1 | 8 | 4 | 64 | 14 | ||||
| 28927 | 105423 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/28/2014 12:00:00 AM | 28 | 3x20 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||
| 28994 | 178321 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5989145.21541 | 2089457.74529 | 37.716628110272 | -122.479488503489 | (37.716628110272, -122.479488503489) | 1 | 8 | 4 | 64 | 14 | ||||
| 29182 | 30079 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 14 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
| 29719 | 111573 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1x SUNSET BLVD OFF RAMP | 5 | Median : Cutout | Tree | DPW 1 | 3x3 | 5984955 | 2095624 | 37.7333147463652 | -122.494426056577 | (37.7333147463652, -122.494426056577) | 1 | 8 | 4 | 64 | 35 | ||||
| 29960 | 211180 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 582 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 10ft | 5993025.94839 | 2091087.79272 | 37.7213284790141 | -122.466193251017 | (37.7213284790141, -122.466193251017) | 9 | 8 | 6 | 64 | 24 | |||
| 30187 | 178322 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 5989407.26888 | 2089196.13882 | 37.7159250221006 | -122.478563605643 | (37.7159250221006, -122.478563605643) | 1 | 8 | 4 | 64 | 14 | ||||
| 30556 | 104909 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 533 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 30619 | 114927 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
| 31393 | 211194 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 61 | : | Tree | Private 2 | 6 | Width 0ft | 5991249.68051 | 2092388.77229 | 37.7247980032196 | -122.472428045728 | (37.7247980032196, -122.472428045728) | 9 | 8 | 4 | 64 | 40 | |||
| 31451 | 114152 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 11 | Front Yard : Yard | Tree | Private 2 | 8 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 32419 | 110166 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 131x GARCES DR | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||||
| 33452 | 2296 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Brotherhood Way | 11 | Median : Cutout | Tree | DPW 1 | 50 | 14M | 5990276.2096462 | 2088591.5343604 | 37.7143153385926 | -122.475516051132 | (37.7143153385926, -122.475516051132) | 1 | 8 | 4 | 64 | 14 | |||
| 33460 | 115831 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1X JUNIPERO SERRA BLVD OFF RAMP | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | ||||
| 34113 | 178309 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5989840.96696 | 2090677.12627 | 37.720016616367 | -122.477172722251 | (37.720016616367, -122.477172722251) | 1 | 8 | 4 | 64 | 14 | ||||
| 34127 | 254296 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 130X Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 10x30 | 5991393 | 2095322 | 37.7328602072681 | -122.472146321186 | (37.7328602072681, -122.472146321186) | 1 | 8 | 4 | 64 | 40 | ||||
| 34293 | 111094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 150x FONT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 30 | 3x3 | Permit Number 775594 | 5990976 | 2089133 | 37.7158426125161 | -122.473136789074 | (37.7158426125161, -122.473136789074) | 1 | 8 | 4 | 64 | 14 | ||
| 35165 | 114121 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 35519 | 30055 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 1 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
| 35748 | 30062 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 7 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
| 37079 | 104885 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 134 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 37106 | 211195 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 69 | : | Tree | Private 2 | 52 | Width 0ft | 5991251.70893 | 2092296.84954 | 37.7245457235837 | -122.472414335578 | (37.7245457235837, -122.472414335578) | 9 | 8 | 4 | 64 | 40 | |||
| 37581 | 114212 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 302 SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 64 | 5988825 | 2090618 | 37.7197952736455 | -122.480680205506 | (37.7197952736455, -122.480680205506) | 1 | 8 | 4 | 64 | 14 | ||||
| 37858 | 107319 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 530X JUNIPERO SERRA BLVD | 1 | Median : Cutout | Tree | DPW 1 | 27 | 5991365.2 | 2093720 | 37.728459908419 | -122.472125702067 | (37.728459908419, -122.472125702067) | 9 | 8 | 4 | 64 | 40 | ||||
| 38536 | 95334 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 466 Gonzalez Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2011 12:00:00 AM | 75 | Permit Number 767212 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | 1 | 8 | 4 | 64 | 14 | ||
| 38864 | 114149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 8 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 39717 | 30064 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 9 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
| 40445 | 211201 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 145 | : | Tree | Private 2 | 1 | Width 0ft | 5991189.49156 | 2091528.19134 | 37.722431577537 | -122.472573395941 | (37.722431577537, -122.472573395941) | 9 | 8 | 4 | 64 | 40 | |||
| 41865 | 30081 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 16 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
| 42877 | 30058 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 3 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
| 42934 | 114111 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 43604 | 114263 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800x BROTHERHOOD WAY | 4 | Front Yard : Cutout | Tree | Private 2 | 29 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 44835 | 105258 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 132 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 50 | 5990327 | 2090136 | 37.7185590045312 | -122.47545320092 | (37.7185590045312, -122.47545320092) | 1 | 8 | 4 | 64 | 14 | ||||
| 44870 | 256450 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 3001 Sunset Blvd | 34 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 44944 | 115562 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 450x JUNIPERO SERRA BLVD | 1 | Median : Cutout | Tree | Private 2 | 30 | 3x3 | 5991387 | 2094058 | 37.7293892334347 | -122.472074965405 | (37.7293892334347, -122.472074965405) | 9 | 8 | 4 | 64 | 40 | |||
| 45079 | 2291 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 600X Brotherhood Way | 6 | Median : Cutout | Tree | DPW 1 | 24 | 14M | 5991856 | 2088020 | 37.7128374968227 | -122.470014135427 | (37.7128374968227, -122.470014135427) | 9 | 8 | 6 | 64 | 24 | |||
| 45204 | 211202 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 146 | : | Tree | Private 2 | 1 | Width 0ft | 5991184.50895 | 2091529.29339 | 37.722434315083 | -122.472590699819 | (37.722434315083, -122.472590699819) | 9 | 8 | 4 | 64 | 40 | |||
| 45230 | 114939 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 15 | Front Yard : Cutout | Tree | Private 2 | 36 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | |||
| 45412 | 30080 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 15 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
| 45485 | 211181 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300 Junipero Serra Blvd | 9 | : | Tree | Private 2 | 12 | Width 0ft | 5991393.792 | 2094552.98519 | 37.7307487317665 | -122.472087549812 | (37.7307487317665, -122.472087549812) | 9 | 8 | 4 | 64 | 40 | |||
| 45971 | 91488 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 750x Brotherhood Way | 22 | Median : Cutout | Tree | DPW 1 | 03/15/2007 12:00:00 AM | 3 | 5991053.474445 | 2088092.036965 | 37.7129888676025 | -122.472793145921 | (37.7129888676025, -122.472793145921) | 1 | 8 | 4 | 64 | 14 | |||
| 46446 | 211209 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Junipero Serra Blvd | 108 | : | Tree | Private 2 | 38 | Width 0ft | 5991125.77037 | 2090347.71078 | 37.7191865807757 | -122.472707634153 | (37.7191865807757, -122.472707634153) | 9 | 8 | 4 | 64 | 40 | |||
| 46878 | 30075 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 20 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
| 47284 | 111091 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 423 GONZALEZ DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775595 | 5989758 | 2089186 | 37.715917540265 | -122.477350587483 | (37.715917540265, -122.477350587483) | 1 | 8 | 4 | 64 | 14 | |
| 47402 | 120930 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
| 48176 | 114926 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
| 48591 | 114380 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 437X SERRANO DR | Sidewalk: Curb side : Cutout | Tree | Private 2 | 48 | 5988907 | 2090368 | 37.7191136019865 | -122.480378474397 | (37.7191136019865, -122.480378474397) | 1 | 8 | 4 | 64 | 14 |
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) );