Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3850 | 3850 | 207785 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 290 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 09/28/2017 12:00:00 AM | 3 | Width 10ft | 5993081.87997 | 2096205.8056700001 | 37.7353845093885 | -122.46637169180299 | (37.7353845093885, -122.466371691803) | ||
28258 | 28258 | 208938 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 66 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 10ft | 5991979.81471 | 2095977.19537 | 37.7346931510662 | -122.470165265142 | (37.7346931510662, -122.470165265142) | |||
29388 | 29388 | 207794 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 213 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993149.25155 | 2096563.99491 | 37.736371894833 | -122.46616478658999 | (37.736371894833, -122.46616478659) | |||
32381 | 32381 | 207778 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 124 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 10ft | 5993200.08857 | 2096786.31561 | 37.7369852648432 | -122.46600517310699 | (37.7369852648432, -122.466005173107) | |||
33664 | 33664 | 207789 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 275 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5993131.90761 | 2096210.54353 | 37.735400404893 | -122.46619907325199 | (37.735400404893, -122.466199073252) | |||
40215 | 40215 | 207788 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 285 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993135.10109 | 2096167.2284099997 | 37.7352816566244 | -122.46618488553001 | (37.7352816566244, -122.46618488553) | |||
41418 | 41418 | 207775 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 110 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 10ft | 5993244.34274 | 2096906.29835 | 37.737317260394 | -122.465860883191 | (37.737317260394, -122.465860883191) | |||
41832 | 41832 | 208941 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 130 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 10ft | 5992287.573419999 | 2095984.60456 | 37.734731282309106 | -122.469101787134 | (37.7347312823091, -122.469101787134) | |||
43824 | 43824 | 207767 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 20 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 10ft | 5993205.662140001 | 2097402.75145 | 37.7386781648646 | -122.466030683288 | (37.7386781648646, -122.466030683288) | |||
46031 | 46031 | 207784 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 270 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 10ft | 5993081.2153199995 | 2096255.53806 | 37.735521023771604 | -122.466377603044 | (37.7355210237716, -122.466377603044) | |||
51382 | 51382 | 207780 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 250 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 10ft | 5993075.61435 | 2096444.65306 | 37.7360399631594 | -122.46641070800501 | (37.7360399631594, -122.466410708005) | |||
53478 | 53478 | 207782 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 260 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 10ft | 5993076.07579 | 2096352.6988099997 | 37.7357875063795 | -122.466402431535 | (37.7357875063795, -122.466402431535) | |||
55842 | 55842 | 207761 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 345 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 10ft | 5993145.033430001 | 2095739.54752 | 37.7341079244482 | -122.46611947693701 | (37.7341079244482, -122.466119476937) | |||
60450 | 60450 | 207766 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 14 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 10ft | 5993184.09693 | 2097461.91411 | 37.7388393665447 | -122.46610954301799 | (37.7388393665447, -122.466109543018) | |||
60463 | 60463 | 207807 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 25 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 10ft | 5993231.15579 | 2097483.74028 | 37.7389020106052 | -122.46594842230199 | (37.7389020106052, -122.465948422302) | |||
61081 | 61081 | 208914 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 45 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 10ft | 5991964.75621 | 2096031.6123 | 37.7348416956868 | -122.470221288386 | (37.7348416956868, -122.470221288386) | |||
61439 | 61439 | 208913 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 25 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 52 | Width 10ft | 5991855.18446 | 2096027.3519599999 | 37.7348236624713 | -122.470599802253 | (37.7348236624713, -122.470599802253) | |||
64951 | 64951 | 208942 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 200 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 10ft | 5992406.13159 | 2095989.66706 | 37.7347520323855 | -122.468692262863 | (37.7347520323855, -122.468692262863) | |||
65901 | 65901 | 208933 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 405 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 10ft | 5992936.60702 | 2096064.2661700002 | 37.7349874937845 | -122.466863664131 | (37.7349874937845, -122.466863664131) | |||
72305 | 72305 | 208950 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 440 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 10ft | 5992985.54967 | 2096006.72468 | 37.734832323836706 | -122.46669027215599 | (37.7348323238367, -122.466690272156) | |||
73538 | 73538 | 207772 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 60 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5993256.95856 | 2097201.9739 | 37.7381298392237 | -122.46583874187 | (37.7381298392237, -122.46583874187) | |||
74311 | 74311 | 208919 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 10ft | 5992247.91507 | 2096042.0705099998 | 37.734886777797996 | -122.469243079632 | (37.734886777798, -122.469243079632) | |||
74562 | 74562 | 209046 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 301 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 55 | Width 10ft | 5999983.24986 | 2094934.98428 | 37.732290932375605 | -122.442419949729 | (37.7322909323756, -122.442419949729) | |||
76666 | 76666 | 207779 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 126 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 10ft | 5993175.19587 | 2096740.86685 | 37.7368590378112 | -122.46608793591001 | (37.7368590378112, -122.46608793591) | |||
76936 | 76936 | 208937 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 64 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 10ft | 5991925.34536 | 2095973.96809 | 37.734681140613105 | -122.47035334753201 | (37.7346811406131, -122.470353347532) | |||
76953 | 76953 | 208935 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 3 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5991812.79149 | 2095969.62922 | 37.7346627188958 | -122.47074216493401 | (37.7346627188958, -122.470742164934) | |||
77267 | 77267 | 207777 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 118 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | Width 10ft | 5993220.0955300005 | 2096827.0991599998 | 37.737098400464795 | -122.465938963216 | (37.7370984004648, -122.465938963216) | |||
130507 | 130507 | 207805 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 35 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 10ft | 5993257.8737699995 | 2097404.51842 | 37.738686028527 | -122.46585029007099 | (37.738686028527, -122.465850290071) | |||
131911 | 131911 | 207759 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 315 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 10ft | 5993145.97421 | 2095838.45755 | 37.7343795610583 | -122.46612340966999 | (37.7343795610583, -122.46612340967) | |||
137042 | 137042 | 207787 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 292 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 10ft | 5993086.25016 | 2096104.5741400002 | 37.7351068050182 | -122.466349227661 | (37.7351068050182, -122.466349227661) | |||
147322 | 147322 | 207803 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 55 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 10ft | 5993318.6344099995 | 2097122.65017 | 37.737915593714106 | -122.465619738075 | (37.7379155937141, -122.465619738075) | |||
149306 | 149306 | 207808 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 15 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5993219.0538800005 | 2097526.21938 | 37.7390179494069 | -122.46599335061899 | (37.7390179494069, -122.465993350619) | |||
153159 | 153159 | 207790 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 265 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | Width 10ft | 5993131.48438 | 2096255.5032900001 | 37.735523828762005 | -122.466203802777 | (37.735523828762, -122.466203802777) | |||
153757 | 153757 | 207801 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 75 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 10ft | 5993316.85986 | 2097021.89165 | 37.737638833663794 | -122.465618555459 | (37.7376388336638, -122.465618555459) | |||
157431 | 157431 | 207769 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 40 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | Width 10ft | 5993228.66009 | 2097329.84492 | 37.7384793085579 | -122.46594587182899 | (37.7384793085579, -122.465945871829) | |||
157860 | 157860 | 208927 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 301 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 10ft | 5992731.01578 | 2096057.52147 | 37.7349571065737 | -122.46757396937299 | (37.7349571065737, -122.467573969373) | |||
158211 | 158211 | 208916 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 47 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | Width 10ft | 5992082.23886 | 2096035.7065400002 | 37.7348597288875 | -122.469815411761 | (37.7348597288875, -122.469815411761) | |||
158456 | 158456 | 207762 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 355 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 10ft | 5993165.17049 | 2095669.26931 | 37.7339161197195 | -122.46604475226499 | (37.7339161197195, -122.466044752265) | |||
159777 | 159777 | 208923 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 201 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 10ft | 5992447.89906 | 2096049.02744 | 37.734917433899 | -122.468552177239 | (37.734917433899, -122.468552177239) | |||
160736 | 160736 | 207773 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 80 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 58 | Width 10ft | 5993272.22832 | 2097088.94625 | 37.7378203744176 | -122.465777737259 | (37.7378203744176, -122.465777737259) | |||
162142 | 162142 | 207781 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 256 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 10ft | 5993074.748819999 | 2096403.4667 | 37.7359268257591 | -122.466410707985 | (37.7359268257591, -122.466410707985) | |||
162672 | 162672 | 207760 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 333 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5993144.47081 | 2095802.99513 | 37.734282103340796 | -122.46612603120501 | (37.7342821033408, -122.466126031205) | |||
164844 | 164844 | 208930 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 435 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 55 | Width 10ft | 5993068.37064 | 2096069.711 | 37.735010047856704 | -122.466408510055 | (37.7350100478567, -122.466408510055) | |||
165081 | 165081 | 207774 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 98 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 10ft | 5993269.03182 | 2097018.73215 | 37.7376273996789 | -122.465783688974 | (37.7376273996789, -122.465783688974) | |||
165361 | 165361 | 207798 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 101 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 10ft | 5993265.61107 | 2096796.17632 | 37.7370161196856 | -122.465779350629 | (37.7370161196856, -122.465779350629) | |||
165620 | 165620 | 207802 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 65 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 10ft | 5993322.83202 | 2097078.2937 | 37.7377940440554 | -122.465602003431 | (37.7377940440554, -122.465602003431) | |||
167226 | 167226 | 208947 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 340 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 10ft | 5992761.11825 | 2096003.55707 | 37.734810671779705 | -122.467465972472 | (37.7348106717797, -122.467465972472) | |||
167382 | 167382 | 207793 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 215 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 10ft | 5993139.697869999 | 2096516.18073 | 37.7362400578338 | -122.466194343712 | (37.7362400578338, -122.466194343712) | |||
173563 | 173563 | 208921 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 135 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 10ft | 5992336.36345 | 2096045.4635 | 37.7349012047205 | -122.46893753225001 | (37.7349012047205, -122.46893753225) | |||
175986 | 175986 | 207763 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 290 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 10ft | 5993266.97338 | 2095443.21542 | 37.7333013044925 | -122.46567637377599 | (37.7333013044925, -122.465676373776) | |||
176352 | 176352 | 208925 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 235 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 45 | Width 10ft | 5992554.16067 | 2096052.7030900002 | 37.734933663950294 | -122.46818506409599 | (37.7349336639503, -122.468185064096) | |||
178890 | 178890 | 207796 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 145 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 45 | Width 10ft | 5993217.29355 | 2096710.01575 | 37.736776757040204 | -122.465940145823 | (37.7367767570402, -122.465940145823) | |||
180635 | 180635 | 208944 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 234 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 10ft | 5992497.26068 | 2095992.6782799999 | 37.73476556447329 | -122.468377420108 | (37.7347655644733, -122.468377420108) | |||
181129 | 181129 | 207771 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 50 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 10ft | 5993253.43088 | 2097238.9026200003 | 37.7382310327445 | -122.465853621172 | (37.7382310327445, -122.465853621172) | |||
185411 | 185411 | 208939 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 10ft | 5992155.70572 | 2095974.23732 | 37.7346951961161 | -122.469556940308 | (37.7346951961161, -122.469556940308) | |||
188685 | 188685 | 207791 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 255 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 10ft | 5993127.95212 | 2096331.51719 | 37.7357323401679 | -122.466221537416 | (37.7357323401679, -122.466221537416) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");