trees
713 rows where qSpecies_id = 102 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4056 | 249318 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
11345 | 140075 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 544 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005143.7718 | 2111312.9909 | 37.7775539050019 | -122.425744146907 | (37.7775539050019, -122.425744146907) | 7 | 9 | 11 | 28852 | 10 | |||
11641 | 223098 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004264.58531 | 2109293.13989 | 37.7719581680779 | -122.428641529305 | (37.7719581680779, -122.428641529305) | 7 | 9 | 11 | 28852 | 10 | |||
23956 | 255489 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 415 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781958 | 6004580.17678 | 2109974.62519 | 37.7738472162761 | -122.427598435585 | (37.7738472162761, -122.427598435585) | 7 | 9 | 11 | 28852 | 10 |
29934 | 49988 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 300@ GOUGH Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2003 12:00:00 AM | 2 | Permit Number 46733 | 6005922.1673 | 2110886.7951 | 37.7764276301155 | -122.423021112586 | (37.7764276301155, -122.423021112586) | 7 | 9 | 11 | 28852 | 10 | ||
55577 | 47062 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45049 | 6004269.57542485 | 2109262.75093616 | 37.7718750098204 | -122.42862210153 | (37.7718750098204, -122.42862210153) | 7 | 9 | 11 | 28852 | 10 | ||
75618 | 47063 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45049 | 6004269.57542485 | 2109262.75093616 | 37.7718750098204 | -122.42862210153 | (37.7718750098204, -122.42862210153) | 7 | 9 | 11 | 28852 | 10 | |||
108678 | 244958 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 270 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005192.4053 | 2109747.089 | 37.7732570676035 | -122.425464439836 | (37.7732570676035, -122.425464439836) | 7 | 9 | 11 | 28852 | 10 | |||
113277 | 42782 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 200 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42750 | 6005188.63098476 | 2109645.76261136 | 37.7729786366348 | -122.425470283277 | (37.7729786366348, -122.425470283277) | 7 | 9 | 11 | 28852 | 10 | |||
120424 | 47060 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 114 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45048 | 6004275.94265243 | 2109216.94695979 | 37.7717496035942 | -122.428596811267 | (37.7717496035942, -122.428596811267) | 7 | 9 | 11 | 28852 | 10 | |||
172267 | 244962 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 202 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005157.1549 | 2109800.5724 | 37.7734019283256 | -122.425590183018 | (37.7734019283256, -122.425590183018) | 7 | 9 | 11 | 28852 | 10 | |||
176535 | 223097 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 124 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004260.2997 | 2109306.43724 | 37.7719944368218 | -122.428657301609 | (37.7719944368218, -122.428657301609) | 7 | 9 | 11 | 28852 | 10 | |||
8184 | 82951 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 660X Clementina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | 3 | 3x3 | Permit Number 52432 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 |
10416 | 42198 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1108 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42472 | 6010019.96061049 | 2108918.62513791 | 37.7712538746338 | -122.408706742901 | (37.7712538746338, -122.408706742901) | 8 | 2 | 9 | 28853 | 34 | ||
18332 | 223062 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 257 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007025.24447 | 2107893.6932 | 37.7682714683756 | -122.41899290632 | (37.7682714683756, -122.41899290632) | 8 | 4 | 7 | 28853 | 19 | |||
37017 | 223065 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 436 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005845.27485 | 2107876.32583 | 37.7681572661617 | -122.423073077374 | (37.7681572661617, -122.423073077374) | 8 | 4 | 5 | 28853 | 19 | |||
54040 | 36674 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1688 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39479 | 6006203.35466934 | 2107311.37468916 | 37.7666262444629 | -122.421794380159 | (37.7666262444629, -122.421794380159) | 8 | 4 | 7 | 28853 | 19 | ||
64942 | 223096 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 32 Hidalgo Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004965.45271 | 2107513.10439 | 37.7671102592495 | -122.426090433249 | (37.7671102592495, -122.426090433249) | 8 | 4 | 5 | 28853 | 19 | |||
95582 | 38248 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 229 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40359 | 6007173.84048411 | 2107898.39923315 | 37.7682927564576 | -122.418479259688 | (37.7682927564576, -122.418479259688) | 8 | 4 | 7 | 28853 | 19 | |||
98791 | 223063 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 245 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007064.74845 | 2107895.30942 | 37.7682781305518 | -122.418856380225 | (37.7682781305518, -122.418856380225) | 8 | 4 | 7 | 28853 | 19 | |||
101560 | 88357 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 245 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51336 | 6008270 | 2109444 | 37.7725982617206 | -122.414797136624 | (37.7725982617206, -122.414797136624) | 8 | 2 | 9 | 28853 | 34 | ||
105813 | 95818 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 679 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767556 | 6009585 | 2110509 | 37.7755963018026 | -122.410323605803 | (37.7755963018026, -122.410323605803) | 8 | 2 | 9 | 28853 | 34 | |
107971 | 36670 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 436 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39476 | 6005855.91520687 | 2107877.41671779 | 37.7681608619134 | -122.423036350967 | (37.7681608619134, -122.423036350967) | 8 | 4 | 5 | 28853 | 19 | ||
111703 | 36669 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 227 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39475 | 6007187.51257647 | 2107899.1578032 | 37.7682956089816 | -122.418432022919 | (37.7682956089816, -122.418432022919) | 8 | 4 | 7 | 28853 | 19 | ||
116228 | 82950 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 660X Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52432 | 6009636 | 2110586 | 37.7758105844997 | -122.410152621086 | (37.7758105844997, -122.410152621086) | 8 | 2 | 9 | 28853 | 34 |
125167 | 223064 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 227 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007193.29564 | 2107902.3787 | 37.7683047783566 | -122.418412248219 | (37.7683047783566, -122.418412248219) | 8 | 4 | 7 | 28853 | 19 | |||
138883 | 88356 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 245 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51336 | 6008270 | 2109444 | 37.7725982617206 | -122.414797136624 | (37.7725982617206, -122.414797136624) | 8 | 2 | 9 | 28853 | 34 | ||
153009 | 88358 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 245 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51336 | 6008270 | 2109444 | 37.7725982617206 | -122.414797136624 | (37.7725982617206, -122.414797136624) | 8 | 2 | 9 | 28853 | 34 | ||
162293 | 84596 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 660-668 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50124 | 6009623.56460334 | 2110595.7986646 | 37.7758367923088 | -122.410196330421 | (37.7758367923088, -122.410196330421) | 8 | 2 | 9 | 28853 | 34 |
181443 | 39312 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 257 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40890 | 6007011.30280747 | 2107889.38110273 | 37.7682588432998 | -122.419040823391 | (37.7682588432998, -122.419040823391) | 8 | 4 | 7 | 28853 | 19 | ||
67391 | 173674 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
92116 | 173673 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
182808 | 173672 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
415 | 190934 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015168.60212 | 2102024.17667 | 37.7526102335912 | -122.390415424833 | (37.7526102335912, -122.390415424833) | 10 | 3 | 8 | 28856 | 1 | |||
4597 | 190929 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015301.73602 | 2102030.54675 | 37.752635108841 | -122.389955465678 | (37.752635108841, -122.389955465678) | 10 | 3 | 8 | 28856 | 1 | |||
17734 | 47651 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 363 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 4 | Permit Number 45455 | 6012960.30928 | 2105372.99833 | 37.761682620471 | -122.3982870765 | (37.761682620471, -122.3982870765) | 10 | 3 | 8 | 28856 | 29 | |
20547 | 190947 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 40 Bluxome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6013395.86609 | 2110840.5938 | 37.7767196691005 | -122.397164055286 | (37.7767196691005, -122.397164055286) | 6 | 2 | 9 | 28856 | 34 | |||
20685 | 103447 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 24 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
24718 | 190936 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012268.87212 | 2103730.35281 | 37.7571337389375 | -122.400563099634 | (37.7571337389375, -122.400563099634) | 10 | 3 | 8 | 28856 | 29 | |||
27906 | 103441 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
28151 | 190948 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 40 Bluxome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6013368.27074 | 2110817.70841 | 37.7766552947402 | -122.397257911242 | (37.7766552947402, -122.397257911242) | 6 | 2 | 9 | 28856 | 34 | |||
29107 | 190945 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 40 Bluxome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6013445.03636 | 2110888.0497 | 37.7768527094247 | -122.396997287698 | (37.7768527094247, -122.396997287698) | 6 | 2 | 9 | 28856 | 34 | |||
31335 | 42183 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 730 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42467 | 6012299.41281254 | 2111097.65921114 | 37.7773644110039 | -122.400975101339 | (37.7773644110039, -122.400975101339) | 14 | 2 | 9 | 28856 | 34 | ||
36801 | 39544 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1947 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52628 | 6012257.26801 | 2103730.73131 | 37.7571341310464 | -122.400603257944 | (37.7571341310464, -122.400603257944) | 10 | 3 | 8 | 28856 | 29 | |
37015 | 39548 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40973 | 6012286.64815743 | 2103730.55141744 | 37.7571352756248 | -122.400501636831 | (37.7571352756248, -122.400501636831) | 10 | 3 | 8 | 28856 | 29 | ||
55677 | 103442 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
65127 | 190935 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 767 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6011029.84564 | 2104766.51746 | 37.7599096376513 | -122.404921103652 | (37.7599096376513, -122.404921103652) | 10 | 3 | 8 | 28856 | 29 | |||
73475 | 103443 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
79480 | 190937 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6012285.9595 | 2103731.71906 | 37.7571384433095 | -122.400504100505 | (37.7571384433095, -122.400504100505) | 10 | 3 | 8 | 28856 | 29 | |||
79677 | 39542 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1947 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52628 | 6012231.74927 | 2103730.67877 | 37.757132563538 | -122.400691508412 | (37.757132563538, -122.400691508412) | 10 | 3 | 8 | 28856 | 29 | |
81028 | 103428 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
83968 | 103448 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 25 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
92271 | 39546 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40973 | 6012286.64815743 | 2103730.55141744 | 37.7571352756248 | -122.400501636831 | (37.7571352756248, -122.400501636831) | 10 | 3 | 8 | 28856 | 29 | ||
92337 | 103429 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
104003 | 39545 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52628 | 6012317.54572 | 2103734.07541 | 37.7571466747898 | -122.40039502803 | (37.7571466747898, -122.40039502803) | 10 | 3 | 8 | 28856 | 29 | |
108831 | 190930 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015277.62058 | 2102029.1535 | 37.7526299458258 | -122.390038764478 | (37.7526299458258, -122.390038764478) | 10 | 3 | 8 | 28856 | 1 | |||
111529 | 103439 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
114299 | 190932 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 9ft | 6015229.59957 | 2102026.97334 | 37.7526212961411 | -122.390204678629 | (37.7526212961411, -122.390204678629) | 10 | 3 | 8 | 28856 | 1 | |||
116670 | 49954 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1704@ ARKANSAS 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 2 | 3x3 | Permit Number 46735 | 6012896.20183 | 2104748.72577 | 37.7599649342604 | -122.39846499386 | (37.7599649342604, -122.39846499386) | 10 | 3 | 8 | 28856 | 29 |
122814 | 103435 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
123570 | 190938 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6012303.18984 | 2103733.08208 | 37.7571431467556 | -122.400444606729 | (37.7571431467556, -122.400444606729) | 10 | 3 | 8 | 28856 | 29 | |||
135307 | 40184 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1402 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1999 12:00:00 AM | 3 | 9x6 | Permit Number 41371 | 6013366.18337 | 2105703.90093 | 37.7626138064095 | -122.396906512841 | (37.7626138064095, -122.396906512841) | 14 | 3 | 8 | 28856 | 29 | |
145281 | 39543 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1947 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52628 | 6012246.93603 | 2103730.22749 | 37.7571321714345 | -122.400638954732 | (37.7571321714345, -122.400638954732) | 10 | 3 | 8 | 28856 | 29 | |
158047 | 39547 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40973 | 6012286.64815743 | 2103730.55141744 | 37.7571352756248 | -122.400501636831 | (37.7571352756248, -122.400501636831) | 10 | 3 | 8 | 28856 | 29 | ||
159372 | 103433 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
160032 | 103444 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 21 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
165939 | 103440 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
166719 | 190933 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015201.2247 | 2102025.49065 | 37.7526156511008 | -122.390302701123 | (37.7526156511008, -122.390302701123) | 10 | 3 | 8 | 28856 | 1 | |||
180455 | 190931 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 9ft | 6015254.41614 | 2102028.26395 | 37.752626216333 | -122.390118948029 | (37.752626216333, -122.390118948029) | 10 | 3 | 8 | 28856 | 1 | |||
185180 | 42184 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 730 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42467 | 6012299.41281254 | 2111097.65921114 | 37.7773644110039 | -122.400975101339 | (37.7773644110039, -122.400975101339) | 14 | 2 | 9 | 28856 | 34 | ||
77921 | 41778 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2237 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770942 | 6006325.04545 | 2118559.33959 | 37.7975172684732 | -122.422172662639 | (37.7975172684732, -122.422172662639) | 13 | 9 | 10 | 28858 | 32 |
1780 | 223125 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1105 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009223.64941 | 2102625.89478 | 37.7539308430518 | -122.411016683293 | (37.7539308430518, -122.411016683293) | 2 | 4 | 7 | 28859 | 19 | |||
3357 | 223122 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 148 Ellert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007428.54288 | 2096958.74229 | 37.7382692862941 | -122.416823127285 | (37.7382692862941, -122.416823127285) | 2 | 7 | 7 | 28859 | 2 | |||
6544 | 223185 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105x Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007139 | 2097159 | 37.7388028593756 | -122.417838417363 | (37.7388028593756, -122.417838417363) | 2 | 7 | 7 | 28859 | 2 | |||
7017 | 223186 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105x Bennington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007192 | 2097251 | 37.7390584535481 | -122.417661686747 | (37.7390584535481, -122.417661686747) | 2 | 7 | 7 | 28859 | 2 | |||
9146 | 32509 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 718 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 6 | 2.5x3 | Permit Number 37011 | 6007605.33765 | 2096031.84482 | 37.7357341720927 | -122.416146230064 | (37.7357341720927, -122.416146230064) | 2 | 7 | 7 | 28859 | 2 |
9182 | 223199 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2957 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009122.48149 | 2102727.86117 | 37.7542051461569 | -122.411373750107 | (37.7542051461569, -122.411373750107) | 2 | 4 | 7 | 28859 | 19 | |||
13495 | 223059 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 154 Tiffany Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6006099.59544 | 2099325.6028 | 37.7446933136478 | -122.421586033986 | (37.7446933136478, -122.421586033986) | 2 | 7 | 5 | 28859 | 2 | |||
13635 | 261439 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 374x Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007239 | 2095686 | 37.7347639531109 | -122.417388303298 | (37.7347639531109, -122.417388303298) | 2 | 7 | 7 | 28859 | 2 | ||||
14459 | 223187 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105x Bennington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007139 | 2097159 | 37.7388028593756 | -122.417838417363 | (37.7388028593756, -122.417838417363) | 2 | 7 | 7 | 28859 | 2 | |||
15984 | 52285 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 49 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48443 | 6005568.13669376 | 2099312.5052799 | 37.7446273691442 | -122.423422786255 | (37.7446273691442, -122.423422786255) | 2 | 7 | 5 | 28859 | 22 | ||
17067 | 223124 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 99x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
17578 | 223163 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 220 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6008988.9604 | 2097329.9937 | 37.7393763076577 | -122.411454173775 | (37.7393763076577, -122.411454173775) | 10 | 7 | 7 | 28859 | 2 | |||
18133 | 48935 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2743 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46123 | 6008967.24880953 | 2102489.58925571 | 37.7535421972635 | -122.411893748881 | (37.7535421972635, -122.411893748881) | 2 | 4 | 7 | 28859 | 19 | ||
19006 | 259153 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 207 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007591 | 2097689 | 37.7402835491894 | -122.416313137546 | (37.7402835491894, -122.416313137546) | 2 | 7 | 7 | 28859 | 2 | ||||
19857 | 223198 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2901 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009412.47335 | 2102745.855 | 37.7542708137705 | -122.410372152653 | (37.7542708137705, -122.410372152653) | 2 | 4 | 7 | 28859 | 19 | |||
19895 | 223061 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3705 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005700.15311 | 2101372.39104 | 37.750290794794 | -122.423112686203 | (37.750290794794, -122.423112686203) | 2 | 4 | 5 | 28859 | 19 | |||
20720 | 223188 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 100 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007765.60912 | 2096998.87207 | 37.7383984271532 | -122.415660555692 | (37.7383984271532, -122.415660555692) | 2 | 7 | 7 | 28859 | 2 | |||
20837 | 39081 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 816 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40779 | 6009882.35970531 | 2104453.69348919 | 37.758986484759 | -122.408867645938 | (37.758986484759, -122.408867645938) | 2 | 4 | 7 | 28859 | 19 | ||
21672 | 36567 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 281 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/1998 12:00:00 AM | Permit Number 39429 | 6006271.54294487 | 2096111.84764875 | 37.7358787559596 | -122.420763362902 | (37.7358787559596, -122.420763362902) | 2 | 7 | 7 | 28859 | 2 | ||
24836 | 96563 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 567 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2011 12:00:00 AM | Permit Number 767781 | 6007698 | 2096716 | 37.7376179219065 | -122.415874290579 | (37.7376179219065, -122.415874290579) | 2 | 7 | 7 | 28859 | 2 | ||||
24895 | 35947 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 354 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39109 | 6007155.94334709 | 2095722.46816688 | 37.734859413246 | -122.417678043362 | (37.734859413246, -122.417678043362) | 2 | 7 | 7 | 28859 | 2 | ||
26989 | 42903 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3267 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42817 | 6007744.73028146 | 2104990.07889872 | 37.7603393072133 | -122.416298586055 | (37.7603393072133, -122.416298586055) | 2 | 4 | 7 | 28859 | 19 | ||
27660 | 36691 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 15 Bird St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39490 | 6005970.65710535 | 2105699.54901563 | 37.7621874267643 | -122.42248469974 | (37.7621874267643, -122.42248469974) | 8 | 4 | 5 | 28859 | 19 | ||
28412 | 223085 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1383 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010105.40683 | 2101175.29906 | 37.7499972353919 | -122.407865061343 | (37.7499972353919, -122.407865061343) | 2 | 4 | 7 | 28859 | 19 | |||
30784 | 84349 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 333 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50602 | 6006744.47832295 | 2104177.6342219 | 37.758052226043 | -122.419700351439 | (37.758052226043, -122.419700351439) | 2 | 4 | 7 | 28859 | 19 | ||
32339 | 223182 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 300 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006910.11223 | 2097068.32628 | 37.7385410056619 | -122.41862337757 | (37.7385410056619, -122.41862337757) | 2 | 7 | 7 | 28859 | 2 | |||
35923 | 40727 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 242 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2002 12:00:00 AM | Permit Number 41706 | 6008971.38235478 | 2097242.21876487 | 37.7391343108464 | -122.411508751405 | (37.7391343108464, -122.411508751405) | 10 | 7 | 7 | 28859 | 2 | ||
36056 | 83944 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2619 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52652 | 6010400.97039498 | 2103382.22541329 | 37.7560735087835 | -122.406998516177 | (37.7560735087835, -122.406998516177) | 10 | 4 | 7 | 28859 | 19 | ||
36063 | 223116 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 13 Stoneman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008405.91567 | 2099418.14842 | 37.7450772000642 | -122.413617744757 | (37.7450772000642, -122.413617744757) | 2 | 7 | 7 | 28859 | 2 |
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) );