trees
438 rows where qSpecies_id = 63 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
954 | 20324 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
2047 | 20346 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 40 | |||||||||||||
3556 | 20340 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | |||||||||||||
5800 | 98837 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5956 | 98839 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
7308 | 20330 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
7987 | 20066 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 100 STAIRWAY54 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
8061 | 20397 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 262X Sunset Blvd | 42 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
8532 | 19778 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 100 STAIRWAY18 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
9886 | 20336 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
10489 | 102839 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1101X Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10520 | 20335 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | |||||||||||||
12952 | 20300 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 50X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
13465 | 20460 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 495X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
14475 | 20345 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 40 | |||||||||||||
16263 | 20326 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 101X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
35868 | 24283 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 300X Winding Way | 21 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | 9 | 7 | 6 | 28861 | 5 | |||
77810 | 1321 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 4050X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | TR | 5991740.4279021 | 2087082.0100679 | 37.7102553211792 | -122.470345319704 | (37.7102553211792, -122.470345319704) | 9 | 8 | 4 | 64 | 24 | |||
22688 | 120924 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
60656 | 120926 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
109715 | 120932 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
136239 | 120933 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
145282 | 120934 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
156900 | 120929 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
162123 | 120936 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
162461 | 120921 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
17861 | 201752 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 491 Jamestown Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 6015886.86298 | 2086978.1992 | 37.7113368105223 | -122.386882306895 | (37.7113368105223, -122.386882306895) | 10 | 3 | 8 | 58 | 1 | |||
144133 | 201751 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 491 Jamestown Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 6015871.64119 | 2086992.23012 | 37.7113744939227 | -122.386935895675 | (37.7113744939227, -122.386935895675) | 10 | 3 | 8 | 58 | 1 | |||
82734 | 201750 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 491 Jamestown Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | Width 8ft | 6015853.10494 | 2087012.76113 | 37.7114298417752 | -122.3870013933 | (37.7114298417752, -122.3870013933) | 10 | 3 | 8 | 58 | 1 | |||
113722 | 201749 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 491 Jamestown Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 8ft | 6015821.03447 | 2087045.57383 | 37.7115181633057 | -122.387114525336 | (37.7115181633057, -122.387114525336) | 10 | 3 | 8 | 58 | 1 | |||
49296 | 121082 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 24X KEMPTON AVE | 6 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
110823 | 201753 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015806.16056 | 2087204.98759 | 37.7119550593549 | -122.387177046177 | (37.7119550593549, -122.387177046177) | 10 | 3 | 8 | 58 | 1 | |||
106418 | 201754 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015794.33118 | 2087216.37677 | 37.7119856767735 | -122.387218726159 | (37.7119856767735, -122.387218726159) | 10 | 3 | 8 | 58 | 1 | |||
142542 | 201755 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015777.13838 | 2087239.45412 | 37.7120480906272 | -122.38727975865 | (37.7120480906272, -122.38727975865) | 10 | 3 | 8 | 58 | 1 | |||
157528 | 201756 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6015765.33497 | 2087252.12963 | 37.7120822414633 | -122.387321438639 | (37.7120822414633, -122.387321438639) | 10 | 3 | 8 | 58 | 1 | |||
79660 | 201757 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015756.55363 | 2087265.17293 | 37.7121175695368 | -122.38735269906 | (37.7121175695368, -122.38735269906) | 10 | 3 | 8 | 58 | 1 | |||
133258 | 201758 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015742.62341 | 2087279.17788 | 37.7121552529428 | -122.387401822747 | (37.7121552529428, -122.387401822747) | 10 | 3 | 8 | 58 | 1 | |||
23165 | 201759 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015719.97269 | 2087309.22701 | 37.712236507578 | -122.387482205949 | (37.712236507578, -122.387482205949) | 10 | 3 | 8 | 58 | 1 | |||
107661 | 201748 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015601.73852 | 2087319.33199 | 37.7122577046069 | -122.387891566548 | (37.7122577046069, -122.387891566548) | 10 | 3 | 8 | 58 | 1 | |||
120938 | 110397 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 2200 BAY SHORE BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x30 | 6011234 | 2087411 | 37.7122664722191 | -122.40299429709 | (37.7122664722191, -122.40299429709) | 9 | 7 | 8 | 309 | 39 | ||||
119044 | 201747 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015587.35405 | 2087353.50341 | 37.7123507358797 | -122.387943666966 | (37.7123507358797, -122.387943666966) | 10 | 3 | 8 | 58 | 1 | |||
131920 | 201760 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6015686.51796 | 2087358.79354 | 37.7123707547676 | -122.387601292376 | (37.7123707547676, -122.387601292376) | 10 | 3 | 8 | 58 | 1 | |||
160907 | 201746 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015580.41623 | 2087372.51377 | 37.7124025503214 | -122.387968972099 | (37.7124025503214, -122.387968972099) | 10 | 3 | 8 | 58 | 1 | |||
25951 | 201761 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015680.02756 | 2087378.65264 | 37.7124249245429 | -122.387625110022 | (37.7124249245429, -122.387625110022) | 10 | 3 | 8 | 58 | 1 | |||
187791 | 201745 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6015574.32176 | 2087390.64932 | 37.7124520094198 | -122.387991301359 | (37.7124520094198, -122.387991301359) | 10 | 3 | 8 | 58 | 1 | |||
166606 | 201762 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6015664.25655 | 2087408.13431 | 37.712505001973 | -122.387681675578 | (37.712505001973, -122.387681675578) | 10 | 3 | 8 | 58 | 1 | |||
57881 | 201744 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015567.574 | 2087419.0912 | 37.7125297315236 | -122.388016607392 | (37.7125297315236, -122.388016607392) | 10 | 3 | 8 | 58 | 1 | |||
156029 | 201763 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015661.0546 | 2087420.2073 | 37.7125379747236 | -122.387693584416 | (37.7125379747236, -122.387693584416) | 10 | 3 | 8 | 58 | 1 | |||
172168 | 201743 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015564.44995 | 2087435.02252 | 37.7125733027894 | -122.388028516211 | (37.7125733027894, -122.388028516211) | 10 | 3 | 8 | 58 | 1 | |||
122823 | 201764 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015653.28128 | 2087440.52101 | 37.7125933216851 | -122.387721868094 | (37.7125933216851, -122.387721868094) | 10 | 3 | 8 | 58 | 1 | |||
171241 | 201765 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015652.50021 | 2087465.84041 | 37.7126628006338 | -122.387726333216 | (37.7126628006338, -122.387726333216) | 10 | 3 | 8 | 58 | 1 | |||
168552 | 201742 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015557.23057 | 2087482.77303 | 37.7127040165438 | -122.388056798998 | (37.7127040165438, -122.388056798998) | 10 | 3 | 8 | 58 | 1 | |||
32167 | 201766 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015647.69731 | 2087483.94989 | 37.7127122597387 | -122.387744196458 | (37.7127122597387, -122.387744196458) | 10 | 3 | 8 | 58 | 1 | |||
36162 | 110396 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1x ARLETA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x30 | 6011055 | 2087587 | 37.7127397354919 | -122.403625353192 | (37.7127397354919, -122.403625353192) | 9 | 7 | 8 | 309 | 39 | ||||
63112 | 201741 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015551.73985 | 2087509.47398 | 37.7127770280164 | -122.388077638997 | (37.7127770280164, -122.388077638997) | 10 | 3 | 8 | 58 | 1 | |||
106214 | 201767 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015642.29299 | 2087514.93769 | 37.7127970469199 | -122.387765036445 | (37.7127970469199, -122.387765036445) | 10 | 3 | 8 | 58 | 1 | |||
96403 | 201768 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015641.02933 | 2087537.69345 | 37.7128594598683 | -122.387770990859 | (37.7128594598683, -122.387770990859) | 10 | 3 | 8 | 58 | 1 | |||
114462 | 201769 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015636.77799 | 2087561.79601 | 37.7129254053659 | -122.387787365691 | (37.7129254053659, -122.387787365691) | 10 | 3 | 8 | 58 | 1 | |||
20635 | 201770 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015634.53236 | 2087578.56705 | 37.712971331023 | -122.387796296857 | (37.712971331023, -122.387796296857) | 10 | 3 | 8 | 58 | 1 | |||
39195 | 201740 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015542.0778 | 2087585.57887 | 37.7129854620959 | -122.388116342205 | (37.7129854620959, -122.388116342205) | 10 | 3 | 8 | 58 | 1 | |||
116365 | 2273 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 750X Brotherhood Way | 7 | Median : Cutout | Tree | DPW 1 | 35 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
134014 | 2272 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 750X Brotherhood Way | 6 | Median : Cutout | Tree | DPW 1 | 20 | 14M | 5991074.0426161 | 2088106.2478104 | 37.7130290777882 | -122.47272309172 | (37.7130290777882, -122.47272309172) | 1 | 8 | 4 | 64 | 14 | |||
191105 | 201771 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6015632.38361 | 2087621.49757 | 37.7130890909533 | -122.387806717322 | (37.7130890909533, -122.387806717322) | 10 | 3 | 8 | 58 | 1 | |||
175395 | 201739 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015537.38953 | 2087630.70495 | 37.7131091098792 | -122.388135693819 | (37.7131091098792, -122.388135693819) | 10 | 3 | 8 | 58 | 1 | |||
188380 | 201772 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015630.59439 | 2087639.54626 | 37.7131385500726 | -122.387814160092 | (37.7131385500726, -122.387814160092) | 10 | 3 | 8 | 58 | 1 | |||
48450 | 201773 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015629.12317 | 2087652.01307 | 37.7131727000372 | -122.387820114508 | (37.7131727000372, -122.387820114508) | 10 | 3 | 8 | 58 | 1 | |||
146862 | 201738 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015533.66415 | 2087659.51426 | 37.7131880082953 | -122.388150579386 | (37.7131880082953, -122.388150579386) | 10 | 3 | 8 | 58 | 1 | |||
182292 | 201774 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015625.88693 | 2087662.37118 | 37.7132009621398 | -122.38783202245 | (37.7132009621398, -122.38783202245) | 10 | 3 | 8 | 58 | 1 | |||
31995 | 201737 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6015529.27451 | 2087676.75764 | 37.7132351120852 | -122.38816695425 | (37.7132351120852, -122.38816695425) | 10 | 3 | 8 | 58 | 1 | |||
7554 | 201736 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015525.30693 | 2087693.56377 | 37.7132810386533 | -122.38818183984 | (37.7132810386533, -122.38818183984) | 10 | 3 | 8 | 58 | 1 | |||
183877 | 201775 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015614.36786 | 2087706.44647 | 37.7133213462866 | -122.387874910195 | (37.7133213462866, -122.387874910195) | 10 | 3 | 8 | 58 | 1 | |||
43163 | 201735 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015522.2781 | 2087714.21053 | 37.7133375628641 | -122.388193748644 | (37.7133375628641, -122.388193748644) | 10 | 3 | 8 | 58 | 1 | |||
38128 | 201734 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015517.44938 | 2087731.03371 | 37.71338348853 | -122.388211611887 | (37.71338348853, -122.388211611887) | 10 | 3 | 8 | 58 | 1 | |||
67122 | 201776 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6015607.24672 | 2087763.10237 | 37.7134765179931 | -122.387903474463 | (37.7134765179931, -122.387903474463) | 10 | 3 | 8 | 58 | 1 | |||
21065 | 201733 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015510.4184 | 2087766.77172 | 37.7134812286504 | -122.388238406274 | (37.7134812286504, -122.388238406274) | 10 | 3 | 8 | 58 | 1 | |||
99536 | 201777 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6015601.56547 | 2087780.3718 | 37.7135236217889 | -122.387924315354 | (37.7135236217889, -122.387924315354) | 10 | 3 | 8 | 58 | 1 | |||
164947 | 201778 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 8ft | 6015594.19044 | 2087820.40535 | 37.7136331376383 | -122.387952598145 | (37.7136331376383, -122.387952598145) | 10 | 3 | 8 | 58 | 1 | |||
187046 | 201779 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015589.3271 | 2087835.51364 | 37.7136743526627 | -122.387970461377 | (37.7136743526627, -122.387970461377) | 10 | 3 | 8 | 58 | 1 | |||
132708 | 201780 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015582.72471 | 2087849.79956 | 37.7137132132682 | -122.387994278123 | (37.7137132132682, -122.387994278123) | 10 | 3 | 8 | 58 | 1 | |||
25472 | 201732 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015480.18133 | 2087865.40702 | 37.713750386735 | -122.388349797223 | (37.713750386735, -122.388349797223) | 10 | 3 | 8 | 58 | 1 | |||
96989 | 201781 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6015573.4977 | 2087883.43723 | 37.713805064638 | -122.388028516222 | (37.713805064638, -122.388028516222) | 10 | 3 | 8 | 58 | 1 | |||
124322 | 201782 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015559.74323 | 2087927.45907 | 37.713925178088 | -122.388079127353 | (37.713925178088, -122.388079127353) | 10 | 3 | 8 | 58 | 1 | |||
84080 | 201783 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015549.05195 | 2087952.54872 | 37.7139934770858 | -122.388117830599 | (37.7139934770858, -122.388117830599) | 10 | 3 | 8 | 58 | 1 | |||
2009 | 201784 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015541.73553 | 2087974.13978 | 37.7140523566047 | -122.388144625001 | (37.7140523566047, -122.388144625001) | 10 | 3 | 8 | 58 | 1 | |||
133522 | 201785 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6015530.91454 | 2087992.79913 | 37.7141029920284 | -122.388183328214 | (37.7141029920284, -122.388183328214) | 10 | 3 | 8 | 58 | 1 | |||
154803 | 201786 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015524.34656 | 2088008.79963 | 37.714146562401 | -122.38820714586 | (37.714146562401, -122.38820714586) | 10 | 3 | 8 | 58 | 1 | |||
154751 | 201787 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 8ft | 6015507.5354 | 2088050.73887 | 37.7142607879799 | -122.388268177459 | (37.7142607879799, -122.388268177459) | 10 | 3 | 8 | 58 | 1 | |||
67974 | 201788 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015494.63123 | 2088072.87111 | 37.7143208438162 | -122.388314323455 | (37.7143208438162, -122.388314323455) | 10 | 3 | 8 | 58 | 1 | |||
192204 | 201789 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015483.87953 | 2088094.96024 | 37.7143809005356 | -122.388353026664 | (37.7143809005356, -122.388353026664) | 10 | 3 | 8 | 58 | 1 | |||
90634 | 201790 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015475.6761 | 2088115.28204 | 37.7144362457024 | -122.388382798743 | (37.7144362457024, -122.388382798743) | 10 | 3 | 8 | 58 | 1 | |||
160221 | 201791 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6015459.4491 | 2088143.48556 | 37.7145127879215 | -122.388440853585 | (37.7145127879215, -122.388440853585) | 10 | 3 | 8 | 58 | 1 | |||
12042 | 201792 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 8ft | 6015451.0989 | 2088156.51994 | 37.7145481150837 | -122.388470624731 | (37.7145481150837, -122.388470624731) | 10 | 3 | 8 | 58 | 1 | |||
145724 | 201793 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015446.06267 | 2088163.05451 | 37.7145657786635 | -122.388488487967 | (37.7145657786635, -122.388488487967) | 10 | 3 | 8 | 58 | 1 | |||
87306 | 201794 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6015439.96848 | 2088181.18977 | 37.7146152368657 | -122.388510817234 | (37.7146152368657, -122.388510817234) | 10 | 3 | 8 | 58 | 1 | |||
65486 | 201795 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 6015420.28917 | 2088209.03426 | 37.7146906018698 | -122.388580780005 | (37.7146906018698, -122.388580780005) | 10 | 3 | 8 | 58 | 1 | |||
97073 | 194469 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 981 Le Conte Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | 6013175.32991 | 2089516.24763 | 37.7181552814285 | -122.396431907321 | (37.7181552814285, -122.396431907321) | 10 | 3 | 8 | 58 | 1 | ||||
59640 | 211078 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 97 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 5994121.91269 | 2090532.87853 | 37.7198679898921 | -122.462364611346 | (37.7198679898921, -122.462364611346) | 9 | 8 | 6 | 28861 | 24 | |||
135343 | 30050 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 900X Junipero Serra Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 3X3 | 5991182.41456 | 2091161.54655 | 37.7214244519661 | -122.472571141372 | (37.7214244519661, -122.472571141372) | 9 | 8 | 4 | 64 | 40 | |||
142939 | 199653 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2700 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014921.1055 | 2090874.3975 | 37.721981490288 | -122.390492306355 | (37.721981490288, -122.390492306355) | 10 | 3 | 8 | 58 | 1 | |||
138520 | 22454 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 6155X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 40M | 6013523.9988031 | 2091160.9249677 | 37.722690633869 | -122.395341851189 | (37.722690633869, -122.395341851189) | 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) );