trees
484 rows where qSpecies_id = 56 sorted by Longitude
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 | |||||||||||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
973 | 176338 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 100x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6011479.2515 | 2090641.1055 | 37.721149380822 | -122.402373605767 | (37.721149380822, -122.402373605767) | 10 | 7 | 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 | |||
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 | |||
26442 | 176342 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 101 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6011455.5144 | 2090588.63485 | 37.7210039820195 | -122.402451970878 | (37.7210039820195, -122.402451970878) | 10 | 7 | 8 | 309 | 28 | |||
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 | ||||
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 | ||||
28767 | 176346 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 40 Teddy Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6011228.44814 | 2087808.7969 | 37.7133584325151 | -122.40304144861 | (37.7133584325151, -122.40304144861) | 9 | 7 | 8 | 309 | 39 | ||||
21127 | 176347 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 40 Teddy Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6011214.18105 | 2087815.33758 | 37.7133755951756 | -122.403091220704 | (37.7133755951756, -122.403091220704) | 9 | 7 | 8 | 309 | 39 | ||||
179774 | 176340 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 200x Mansell St | 15 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6011135.84107 | 2090535.25569 | 37.720839562572 | -122.403553239308 | (37.720839562572, -122.403553239308) | 10 | 7 | 7 | 309 | 28 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
23613 | 248107 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 138 Rutledge St | 1 | Side Yard : Yard | Tree | Private 2 | 35 | 6010423.63855 | 2099478.50343 | 37.7453560168793 | -122.406645033853 | (37.7453560168793, -122.406645033853) | 2 | 7 | 7 | 28859 | 2 | ||||
96951 | 247928 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 22 | 6010393.74755 | 2098772.89885 | 37.7434169076795 | -122.406698675702 | (37.7434169076795, -122.406698675702) | 10 | 7 | 7 | 28859 | 2 | ||||
20776 | 247930 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 3 | Side Yard : Yard | Tree | Private 2 | 18 | 6010384.98383 | 2098777.78466 | 37.7434298327179 | -122.406729322818 | (37.7434298327179, -122.406729322818) | 10 | 7 | 7 | 28859 | 2 | ||||
142651 | 247929 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 2 | Side Yard : Yard | Tree | Private 2 | 37 | 6010384.75611 | 2098766.60945 | 37.7433991352743 | -122.406729322823 | (37.7433991352743, -122.406729322823) | 10 | 7 | 7 | 28859 | 2 | ||||
191735 | 247932 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 5 | Side Yard : Yard | Tree | Private 2 | 11 | 6010369.90614 | 2098762.79338 | 37.7433878262904 | -122.406780401602 | (37.7433878262904, -122.406780401602) | 10 | 7 | 7 | 28859 | 2 | ||||
134451 | 247927 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 12 | Side Yard : Yard | Tree | Private 2 | 34 | 6010318.55961 | 2098736.7728 | 37.7433135063186 | -122.406956112045 | (37.7433135063186, -122.406956112045) | 10 | 7 | 7 | 28859 | 2 | ||||
179161 | 247926 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 11 | Side Yard : Yard | Tree | Private 2 | 27 | 6010312.05046 | 2098736.31721 | 37.7433118911276 | -122.406978587005 | (37.7433118911276, -122.406978587005) | 10 | 7 | 7 | 28859 | 2 | ||||
190524 | 247925 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 10 | Side Yard : Yard | Tree | Private 2 | 25 | 6010304.27631 | 2098731.76841 | 37.7432989660778 | -122.407005147582 | (37.7432989660778, -122.407005147582) | 10 | 7 | 7 | 28859 | 2 | ||||
71078 | 247924 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 9 | Side Yard : Yard | Tree | Private 2 | 23 | 6010297.69523 | 2098727.78354 | 37.7432876562154 | -122.407027622545 | (37.7432876562154, -122.407027622545) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
144422 | 247935 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1099 Esmeralda Ave | 8 | Side Yard : Yard | Tree | Private 2 | 31 | 6010295.56922 | 2098768.42696 | 37.7433991352522 | -122.407037837932 | (37.7433991352522, -122.407037837932) | 2 | 7 | 7 | 28859 | 2 | ||||
67100 | 247923 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 8 | Side Yard : Yard | Tree | Private 2 | 17 | 6010288.87158 | 2098729.72842 | 37.7432925026595 | -122.407058269637 | (37.7432925026595, -122.407058269637) | 10 | 7 | 7 | 28859 | 2 | ||||
63828 | 247922 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 7 | Side Yard : Yard | Tree | Private 2 | 24 | 6010270.94858 | 2098720.09099 | 37.7432650373678 | -122.40711956383 | (37.7432650373678, -122.40711956383) | 10 | 7 | 7 | 28859 | 2 | ||||
103652 | 247921 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 6 | Side Yard : Yard | Tree | Private 2 | 38 | 6010260.8237 | 2098716.17835 | 37.7432537274883 | -122.407154297447 | (37.7432537274883, -122.407154297447) | 10 | 7 | 7 | 28859 | 2 | ||||
88934 | 247919 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 22 | 6010242.48982 | 2098715.37522 | 37.7432504962209 | -122.40721763491 | (37.7432504962209, -122.40721763491) | 10 | 7 | 7 | 28859 | 2 | ||||
188383 | 247937 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1149 Esmeralda Ave | 2 | Front Yard : Yard | Tree | Private 2 | 24 | 6010236.06133 | 2098747.86868 | 37.7433393564296 | -122.407242153126 | (37.7433393564296, -122.407242153126) | 10 | 7 | 7 | 28859 | 2 | ||||
97103 | 247917 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1098 Esmeralda Ave | 2 | Side Yard : Yard | Tree | Private 2 | 32 | 6010231.88216 | 2098716.76824 | 37.7432537274832 | -122.407254411775 | (37.7432537274832, -122.407254411775) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
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 | ||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
165894 | 247821 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1201 Jarboe Ave | 3 | Front Yard : Yard | Tree | Private 2 | 8 | 6009717.95526 | 2096849.33319 | 37.7380973799798 | -122.40889971695 | (37.7380973799798, -122.40889971695) | 10 | 7 | 7 | 28859 | 2 | ||||
158886 | 247820 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1201 Jarboe Ave | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6009707.55977 | 2096850.28614 | 37.7380994142676 | -122.408935726717 | (37.7380994142676, -122.408935726717) | 10 | 7 | 7 | 28859 | 2 | ||||
1776 | 247999 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450 Peralta Ave | 3 | Side Yard : Yard | Tree | Private 2 | 35 | 6009750 | 2099218 | 37.744603019334 | -122.408955999129 | (37.744603019334, -122.408955999129) | 2 | 7 | 7 | 28859 | 2 | ||||
167287 | 247819 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1201 Jarboe Ave | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 6009694.17454 | 2096850.55921 | 37.738099414264 | -122.408982025597 | (37.738099414264, -122.408982025597) | 10 | 7 | 7 | 28859 | 2 | ||||
11269 | 247818 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 1158x Jarboe Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 46 | 6009634.53348 | 2096844.36766 | 37.7380790724954 | -122.409187798594 | (37.7380790724954, -122.409187798594) | 10 | 7 | 7 | 28859 | 2 | ||||
62684 | 106004 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 695X CAMPBELL AVE | unknown : Yard | Tree | Rec/Park 5 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.410348471622 | (37.716271678506, -122.410348471622) | 9 | 7 | 8 | 309 | 39 | ||||||
163874 | 246763 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Waltham St | 7 | Front Yard : Yard | Tree | Private 2 | 27 | 6009290.72604 | 2098884.53398 | 37.7436616572582 | -122.410520540796 | (37.7436616572582, -122.410520540796) | 2 | 7 | 7 | 28859 | 2 | ||||
15695 | 262389 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 67 Rosenkranz St | 1 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6009267 | 2098344 | 37.7421761391661 | -122.410564417702 | (37.7421761391661, -122.410564417702) | 10 | 7 | 7 | 28859 | 2 | ||||
444 | 105900 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
136862 | 105901 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
189511 | 105902 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 40 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
36885 | 246762 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Waltham St | 6 | Front Yard : Yard | Tree | Private 2 | 38 | 6009259.9688 | 2098886.63063 | 37.743665689828 | -122.410627040331 | (37.743665689828, -122.410627040331) | 2 | 7 | 7 | 28859 | 2 | ||||
170504 | 246760 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Waltham St | 4 | Front Yard : Yard | Tree | Private 2 | 23 | 6009218.12342 | 2098889.2056 | 37.7436704139605 | -122.410771913907 | (37.7436704139605, -122.410771913907) | 2 | 7 | 7 | 28859 | 2 | ||||
37673 | 246758 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 70 Waltham St | 2 | Front Yard : Yard | Tree | Private 2 | 45 | 6009165.37597 | 2098887.8964 | 37.7436638615084 | -122.410954210088 | (37.7436638615084, -122.410954210088) | 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) );