161 rows where qSiteInfo = "Sidewalk: Property side : Yard" and qSpecies_id = 63 sorted by Neighborhoods (old)

View and edit SQL

qSiteInfo

  • Sidewalk: Property side : Yard · 161
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) ▼
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                              
10489 102839 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 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
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
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
12450 261565 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 26th St 2 Sidewalk: Property side : Yard Tree DPW 1       3x3   6013146 2101521 37.7511162126671 -122.39737469907 (37.7511162126671, -122.39737469907) 10 3 8 28856 1
14391 194472 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 84 Whitney Young Cir 5 Sidewalk: Property side : Yard Tree Private 2     16     6016745.33826 2095063.00852 37.7335836232886 -122.384477928938 (37.7335836232886, -122.384477928938) 10 3 8 58 1
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
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
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
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
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
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
27135 194470 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 84 Whitney Young Cir 3 Sidewalk: Property side : Yard Tree Private 2     16     6016764.11928 2095038.85548 37.7335183423928 -122.384411315236 (37.7335183423928, -122.384411315236) 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
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
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
38402 194467 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Quint St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   6012416.6749 2095223.97206 37.7337852773717 -122.399454760738 (37.7337852773717, -122.399454760738) 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
137520 194468 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Quint St 5 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6012422.70585 2095229.76642 37.7338015236278 -122.399434316464 (37.7338015236278, -122.399434316464) 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
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
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
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
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
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
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
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
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
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
163834 194471 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 84 Whitney Young Cir 4 Sidewalk: Property side : Yard Tree Private 2     14     6016756.75905 2095047.76274 37.7335423929578 -122.38443738208 (37.7335423929578, -122.38443738208) 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
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
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
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
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
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
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
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
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
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
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
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
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
77915 257969 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1998X 09th Ave 1 Sidewalk: Property side : Yard Tree Private 2       6x15   5993560 2101938 37.7511512457798 -122.465134876758 (37.7511512457798, -122.465134876758) 1 8 4 29491 12
118830 211056 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 17th Ave 2 Sidewalk: Property side : Yard Tree Private 2     20     5990908.64637 2104472.93122 37.7579582535812 -122.474488420401 (37.7579582535812, -122.474488420401) 1 8 4 56 12
108195 247896 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 351 Mayflower St 1 Sidewalk: Property side : Yard Tree Private 2     29 Width 5ft   6010145.43386 2098385.46575 37.7423392041921 -122.407529975731 (37.7423392041921, -122.407529975731) 10 7 7 28859 2
128762 247016 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 500 Valley St 6 Sidewalk: Property side : Yard Tree Private 2     3     6002574.36339 2099193.51243 37.7441312166966 -122.433766148707 (37.7441312166966, -122.433766148707) 2 7 5 63 22
6278 132178 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2449 Mason St 1 Sidewalk: Property side : Yard Tree Private 2     36     6008741.74811 2122071.63658 37.807297172691 -122.414058809171 (37.807297172691, -122.414058809171) 3 1 10 308 23
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
154451 178178 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 769 Cayuga Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   6001369.37887 2092541.7115 37.725798463024 -122.43745647446 (37.725798463024, -122.43745647446) 9 7 6 28861 25
29047 194457 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 32 Sidewalk: Property side : Yard Tree Private 2     30     6012708.71911 2101842.22219 37.7519738634013 -122.398909414543 (37.7519738634013, -122.398909414543) 10 3 8 28856 29
66190 194458 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 33 Sidewalk: Property side : Yard Tree Private 2     26     6012757.94703 2101850.0059 37.7519979787223 -122.398739722368 (37.7519979787223, -122.398739722368) 10 3 8 28856 29
78908 194452 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 20th St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6011998.43391 2104639.55141 37.7596151114626 -122.401562284167 (37.7596151114626, -122.401562284167) 10 3 8 28856 29
120848 194447 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 680 De Haro St 4 Sidewalk: Property side : Yard Tree Private 2     1     6012074.20817 2105270.47212 37.761351707727 -122.401344555627 (37.761351707727, -122.401344555627) 10 3 8 28856 29
133881 194454 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Rhode Island St 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   6012013.85217 2102295.56099 37.753179889343 -122.40134423455 (37.753179889343, -122.40134423455) 10 3 8 28856 29
166032 194459 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2001 25th St 34 Sidewalk: Property side : Yard Tree Private 2     24     6012781.55557 2101851.76257 37.7520041175184 -122.398658203327 (37.7520041175184, -122.398658203327) 10 3 8 28856 29
192071 132173 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 91 Mayfair Dr 3 Sidewalk: Property side : Yard Tree Private 2     15 Width 6ft   5997717.35609 2114490.42899 37.7858558611085 -122.45166373929 (37.7858558611085, -122.45166373929) 15 6 1 54 31
103192 132176 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2745 Larkin St 2 Sidewalk: Property side : Yard Tree Private 2     14     6006527.83964 2120663.1294 37.8033051783476 -122.421620437537 (37.8033051783476, -122.421620437537) 5 9 1 28858 32
108098 132177 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1048 Union St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6007888.26555 2119276.18895 37.7995736051877 -122.416814304957 (37.7995736051877, -122.416814304957) 5 1 1 308 32
117514 132181 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 4 Sidewalk: Property side : Yard Tree Private 2     21     6007227.55341 2121889.28804 37.8067113282286 -122.419286081687 (37.8067113282286, -122.419286081687) 5 1 1 28858 32
146172 132180 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 3 Sidewalk: Property side : Yard Tree Private 2     26     6007242.78631 2121872.67886 37.8066665815484 -122.419232186229 (37.8066665815484, -122.419232186229) 5 1 1 28858 32
187217 132182 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 601 Beach St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 5ft   6007241.65576 2121894.78138 37.8067272057567 -122.419237667598 (37.8067272057567, -122.419237667598) 5 1 1 28858 32
193997 132179 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1302 Columbus Ave 2 Sidewalk: Property side : Yard Tree Private 2     33     6007259.69894 2121860.76679 37.8066348265036 -122.419172811197 (37.8066348265036, -122.419172811197) 5 1 1 28858 32
1901 262254 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 4210 Ocean Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
2394 184349 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1251 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     28 Width 0ft   5984659.3559 2106454.1603 37.7630340956965 -122.496246960605 (37.7630340956965, -122.496246960605) 1 8 3 56 35
11326 186595 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 66 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984740.8383 2104479.6291 37.7576173573885 -122.49581948315 (37.7576173573885, -122.49581948315) 1 8 3 56 35
16186 186101 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984808.9821 2101715.6546 37.7500322370685 -122.495379978089 (37.7500322370685, -122.495379978089) 1 8 3 29491 35
20177 187394 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 2100 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5985039.81 2100667.7899 37.7471685994587 -122.494504537591 (37.7471685994587, -122.494504537591) 1 8 3 29491 35
21400 186097 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984866.2826 2101735.8043 37.7500909175156 -122.495183318527 (37.7500909175156, -122.495183318527) 1 8 3 29491 35
33872 186702 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1401 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     23 Width 0ft   5984718.4366 2105146.0279 37.7594457908807 -122.495946116181 (37.7594457908807, -122.495946116181) 1 8 3 56 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);