trees
1,914 rows where qSpecies_id = 45 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18831 | 199650 | DPW Maintained 1 | :: 45 | 0 | 1 | : | Tree | Private 2 | 0 | Width 0ft | 6014963.58685 | 2093280.81794 | 37.7285913984524 | -122.390513521988 | (37.7285913984524, -122.390513521988) | 10 | 3 | 8 | 58 | 1 | |||
| 98915 | 199651 | DPW Maintained 1 | :: 45 | 0 | 37 | : | Tree | Private 2 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.379309965799 | (37.7414476037323, -122.379309965799) | 10 | 3 | 8 | 58 | 1 | |||
| 7264 | 182773 | DPW Maintained 1 | :: 45 | 1 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985975.4571 | 2103368.6441 | 37.754639125693 | -122.491467955558 | (37.754639125693, -122.491467955558) | 1 | 8 | 3 | 56 | 35 | |||
| 128264 | 183607 | DPW Maintained 1 | :: 45 | 1 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989903.61 | 2101103.2452 | 37.7486477060916 | -122.477717911497 | (37.7486477060916, -122.477717911497) | 1 | 8 | 3 | 29491 | 35 | |||
| 27324 | 142128 | DPW Maintained 1 | :: 45 | 10 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998660.4892 | 2110810.2219 | 37.7758049360467 | -122.448135688829 | (37.7758049360467, -122.448135688829) | 15 | 6 | 2 | 29492 | 16 | |||
| 87545 | 142129 | DPW Maintained 1 | :: 45 | 10 HEMWAY TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998655.1761 | 2110837.1975 | 37.7758787003739 | -122.448156010928 | (37.7758787003739, -122.448156010928) | 15 | 6 | 2 | 29492 | 16 | |||
| 8417 | 259628 | DPW Maintained 1 | :: 45 | 100 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008465.19154 | 2087632.83273 | 37.7127205750598 | -122.412579828323 | (37.7127205750598, -122.412579828323) | 9 | 7 | 8 | 309 | 39 | ||
| 30113 | 33407 | Permitted Site 7 | :: 45 | 100 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | 1 | 5 | 4 | 59 | 40 | ||
| 47607 | 33409 | Permitted Site 7 | :: 45 | 100 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | 1 | 5 | 4 | 59 | 40 | ||
| 63227 | 33408 | Permitted Site 7 | :: 45 | 100 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | 1 | 5 | 4 | 59 | 40 | ||
| 66255 | 33411 | Permitted Site 7 | :: 45 | 100 Ulloa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | 1 | 5 | 4 | 59 | 40 | ||
| 100466 | 33410 | Permitted Site 7 | :: 45 | 100 Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | 1 | 5 | 4 | 59 | 40 | ||
| 186908 | 33406 | Permitted Site 7 | :: 45 | 100 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | 1 | 5 | 4 | 59 | 40 | ||
| 4944 | 259613 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 12908 | 259612 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 190693 | 247418 | DPW Maintained 1 | :: 45 | 1001 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002608.194 | 2110213.5869 | 37.7743916070028 | -122.434436924996 | (37.7743916070028, -122.434436924996) | 15 | 5 | 11 | 29492 | 10 | |||
| 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 | |||
| 93102 | 139926 | DPW Maintained 1 | :: 45 | 1001 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005215.378 | 2112666.1069 | 37.7812732756423 | -122.425592763682 | (37.7812732756423, -122.425592763682) | 7 | 9 | 11 | 28852 | 41 | |||
| 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 | |||
| 74202 | 248338 | DPW Maintained 1 | :: 45 | 101 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998210.6283 | 2108198.2582 | 37.7686074267176 | -122.44950361782 | (37.7686074267176, -122.44950361782) | 15 | 5 | 11 | 29492 | 9 | |||
| 62403 | 245199 | DPW Maintained 1 | :: 45 | 101 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001311.3344 | 2109146.8192 | 37.771388829884 | -122.43884653486 | (37.771388829884, -122.43884653486) | 15 | 5 | 11 | 29492 | 9 | |||
| 12777 | 137758 | DPW Maintained 1 | :: 45 | 101 Saint Joseph's Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000707.9938 | 2112291.934 | 37.7799901751967 | -122.441159201538 | (37.7799901751967, -122.441159201538) | 15 | 5 | 1 | 29490 | 16 | |||
| 79490 | 137739 | DPW Maintained 1 | :: 45 | 101 Saint Joseph's Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000676.859 | 2112512.2466 | 37.7805933238275 | -122.441282722586 | (37.7805933238275, -122.441282722586) | 15 | 5 | 1 | 29490 | 16 | |||
| 87596 | 137740 | DPW Maintained 1 | :: 45 | 101 Saint Joseph's Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000679.5664 | 2112493.295 | 37.7805414418009 | -122.441271996241 | (37.7805414418009, -122.441271996241) | 15 | 5 | 1 | 29490 | 16 | |||
| 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 | |||
| 148676 | 247379 | Undocumented 4 | :: 45 | 1015 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002146.8166 | 2109803.9081 | 37.7732405306973 | -122.436003592649 | (37.7732405306973, -122.436003592649) | 15 | 5 | 11 | 29492 | 9 | |||
| 185827 | 10354 | DPW Maintained 1 | :: 45 | 1016 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2000 12:00:00 AM | 20 | 3X3 | 6001244.7283 | 2109040.2146 | 37.7710923306016 | -122.439069286514 | (37.7710923306016, -122.439069286514) | 15 | 5 | 11 | 29492 | 9 | ||
| 188054 | 35462 | DPW Maintained 1 | :: 45 | 1016 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | 6 | Permit Number 38885 | 6014468.80099 | 2102427.52316 | 37.7536788925865 | -122.392863694223 | (37.7536788925865, -122.392863694223) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |||
| 87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 141876 | 247384 | Undocumented 4 | :: 45 | 1021 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002057.9469 | 2109793.0538 | 37.7732056784261 | -122.436310227416 | (37.7732056784261, -122.436310227416) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 5982 | 259609 | DPW Maintained 1 | :: 45 | 1035 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009443.72066 | 2087255.36906 | 37.711739006489 | -122.40917108656 | (37.711739006489, -122.40917108656) | 9 | 7 | 8 | 309 | 39 | ||
| 45772 | 110159 | Permitted Site 7 | :: 45 | 1041 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 55966 | 6008597.3 | 2118278.8 | 37.7968748776387 | -122.414290174718 | (37.7968748776387, -122.414290174718) | 5 | 1 | 10 | 308 | 21 | |||
| 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 | |||
| 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 | |||
| 64113 | 228482 | DPW Maintained 1 | :: 45 | 105 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006464.96947 | 2105462.22062 | 37.7615636518725 | -122.420758208947 | (37.7615636518725, -122.420758208947) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 29616 | 140863 | DPW Maintained 1 | :: 45 | 106 JORDAN AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5996246.41 | 2113718.2127 | 37.7836512118011 | -122.456696904969 | (37.7836512118011, -122.456696904969) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 3862 | 260676 | DPW Maintained 1 | :: 45 | 108 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2019 12:00:00 AM | 3 | 3x3 | 5992434.1895 | 2114741.52104 | 37.7862413120358 | -122.469960148163 | (37.7862413120358, -122.469960148163) | 11 | 6 | 2 | 54 | 11 | ||
| 12815 | 261606 | DPW Maintained 1 | :: 45 | 108 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993739.19456 | 2089854.88419 | 37.7179843347129 | -122.463638343115 | (37.7179843347129, -122.463638343115) | 9 | 8 | 6 | 64 | 24 | |||||
| 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 | |||
| 101961 | 200202 | DPW Maintained 1 | :: 45 | 1090 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6013720.7054 | 2090215.6197 | 37.72010595277 | -122.394595711042 | (37.72010595277, -122.394595711042) | 10 | 3 | 8 | 58 | 1 | |||
| 155612 | 200201 | DPW Maintained 1 | :: 45 | 1090 Ingerson Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6013694.5474 | 2090234.3998 | 37.7201560648851 | -122.394687445541 | (37.7201560648851, -122.394687445541) | 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 | |||
| 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 | |||
| 82350 | 7876 | DPW Maintained 1 | :: 45 | 1095X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2011 12:00:00 AM | 3 | 3x3 | 6006012.62101 | 2113826.37447 | 37.7845041008944 | -122.422917178661 | (37.7845041008944, -122.422917178661) | 7 | 9 | 11 | 28858 | 41 | ||
| 28186 | 185060 | DPW Maintained 1 | :: 45 | 10x El Mirasol Pl | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5987413.8008 | 2096060.1353 | 37.7346558528299 | -122.485957413668 | (37.7346558528299, -122.485957413668) | 1 | 8 | 3 | 64 | 35 | |||
| 59461 | 142105 | DPW Maintained 1 | :: 45 | 11 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998624.9098 | 2110833.4671 | 37.7758667273984 | -122.448260440712 | (37.7758667273984, -122.448260440712) | 15 | 6 | 2 | 29492 | 16 | |||
| 104388 | 142063 | DPW Maintained 1 | :: 45 | 1100 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004132.6367 | 2112218.0001 | 37.7799816466739 | -122.429306552664 | (37.7799816466739, -122.429306552664) | 7 | 9 | 11 | 29490 | 41 | |||
| 102598 | 141857 | DPW Maintained 1 | :: 45 | 1100 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004651.3626 | 2112630.8889 | 37.7811446903449 | -122.427541470502 | (37.7811446903449, -122.427541470502) | 7 | 9 | 11 | 29490 | 41 | |||
| 79402 | 141945 | DPW Maintained 1 | :: 45 | 1101 GOLDEN GATE AVE | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004212.2215 | 2112170.9783 | 37.7798570416861 | -122.429027879664 | (37.7798570416861, -122.429027879664) | 7 | 9 | 11 | 29490 | 41 | |||
| 108551 | 141944 | DPW Maintained 1 | :: 45 | 1101 GOLDEN GATE AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004183.4678 | 2112169.0928 | 37.779850236925 | -122.429127216952 | (37.779850236925, -122.429127216952) | 7 | 9 | 11 | 29490 | 41 | |||
| 135855 | 141940 | DPW Maintained 1 | :: 45 | 1101 GOLDEN GATE AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004067.7741 | 2112149.004 | 37.7797885282032 | -122.429526019495 | (37.7797885282032, -122.429526019495) | 7 | 9 | 11 | 29490 | 41 | |||
| 94117 | 139809 | DPW Maintained 1 | :: 45 | 1101 GOUGH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005660.0139 | 2112868.3262 | 37.7818536339515 | -122.424068925498 | (37.7818536339515, -122.424068925498) | 7 | 9 | 11 | 28852 | 41 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 8458 | 259610 | DPW Maintained 1 | :: 45 | 1107 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6009254.2033 | 2087326.13058 | 37.7119226839796 | -122.409831104788 | (37.7119226839796, -122.409831104788) | 9 | 7 | 8 | 309 | 39 | ||||
| 105542 | 251314 | Planning Code 138.1 required 2 | :: 45 | 1108 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001901 | 2100825 | 37.7485726639367 | -122.4362112186 | (37.7485726639367, -122.4362112186) | 2 | 4 | 5 | 28862 | 22 | ||||
| 49781 | 217557 | DPW Maintained 1 | :: 45 | 111 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5995778.3452 | 2088036.9975 | 37.7131101315221 | -122.456458551068 | (37.7131101315221, -122.456458551068) | 9 | 8 | 6 | 28861 | 24 | |||
| 43706 | 200497 | DPW Maintained 1 | :: 45 | 1110 Gilman Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6014977.2953 | 2089975.1673 | 37.7195154981888 | -122.390235277748 | (37.7195154981888, -122.390235277748) | 10 | 3 | 8 | 58 | 1 | |||
| 217 | 105438 | Undocumented 4 | :: 45 | 1116 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002483 | 2102334 | 37.7527490702591 | -122.434306541099 | (37.7527490702591, -122.434306541099) | 2 | 4 | 5 | 28862 | 22 | ||||
| 128780 | 105437 | Undocumented 4 | :: 45 | 1116 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002483 | 2102334 | 37.7527490702591 | -122.434306541099 | (37.7527490702591, -122.434306541099) | 2 | 4 | 5 | 28862 | 22 | ||||
| 57150 | 10247 | DPW Maintained 1 | :: 45 | 112 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/1997 12:00:00 AM | 8 | 3X3 | 6005536.2501 | 2109637.4907 | 37.7729755585516 | -122.424267236647 | (37.7729755585516, -122.424267236647) | 7 | 9 | 11 | 28852 | 10 | ||
| 80565 | 142716 | DPW Maintained 1 | :: 45 | 1120 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6008073.8404 | 2121121.2819 | 37.804650203273 | -122.416302902461 | (37.804650203273, -122.416302902461) | 5 | 1 | 10 | 308 | 23 | |||
| 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 | |||
| 166300 | 244483 | DPW Maintained 1 | :: 45 | 1124 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001145.6174 | 2109366.8236 | 37.7719834774065 | -122.439435529733 | (37.7719834774065, -122.439435529733) | 15 | 5 | 11 | 29492 | 9 | |||
| 76602 | 200226 | DPW Maintained 1 | :: 45 | 1131 Fitzgerald Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6015013.4132 | 2090222.9153 | 37.7201977688326 | -122.390127728915 | (37.7201977688326, -122.390127728915) | 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 | |||
| 38005 | 35482 | Permitted Site 7 | :: 45 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/2000 12:00:00 AM | Permit Number 40088 | 6008340.04148266 | 2093836.36406151 | 37.7297471396453 | -122.413450843683 | (37.7297471396453, -122.413450843683) | 9 | 3 | 7 | 309 | 28 | ||
| 184750 | 120651 | Undocumented 4 | :: 45 | 114 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005371 | 2102934 | 37.7545600310384 | -122.424361977892 | (37.7545600310384, -122.424361977892) | 2 | 4 | 5 | 28859 | 19 | ||||
| 116983 | 49797 | DPW Maintained 1 | :: 45 | 1145 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | 13 | 3x3 | Permit Number 46589 | 6008423.57277 | 2115887.46945 | 37.7902991118549 | -122.41472199442 | (37.7902991118549, -122.41472199442) | 5 | 1 | 10 | 28858 | 21 |
| 132751 | 183877 | DPW Maintained 1 | :: 45 | 1145 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989814.4341 | 2101045.8603 | 37.7484849666087 | -122.4780220827 | (37.7484849666087, -122.4780220827) | 1 | 8 | 3 | 29491 | 35 | |||
| 132635 | 245065 | DPW Maintained 1 | :: 45 | 1150 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000577.9392 | 2108943.6108 | 37.7707891181366 | -122.441368793683 | (37.7707891181366, -122.441368793683) | 15 | 5 | 11 | 29492 | 9 | |||
| 33675 | 137589 | DPW Maintained 1 | :: 45 | 1150 PIERCE ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002346.2752 | 2112589.0782 | 37.7808992401303 | -122.435512922421 | (37.7808992401303, -122.435512922421) | 15 | 5 | 11 | 29490 | 41 | |||
| 100995 | 137588 | DPW Maintained 1 | :: 45 | 1150 PIERCE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002345.2566 | 2112562.5967 | 37.7808264707559 | -122.435514551268 | (37.7808264707559, -122.435514551268) | 15 | 5 | 11 | 29490 | 41 | |||
| 120207 | 137586 | DPW Maintained 1 | :: 45 | 1150 PIERCE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002357.4789 | 2112504.0318 | 37.7806663604621 | -122.435468077701 | (37.7806663604621, -122.435468077701) | 15 | 5 | 11 | 29490 | 41 | |||
| 137746 | 137587 | DPW Maintained 1 | :: 45 | 1150 PIERCE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002352.8955 | 2112542.7356 | 37.7807723710322 | -122.435486703411 | (37.7807723710322, -122.435486703411) | 15 | 5 | 11 | 29490 | 41 | |||
| 354 | 141882 | DPW Maintained 1 | :: 45 | 1160 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003839.6945 | 2112655.4467 | 37.7811661774464 | -122.430351190021 | (37.7811661774464, -122.430351190021) | 7 | 9 | 11 | 29490 | 41 | |||
| 8130 | 261244 | Permitted Site 7 | :: 45 | 1166 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 3 | 3x3 | 6009198.71093 | 2102367.64119 | 37.75322033811 | -122.41108468628 | (37.75322033811, -122.41108468628) | 2 | 4 | 7 | 28859 | 19 | ||
| 10228 | 142720 | Undocumented 4 | :: 45 | 1170 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6007999.4825 | 2121188.7351 | 37.8048312311886 | -122.416565007078 | (37.8048312311886, -122.416565007078) | 5 | 1 | 10 | 308 | 23 | ||||
| 41987 | 139753 | DPW Maintained 1 | :: 45 | 1171 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005547.6328 | 2113641.325 | 37.7839697525349 | -122.424512713511 | (37.7839697525349, -122.424512713511) | 7 | 9 | 11 | 28858 | 41 | |||
| 111230 | 139604 | DPW Maintained 1 | :: 45 | 1173 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001838.238 | 2112425.6952 | 37.7804217645564 | -122.437258767268 | (37.7804217645564, -122.437258767268) | 15 | 5 | 11 | 29490 | 41 | |||
| 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 | |||
| 191838 | 200182 | DPW Maintained 1 | :: 45 | 1175 Ingerson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6013359.1884 | 2090422.8715 | 37.7206549194654 | -122.395859877099 | (37.7206549194654, -122.395859877099) | 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 | |||
| 154119 | 141865 | DPW Maintained 1 | :: 45 | 1198 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004361.706 | 2112589.3295 | 37.7810141909048 | -122.428540575057 | (37.7810141909048, -122.428540575057) | 7 | 9 | 11 | 29490 | 41 | |||
| 35508 | 3826 | DPW Maintained 1 | :: 45 | 120 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1992 12:00:00 AM | 3 | 3X3 | 6016868.5122165 | 2095917.6664165 | 37.7359371538987 | -122.384111573291 | (37.7359371538987, -122.384111573291) | 10 | 3 | 8 | 58 | 1 |
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) );