trees
484 rows where qSpecies_id = 56 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
819 | 20315 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
1295 | 19941 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY38 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
2286 | 20017 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY48 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
2572 | 20316 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
3457 | 20016 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY48 | 0 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
7537 | 19938 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY38 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
8170 | 19942 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY38 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
10058 | 20314 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
12313 | 20320 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
13640 | 19939 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY38 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
17517 | 19940 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 STAIRWAY38 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10ST | |||||||||||||
17932 | 20319 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
19409 | 20318 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
45655 | 121204 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 44 MacOndray Ln | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 52 | 6008473.20212 | 2119153.5676 | 37.7992698007193 | -122.41478152415 | (37.7992698007193, -122.41478152415) | 5 | 1 | 10 | 308 | 32 | ||||
82973 | 126581 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 556 Pine St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 6011285.65956 | 2116338.25251 | 37.7916972455684 | -122.404851076143 | (37.7916972455684, -122.404851076143) | 5 | 1 | 10 | 28857 | 6 | |||
104435 | 106173 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 267 Green St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 771881 | 6011670.8 | 2119368.7 | 37.8000396459541 | -122.403731811098 | (37.8000396459541, -122.403731811098) | 3 | 1 | 10 | 308 | 23 | ||||
153947 | 249920 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 358 Greenwich St | 5 | Back Yard : Yard | Tree | Private 2 | 35 | Width 0ft | 6011181.16541 | 2120413.994 | 37.8028824034529 | -122.405499802075 | (37.8028824034529, -122.405499802075) | 3 | 1 | 10 | 308 | 23 | |||
93652 | 115295 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 500X 08TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010511 | 2109243 | 37.7721720235673 | -122.407031076357 | (37.7721720235673, -122.407031076357) | 14 | 2 | 9 | 28853 | 34 | ||||
104699 | 114731 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 934 BRANNAN ST | Back Yard : Yard | Tree | Private 2 | Dept of Real Estate | 10x10 | 6010724 | 2108745 | 37.7708165471861 | -122.406259194073 | (37.7708165471861, -122.406259194073) | 14 | 2 | 9 | 28853 | 34 | ||||
189109 | 120533 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 22 | 3x3 | 6010745 | 2108673 | 37.7706200263658 | -122.406181480785 | (37.7706200263658, -122.406181480785) | 14 | 2 | 9 | 28853 | 34 | |||
776 | 113502 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200x MANSELL ST | 8 | Median : Cutout | Tree | DPW 1 | 30 | 3x3 | 6011136 | 2090597 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | 10 | 3 | 7 | 309 | 28 | |||
8037 | 257932 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
17952 | 176334 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 287 Hester Ave | 7 | Side Yard : Yard | Tree | Private 2 | 34 | 6012223.87562 | 2087782.54699 | 37.713341893097 | -122.399599040764 | (37.713341893097, -122.399599040764) | 10 | 3 | 8 | 309 | 1 | ||||
22979 | 176339 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100x Mansell St | 7 | Median : Cutout | Tree | DPW 1 | 26 | Width 0ft | 6011461.59774 | 2090655.36204 | 37.7211875408569 | -122.402435631998 | (37.7211875408569, -122.402435631998) | 10 | 3 | 8 | 309 | 28 | |||
36331 | 256763 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
44889 | 191727 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1790 23rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6013509.42079 | 2102917.94191 | 37.7549721419751 | -122.396215837988 | (37.7549721419751, -122.396215837988) | 10 | 3 | 8 | 28856 | 29 | ||||
45615 | 251302 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Cashmere St | 1 | Back Yard : Yard | Tree | Health Dept 13 | 3x3 | 6017463 | 2095772 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | 10 | 3 | 8 | 58 | 1 | ||||
46802 | 176341 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 500x Mansell St | 17 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6010266.44711 | 2090286.24099 | 37.7201072185592 | -122.406540946309 | (37.7201072185592, -122.406540946309) | 10 | 3 | 8 | 309 | 28 | |||
47155 | 176337 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100x Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 59 | Width 0ft | 6011478.9031 | 2090656.66454 | 37.7211920833183 | -122.402375903539 | (37.7211920833183, -122.402375903539) | 10 | 3 | 8 | 309 | 28 | |||
64758 | 191722 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1100 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6014479.64038 | 2101959.5389 | 37.7523945096015 | -122.392793471535 | (37.7523945096015, -122.392793471535) | 10 | 3 | 8 | 28856 | 1 | ||||
65425 | 191724 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 950x Kansas St | 5 | Median : Yard | Tree | DPW 1 | 43 | 6011608.52294 | 2103823.60133 | 37.7573529289142 | -122.402853412073 | (37.7573529289142, -122.402853412073) | 10 | 3 | 8 | 28856 | 29 | ||||
89575 | 113506 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200x Mansell St | 12 | Median : Cutout | Tree | DPW 1 | 39 | 3x3 | 6011135.08211 | 2090555.53588 | 37.7208952054249 | -122.403557288932 | (37.7208952054249, -122.403557288932) | 10 | 3 | 7 | 309 | 28 | |||
103215 | 3751 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 990 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 42 | 18 | 6012435.5557064 | 2103342.2152382 | 37.7560772927341 | -122.399959384248 | (37.7560772927341, -122.399959384248) | 10 | 3 | 8 | 28856 | 29 | |||
110057 | 191738 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 920 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 6011311.04969 | 2104026.19787 | 37.757892599481 | -122.403896453867 | (37.757892599481, -122.403896453867) | 10 | 3 | 8 | 28856 | 29 | ||||
112880 | 191737 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200 Helena St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6010885.73151 | 2096220.33708 | 37.7364356342809 | -122.404817839882 | (37.7364356342809, -122.404817839882) | 10 | 3 | 8 | 58 | 1 | ||||
114444 | 176336 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 287 Hester Ave | 9 | Side Yard : Yard | Tree | Private 2 | 31 | 6012249.60162 | 2087766.47281 | 37.7132991905898 | -122.39950899437 | (37.7132991905898, -122.39950899437) | 10 | 3 | 8 | 309 | 1 | ||||
119025 | 176335 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 287 Hester Ave | 5 | Side Yard : Yard | Tree | Private 2 | 17 | 6012233.93602 | 2087774.20569 | 37.7133195503322 | -122.399563683027 | (37.7133195503322, -122.399563683027) | 10 | 3 | 8 | 309 | 1 | ||||
124028 | 257931 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
126653 | 191723 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 900x Carolina St | 30 | Median : Yard | Tree | DPW 1 | 50 | 6012476.48508 | 2103328.88343 | 37.7560429683291 | -122.399816899747 | (37.7560429683291, -122.399816899747) | 10 | 3 | 8 | 28856 | 29 | ||||
130715 | 251303 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1 Cashmere St | 2 | Back Yard : Yard | Tree | Health Dept 13 | 3x3 | 6017463 | 2095772 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | 10 | 3 | 8 | 58 | 1 | ||||
137649 | 108201 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 90 Reuel Ct | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 774102 | 6017404.09127 | 2096025.61699 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | 10 | 3 | 8 | 58 | 1 | ||||
146246 | 191736 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200 Helena St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 57 | 6010895.57722 | 2096228.10312 | 37.7364575084979 | -122.404784345514 | (37.7364575084979, -122.404784345514) | 10 | 3 | 8 | 58 | 1 | ||||
152900 | 257934 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
154190 | 121341 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 401X Cargo Way | 2 | Side Yard : Yard | Tree | Private 2 | 18 | 3x3 | 6017217 | 2098844 | 37.7439915378474 | -122.383110313195 | (37.7439915378474, -122.383110313195) | 10 | 3 | 8 | 58 | 1 | |||
162813 | 191721 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1150x Tennessee St | 7 | Median : Yard | Tree | DPW 1 | 50 | 6015559.12531 | 2103608.85918 | 37.7569830917109 | -122.389175557402 | (37.7569830917109, -122.389175557402) | 10 | 3 | 8 | 28856 | 29 | ||||
165630 | 108200 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 90 Reuel Ct | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 774102 | 6017404.09127 | 2096025.61699 | 37.7362631610075 | -122.382267352258 | (37.7362631610075, -122.382267352258) | 10 | 3 | 8 | 58 | 1 | ||||
170679 | 257933 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 1039 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018789 | 2095103 | 37.7338062313868 | -122.377415095373 | (37.7338062313868, -122.377415095373) | 10 | 3 | 8 | 58 | 1 | ||||
173879 | 201514 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1001 Innes Ave | 12 | Front Yard : Yard | Tree | Private 2 | 75 | 6018663.55815 | 2094844.49481 | 37.7330895150748 | -122.377830854436 | (37.7330895150748, -122.377830854436) | 10 | 3 | 8 | 58 | 1 | ||||
177111 | 201510 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1001 Innes Ave | 8 | Front Yard : Yard | Tree | Private 2 | 38 | 6018594.17439 | 2094891.11142 | 37.7332136916637 | -122.378073969944 | (37.7332136916637, -122.378073969944) | 10 | 3 | 8 | 58 | 1 | ||||
179253 | 30154 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 410X Mansell St | 23 | Median : Cutout | Tree | DPW 1 | 24 | M | 6010678.994322 | 2090457.626596 | 37.7206008798567 | -122.405126964413 | (37.7206008798567, -122.405126964413) | 10 | 3 | 7 | 309 | 28 | |||
181513 | 191726 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 700 Missouri St | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 6013632.69543 | 2103711.63212 | 37.757158302141 | -122.395845128465 | (37.757158302141, -122.395845128465) | 10 | 3 | 8 | 28856 | 29 | ||||
184600 | 115801 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 9M CAIRE TER | 1 | Front Yard : Yard | Tree | Private 2 | 6012720 | 2101959 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | 10 | 3 | 8 | 28856 | 29 | |||||
185421 | 191728 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1790 23rd St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6013472.8835 | 2102915.30193 | 37.754962860065 | -122.39634201018 | (37.754962860065, -122.39634201018) | 10 | 3 | 8 | 28856 | 29 | ||||
187675 | 191725 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 950x Kansas St | 6 | Median : Yard | Tree | DPW 1 | 46 | 6011608.2265 | 2103816.01851 | 37.7573320916147 | -122.402853903992 | (37.7573320916147, -122.402853903992) | 10 | 3 | 8 | 28856 | 29 | ||||
4881 | 259031 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 3 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
5343 | 259035 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 7 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
6781 | 259030 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
6957 | 259032 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 4 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
11644 | 259033 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
13646 | 259034 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 6 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
14634 | 259029 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
23508 | 224254 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 190 Storrie St | 4 | Front Yard : Yard | Tree | Private 2 | 16 | Width 3ft | 6000752.12131 | 2105271.59361 | 37.7607165903087 | -122.440502889194 | (37.7607165903087, -122.440502889194) | 15 | 4 | 5 | 28862 | 3 | |||
34158 | 191733 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 5 | Front Yard : Yard | Tree | Private 2 | 25 | 6009990.50539 | 2107548.56259 | 37.7674903487254 | -122.408711960091 | (37.7674903487254, -122.408711960091) | 8 | 4 | 8 | 28853 | 19 | ||||
42249 | 224253 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 755 Sanchez St | 6 | Front Yard : Yard | Tree | Private 2 | 28 | Width 3ft | 6003620.82081 | 2103873.1752 | 37.7570397984623 | -122.430481566473 | (37.7570397984623, -122.430481566473) | 2 | 4 | 5 | 28862 | 3 | |||
42456 | 191735 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 8 | Front Yard : Yard | Tree | Private 2 | 27 | 6010009.09697 | 2107534.42743 | 37.7674525780981 | -122.408646656734 | (37.7674525780981, -122.408646656734) | 8 | 4 | 8 | 28853 | 19 | ||||
43919 | 113860 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 456 HILL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003369 | 2103347 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | 2 | 4 | 5 | 28862 | 22 | ||||
44584 | 116530 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 745X SANCHEZ ST | 7 | Median : Yard | Tree | DPW 1 | 45 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | ||||
51387 | 224267 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2300 22nd St | 3 | Front Yard : Yard | Tree | Private 2 | 26 | 6011260.20343 | 2103721.90369 | 37.7570542343818 | -122.40405088815 | (37.7570542343818, -122.40405088815) | 10 | 4 | 8 | 28859 | 19 | ||||
52709 | 191734 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 7 | Front Yard : Yard | Tree | Private 2 | 22 | 6009976.80194 | 2107534.39117 | 37.7674506697311 | -122.408758358812 | (37.7674506697311, -122.408758358812) | 8 | 4 | 8 | 28853 | 19 | ||||
68807 | 43994 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 141 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2000 12:00:00 AM | 18 | Permit Number 43551 | 6010001.85414 | 2107517.13485 | 37.7674046909874 | -122.408670488759 | (37.7674046909874, -122.408670488759) | 8 | 4 | 8 | 28853 | 19 | ||
76221 | 224266 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2300 22nd St | 2 | Front Yard : Yard | Tree | Private 2 | 28 | 6011271.09407 | 2103721.28577 | 37.7570531461907 | -122.404013180481 | (37.7570531461907, -122.404013180481) | 10 | 4 | 8 | 28859 | 19 | ||||
85519 | 113859 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 456 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003369 | 2103347 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | 2 | 4 | 5 | 28862 | 22 | ||||
87214 | 224248 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 512 Clipper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6001839.26935 | 2100907.02963 | 37.7487943903519 | -122.43643055214 | (37.7487943903519, -122.43643055214) | 2 | 4 | 5 | 28862 | 22 | |||
94300 | 113861 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 456 HILL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003369 | 2103347 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | 2 | 4 | 5 | 28862 | 22 | ||||
108717 | 224262 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 91 Stanton St | 2 | : Yard | Tree | Private 2 | 22 | Width 3ft | 6000293.691 | 2103856.20704 | 37.7568041715846 | -122.44198679486 | (37.7568041715846, -122.44198679486) | 2 | 4 | 5 | 28862 | 38 | |||
118601 | 113862 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 456 HILL ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003369 | 2103347 | 37.755580778127 | -122.431314899346 | (37.755580778127, -122.431314899346) | 2 | 4 | 5 | 28862 | 22 | ||||
119427 | 191731 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 3 | Front Yard : Yard | Tree | Private 2 | 24 | 6009975.96776 | 2107617.96239 | 37.7676800903972 | -122.408767140702 | (37.7676800903972, -122.408767140702) | 8 | 4 | 8 | 28853 | 19 | ||||
155844 | 191729 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 6009963.10998 | 2107668.13664 | 37.7678171371844 | -122.408815154618 | (37.7678171371844, -122.408815154618) | 8 | 4 | 8 | 28853 | 19 | ||||
161936 | 191732 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 4 | Front Yard : Yard | Tree | Private 2 | 18 | 6009982.19315 | 2107558.06249 | 37.7675159677065 | -122.408741381426 | (37.7675159677065, -122.408741381426) | 8 | 4 | 8 | 28853 | 19 | ||||
169543 | 224269 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2300 22nd St | 7 | Front Yard : Yard | Tree | Private 2 | 23 | 6011241.96431 | 2103719.95233 | 37.7570478572995 | -122.404113828986 | (37.7570478572995, -122.404113828986) | 10 | 4 | 8 | 28859 | 19 | ||||
180221 | 191730 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100 Hampshire St | 2 | Front Yard : Yard | Tree | Private 2 | 24 | 6009966.38063 | 2107638.17528 | 37.7677350533657 | -122.408801727734 | (37.7677350533657, -122.408801727734) | 8 | 4 | 8 | 28853 | 19 | ||||
181524 | 121089 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 1X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
190520 | 224268 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2300 22nd St | 6 | Front Yard : Yard | Tree | Private 2 | 28 | 6011248.24436 | 2103720.25065 | 37.7570490273112 | -122.40409213106 | (37.7570490273112, -122.40409213106) | 10 | 4 | 8 | 28859 | 19 | ||||
5342 | 260946 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
7245 | 251144 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 200X Clarendon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | ||||
8712 | 207757 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5994806.26925 | 2105291.62903 | 37.7604312408178 | -122.461068228734 | (37.7604312408178, -122.461068228734) | 15 | 5 | 4 | 56 | 12 | ||||
10388 | 251145 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 200X Clarendon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | ||||
11415 | 260944 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
14474 | 260945 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 351X Upper Ter | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 3x3 | 5999155 | 2106055 | 37.7627765565078 | -122.446082944502 | (37.7627765565078, -122.446082944502) | 15 | 5 | 5 | 29492 | 9 | ||||
18104 | 260417 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 335 Corbett Ave | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 5999565 | 2105069 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | 15 | 5 | 5 | 28862 | 3 | ||||
23924 | 92900 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 4 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
37863 | 224257 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6001064.07525 | 2107884.43165 | 37.7679085577502 | -122.439611299541 | (37.7679085577502, -122.439611299541) | 15 | 5 | 5 | 29492 | 3 | |||
59460 | 207755 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 43 | 5994788.04604 | 2105291.71815 | 37.7604304368423 | -122.461131260407 | (37.7604304368423, -122.461131260407) | 15 | 5 | 4 | 56 | 12 | ||||
66487 | 207756 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 Kirkham St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 49 | 5994800.39892 | 2105292.04488 | 37.7604320448233 | -122.461088561491 | (37.7604320448233, -122.461088561491) | 15 | 5 | 4 | 56 | 12 | ||||
90994 | 113367 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 6X Christopher Dr | 1 | Front Yard : Yard | Tree | DPW 1 | 25 | 5996701.11551 | 2103988.82524 | 37.7569629284433 | -122.454420756361 | (37.7569629284433, -122.454420756361) | 1 | 5 | 4 | 63 | 12 | ||||
91988 | 224256 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 3ft | 6001050.21768 | 2107873.33716 | 37.7678773063135 | -122.439658435714 | (37.7678773063135, -122.439658435714) | 15 | 5 | 5 | 29492 | 3 | |||
108912 | 245009 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1466 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 5999558.6674 | 2109145.6245 | 37.7712856788974 | -122.444908986977 | (37.7712856788974, -122.444908986977) | 15 | 5 | 11 | 29492 | 9 | |||
110371 | 112189 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 301x CORBETT AVE | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 12 | 3x3 | 5999677 | 2105220 | 37.760513648973 | -122.444217531177 | (37.760513648973, -122.444217531177) | 15 | 5 | 5 | 28862 | 3 | |||
111198 | 208961 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1575 07th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5993977.82871 | 2104681.32491 | 37.7587077962432 | -122.463889098911 | (37.7587077962432, -122.463889098911) | 1 | 5 | 4 | 56 | 12 | |||
112183 | 224260 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 355 Buena Vista Ave East | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 3ft | 6001102.84855 | 2107909.89342 | 37.7679806761809 | -122.439479012854 | (37.7679806761809, -122.439479012854) | 15 | 5 | 5 | 29492 | 3 |
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) );