Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29169 | 29169 | 202128 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2799 Newhall St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6012573.71911 | 2093089.235 | 37.7279324822924 | -122.398762044451 | (37.7279324822924, -122.398762044451) | |||
29243 | 29243 | 201365 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 205 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6013111.57283 | 2092803.6730099998 | 37.7271783404816 | -122.39688264483401 | (37.7271783404816, -122.396882644834) | |||
29951 | 29951 | 201313 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 300 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 6012967.92533 | 2092673.3343599997 | 37.7268124603184 | -122.397370099843 | (37.7268124603184, -122.397370099843) | |||
34984 | 34984 | 182861 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1839 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988124.6648 | 2102778.1754 | 37.7531432168441 | -122.483992213945 | (37.7531432168441, -122.483992213945) | |||
38238 | 38238 | 118387 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 5640 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981104.69221 | 2111668.01683 | 37.7771409589636 | -122.508928263307 | (37.7771409589636, -122.508928263307) | |||
40257 | 40257 | 193614 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 400 Cargo Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6016222.8918 | 2099596.86251 | 37.746003760769796 | -122.38660023182 | (37.7460037607698, -122.38660023182) | |||
41096 | 41096 | 201274 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 210 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 6013027.04362 | 2092751.29466 | 37.7270298147504 | -122.39717119231899 | (37.7270298147504, -122.397171192319) | |||
51619 | 51619 | 202125 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2801 Newhall St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 2ft | 6012532.0475 | 2092956.0428099998 | 37.7275644419367 | -122.398896761103 | (37.7275644419367, -122.398896761103) | |||
52332 | 52332 | 201344 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Bitting Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 6012750.594330001 | 2092624.2153200002 | 37.7266654868035 | -122.39811796796499 | (37.7266654868035, -122.398117967965) | |||
57004 | 57004 | 193613 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 400 Cargo Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6016243.299930001 | 2099581.7873299997 | 37.745963497216 | -122.386528611609 | (37.745963497216, -122.386528611609) | |||
64294 | 64294 | 177562 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 10 Ruth St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6001656.83533 | 2091594.1990900002 | 37.7232131468593 | -122.43639497677201 | (37.7232131468593, -122.436394976772) | |||
64584 | 64584 | 201341 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Bitting Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6012735.10181 | 2092634.8954900003 | 37.726693949445 | -122.398172274424 | (37.726693949445, -122.398172274424) | |||
65618 | 65618 | 201316 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 338 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 2ft | 6012923.5709 | 2092614.11032 | 37.7266473735717 | -122.397519281196 | (37.7266473735717, -122.397519281196) | |||
67052 | 67052 | 193616 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 400 Cargo Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6016188.46596 | 2099620.47272 | 37.7460666836449 | -122.386720919033 | (37.7460666836449, -122.386720919033) | |||
69547 | 69547 | 202123 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2801 Newhall St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 6012526.8692 | 2092938.70348 | 37.7275165431484 | -122.39891344620001 | (37.7275165431484, -122.3989134462) | |||
71732 | 71732 | 201317 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 338 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6012912.13536 | 2092610.19573 | 37.7266359881561 | -122.39755853931001 | (37.7266359881561, -122.39755853931) | |||
74802 | 74802 | 202126 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2801 Newhall St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 6012542.38244 | 2092989.6541799998 | 37.727657307738795 | -122.39886339085 | (37.7276573077388, -122.39886339085) | |||
75998 | 75998 | 118388 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 5640 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5981070.6492099995 | 2111666.32883 | 37.7771343173465 | -122.50904590130502 | (37.7771343173465, -122.509045901305) | |||
76672 | 76672 | 177561 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 10 Ruth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6001695.33402 | 2091574.4813599999 | 37.7231611939064 | -122.436260484046 | (37.7231611939064, -122.436260484046) | |||
80961 | 80961 | 104879 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 234 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/25/2013 12:00:00 AM | Permit Number 771117 | 5987170.1 | 2114381.0 | 37.784945722992504 | -122.488145785283 | (37.7849457229925, -122.488145785283) | |||
104750 | 104750 | 201314 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 300 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6012949.79576 | 2092647.31543 | 37.7267400082294 | -122.397430949795 | (37.7267400082294, -122.397430949795) | |||
115865 | 115865 | 104878 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 234 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/25/2013 12:00:00 AM | Permit Number 771117 | 5987170.1 | 2114381.0 | 37.784945722992504 | -122.488145785283 | (37.7849457229925, -122.488145785283) | |||
126756 | 126756 | 202160 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1901 Armstrong Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6013174.41964 | 2093345.4419200001 | 37.7286694254389 | -122.396703346088 | (37.7286694254389, -122.396703346088) | |||
134027 | 134027 | 193615 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 400 Cargo Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6016204.3919 | 2099609.55217 | 37.746037579778296 | -122.38666508732 | (37.7460375797783, -122.38666508732) | |||
134491 | 134491 | 118741 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 616 44th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5982283.91795 | 2111534.27882 | 37.776843197495396 | -122.50483910608801 | (37.7768431974954, -122.504839106088) | |||
146338 | 146338 | 202127 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2799 Newhall St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 2ft | 6012570.68337 | 2093080.57423 | 37.7279085324504 | -122.39877193159401 | (37.7279085324504, -122.398771931594) | |||
146984 | 146984 | 202130 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2799 Newhall St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 6012587.09689 | 2093131.8623799998 | 37.7280502737004 | -122.398718787067 | (37.7280502737004, -122.398718787067) | |||
151860 | 151860 | 201339 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Bitting Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 6012722.61322 | 2092644.3841099998 | 37.7267193076322 | -122.39821611279899 | (37.7267193076322, -122.398216112799) | |||
152281 | 152281 | 201338 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 51 Bitting Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 6012714.99003 | 2092651.13548 | 37.7267374208889 | -122.398242939583 | (37.7267374208889, -122.398242939583) | |||
153414 | 153414 | 210169 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 41 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5995167.26839 | 2100034.8829799998 | 37.74601831629221 | -122.459438997135 | (37.7460183162922, -122.459438997135) | |||
160496 | 160496 | 210124 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1385 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 5993817.1822 | 2094684.91892 | 37.7312509302751 | -122.46371914682 | (37.7312509302751, -122.46371914682) | |||
164938 | 164938 | 250939 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 234 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987146.614630001 | 2114364.81328 | 37.7848999087463 | -122.488225846149 | (37.7848999087463, -122.488225846149) | |||
169002 | 169002 | 201337 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 51 Bitting Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6012704.55198 | 2092659.0745700002 | 37.7267586385791 | -122.39827958063101 | (37.7267586385791, -122.398279580631) | |||
171087 | 171087 | 202312 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 185 Orsi Cir | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 6013083.45837 | 2092922.00198 | 37.7275016827573 | -122.396988129905 | (37.7275016827573, -122.396988129905) | |||
171616 | 171616 | 210170 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2 Castenada Ave | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994405.540030001 | 2101788.9610200003 | 37.7507907441137 | -122.462200123556 | (37.7507907441137, -122.462200123556) | |||
172881 | 172881 | 201320 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2 Bitting Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 6012844.74105 | 2092628.1484700001 | 37.7266815298237 | -122.397792779424 | (37.7266815298237, -122.397792779424) | |||
176636 | 176636 | 202122 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2821 Newhall St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 6012522.62409 | 2092923.30317 | 37.727474020508296 | -122.398927041246 | (37.7274740205083, -122.398927041246) | |||
178485 | 178485 | 201315 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 300 Kalmanovitz St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 6012943.34594 | 2092637.26865 | 37.726712062701296 | -122.397452542498 | (37.7267120627013, -122.397452542498) | |||
178880 | 178880 | 117826 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 639 40th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5983481.30251 | 2111445.18055 | 37.776668928038504 | -122.500690467806 | (37.7766689280385, -122.500690467806) | |||
182179 | 182179 | 202129 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2799 Newhall St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 2ft | 6012584.23259 | 2093122.84243 | 37.72802534718 | -122.39872805636601 | (37.72802534718, -122.398728056366) | |||
183683 | 183683 | 202120 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2851 Newhall St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 2ft | 6012482.2608 | 2092792.9317 | 37.7271137979631 | -122.399057431278 | (37.7271137979631, -122.399057431278) | |||
187295 | 187295 | 202124 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2801 Newhall St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 6012530.10914 | 2092948.6060099998 | 37.7275439140005 | -122.398902940345 | (37.7275439140005, -122.398902940345) |
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");