trees
1,914 rows where qSpecies_id = 45 sorted by qSiteInfo descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 295 | 200164 | DPW Maintained 1 | :: 45 | 1027 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014014.4798 | 2089939.2839 | 37.7193635176037 | -122.393560894555 | (37.7193635176037, -122.393560894555) | 10 | 3 | 8 | 58 | 1 | |||
| 8110 | 200249 | DPW Maintained 1 | :: 45 | 1067 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013803.2037 | 2090093.549 | 37.7197753570889 | -122.394301997885 | (37.7197753570889, -122.394301997885) | 10 | 3 | 8 | 58 | 1 | |||
| 9415 | 200180 | DPW Maintained 1 | :: 45 | 1031 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014690.5634 | 2089785.0188 | 37.7189774793874 | -122.391213128817 | (37.7189774793874, -122.391213128817) | 10 | 3 | 8 | 58 | 1 | |||
| 9942 | 200177 | DPW Maintained 1 | :: 45 | 1041 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014650.3204 | 2089811.8475 | 37.7190489123065 | -122.39135410876 | (37.7190489123065, -122.39135410876) | 10 | 3 | 8 | 58 | 1 | |||
| 12451 | 200191 | DPW Maintained 1 | :: 45 | 981 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014255.2675 | 2089757.5194 | 37.7188778046353 | -122.392715865878 | (37.7188778046353, -122.392715865878) | 10 | 3 | 8 | 58 | 1 | |||
| 26314 | 200498 | DPW Maintained 1 | :: 45 | 1055 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013869.6047 | 2090039.2209 | 37.7196298737115 | -122.394068670065 | (37.7196298737115, -122.394068670065) | 10 | 3 | 8 | 58 | 1 | |||
| 28805 | 200245 | DPW Maintained 1 | :: 45 | 1075 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013768.3263 | 2090118.3656 | 37.7198415597531 | -122.394424294358 | (37.7198415597531, -122.394424294358) | 10 | 3 | 8 | 58 | 1 | |||
| 50825 | 200155 | DPW Maintained 1 | :: 45 | 1091 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014363.9238 | 2090021.1115 | 37.7196076106807 | -122.392358707449 | (37.7196076106807, -122.392358707449) | 10 | 3 | 8 | 58 | 1 | |||
| 62362 | 200730 | DPW Maintained 1 | :: 45 | 1466 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015770.4184 | 2094966.2292 | 37.73326392707 | -122.387841787924 | (37.73326392707, -122.387841787924) | 10 | 3 | 8 | 58 | 1 | |||
| 62817 | 200162 | DPW Maintained 1 | :: 45 | 1035 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013970.2124 | 2089969.4662 | 37.7194439323961 | -122.393716023061 | (37.7194439323961, -122.393716023061) | 10 | 3 | 8 | 58 | 1 | |||
| 66506 | 200248 | DPW Maintained 1 | :: 45 | 1107 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014274.7183 | 2090092.8783 | 37.7197997141545 | -122.392672078819 | (37.7197997141545, -122.392672078819) | 10 | 3 | 8 | 58 | 1 | |||
| 69996 | 200194 | DPW Maintained 1 | :: 45 | 1011 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014781.1104 | 2089713.252 | 37.7187854464432 | -122.390895127615 | (37.7187854464432, -122.390895127615) | 10 | 3 | 8 | 58 | 1 | |||
| 71785 | 200213 | DPW Maintained 1 | :: 45 | 1101 Ingerson Ave | 2 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013590.5861 | 2090251.1677 | 37.7201963256026 | -122.395047981349 | (37.7201963256026, -122.395047981349) | 10 | 3 | 8 | 58 | 1 | |||
| 75061 | 200171 | DPW Maintained 1 | :: 45 | 1059 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014549.7127 | 2089886.9679 | 37.7192495938582 | -122.391707122944 | (37.7192495938582, -122.391707122944) | 10 | 3 | 8 | 58 | 1 | |||
| 77012 | 200166 | DPW Maintained 1 | :: 45 | 1023 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014031.9185 | 2089919.1624 | 37.7193092369184 | -122.393499207549 | (37.7193092369184, -122.393499207549) | 10 | 3 | 8 | 58 | 1 | |||
| 86077 | 200212 | DPW Maintained 1 | :: 45 | 1101 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013545.648 | 2090276.655 | 37.7202638095936 | -122.395205102903 | (37.7202638095936, -122.395205102903) | 10 | 3 | 8 | 58 | 1 | |||
| 94232 | 200742 | DPW Maintained 1 | :: 45 | 1454 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015834.4667 | 2094922.2745 | 37.7331467841736 | -122.387617287866 | (37.7331467841736, -122.387617287866) | 10 | 3 | 8 | 58 | 1 | |||
| 95954 | 200161 | DPW Maintained 1 | :: 45 | 1083 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014425.6299 | 2089982.8806 | 37.7195060625081 | -122.392142737787 | (37.7195060625081, -122.392142737787) | 10 | 3 | 8 | 58 | 1 | |||
| 97709 | 200156 | DPW Maintained 1 | :: 45 | 1047 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013914.5428 | 2090009.7093 | 37.7195513382693 | -122.39391126933 | (37.7195513382693, -122.39391126933) | 10 | 3 | 8 | 58 | 1 | |||
| 100708 | 200169 | DPW Maintained 1 | :: 45 | 1061 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014525.5668 | 2089911.1138 | 37.7193145533562 | -122.391792274296 | (37.7193145533562, -122.391792274296) | 10 | 3 | 8 | 58 | 1 | |||
| 103836 | 200167 | DPW Maintained 1 | :: 45 | 1019 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014049.3571 | 2089910.443 | 37.7192862641022 | -122.393438318502 | (37.7192862641022, -122.393438318502) | 10 | 3 | 8 | 58 | 1 | |||
| 107754 | 200193 | DPW Maintained 1 | :: 45 | 975 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014303.5592 | 2089724.6542 | 37.7187902452961 | -122.392546641558 | (37.7187902452961, -122.392546641558) | 10 | 3 | 8 | 58 | 1 | |||
| 115629 | 200244 | DPW Maintained 1 | :: 45 | 1123 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014193.5615 | 2090152.5722 | 37.7199591140845 | -122.392956785762 | (37.7199591140845, -122.392956785762) | 10 | 3 | 8 | 58 | 1 | |||
| 118244 | 200165 | DPW Maintained 1 | :: 45 | 1071 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014485.3238 | 2089939.2839 | 37.7193896687982 | -122.391933349185 | (37.7193896687982, -122.391933349185) | 10 | 3 | 8 | 58 | 1 | |||
| 122628 | 200190 | DPW Maintained 1 | :: 45 | 1027 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014706.6607 | 2089771.6044 | 37.7189415394071 | -122.391156549139 | (37.7189415394071, -122.391156549139) | 10 | 3 | 8 | 58 | 1 | |||
| 123816 | 200722 | DPW Maintained 1 | :: 45 | 1476 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015747.1852 | 2094980.6714 | 37.7333022953684 | -122.387923119588 | (37.7333022953684, -122.387923119588) | 10 | 3 | 8 | 58 | 1 | |||
| 125844 | 200178 | DPW Maintained 1 | :: 45 | 3201 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014218.378 | 2089782.3359 | 37.7189438969212 | -122.39284511455 | (37.7189438969212, -122.39284511455) | 10 | 3 | 8 | 58 | 1 | |||
| 128848 | 200239 | DPW Maintained 1 | :: 45 | 1131 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014148.6234 | 2090188.791 | 37.7200560674381 | -122.393114655414 | (37.7200560674381, -122.393114655414) | 10 | 3 | 8 | 58 | 1 | |||
| 130912 | 200238 | DPW Maintained 1 | :: 45 | 917 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014595.9922 | 2089500.6344 | 37.7181913669776 | -122.391520156023 | (37.7181913669776, -122.391520156023) | 10 | 3 | 8 | 58 | 1 | |||
| 143855 | 200204 | DPW Maintained 1 | :: 45 | 2 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014372.6432 | 2089670.326 | 37.7186449071271 | -122.392304046142 | (37.7186449071271, -122.392304046142) | 10 | 3 | 8 | 58 | 1 | |||
| 145711 | 200183 | DPW Maintained 1 | :: 45 | 1197 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013828.6909 | 2090422.2008 | 37.7206791862384 | -122.394236894514 | (37.7206791862384, -122.394236894514) | 10 | 3 | 8 | 58 | 1 | |||
| 148127 | 200205 | DPW Maintained 1 | :: 45 | 1003 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014813.9755 | 2089679.7161 | 37.7186951869692 | -122.390779182777 | (37.7186951869692, -122.390779182777) | 10 | 3 | 8 | 58 | 1 | |||
| 157514 | 200157 | DPW Maintained 1 | :: 45 | 1091 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014392.094 | 2090006.3557 | 37.7195686584119 | -122.392260301004 | (37.7195686584119, -122.392260301004) | 10 | 3 | 8 | 58 | 1 | |||
| 191663 | 200246 | DPW Maintained 1 | :: 45 | 1071 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013781.7407 | 2090110.9877 | 37.719822047209 | -122.394377408818 | (37.719822047209, -122.394377408818) | 10 | 3 | 8 | 58 | 1 | |||
| 191797 | 200172 | DPW Maintained 1 | :: 45 | 1053 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014576.5414 | 2089866.8464 | 37.7191958334242 | -122.391612979464 | (37.7191958334242, -122.391612979464) | 10 | 3 | 8 | 58 | 1 | |||
| 192580 | 200170 | DPW Maintained 1 | :: 45 | 1001 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014099.661 | 2089867.5171 | 37.7191711929066 | -122.393261433304 | (37.7191711929066, -122.393261433304) | 10 | 3 | 8 | 58 | 1 | |||
| 19781 | 186781 | DPW Maintained 1 | :: 45 | 1200 Sunset Blvd | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984857.4742 | 2106824.783 | 37.7640633248358 | -122.495589084984 | (37.7640633248358, -122.495589084984) | 1 | 8 | 3 | 56 | 35 | |||
| 28545 | 186800 | DPW Maintained 1 | :: 45 | 1200 Sunset Blvd | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984846.2035 | 2106925.1049 | 37.7643381205783 | -122.495635466651 | (37.7643381205783, -122.495635466651) | 1 | 8 | 3 | 56 | 35 | |||
| 29145 | 121591 | Undocumented 4 | :: 45 | 162 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6000339 | 2095263 | 37.7332118579221 | -122.441213569672 | (37.7332118579221, -122.441213569672) | 9 | 7 | 5 | 63 | 40 | ||||
| 46922 | 129089 | DPW Maintained 1 | :: 45 | 190 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6011405.84379 | 2120790.43469 | 37.8039285776094 | -122.404748812406 | (37.8039285776094, -122.404748812406) | 3 | 1 | 10 | 28860 | 6 | |||
| 52218 | 129090 | DPW Maintained 1 | :: 45 | 190 Lombard St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011386.68599 | 2120789.41334 | 37.8039247024384 | -122.404815037597 | (37.8039247024384, -122.404815037597) | 3 | 1 | 10 | 28860 | 6 | |||
| 66935 | 200181 | DPW Maintained 1 | :: 45 | 1175 Ingerson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 0 | Width 0ft | 6013299.4945 | 2090456.4074 | 37.7207436812319 | -122.396068570714 | (37.7207436812319, -122.396068570714) | 10 | 3 | 8 | 58 | 1 | |||
| 71605 | 109344 | DPW Maintained 1 | :: 45 | 3211 Baker St | 3 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 74718 | 186771 | DPW Maintained 1 | :: 45 | 1200 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984865.2362 | 2106774.8154 | 37.7639265823683 | -122.495558553205 | (37.7639265823683, -122.495558553205) | 1 | 8 | 3 | 56 | 35 | |||
| 79210 | 109345 | DPW Maintained 1 | :: 45 | 3211 Baker St | 4 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 82203 | 124714 | DPW Maintained 1 | :: 45 | 500X 28th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6002346 | 2099447 | 37.7448142732195 | -122.434573899432 | (37.7448142732195, -122.434573899432) | 2 | 7 | 5 | 63 | 22 | ||||
| 82433 | 109343 | DPW Maintained 1 | :: 45 | 3211 Baker St | 2 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 87438 | 219181 | DPW Maintained 1 | :: 45 | 431 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5999211.06214 | 2094946.25439 | 37.7322778337559 | -122.445090379531 | (37.7322778337559, -122.445090379531) | 9 | 7 | 4 | 59 | 40 | |||
| 110859 | 109342 | DPW Maintained 1 | :: 45 | 3211 Baker St | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 02/11/2015 12:00:00 AM | 3 | 1x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | 13 | 9 | 1 | 57 | 17 | ||
| 112197 | 107208 | Undocumented 4 | :: 45 | 3795 Market St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6000195.59748 | 2102713.68465 | 37.7536614933614 | -122.442244022259 | (37.7536614933614, -122.442244022259) | 2 | 4 | 5 | 63 | 38 | |||||
| 121385 | 119124 | Undocumented 4 | :: 45 | 601 46th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 5ft | 5981605.53063 | 2111566.74083 | 37.7768923962204 | -122.507188220302 | (37.7768923962204, -122.507188220302) | 11 | 6 | 2 | 55 | 26 | ||||
| 134703 | 129088 | DPW Maintained 1 | :: 45 | 190 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011425.38411 | 2120792.86026 | 37.8039363297663 | -122.40468136238 | (37.8039363297663, -122.40468136238) | 3 | 1 | 10 | 28860 | 6 | |||
| 141371 | 129087 | DPW Maintained 1 | :: 45 | 190 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011445.1234 | 2120796.34037 | 37.8039469885131 | -122.404613298068 | (37.8039469885131, -122.404613298068) | 3 | 1 | 10 | 28860 | 6 | |||
| 145763 | 181517 | DPW Maintained 1 | :: 45 | 1400 Sunset Blvd | 77 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984871.9567 | 2105586.7319 | 37.7606648313705 | -122.495447679304 | (37.7606648313705, -122.495447679304) | 1 | 8 | 3 | 56 | 35 | |||
| 397 | 253904 | DPW Maintained 1 | :: 45 | 3637 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997456 | 2115038 | 37.7873443747179 | -122.4526074861 | (37.7873443747179, -122.4526074861) | 11 | 6 | 1 | 54 | 31 | ||||
| 532 | 261313 | Permitted Site 7 | :: 45 | 2700 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x40 | 6000687.88763 | 2117206.96839 | 37.7934844433083 | -122.441581569821 | (37.7934844433083, -122.441581569821) | 13 | 9 | 1 | 57 | 27 | ||
| 740 | 105361 | Permitted Site 7 | :: 45 | 850 Guerrero St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | 2 | 4 | 5 | 28859 | 19 | ||||
| 1416 | 109762 | DPW Maintained 1 | :: 45 | 1801 Scott St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x6.5 | 6001511.7 | 2114646.3 | 37.7865004107291 | -122.438547564751 | (37.7865004107291, -122.438547564751) | 13 | 6 | 1 | 29490 | 27 | ||||
| 2087 | 261314 | Permitted Site 7 | :: 45 | 2601 Divisadero St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x106 | ||||||||||||
| 2548 | 104858 | DPW Maintained 1 | :: 45 | 4205 24th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6001816 | 2101720.7 | 37.7510272133613 | -122.436569249202 | (37.7510272133613, -122.436569249202) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 2737 | 258983 | Permitted Site 7 | :: 45 | 1355 27th Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 07/03/2019 12:00:00 AM | 3 | 5.5x17 | Permit Number 782298 | 5987701.73439 | 2106071.48854 | 37.7621611287816 | -122.48569645736 | (37.7621611287816, -122.48569645736) | 1 | 8 | 3 | 56 | 35 | |
| 7664 | 261543 | Permitted Site 7 | :: 45 | 1305 Lombard St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 20x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
| 8663 | 258698 | Permitted Site 7 | :: 45 | 32 Clifford Ter | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/11/2019 12:00:00 AM | 3 | 5999959.18713 | 2106432.26938 | 37.76385833527 | -122.443328653185 | (37.76385833527, -122.443328653185) | 15 | 5 | 5 | 29492 | 3 | |||
| 8883 | 261542 | Permitted Site 7 | :: 45 | 1305 Lombard St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 01/17/2020 12:00:00 AM | 3 | 10x5 | 6006114.74348 | 2120010.24127 | 37.8014892121583 | -122.423003541085 | (37.8014892121583, -122.423003541085) | 13 | 9 | 1 | 28858 | 32 | ||
| 8983 | 258699 | Permitted Site 7 | :: 45 | 32 Clifford Ter | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/11/2019 12:00:00 AM | 3 | 5999959.18713 | 2106432.26938 | 37.76385833527 | -122.443328653185 | (37.76385833527, -122.443328653185) | 15 | 5 | 5 | 29492 | 3 | |||
| 10197 | 251293 | DPW Maintained 1 | :: 45 | 3789 Market St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 6000208 | 2102740 | 37.753734455764 | -122.442203020617 | (37.753734455764, -122.442203020617) | 2 | 4 | 5 | 63 | 38 | ||||
| 14351 | 109754 | Permitted Site 7 | :: 45 | 601 Steiner St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1x12 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | ||||
| 17437 | 105043 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 5 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x4 | 6008902 | 2102968 | 37.7548521445958 | -122.412153203197 | (37.7548521445958, -122.412153203197) | 2 | 4 | 7 | 28859 | 19 | ||||
| 17886 | 261591 | Planning Code 138.1 required 2 | :: 45 | 1747 Cayuga Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/28/2020 12:00:00 AM | 3 | Permit Number 784552 | 5998049.81023 | 2088594.07996 | 37.7147698965646 | -122.44864773571 | (37.7147698965646, -122.44864773571) | 9 | 7 | 6 | 28861 | 25 | ||
| 22031 | 254088 | DPW Maintained 1 | :: 45 | 2520 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 3.5x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 22093 | 254089 | DPW Maintained 1 | :: 45 | 2520 Broadway | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 5x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 31577 | 104151 | DPW Maintained 1 | :: 45 | 525X Church St | 1 | Sidewalk: Property side : Cutout | Landscaping | SFUSD 4 | DPW | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 31879 | 115804 | Undocumented 4 | :: 45 | 282X GRAYSTONE TER | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5999572 | 2103825 | 37.7566773324243 | -122.444480417383 | (37.7566773324243, -122.444480417383) | 2 | 5 | 5 | 28862 | 38 | ||||
| 47766 | 253517 | DPW Maintained 1 | :: 45 | 559 24th Ave | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 09/15/2017 12:00:00 AM | 3 | 2x4.5 | 5988391 | 2112180 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | 11 | 6 | 2 | 55 | 26 | ||
| 49257 | 105359 | Permitted Site 7 | :: 45 | 850 Guerrero St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | 2 | 4 | 5 | 28859 | 19 | ||||
| 54959 | 258601 | Private 9 | :: 45 | 682 12th Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 05/29/2019 12:00:00 AM | 3 | 9X2 | 5992266.47414 | 2110804.58144 | 37.7754218561197 | -122.470253595146 | (37.7754218561197, -122.470253595146) | 11 | 6 | 2 | 54 | 11 | ||
| 57021 | 255180 | Permitted Site 7 | :: 45 | 619 06th Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 04/18/2018 12:00:00 AM | 3 | 5994069.31075 | 2111288.088 | 37.7768535012339 | -122.464052313375 | (37.7768535012339, -122.464052313375) | 11 | 6 | 2 | 54 | 11 | |||
| 59373 | 109769 | DPW Maintained 1 | :: 45 | 2502X Bush St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1.5x12.75 | 6001313.62368 | 2114572.17699 | 37.7862856185892 | -122.439227543381 | (37.7862856185892, -122.439227543381) | 13 | 6 | 1 | 29490 | 27 | ||||
| 63769 | 173868 | DPW Maintained 1 | :: 45 | 808 Capitol Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/31/2017 12:00:00 AM | 3 | 5995075.95943 | 2089664.90678 | 37.7175396369842 | -122.459004013836 | (37.7175396369842, -122.459004013836) | 9 | 8 | 6 | 28861 | 24 | |||
| 64175 | 109535 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 66039 | 109366 | DPW Maintained 1 | :: 45 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | 5 | 1 | 1 | 28858 | 32 | |
| 75042 | 100252 | DPW Maintained 1 | :: 45 | 540 Delancey St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015236.96681 | 2113599.67086 | 37.784397795653 | -122.390987973742 | (37.784397795653, -122.390987973742) | 6 | 2 | 9 | 28856 | 6 | |||
| 78434 | 104861 | DPW Maintained 1 | :: 45 | 3458A 18th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6006508 | 2105569.9 | 37.7618617394874 | -122.420617027809 | (37.7618617394874, -122.420617027809) | 8 | 4 | 7 | 28859 | 19 | ||||||
| 78553 | 109534 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 79912 | 254090 | DPW Maintained 1 | :: 45 | 2520 Broadway | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/22/2017 12:00:00 AM | 3 | 1.75x4.9 | 6001556.59478 | 2117325.5311 | 37.7938594403451 | -122.438584281493 | (37.7938594403451, -122.438584281493) | 13 | 9 | 1 | 57 | 27 | ||
| 80379 | 105360 | Permitted Site 7 | :: 45 | 850 Guerrero St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | 2 | 4 | 5 | 28859 | 19 | ||||
| 86162 | 254706 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
| 91643 | 97034 | Property Tree 8 | :: 45 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
| 103545 | 117372 | DPW Maintained 1 | :: 45 | 1533 McAllister St | 5 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 06/08/2016 12:00:00 AM | 3 | 1x2.75 | 6001806.7 | 2111472.8 | 37.7778035619302 | -122.437299621265 | (37.7778035619302, -122.437299621265) | 15 | 5 | 11 | 29492 | 41 | ||
| 110069 | 116528 | Planning Code 138.1 required 2 | :: 45 | 125 CROWN TER | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 5998841 | 2104182 | 37.7576158290564 | -122.447034160915 | (37.7576158290564, -122.447034160915) | 2 | 5 | 5 | 28862 | 3 | |||
| 112455 | 109755 | DPW Maintained 1 | :: 45 | 601 Steiner St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1x12 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | ||||
| 112534 | 253518 | DPW Maintained 1 | :: 45 | 559 24th Ave | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 09/15/2017 12:00:00 AM | 3 | 2x1 | 5988391 | 2112180 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | 11 | 6 | 2 | 55 | 26 | ||
| 114988 | 109756 | DPW Maintained 1 | :: 45 | 601 Steiner St | 3 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 1x12 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | ||||
| 123221 | 109536 | DPW Maintained 1 | :: 45 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.8001572481983 | -122.419877066677 | (37.8001572481983, -122.419877066677) | 5 | 1 | 1 | 28858 | 32 | |
| 127804 | 109831 | DPW Maintained 1 | :: 45 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | 9 | 7 | 4 | 28861 | 40 | ||||
| 129547 | 173867 | DPW Maintained 1 | :: 45 | 808 Capitol Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/31/2017 12:00:00 AM | 3 | 5995075.95943 | 2089664.90678 | 37.7175396369842 | -122.459004013836 | (37.7175396369842, -122.459004013836) | 9 | 8 | 6 | 28861 | 24 | |||
| 142135 | 105042 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 4 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x10 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | 2 | 4 | 7 | 28859 | 19 | ||||
| 154536 | 254705 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
| 157116 | 256250 | Permitted Site 7 | :: 45 | 2532 Sutter St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x18 | 6000473.43497 | 2114128.52893 | 37.7850196296057 | -122.442102513681 | (37.7850196296057, -122.442102513681) | 15 | 6 | 1 | 29490 | 27 | ||||
| 157539 | 109767 | DPW Maintained 1 | :: 45 | 1801 Scott St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 11.75x1.5+3.6x3.6 | 6001511.7 | 2114646.3 | 37.7865004107291 | -122.438547564751 | (37.7865004107291, -122.438547564751) | 13 | 6 | 1 | 29490 | 27 |
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) );