trees
229 rows where Police Districts = 5 and qSpecies_id = 8 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1004 | 50532 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47171 | 5996679.82856356 | 2106618.62344586 | 37.7641824656847 | -122.454684361894 | (37.7641824656847, -122.454684361894) | 15 | 5 | 11 | 29492 | 12 | |||
| 4498 | 58438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 3x3 | Permit Number 51484 | 5999161.38005537 | 2107089.77623283 | 37.7656181571992 | -122.446135313725 | (37.7656181571992, -122.446135313725) | 15 | 5 | 11 | 29492 | 9 | ||
| 13230 | 260498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 349 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6000178 | 2110153 | 37.7740870040886 | -122.442839045318 | (37.7740870040886, -122.442839045318) | 15 | 5 | 11 | 29492 | 16 | ||||
| 14615 | 260497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6000185 | 2110105 | 37.7739556073117 | -122.44281138372 | (37.7739556073117, -122.44281138372) | 15 | 5 | 11 | 29492 | 16 | ||||
| 30387 | 60896 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1992 12:00:00 AM | Permit Number 20684 | 5995496.17178877 | 2107213.04806332 | 37.7657466388052 | -122.458821302083 | (37.7657466388052, -122.458821302083) | 15 | 5 | 11 | 56 | 12 | ||
| 38788 | 46109 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 798 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | 3x3 | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | ||
| 42072 | 39611 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 786 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | 6x6 | Permit Number 44486 | 5998641.21928003 | 2107708.61027258 | 37.7672876005221 | -122.447978986539 | (37.7672876005221, -122.447978986539) | 15 | 5 | 11 | 29492 | 9 | |
| 47336 | 114900 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | Permit Number 775911 | 5994035.5 | 2105147.2 | 37.7599902919139 | -122.463723459922 | (37.7599902919139, -122.463723459922) | 1 | 5 | 4 | 56 | 12 | |||
| 49386 | 88828 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52530 | 6000678 | 2109601 | 37.7725998435487 | -122.441069852882 | (37.7725998435487, -122.441069852882) | 15 | 5 | 11 | 29492 | 9 | ||
| 56364 | 67198 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 49 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30650 | 5998389.1076576 | 2106230.44875795 | 37.7632145281987 | -122.448744521857 | (37.7632145281987, -122.448744521857) | 15 | 5 | 11 | 29492 | 9 | ||
| 63409 | 46246 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 107 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | 15 | 5 | 11 | 29492 | 9 | |||
| 63990 | 46247 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 107 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | 15 | 5 | 11 | 29492 | 9 | ||
| 66207 | 41815 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Barcelona Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42202 | 5999705.97173025 | 2112292.94161938 | 37.7799358147995 | -122.444625705837 | (37.7799358147995, -122.444625705837) | 15 | 5 | 1 | 29490 | 16 | ||
| 72578 | 257907 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 44 Clarendon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998004 | 2104650 | 37.7588529837709 | -122.449962562921 | (37.7588529837709, -122.449962562921) | 15 | 5 | 4 | 28862 | 38 | ||||
| 73087 | 88794 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1240 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2010 12:00:00 AM | 3x3 | Permit Number 51706 | 5994624.7 | 2107112.8 | 37.7654212536678 | -122.461828244278 | (37.7654212536678, -122.461828244278) | 15 | 5 | 11 | 56 | 12 | |||
| 77440 | 115160 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 77634 | 67192 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30642 | 5997398.59481409 | 2105779.27985473 | 37.7619190417907 | -122.452137804207 | (37.7619190417907, -122.452137804207) | 15 | 5 | 11 | 29492 | 12 | ||
| 79722 | 47754 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 719 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 45534 | 6003126.79155658 | 2109592.75856581 | 37.7727163895077 | -122.43259864509 | (37.7727163895077, -122.43259864509) | 15 | 5 | 11 | 29492 | 9 | ||
| 80102 | 88825 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52530 | 6000678 | 2109601 | 37.7725998435487 | -122.441069852882 | (37.7725998435487, -122.441069852882) | 15 | 5 | 11 | 29492 | 9 | ||
| 80181 | 59667 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 31 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32205 | 5998489.35496183 | 2105990.50764874 | 37.7625614421927 | -122.448380521343 | (37.7625614421927, -122.448380521343) | 15 | 5 | 11 | 29492 | 9 | ||
| 84552 | 46904 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1377 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44960 | 5994548.84037989 | 2106162.48962063 | 37.7628075813013 | -122.462021703411 | (37.7628075813013, -122.462021703411) | 1 | 5 | 11 | 56 | 12 | ||
| 91090 | 67135 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1331 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 30558 | 5994848.07934787 | 2106497.79434195 | 37.7637454647694 | -122.461011052487 | (37.7637454647694, -122.461011052487) | 15 | 5 | 11 | 56 | 12 | ||
| 92322 | 88205 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 241 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51210 | 5998774 | 2109909 | 37.7733369001006 | -122.447678136621 | (37.7733369001006, -122.447678136621) | 15 | 5 | 11 | 29492 | 16 | |||
| 108208 | 46111 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 798 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/2006 12:00:00 AM | 3x3 | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | |
| 110726 | 51799 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4846 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | Permit Number 48049 | 5998068.13353383 | 2105677.65225625 | 37.7616783285621 | -122.449814819276 | (37.7616783285621, -122.449814819276) | 15 | 5 | 11 | 29492 | 9 | |||
| 112647 | 68730 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 61 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50876 | 5998357.78422562 | 2106846.9101755 | 37.764905384605 | -122.448897266381 | (37.764905384605, -122.448897266381) | 15 | 5 | 11 | 29492 | 9 | ||
| 114458 | 88149 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 980 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51177 | 5999654.9 | 2101769.7 | 37.7510387106784 | -122.444046045087 | (37.7510387106784, -122.444046045087) | 2 | 5 | 5 | 63 | 38 | ||
| 116267 | 31709 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 494 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 3x3 | Permit Number 35209 | 5997243.8482988 | 2107438.78274184 | 37.7664667487492 | -122.452792790242 | (37.7664667487492, -122.452792790242) | 15 | 5 | 11 | 29492 | 9 | |
| 116668 | 54371 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1475 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50890 | 5994261.74442721 | 2105485.85462575 | 37.760933184118 | -122.46296556602 | (37.760933184118, -122.46296556602) | 1 | 5 | 11 | 56 | 12 | ||
| 116965 | 65907 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1385 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28916 | 5993931.02559851 | 2106089.21026455 | 37.7625707863634 | -122.464153170818 | (37.7625707863634, -122.464153170818) | 1 | 5 | 11 | 56 | 12 | ||
| 119910 | 115159 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 120751 | 46128 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 636 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | Permit Number 44478 | 5999007.45186043 | 2108568.17204311 | 37.7696686672108 | -122.446774101055 | (37.7696686672108, -122.446774101055) | 15 | 5 | 11 | 29492 | 9 | ||
| 125816 | 88827 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52530 | 6000678 | 2109601 | 37.7725998435487 | -122.441069852882 | (37.7725998435487, -122.441069852882) | 15 | 5 | 11 | 29492 | 9 | ||
| 126085 | 50948 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 200 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2004 12:00:00 AM | Permit Number 47443 | 6001908.432704 | 2108758.04383333 | 37.7703553018642 | -122.436753312122 | (37.7703553018642, -122.436753312122) | 15 | 5 | 11 | 29492 | 9 | |||
| 131090 | 94553 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 634 Clayton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53730 | 5998522 | 2108509 | 37.7694784520689 | -122.448448994315 | (37.7694784520689, -122.448448994315) | 15 | 5 | 11 | 29492 | 9 | ||
| 133465 | 59743 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4377 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22594 | 6000259.423804 | 2105746.15937443 | 37.7619915633709 | -122.442240971868 | (37.7619915633709, -122.442240971868) | 15 | 5 | 5 | 28862 | 3 | ||
| 133822 | 91144 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 574 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2009 12:00:00 AM | 3x3 | Permit Number 52029 | 5998646 | 2105859 | 37.7622093097711 | -122.447829277204 | (37.7622093097711, -122.447829277204) | 15 | 5 | 11 | 29492 | 9 | ||
| 135243 | 41814 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Barcelona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42202 | 5999705.97173025 | 2112292.94161938 | 37.7799358147995 | -122.444625705837 | (37.7799358147995, -122.444625705837) | 15 | 5 | 1 | 29490 | 16 | ||
| 138465 | 50181 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1223 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2003 12:00:00 AM | Permit Number 46888 | 5997714.25979523 | 2106396.55176256 | 37.7636319916344 | -122.4510905637 | (37.7636319916344, -122.4510905637) | 15 | 5 | 11 | 29492 | 9 | |||
| 139938 | 67136 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1340 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 30559 | 5994902.02611098 | 2106442.10113371 | 37.763595649797 | -122.46082043205 | (37.763595649797, -122.46082043205) | 15 | 5 | 11 | 56 | 12 | ||
| 153704 | 32795 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1701 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37158 | 5999667.64263466 | 2110499.43513135 | 37.7750091179441 | -122.444629358923 | (37.7750091179441, -122.444629358923) | 15 | 5 | 11 | 29492 | 16 | ||
| 154867 | 54507 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1216 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30517 | 5995821.5576283 | 2107222.6478093 | 37.7657916947959 | -122.457696564157 | (37.7657916947959, -122.457696564157) | 15 | 5 | 11 | 29492 | 12 | ||
| 157529 | 55450 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1238 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20687 | 5995498.97479315 | 2107131.57167312 | 37.7655230868492 | -122.458805707854 | (37.7655230868492, -122.458805707854) | 15 | 5 | 11 | 56 | 12 | ||
| 162573 | 62434 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4347 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22595 | 6000487.62701634 | 2105758.51838651 | 37.7620385014788 | -122.441452594893 | (37.7620385014788, -122.441452594893) | 15 | 5 | 5 | 28862 | 3 | ||
| 167235 | 39612 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 563 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41014 | 5996904.00542079 | 2107338.98044798 | 37.76617323756 | -122.453961030301 | (37.76617323756, -122.453961030301) | 15 | 5 | 11 | 29492 | 12 | ||
| 168985 | 41130 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2162 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41869 | 5997461.2 | 2110270 | 37.7742529957255 | -122.452245323936 | (37.7742529957255, -122.452245323936) | 15 | 5 | 2 | 29492 | 16 | ||
| 173356 | 88826 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52530 | 6000678 | 2109601 | 37.7725998435487 | -122.441069852882 | (37.7725998435487, -122.441069852882) | 15 | 5 | 11 | 29492 | 9 | ||
| 174292 | 61123 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2005 12:00:00 AM | Permit Number 28415 | 5996074.03225847 | 2106928.76760572 | 37.7649992759519 | -122.4568020568 | (37.7649992759519, -122.4568020568) | 15 | 5 | 11 | 29492 | 12 | ||
| 178149 | 115161 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 183766 | 46113 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 798 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | 3xe | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | ||
| 187067 | 88204 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 225 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51209 | 5998766 | 2109964 | 37.7734874588052 | -122.447709769744 | (37.7734874588052, -122.447709769744) | 15 | 5 | 11 | 29492 | 16 | |||
| 188515 | 111022 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1254 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993942 | 2106950 | 37.7649349225469 | -122.464177708405 | (37.7649349225469, -122.464177708405) | 11 | 5 | 11 | 56 | 12 | ||||
| 188777 | 67134 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1319 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 30557 | 5994845.70633792 | 2106566.77166106 | 37.7639347220406 | -122.461024259768 | (37.7639347220406, -122.461024259768) | 15 | 5 | 11 | 56 | 12 | ||
| 189274 | 46110 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 798 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | 3x3 | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | ||
| 189514 | 43646 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 620 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/2000 12:00:00 AM | 4.5x4.5 | Permit Number 43293 | 5998690.88618203 | 2105622.06186628 | 37.7615613024153 | -122.447656976488 | (37.7615613024153, -122.447656976488) | 15 | 5 | 11 | 29492 | 12 | |
| 189927 | 58574 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 131 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1992 12:00:00 AM | Permit Number 30452 | 5997850.5042079 | 2106776.22062192 | 37.7646822655699 | -122.450646713878 | (37.7646822655699, -122.450646713878) | 15 | 5 | 11 | 29492 | 9 | ||
| 190526 | 62432 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4411 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50975 | 5999996.18953726 | 2105731.90313751 | 37.7619374132884 | -122.443150369901 | (37.7619374132884, -122.443150369901) | 15 | 5 | 5 | 28862 | 3 | ||
| 192563 | 52642 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1382@ CENTRAL Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50986 | 5999953.27694394 | 2109203.69693502 | 37.7714676440206 | -122.443548192199 | (37.7714676440206, -122.443548192199) | 15 | 5 | 11 | 29492 | 9 | ||
| 193193 | 83529 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 801X Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3x3 | Permit Number 50887 | 5998610 | 2107600 | 37.7669875996224 | -122.448079148071 | (37.7669875996224, -122.448079148071) | 15 | 5 | 11 | 29492 | 9 | ||
| 4923 | 31224 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1386 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | 0 | Permit Number 42098 | 5999592.83400965 | 2107841.48506455 | 37.76770679076 | -122.444697050343 | (37.76770679076, -122.444697050343) | 15 | 5 | 11 | 29492 | 9 | ||
| 11873 | 224059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002696.79261 | 2106527.84926 | 37.7642765053752 | -122.433866946505 | (37.7642765053752, -122.433866946505) | 15 | 5 | 5 | 28862 | 3 | |||
| 28205 | 223464 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998616.14306 | 2107232.00709 | 37.7659775352626 | -122.448031401823 | (37.7659775352626, -122.448031401823) | 15 | 5 | 11 | 29492 | 9 | |||
| 31228 | 244888 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 158 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999901.22 | 2109095.6532 | 37.7711680141967 | -122.443720495999 | (37.7711680141967, -122.443720495999) | 15 | 5 | 11 | 29492 | 9 | |||
| 54630 | 245044 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 155 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000750.251 | 2109577.8851 | 37.7725404908768 | -122.440818271359 | (37.7725404908768, -122.440818271359) | 15 | 5 | 11 | 29492 | 9 | |||
| 91067 | 223453 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 832 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998055.72491 | 2107364.91893 | 37.7663104264995 | -122.449979345083 | (37.7663104264995, -122.449979345083) | 15 | 5 | 11 | 29492 | 9 | |||
| 129939 | 207696 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994014.568 | 2105145.1879 | 37.7599835610189 | -122.463795707001 | (37.7599835610189, -122.463795707001) | 1 | 5 | 4 | 56 | 12 | |||
| 138810 | 224077 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4333 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000578.70387 | 2105764.82815 | 37.762061014736 | -122.44113804889 | (37.762061014736, -122.44113804889) | 15 | 5 | 5 | 28862 | 3 | |||
| 173130 | 246060 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 627 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998490.4423 | 2108448.6979 | 37.7693110734878 | -122.448553807088 | (37.7693110734878, -122.448553807088) | 15 | 5 | 11 | 29492 | 9 | |||
| 177660 | 223463 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998590.56714 | 2107229.15156 | 37.7659682326767 | -122.448119657713 | (37.7659682326767, -122.448119657713) | 15 | 5 | 11 | 29492 | 9 | |||
| 180953 | 140730 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1801 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998825.1945 | 2110385.2461 | 37.7746474756927 | -122.447535336227 | (37.7746474756927, -122.447535336227) | 15 | 5 | 11 | 29492 | 16 | |||
| 5449 | 245103 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999859.4717 | 2109392.5831 | 37.7719809274281 | -122.443886241527 | (37.7719809274281, -122.443886241527) | 15 | 5 | 11 | 29492 | 9 | |||
| 13393 | 207553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993922.26035 | 2106313.56882 | 37.7631863112193 | -122.464199775125 | (37.7631863112193, -122.464199775125) | 1 | 5 | 11 | 56 | 12 | |||
| 35252 | 31682 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 61 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 10 | Permit Number 35188 | 5998292.66632 | 2107186.56904 | 37.765834277768 | -122.449146963179 | (37.765834277768, -122.449146963179) | 15 | 5 | 11 | 29492 | 9 | |
| 59849 | 223448 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997400.9085 | 2105772.15119 | 37.7618996008164 | -122.452129287752 | (37.7618996008164, -122.452129287752) | 15 | 5 | 11 | 29492 | 12 | |||
| 80482 | 224066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 249 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999824.86167 | 2105514.60319 | 37.7613309909564 | -122.443727312184 | (37.7613309909564, -122.443727312184) | 15 | 5 | 5 | 28862 | 3 | |||
| 129901 | 224081 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002846.5301 | 2108989.93169 | 37.7710452779528 | -122.433525010771 | (37.7710452779528, -122.433525010771) | 15 | 5 | 11 | 29492 | 9 | |||
| 172558 | 223449 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 133 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997855.21004 | 2106781.676 | 37.7646975140134 | -122.45063083107 | (37.7646975140134, -122.45063083107) | 15 | 5 | 11 | 29492 | 9 | |||
| 20827 | 248510 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 167 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998265.1375 | 2107816.9964 | 37.767563696861 | -122.449287603561 | (37.767563696861, -122.449287603561) | 15 | 5 | 11 | 29492 | 9 | |||
| 50886 | 224065 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 249 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999809.62002 | 2105505.92118 | 37.7613062829657 | -122.443779402711 | (37.7613062829657, -122.443779402711) | 15 | 5 | 5 | 28862 | 3 | |||
| 60325 | 217746 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 631 Frederick St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 5996538.5455 | 2107286.52393 | 37.7660082444099 | -122.455221286434 | (37.7660082444099, -122.455221286434) | 15 | 5 | 11 | 29492 | 12 | |||
| 86898 | 207627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 335 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994699.18168 | 2107000.82647 | 37.7651180909611 | -122.461562512304 | (37.7651180909611, -122.461562512304) | 15 | 5 | 11 | 56 | 12 | |||
| 86969 | 207552 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993922.19207 | 2106326.17113 | 37.7632209099368 | -122.464200926233 | (37.7632209099368, -122.464200926233) | 1 | 5 | 11 | 56 | 12 | |||
| 98021 | 244489 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1314 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000169.4163 | 2109230.0491 | 37.7715523247212 | -122.442802449862 | (37.7715523247212, -122.442802449862) | 15 | 5 | 11 | 29492 | 9 | |||
| 108481 | 224076 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4347 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000486.58974 | 2105759.50632 | 37.7620411550071 | -122.441456253314 | (37.7620411550071, -122.441456253314) | 15 | 5 | 5 | 28862 | 3 | |||
| 109851 | 207662 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1203 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5996707.43605 | 2107271.27987 | 37.7659760765509 | -122.454636030138 | (37.7659760765509, -122.454636030138) | 15 | 5 | 11 | 29492 | 12 | |||
| 119980 | 224070 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4411 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000003.97958 | 2105733.89471 | 37.7619433258348 | -122.443123570319 | (37.7619433258348, -122.443123570319) | 15 | 5 | 5 | 28862 | 3 | |||
| 143799 | 207554 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993924.42937 | 2106289.97984 | 37.7631216670542 | -122.46419056067 | (37.7631216670542, -122.46419056067) | 1 | 5 | 11 | 56 | 12 | |||
| 151465 | 207550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993920.73068 | 2106351.7347 | 37.7632910165944 | -122.464207836628 | (37.7632910165944, -122.464207836628) | 1 | 5 | 11 | 56 | 12 | |||
| 152784 | 207634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1377 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5994548.55797 | 2106167.4368 | 37.7628211487125 | -122.462023038935 | (37.7628211487125, -122.462023038935) | 1 | 5 | 11 | 56 | 12 | |||
| 159154 | 207551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993920.84097 | 2106341.12127 | 37.7632618812439 | -122.464206684615 | (37.7632618812439, -122.464206684615) | 1 | 5 | 11 | 56 | 12 | |||
| 189192 | 207659 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1340 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5994898.23943 | 2106428.28078 | 37.7635574848094 | -122.460832527225 | (37.7635574848094, -122.460832527225) | 15 | 5 | 11 | 56 | 12 | |||
| 24617 | 207548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993918.37336 | 2106436.18995 | 37.7635227727814 | -122.464222121451 | (37.7635227727814, -122.464222121451) | 1 | 5 | 11 | 56 | 12 | |||
| 78417 | 207663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5996706.11666 | 2107295.55996 | 37.7660426677731 | -122.454642347884 | (37.7660426677731, -122.454642347884) | 15 | 5 | 11 | 29492 | 12 | |||
| 90320 | 223462 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 801 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998613.88681 | 2107552.61 | 37.766857700856 | -122.448062291746 | (37.766857700856, -122.448062291746) | 15 | 5 | 11 | 29492 | 9 | |||
| 105337 | 207555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993925.10789 | 2106274.71202 | 37.7630797847136 | -122.464187105451 | (37.7630797847136, -122.464187105451) | 1 | 5 | 11 | 56 | 12 | |||
| 129950 | 6373 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000795.1374 | 2112740.1737 | 37.7812258903975 | -122.440889897719 | (37.7812258903975, -122.440889897719) | 15 | 5 | 1 | 29490 | 41 | |||
| 150505 | 244490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1316 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000139.8345 | 2109225.3958 | 37.7715378614524 | -122.442904440425 | (37.7715378614524, -122.442904440425) | 15 | 5 | 11 | 29492 | 9 | |||
| 157791 | 223517 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 980 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999663.10864 | 2101754.10727 | 37.7509963650963 | -122.44401653863 | (37.7509963650963, -122.44401653863) | 2 | 5 | 5 | 63 | 38 | |||
| 178104 | 224060 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 191 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001739.33994 | 2107707.04853 | 37.767459917457 | -122.437262937651 | (37.767459917457, -122.437262937651) | 15 | 5 | 5 | 29492 | 3 | |||
| 184289 | 207549 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 07th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993919.81303 | 2106419.06836 | 37.7634758443473 | -122.464215899053 | (37.7634758443473, -122.464215899053) | 1 | 5 | 11 | 56 | 12 |
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) );