Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 707 | 707 | 214065 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 388 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | 4 | Width 3ft | Permit Number 41588 | 5992652.79455 | 2094064.0577 | 37.729479034728605 | -122.46769947335 | (37.7294790347286, -122.46769947335) | |
| 857 | 857 | 240430 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2637 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2017 12:00:00 AM | 3 | Width 3ft | 6010665.07202 | 2102243.00786 | 37.752960245237105 | -122.406004908126 | (37.7529602452371, -122.406004908126) | ||
| 955 | 955 | 251402 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 190 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007981.0 | 2093052.0 | 37.7275732783897 | -122.41463660892599 | (37.7275732783897, -122.414636608926) | ||||
| 1668 | 1668 | 223648 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 3270 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007658.5453 | 2105622.05871 | 37.7620697309624 | -122.416641430963 | (37.7620697309624, -122.416641430963) | |||
| 1673 | 1673 | 223647 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 3270 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007640.90679 | 2105619.03236 | 37.7620604292697 | -122.416702221525 | (37.7620604292697, -122.416702221525) | |||
| 1826 | 1826 | 31896 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1525 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | Permit Number 35325 | ||||||||
| 2292 | 2292 | 240500 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 53 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002484.13464 | 2096495.8986099998 | 37.7367190745264 | -122.43388535921999 | (37.7367190745264, -122.43388535922) | |||
| 2811 | 2811 | 115532 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007293.46404 | 2111265.83422 | 37.777545665835596 | -122.41830427922501 | (37.7775456658356, -122.418304279225) | ||
| 4875 | 4875 | 253714 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 199x Boylston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009166.0 | 2094503.0 | 37.7316239213188 | -122.41064246098699 | (37.7316239213188, -122.410642460987) | ||||
| 4876 | 4876 | 179410 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 199x Boylston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009166.0 | 2094503.0 | 37.7316239213188 | -122.41064246098699 | (37.7316239213188, -122.410642460987) | |||
| 4896 | 4896 | 179412 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 101X Boylston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009128.0 | 2094630.0 | 37.7319705055503 | -122.41078280093201 | (37.7319705055503, -122.410782800932) | |||
| 6140 | 6140 | 115534 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007259.83389 | 2111260.26588 | 37.777528483399294 | -122.418420222514 | (37.7775284833993, -122.418420222514) | ||
| 6989 | 6989 | 115533 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007275.38703 | 2111262.82601 | 37.7775363884346 | -122.418366600452 | (37.7775363884346, -122.418366600452) | ||
| 7521 | 7521 | 31898 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1525 Houston St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | Permit Number 35325 | ||||||||
| 8241 | 8241 | 115531 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007312.7374599995 | 2111269.98589 | 37.777558150214404 | -122.41823790028 | (37.7775581502144, -122.41823790028) | ||
| 8494 | 8494 | 115535 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007237.56945 | 2111260.60051 | 37.777528148837796 | -122.41849726655899 | (37.7775281488378, -122.418497266559) | ||
| 10608 | 10608 | 27022 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1455 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6010017.04881 | 2094574.7382200002 | 37.7318685774514 | -122.40770525989402 | (37.7318685774514, -122.407705259894) | |||
| 12948 | 12948 | 13361 | DPW Maintained 3 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 681 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009922.88098 | 2090119.1151400001 | 37.7196290984845 | -122.407716765821 | (37.7196290984845, -122.407716765821) | |||
| 13064 | 13064 | 39938 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 507 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | 5 | 3x3 | Permit Number 41209 | 6010273.868559999 | 2088515.64826 | 37.715245949426 | -122.406390599441 | (37.715245949426, -122.406390599441) | |
| 13228 | 13228 | 31899 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1525 Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | Permit Number 35325 | ||||||||
| 14480 | 14480 | 35352 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 700 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2016 12:00:00 AM | 3 | Permit Number 38814 | 6011513.42 | 2105068.48305 | 37.7607657868204 | -122.403269888106 | (37.7607657868204, -122.403269888106) | |
| 14686 | 14686 | 1874 | DPW Maintained 3 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 15 Beatrice Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/2006 12:00:00 AM | 3 | 3X3 | 6017610.71077 | 2094324.6011400002 | 37.731603917783296 | -122.381434724757 | (37.7316039177833, -122.381434724757) | ||
| 16068 | 16068 | 4900 | DPW Maintained 3 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 15 Beatrice Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017703.09263 | 2094179.8242400002 | 37.7312114887134 | -122.381105276987 | (37.7312114887134, -122.381105276987) | |||
| 18034 | 18034 | 35903 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2280 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | Permit Number 39090 | 6011422.71030879 | 2097968.54205143 | 37.7412658332656 | -122.40308419758499 | (37.7412658332656, -122.403084197585) | ||
| 18189 | 18189 | 62931 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 11 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23312 | 6007229.26239434 | 2097742.77574658 | 37.7404108574616 | -122.417567695103 | (37.7404108574616, -122.417567695103) | ||
| 18374 | 18374 | 40540 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 388 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | Permit Number 41588 | 5992603.60686863 | 2094011.26053389 | 37.729331226563794 | -122.467865679912 | (37.7293312265638, -122.467865679912) | |||
| 18561 | 18561 | 38144 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100 Felton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | Permit Number 40298 | 6010597.10061024 | 2093822.92376046 | 37.729836707424205 | -122.40564695547701 | (37.7298367074242, -122.405646955477) | ||
| 18706 | 18706 | 65014 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 425 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | Permit Number 26059 | 6008714.20970491 | 2093942.04668385 | 37.7300583233735 | -122.41216476431299 | (37.7300583233735, -122.412164764313) | ||
| 18716 | 18716 | 36142 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1019 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | 3x3 | Permit Number 39231 | 5992616.68372408 | 2107257.53291998 | 37.765702850857295 | -122.468783982345 | (37.7657028508573, -122.468783982345) | |
| 19055 | 19055 | 40280 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 307 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41432 | 6007215.02535858 | 2105520.83315888 | 37.7617668348059 | -122.41816822210698 | (37.7617668348059, -122.418168222107) | ||
| 19848 | 19848 | 39350 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 378 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40911 | 6007185.43468518 | 2105114.94243818 | 37.7606506875228 | -122.418241786158 | (37.7606506875228, -122.418241786158) | ||
| 20139 | 20139 | 27859 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 501 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005590.08151 | 2106010.51077 | 37.7630197774623 | -122.42382307956801 | (37.7630197774623, -122.423823079568) | |||
| 20676 | 20676 | 27858 | DPW Maintained 3 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 501 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005591.22935 | 2106001.14468 | 37.7629941251915 | -122.423818443561 | (37.7629941251915, -122.423818443561) | |||
| 21815 | 21815 | 9365 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 260 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2009 12:00:00 AM | 3 | 3x3 | 6001129.20472 | 2098260.62267 | 37.7414876109521 | -122.438696344576 | (37.7414876109521, -122.438696344576) | ||
| 23663 | 23663 | 43822 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2825 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43450 | 5985846.03671693 | 2096222.06732973 | 37.7350089880537 | -122.49138954377399 | (37.7350089880537, -122.491389543774) | |
| 24667 | 24667 | 41967 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 660 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42320 | 5993546.32610667 | 2094692.15978902 | 37.731255200572 | -122.464656063289 | (37.731255200572, -122.464656063289) | ||
| 24929 | 24929 | 37138 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 161 Escolta Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 3 | Permit Number 42807 | 5986482.4499372 | 2097271.49394256 | 37.7379276046571 | -122.48926640038401 | (37.7379276046571, -122.489266400384) | |
| 25038 | 25038 | 240469 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 4563 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000734.88793 | 2101096.32355 | 37.7492513304919 | -122.4402630625 | (37.7492513304919, -122.4402630625) | |||
| 25238 | 25238 | 240502 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 65 Brady St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6006718.565119999 | 2109527.53926 | 37.7727403471174 | -122.42016965211 | (37.7727403471174, -122.42016965211) | |||
| 25395 | 25395 | 214102 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 620 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995724.90855 | 2089920.68652 | 37.7182792313899 | -122.456779396068 | (37.7182792313899, -122.456779396068) | |||
| 25450 | 25450 | 214094 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 651 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5997782.04572 | 2094966.2978700001 | 37.7322512012232 | -122.45003223599701 | (37.7322512012232, -122.450032235997) | ||||
| 25513 | 25513 | 38146 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100 Felton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 5 | Permit Number 40298 | 6010515.59192 | 2093794.04855 | 37.7297528639062 | -122.405926708464 | (37.7297528639062, -122.405926708464) | |
| 25788 | 25788 | 240428 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 530 Hickory St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 6004264.4579300005 | 2110312.0386200002 | 37.7747558078645 | -122.42871461628201 | (37.7747558078645, -122.428714616282) | |||
| 26152 | 26152 | 32747 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 267 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 3 | Permit Number 37129 | 5994353.06343 | 2089312.7062799998 | 37.7165309960889 | -122.461477197213 | (37.7165309960889, -122.461477197213) | |
| 26287 | 26287 | 240498 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 4045 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002747.087780001 | 2104716.24804 | 37.759305140333794 | -122.43356351345699 | (37.7593051403338, -122.433563513457) | |||
| 26298 | 26298 | 179386 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 227 Italy Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001320.56571 | 2089533.6970900001 | 37.717536358988205 | -122.437409916557 | (37.7175363589882, -122.437409916557) | |||
| 26415 | 26415 | 43187 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 130 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 42989 | 6009996.56668 | 2094788.79473 | 37.7324551845471 | -122.40779115953 | (37.7324551845471, -122.40779115953) | |
| 26590 | 26590 | 40653 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 228 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 6 | Permit Number 41648 | 6004676.899180001 | 2093899.14915 | 37.7297131732144 | -122.42611920613301 | (37.7297131732144, -122.426119206133) | |
| 26760 | 26760 | 37137 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 161 Escolta Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 3 | Permit Number 42807 | 5986482.4499372 | 2097271.49394256 | 37.7379276046571 | -122.48926640038401 | (37.7379276046571, -122.489266400384) | |
| 26873 | 26873 | 240446 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 225 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007185.08806 | 2105978.8862 | 37.763022856728 | -122.41830424146299 | (37.763022856728, -122.418304241463) | |||
| 27212 | 27212 | 136339 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2020 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008202.0476 | 2119382.96503 | 37.7998844297821 | -122.41573606726101 | (37.7998844297821, -122.415736067261) | |||
| 27249 | 27249 | 43044 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2378 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 4 | Permit Number 42898 | 5984575.17835777 | 2099003.211622 | 37.74257091653121 | -122.495988392138 | (37.7425709165312, -122.495988392138) | |
| 27775 | 27775 | 41222 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1726 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 5 | Permit Number 41929 | 6002465.734180001 | 2120932.6611099998 | 37.8038153520489 | -122.43569676918501 | (37.8038153520489, -122.435696769185) | |
| 27909 | 27909 | 214121 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 245 Kenwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993831.59945 | 2093545.11713 | 37.728122144814 | -122.463586613749 | (37.728122144814, -122.463586613749) | |||
| 27936 | 27936 | 214123 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1422 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995888.964459999 | 2093464.6167 | 37.7280194395365 | -122.45646845638001 | (37.7280194395365, -122.45646845638) | |||
| 28800 | 28800 | 214071 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 110 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993372.153609999 | 2093767.9107 | 37.7287073975199 | -122.465191096889 | (37.7287073975199, -122.465191096889) | |||
| 29319 | 29319 | 39980 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 45 Bay View St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1999 12:00:00 AM | 4 | Permit Number 41239 | 6014289.17027 | 2094727.0607 | 37.7325250510738 | -122.39294618091999 | (37.7325250510738, -122.39294618092) | |
| 29495 | 29495 | 240465 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 83 Sunview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999175.30542 | 2100439.89059 | 37.7473600067581 | -122.445608907946 | (37.7473600067581, -122.445608907946) | |||
| 30257 | 30257 | 214113 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 232 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993322.79937 | 2090505.62474 | 37.719747109313104 | -122.46512486633999 | (37.7197471093131, -122.46512486634) | |||
| 30275 | 30275 | 179398 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 114 Congdon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004666.37209 | 2094131.13756 | 37.7303495667676 | -122.426172108778 | (37.7303495667676, -122.426172108778) | |||
| 30569 | 30569 | 214127 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 60 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001719.56678 | 2094955.5376099998 | 37.7324461814516 | -122.436418585765 | (37.7324461814516, -122.436418585765) | |||
| 30901 | 30901 | 179401 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 413 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006494.32804 | 2091952.03759 | 37.724469381942704 | -122.41969804493 | (37.7244693819427, -122.41969804493) | |||
| 30990 | 30990 | 240456 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 395 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007237.846919999 | 2105039.44875 | 37.760446349428896 | -122.41805516342801 | (37.7604463494289, -122.418055163428) | |||
| 31477 | 31477 | 179388 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 26 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5999809.288380001 | 2088896.52322 | 37.715700789641 | -122.442587971868 | (37.715700789641, -122.442587971868) | |||
| 31643 | 31643 | 214050 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1025 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992561.5369 | 2107264.0373299997 | 37.765717524169204 | -122.46897519495899 | (37.7657175241692, -122.468975194959) | |||
| 31773 | 31773 | 214096 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 229 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5998581.421569999 | 2093477.11614 | 37.7282079680113 | -122.447161488515 | (37.7282079680113, -122.447161488515) | |||
| 31791 | 31791 | 240499 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2118 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003377.293330001 | 2107154.45739 | 37.7660356125773 | -122.431558026196 | (37.7660356125773, -122.431558026196) | |||
| 32228 | 32228 | 123349 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 516 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994708.14146 | 2111967.00888 | 37.778754433673 | -122.46189166295099 | (37.778754433673, -122.461891662951) | |||
| 32292 | 32292 | 37393 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 176 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 6 | Permit Number 39875 | 6000308.53734 | 2087884.7507599997 | 37.7129511358524 | -122.44078980891001 | (37.7129511358524, -122.44078980891) | |
| 32942 | 32942 | 42276 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1523 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | Permit Number 42513 | 5987115.482033901 | 2104898.43212943 | 37.7589060606403 | -122.48763787290399 | (37.7589060606403, -122.487637872904) | |
| 35441 | 35441 | 240467 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 500 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000657.7353300005 | 2101059.8853 | 37.7491468868218 | -122.440527243747 | (37.7491468868218, -122.440527243747) | |||
| 35934 | 35934 | 214064 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 306 San Benito Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992868.39865 | 2094830.01805 | 37.7315946187936 | -122.46700977969999 | (37.7315946187936, -122.4670097797) | |||
| 36145 | 36145 | 49842 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 114@ PIOCHE Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2003 12:00:00 AM | 4 | Permit Number 46625 | 6006337.7607 | 2093333.74713 | 37.7282544350853 | -122.420337301944 | (37.7282544350853, -122.420337301944) | |
| 36148 | 36148 | 214097 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 155 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5999042.44217 | 2093470.7049 | 37.7282166950461 | -122.44556726752701 | (37.7282166950461, -122.445567267527) | |||
| 36419 | 36419 | 179395 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 802 Delano Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998781.55693 | 2089916.70875 | 37.7184433477691 | -122.446213610282 | (37.7184433477691, -122.446213610282) | |||
| 36557 | 36557 | 33275 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1200 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 5 | Permit Number 37444 | 6008934.750659999 | 2117024.05475 | 37.7934486051144 | -122.413033747502 | (37.7934486051144, -122.413033747502) | |
| 36845 | 36845 | 240468 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 4563 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000721.2192400005 | 2101097.24076 | 37.749253070695 | -122.440310394721 | (37.749253070695, -122.440310394721) | |||
| 36993 | 36993 | 179391 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 411 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012708.59796 | 2087058.68535 | 37.711381319763795 | -122.397872915301 | (37.7113813197638, -122.397872915301) | |||
| 37041 | 37041 | 240436 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 315 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008839.1372 | 2097359.36666 | 37.739448554706 | -122.41197427329901 | (37.739448554706, -122.411974273299) | |||
| 37491 | 37491 | 33261 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1421 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 4 | Permit Number 37437 | 5988564.5083506 | 2097603.21531438 | 37.7389597407729 | -122.48209208288 | (37.7389597407729, -122.48209208288) | |
| 37910 | 37910 | 37211 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1335 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 4 | Permit Number 39777 | 5985831.13092418 | 2106137.73809269 | 37.762233858144 | -122.492170947719 | (37.762233858144, -122.492170947719) | |
| 37939 | 37939 | 240451 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 325 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007215.72269 | 2105410.19027 | 37.7614630743871 | -122.418157965843 | (37.7614630743871, -122.418157965843) | |||
| 37955 | 37955 | 214126 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 198 Lippard Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001754.28692 | 2095002.3672900002 | 37.7325767378097 | -122.43630190050699 | (37.7325767378097, -122.436301900507) | |||
| 38274 | 38274 | 187517 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 248 Lauren Ct | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 1ft | 6012485.73667 | 2088132.5858200002 | 37.714317623337706 | -122.398718501961 | (37.7143176233377, -122.398718501961) | |||
| 38931 | 38931 | 43608 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2158 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 3 | Permit Number 43262 | 5986075.03134295 | 2100545.45241808 | 37.7468932271681 | -122.490915873175 | (37.7468932271681, -122.490915873175) | |
| 39441 | 39441 | 136334 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1170 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009052.72645 | 2117042.36337 | 37.7935054980422 | -122.412626835765 | (37.7935054980422, -122.412626835765) | |||
| 39611 | 39611 | 240466 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 821 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001260.5563900005 | 2099974.90576 | 37.7462020990556 | -122.438364964196 | (37.7462020990556, -122.438364964196) | |||
| 39899 | 39899 | 214062 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 306 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992867.8915800005 | 2094835.36028 | 37.7316092579634 | -122.467011920972 | (37.7316092579634, -122.467011920972) | |||
| 39993 | 39993 | 240447 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 307 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007214.00859 | 2105476.56765 | 37.7616452347736 | -122.418168600314 | (37.7616452347736, -122.418168600314) | |||
| 40301 | 40301 | 36973 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 174 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 5 | Permit Number 39601 | 5993690.91098 | 2114398.10282 | 37.785370945064 | -122.465587296093 | (37.785370945064, -122.465587296093) | |
| 40495 | 40495 | 214136 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 280 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6000181.60915 | 2094987.27855 | 37.7324458244188 | -122.441737929968 | (37.7324458244188, -122.441737929968) | |||
| 40698 | 40698 | 246801 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 125 Brewster St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6010345.51776 | 2099245.26098 | 37.744711212847704 | -122.406898728095 | (37.7447112128477, -122.406898728095) | |||
| 41488 | 41488 | 179406 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1048 Felton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007913.23251 | 2092994.1736599999 | 37.7274106920366 | -122.41486679156601 | (37.7274106920366, -122.414866791566) | |||
| 41537 | 41537 | 214057 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 263 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992130.616669999 | 2094998.35123 | 37.732014207382896 | -122.469572663162 | (37.7320142073829, -122.469572663162) | |||
| 41561 | 41561 | 240473 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 106 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003773.04832 | 2096485.69416 | 37.73676411436121 | -122.429428297586 | (37.7367641143612, -122.429428297586) | |||
| 42589 | 42589 | 214140 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 31 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997777.712069999 | 2091415.2513400002 | 37.7225006167019 | -122.449791402972 | (37.7225006167019, -122.449791402972) | |||
| 42750 | 42750 | 36814 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1319 Egbert Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39533 | 6014721.91392724 | 2090796.36288096 | 37.721756170521296 | -122.39117541546601 | (37.7217561705213, -122.391175415466) | ||
| 42812 | 42812 | 214101 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 75 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996192.67617 | 2090390.73795 | 37.71959673007321 | -122.455196480447 | (37.7195967300732, -122.455196480447) | |||
| 43325 | 43325 | 43059 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 3033 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | Permit Number 42909 | 5983784.03584538 | 2100159.31178354 | 37.745698882321896 | -122.498809278198 | (37.7456988823219, -122.498809278198) | ||
| 43332 | 43332 | 41969 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 700 Darien Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42321 | 5993590.54370591 | 2094553.01083875 | 37.73087568091729 | -122.464493096634 | (37.7308756809173, -122.464493096634) |
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");