trees
1,382 rows where qCareAssistant = "" and qSpecies_id = 95 sorted by DBH
This data as json, CSV (advanced)
qSiteInfo ✖
- Sidewalk: Curb side : Cutout 602
- Sidewalk: Property side : Yard 540
- Median : Cutout 49
- Sidewalk: Curb side : Yard 49
- : 46
- unknown : Yard 28
- Side Yard : Yard 15
- Sidewalk: Curb side : Pot 13
- Back Yard : Yard 12
- Sidewalk: Property side : Cutout 11
- Front Yard : Yard 10
- Median : Yard 4
- Unaccepted Street : Yard 2
- Front Yard : Cutout 1
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 429 | 259715 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 210 Gold Mine Dr | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000723 | 2098465 | 37.7420256658379 | -122.440115509428 | (37.7420256658379, -122.440115509428) | 2 | 7 | 5 | 63 | 7 | ||||
| 2120 | 262362 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 160 Central Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 0ft | 5999920 | 2109126 | 37.7712524099727 | -122.443657715912 | (37.7712524099727, -122.443657715912) | 15 | 5 | 11 | 29492 | 9 | ||||
| 3279 | 262361 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 160 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5999920 | 2109126 | 37.7712524099727 | -122.443657715912 | (37.7712524099727, -122.443657715912) | 15 | 5 | 11 | 29492 | 9 | ||||
| 6235 | 261034 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2499X Sunset Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5984844 | 2098260 | 37.740545999365 | -122.495004110004 | (37.740545999365, -122.495004110004) | 1 | 8 | 3 | 29491 | 35 | ||||
| 8974 | 260925 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 1900 Noriega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5987961.4849 | 2103092.5821 | 37.7539969916819 | -122.484579575666 | (37.7539969916819, -122.484579575666) | 1 | 8 | 3 | 56 | 35 | ||||
| 9102 | 83833 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1220 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50199 | 5980896.51884717 | 2106747.16910548 | 37.7636174777723 | -122.509282857292 | (37.7636174777723, -122.509282857292) | 1 | 8 | 3 | 56 | 35 | ||
| 11325 | 92820 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4410 Geary Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53029 | 5993333.8 | 2112848.6 | 37.7810958286268 | -122.466710108029 | (37.7810958286268, -122.466710108029) | 11 | 6 | 2 | 54 | 11 | |||
| 20385 | 251602 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 44R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999509 | 2100035 | 37.7462673204657 | -122.444425925791 | (37.7462673204657, -122.444425925791) | 2 | 7 | 5 | 63 | 22 | |||||
| 20766 | 84183 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 496 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50711 | 6010074.8980178 | 2089472.05898173 | 37.7178609244136 | -122.407145708761 | (37.7178609244136, -122.407145708761) | 10 | 7 | 8 | 309 | 39 | ||
| 22714 | 114635 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||||
| 24191 | 114163 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 201x SHRADER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997258 | 2109797 | 37.7729426176536 | -122.45291407736 | (37.7729426176536, -122.45291407736) | 15 | 5 | 11 | 29492 | 16 | ||||
| 26574 | 100103 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 461 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
| 35142 | 102666 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 3399X Wawona St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5982463.4 | 2096719.2 | 37.7361757338901 | -122.503121118731 | (37.7361757338901, -122.503121118731) | 1 | 8 | 3 | 29491 | 35 | ||||
| 39805 | 253151 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 203 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 5997194 | 2107012 | 37.7652920558138 | -122.452934396642 | (37.7652920558138, -122.452934396642) | 15 | 5 | 11 | 29492 | 12 | ||||
| 40649 | 67453 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1088 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2010 12:00:00 AM | Permit Number 30960 | 6007819.98571592 | 2118911.65470292 | 37.7985688445608 | -122.417024735457 | (37.7985688445608, -122.417024735457) | 5 | 1 | 10 | 308 | 32 | |||
| 40944 | 95611 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 345 08th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993380.9 | 2113168.3 | 37.7819763561044 | -122.466570411383 | (37.7819763561044, -122.466570411383) | 11 | 6 | 2 | 54 | 11 | ||||
| 43548 | 116682 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Esmeralda Ave | 21 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 45533 | 79908 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4668 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 3x3 | Permit Number 50048 | 6000123.33109091 | 2105202.65192777 | 37.7604914689072 | -122.442672635485 | (37.7604914689072, -122.442672635485) | 15 | 4 | 5 | 28862 | 3 | ||
| 48151 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 10 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 50742 | 117072 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 3105X CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999725 | 2115439 | 37.7885751609396 | -122.444786082443 | (37.7885751609396, -122.444786082443) | 13 | 6 | 1 | 29490 | 27 | ||||
| 53963 | 84931 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | ||||
| 54862 | 251605 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 48R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999482 | 2100041 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | 2 | 7 | 5 | 63 | 22 | |||||
| 60900 | 103616 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 201X Haight St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
| 61388 | 117060 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 214 SPRUCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997156 | 2115480 | 37.7885407952581 | -122.453677346309 | (37.7885407952581, -122.453677346309) | 11 | 6 | 1 | 54 | 31 | ||||
| 64594 | 114637 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||||
| 65349 | 83246 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
| 66091 | 100771 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
| 67803 | 95610 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 345 08th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993380.9 | 2113168.3 | 37.7819763561044 | -122.466570411383 | (37.7819763561044, -122.466570411383) | 11 | 6 | 2 | 54 | 11 | ||||
| 69066 | 83404 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4161-4165 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50774 | 6002116.5949366 | 2102338.3887788 | 37.7527403167837 | -122.435573947989 | (37.7527403167837, -122.435573947989) | 2 | 4 | 5 | 28862 | 22 | ||
| 69454 | 98948 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 8 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 69686 | 253094 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1360 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1992 12:00:00 AM | 3x3 | Permit Number 30561 | 5994899.98504 | 2106326.93315 | 37.7632793109173 | -122.460819144348 | (37.7632793109173, -122.460819144348) | 15 | 5 | 11 | 56 | 12 | ||
| 70170 | 102663 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 3399X Wawona St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5982463.4 | 2096719.2 | 37.7361757338901 | -122.503121118731 | (37.7361757338901, -122.503121118731) | 1 | 8 | 3 | 29491 | 35 | ||||
| 75088 | 80866 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 167 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50662 | 6003060.92852227 | 2092556.70085542 | 37.7259356446911 | -122.43160998466 | (37.7259356446911, -122.43160998466) | 9 | 7 | 6 | 28861 | 5 | ||
| 77554 | 115072 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 65 LILY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006230 | 2110204 | 37.7745702053319 | -122.421907716929 | (37.7745702053319, -122.421907716929) | 7 | 9 | 11 | 28852 | 10 | ||||
| 81945 | 83247 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
| 87430 | 99813 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 721x Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 795-797 Elizabeth St same address; corner property | 6001267.3 | 2102059 | 37.751924908035 | -122.438490940634 | (37.751924908035, -122.438490940634) | 2 | 4 | 5 | 28862 | 22 | |||
| 90275 | 47584 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2315 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | Permit Number 45429 | 6002167.38030416 | 2107035.22684309 | 37.7656395833099 | -122.435734334425 | (37.7656395833099, -122.435734334425) | 15 | 5 | 5 | 28862 | 3 | |||
| 95251 | 81819 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 56 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50797 | 6001670.65658428 | 2105505.28086123 | 37.7614104988666 | -122.437342827434 | (37.7614104988666, -122.437342827434) | 15 | 4 | 5 | 28862 | 3 | ||
| 100606 | 100772 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 3 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
| 100894 | 104079 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987336.5 | 2114673.6 | 37.7857588250819 | -122.487591604742 | (37.7857588250819, -122.487591604742) | 11 | 6 | 1 | 55 | 33 | |||||
| 102680 | 50457 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 336 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47102 | 6003706.69547569 | 2099554.47375445 | 37.7451865213865 | -122.429876537024 | (37.7451865213865, -122.429876537024) | 2 | 7 | 5 | 63 | 22 | |||
| 102815 | 114636 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||||
| 103314 | 104080 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987336.5 | 2114673.6 | 37.7857588250819 | -122.487591604742 | (37.7857588250819, -122.487591604742) | 11 | 6 | 1 | 55 | 33 | |||||
| 109060 | 254199 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 201 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5997173 | 2109816 | 37.7729899153653 | -122.453209472915 | (37.7729899153653, -122.453209472915) | 15 | 5 | 11 | 29492 | 16 | ||||
| 110142 | 251675 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2005 12:00:00 AM | 3x3 | Permit Number 48036 | 6001586 | 2113871 | 37.784375861656 | -122.438234943981 | (37.784375861656, -122.438234943981) | 15 | 6 | 11 | 29490 | 13 | ||
| 110919 | 99784 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 4281 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001386 | 2101717 | 37.7509926092516 | -122.438055964302 | (37.7509926092516, -122.438055964302) | 2 | 4 | 5 | 28862 | 22 | ||||
| 113409 | 92745 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 65 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2009 12:00:00 AM | Permit Number 52969 | 6006237.3 | 2110147.2 | 37.7744146578956 | -122.42187842919 | (37.7744146578956, -122.42187842919) | 7 | 9 | 11 | 28852 | 10 | |||
| 115361 | 83929 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1220 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50199 | 5980896.51884717 | 2106747.16910548 | 37.7636174777723 | -122.509282857292 | (37.7636174777723, -122.509282857292) | 1 | 8 | 3 | 56 | 35 | ||
| 121945 | 49984 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 3SEA CLIFF 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46731 | 5988218.33044294 | 2115911.3812309 | 37.7892088105604 | -122.484631586183 | (37.7892088105604, -122.484631586183) | 11 | 6 | 1 | 61 | 33 | |||
| 128960 | 81950 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
| 129496 | 255714 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 618x Mendell St | 9 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 781846 | 6016376 | 2097269 | 37.7396204009215 | -122.385908564927 | (37.7396204009215, -122.385908564927) | 10 | 3 | 8 | 58 | 1 | |||
| 129961 | 114638 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||||
| 133804 | 99755 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 519 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001824 | 2100869 | 37.7486891023588 | -122.43648063187 | (37.7486891023588, -122.43648063187) | 2 | 4 | 5 | 28862 | 22 | ||||
| 137333 | 102662 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 3399X Wawona St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5982463.4 | 2096719.2 | 37.7361757338901 | -122.503121118731 | (37.7361757338901, -122.503121118731) | 1 | 8 | 3 | 29491 | 35 | ||||
| 137357 | 117353 | Private 9 | Pittosporum crassifolium :: Karo Tree 95 | 101X China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 772935 | 6015309.46376 | 2108739.72137 | 37.7710574836343 | -122.390397474374 | (37.7710574836343, -122.390397474374) | 14 | 3 | 9 | 310 | 20 | |||
| 140970 | 50962 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2544 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47454 | 6007484.88144152 | 2121079.14108349 | 37.8045013596833 | -122.418338067384 | (37.8045013596833, -122.418338067384) | 5 | 1 | 1 | 308 | 32 | ||||
| 143804 | 88992 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 680 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013080.3 | 2113726.9 | 37.784627230328 | -122.398458274764 | (37.784627230328, -122.398458274764) | 6 | 2 | 9 | 28853 | 6 | ||||
| 145774 | 100105 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 461 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
| 146402 | 113940 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 1898X FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003895 | 2119074 | 37.7987930300326 | -122.430618004672 | (37.7987930300326, -122.430618004672) | 13 | 9 | 1 | 57 | 17 | ||||
| 147643 | 100770 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
| 150190 | 95609 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 345 08th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993380.9 | 2113168.3 | 37.7819763561044 | -122.466570411383 | (37.7819763561044, -122.466570411383) | 11 | 6 | 2 | 54 | 11 | ||||
| 152270 | 251676 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001586 | 2113871 | 37.784375861656 | -122.438234943981 | (37.784375861656, -122.438234943981) | 15 | 6 | 11 | 29490 | 13 | ||||
| 154901 | 83220 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4431 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51278 | 5981138.26503887 | 2104833.82596272 | 37.7583782380396 | -122.508304716049 | (37.7583782380396, -122.508304716049) | 1 | 8 | 3 | 56 | 35 | ||
| 158204 | 102664 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 3399X Wawona St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5982463.4 | 2096719.2 | 37.7361757338901 | -122.503121118731 | (37.7361757338901, -122.503121118731) | 1 | 8 | 3 | 29491 | 35 | ||||
| 163553 | 51787 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2005 12:00:00 AM | 2x2 | Permit Number 48036 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||
| 169370 | 255812 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1258 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | Permit Number 782103 | 5999099 | 2105411 | 37.7610050950906 | -122.446230300301 | (37.7610050950906, -122.446230300301) | 15 | 5 | 5 | 28862 | 3 | |||
| 173433 | 104078 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987336.5 | 2114673.6 | 37.7857588250819 | -122.487591604742 | (37.7857588250819, -122.487591604742) | 11 | 6 | 1 | 55 | 33 | |||||
| 173825 | 116683 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Esmeralda Ave | 22 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 174521 | 258525 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 50 Hermann St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
| 178800 | 104083 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987336.5 | 2114673.6 | 37.7857588250819 | -122.487591604742 | (37.7857588250819, -122.487591604742) | 11 | 6 | 1 | 55 | 33 | |||||
| 178921 | 102660 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 3399X Wawona St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5982463.4 | 2096719.2 | 37.7361757338901 | -122.503121118731 | (37.7361757338901, -122.503121118731) | 1 | 8 | 3 | 29491 | 35 | ||||
| 181687 | 100104 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 461 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
| 187125 | 97314 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 939 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990332.7 | 2099029.1 | 37.7429775357045 | -122.47608267022 | (37.7429775357045, -122.47608267022) | 1 | 8 | 3 | 29491 | 35 | ||||
| 191350 | 102665 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 3399X Wawona St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5982463.4 | 2096719.2 | 37.7361757338901 | -122.503121118731 | (37.7361757338901, -122.503121118731) | 1 | 8 | 3 | 29491 | 35 | ||||
| 194218 | 82349 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 238 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50654 | 6002996.74050399 | 2092045.80464214 | 37.7245291995552 | -122.431795416268 | (37.7245291995552, -122.431795416268) | 9 | 7 | 6 | 28861 | 5 | ||
| 163493 | 233513 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1001 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 0 | 6005382.19397 | 2097506.55271 | 37.7396581363049 | -122.423937343859 | (37.7396581363049, -122.423937343859) | 2 | 7 | 5 | 28859 | 2 | ||||
| 8775 | 186544 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 15 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984717.8085 | 2104869.8796 | 37.7586875278599 | -122.495927916751 | (37.7586875278599, -122.495927916751) | 1 | 8 | 3 | 56 | 35 | |||
| 20208 | 64478 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2463 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1988 12:00:00 AM | 1 | Permit Number 25351 | 5984544.9144 | 2098464.8556 | 37.7410909641146 | -122.496053326033 | (37.7410909641146, -122.496053326033) | 1 | 8 | 3 | 29491 | 35 | ||
| 25987 | 184067 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984923.6735 | 2103980.1419 | 37.7562566100874 | -122.495150341701 | (37.7562566100874, -122.495150341701) | 1 | 8 | 3 | 56 | 35 | |||
| 27641 | 181377 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1500 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984927.8892 | 2104435.2861 | 37.7575065566558 | -122.495169324722 | (37.7575065566558, -122.495169324722) | 1 | 8 | 3 | 56 | 35 | |||
| 28285 | 185702 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2101 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984899.336 | 2100502.102 | 37.7467054432069 | -122.494978063261 | (37.7467054432069, -122.494978063261) | 1 | 8 | 3 | 29491 | 35 | |||
| 32019 | 233567 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 526 Duncan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6003041.12582 | 2099793.00501 | 37.7458037587468 | -122.432194992624 | (37.7458037587468, -122.432194992624) | 2 | 7 | 5 | 63 | 22 | |||
| 37072 | 185600 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Quintara St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5989679.3737 | 2101097.9705 | 37.7486202073052 | -122.478492924032 | (37.7486202073052, -122.478492924032) | 1 | 8 | 3 | 29491 | 35 | |||
| 45357 | 211399 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 58 | : | Tree | Private 2 | 1 | Width 0ft | 5991315.94371 | 2093311.6752 | 37.7273358999139 | -122.472266228913 | (37.7273358999139, -122.472266228913) | 9 | 8 | 4 | 64 | 40 | |||
| 51215 | 139636 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 932 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000950.5576 | 2112049.201 | 37.7793375058125 | -122.440302654193 | (37.7793375058125, -122.440302654193) | 15 | 5 | 11 | 29490 | 41 | |||
| 58810 | 211398 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 57 | : | Tree | Private 2 | 1 | Width 0ft | 5991312.42459 | 2093316.55821 | 37.7273491037745 | -122.472278750188 | (37.7273491037745, -122.472278750188) | 9 | 8 | 4 | 64 | 40 | |||
| 61239 | 186542 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 13 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984733.3013 | 2104876.5792 | 37.7587068304654 | -122.495874830593 | (37.7587068304654, -122.495874830593) | 1 | 8 | 3 | 56 | 35 | |||
| 62658 | 187285 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2401 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984971.2258 | 2098277.6369 | 37.7406018726595 | -122.49456551882 | (37.7406018726595, -122.49456551882) | 1 | 8 | 3 | 29491 | 35 | |||
| 63730 | 186777 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984843.8908 | 2106796.6459 | 37.7639852728391 | -122.495633989763 | (37.7639852728391, -122.495633989763) | 1 | 8 | 3 | 56 | 35 | |||
| 67313 | 211397 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 56 | : | Tree | Private 2 | 1 | Width 0ft | 5991314.17721 | 2093323.33427 | 37.7273678105764 | -122.47227318518 | (37.7273678105764, -122.47227318518) | 9 | 8 | 4 | 64 | 40 | |||
| 69363 | 184071 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1600 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984926.5971 | 2103990.3748 | 37.7562848779586 | -122.495140985597 | (37.7562848779586, -122.495140985597) | 1 | 8 | 3 | 56 | 35 | |||
| 70045 | 184790 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1301 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984691.969 | 2105851.7842 | 37.7613820501849 | -122.496089721203 | (37.7613820501849, -122.496089721203) | 1 | 8 | 3 | 56 | 35 | |||
| 70729 | 181480 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1400 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984875.577 | 2105321.3408 | 37.7599363534607 | -122.495415585101 | (37.7599363534607, -122.495415585101) | 1 | 8 | 3 | 56 | 35 | |||
| 72190 | 186532 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 3 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984706.503 | 2104907.5647 | 37.7587903384946 | -122.495969795836 | (37.7587903384946, -122.495969795836) | 1 | 8 | 3 | 56 | 35 | |||
| 72529 | 233569 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 526 Duncan St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6003042.82855 | 2099802.56387 | 37.7458301016873 | -122.432189787355 | (37.7458301016873, -122.432189787355) | 2 | 7 | 5 | 63 | 22 | |||
| 73113 | 184820 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1201 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984629.3153 | 2106942.3382 | 37.7643727351397 | -122.496386882515 | (37.7643727351397, -122.496386882515) | 1 | 8 | 3 | 56 | 35 | |||
| 74021 | 185547 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984897.749 | 2099920.0449 | 37.7451071798584 | -122.494940640653 | (37.7451071798584, -122.494940640653) | 1 | 8 | 3 | 29491 | 35 | |||
| 79139 | 186782 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984846.8015 | 2106847.3412 | 37.7641246383354 | -122.495627662164 | (37.7641246383354, -122.495627662164) | 1 | 8 | 3 | 56 | 35 | |||
| 81777 | 194562 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 889 Vermont St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6011315.22024 | 2104197.07336 | 37.7583620186233 | -122.40389405447 | (37.7583620186233, -122.40389405447) | 10 | 3 | 8 | 28856 | 29 | ||||
| 82747 | 186767 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1200 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984852.1379 | 2106748.1337 | 37.7638525549077 | -122.4956018875 | (37.7638525549077, -122.4956018875) | 1 | 8 | 3 | 56 | 35 |
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) );