Data source: data.sfgov.org
This data as json, CSV (advanced)
qSiteInfo ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
141727 | 141727 | 38353 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1800 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1998 12:00:00 AM | Permit Number 40421 | 5981341.25756614 | 2102804.1865841 | 37.7528173861664 | -122.507452100184 | (37.7528173861664, -122.507452100184) | ||
142338 | 142338 | 43216 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 44 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | Permit Number 43006 | 6008111.99433178 | 2094081.5468642 | 37.73040755168461 | -122.41425657074 | (37.7304075516846, -122.41425657074) | ||
142496 | 142496 | 31633 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2522 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35150 | 5981503.28977265 | 2097904.29050404 | 37.739373184525704 | -122.506528416597 | (37.7393731845257, -122.506528416597) | ||
144523 | 144523 | 30672 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 39 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2003 12:00:00 AM | Permit Number 34597 | 6006368.06236527 | 2109117.19408355 | 37.7715938820876 | -122.421352936259 | (37.7715938820876, -122.421352936259) | ||
145753 | 145753 | 31644 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3601 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | Permit Number 35157 | 5982065.15070434 | 2098736.73871701 | 37.7416919237879 | -122.504647444825 | (37.7416919237879, -122.504647444825) | ||
146438 | 146438 | 43057 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1922 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53821 | 5981365.4957 | 2101971.9303 | 37.750533673272706 | -122.507306541093 | (37.7505336732727, -122.507306541093) |
149060 | 149060 | 49454 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 277@ BLANKEN Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2003 12:00:00 AM | 7 | Permit Number 46388 | 6012179.13947 | 2087360.9312099998 | 37.71218172628829 | -122.39972407980801 | (37.7121817262883, -122.399724079808) | |
150340 | 150340 | 250991 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 418 45th Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5981922.93947 | 2112926.15087 | 37.7806436252297 | -122.506191049582 | (37.7806436252297, -122.506191049582) | |||
150825 | 150825 | 31310 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 577 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34948 | 6005032.34705274 | 2111420.35666119 | 37.777842407995294 | -122.42613724809999 | (37.7778424079953, -122.4261372481) | |
153451 | 153451 | 139625 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 1761 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001622.1557 | 2112159.8649 | 37.779679575976 | -122.437987249049 | (37.779679575976, -122.437987249049) | |||
154502 | 154502 | 184532 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 4041 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5981429.119 | 2102119.1438 | 37.7509416273735 | -122.507097450181 | (37.7509416273735, -122.507097450181) | |||
157211 | 157211 | 183355 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 3546 Rivera St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5982088.9451 | 2100155.7156 | 37.74558944081421 | -122.504670285508 | (37.7455894408142, -122.504670285508) | |||
157476 | 157476 | 31309 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 577 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34948 | 6005032.34705274 | 2111420.35666119 | 37.777842407995294 | -122.42613724809999 | (37.7778424079953, -122.4261372481) | |
157813 | 157813 | 98357 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4201 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5981815.8 | 2104809.3 | 37.758350801359704 | -122.50595972261401 | (37.7583508013597, -122.505959722614) | |||
159177 | 159177 | 232034 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 5 Clarendon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 2ft | 5998231.75186 | 2104660.34285 | 37.758894411852204 | -122.449175639859 | (37.7588944118522, -122.449175639859) | |||
159623 | 159623 | 210100 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 700 Junipero Serra Blvd | 125 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991216.87042 | 2091758.40738 | 37.7230652785221 | -122.472495529943 | (37.7230652785221, -122.472495529943) | |||
164869 | 164869 | 37115 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4540 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39707 | 5981688.69009077 | 2106263.69511954 | 37.7623366715481 | -122.506507175967 | (37.7623366715481, -122.506507175967) | |
174219 | 174219 | 40023 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1571 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41268 | 6015526.3634 | 2095776.2911 | 37.73547467040311 | -122.388742090508 | (37.7354746704031, -122.388742090508) | |
174810 | 174810 | 31307 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 569 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34947 | 6005068.91365842 | 2111425.45669453 | 37.7778584781223 | -122.42601111452801 | (37.7778584781223, -122.426011114528) | |
176806 | 176806 | 38370 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4245 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 4 | Permit Number 41159 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | |
178533 | 178533 | 31308 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 569 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34947 | 6005068.91365842 | 2111425.45669453 | 37.7778584781223 | -122.42601111452801 | (37.7778584781223, -122.426011114528) | |
178579 | 178579 | 46391 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2474 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 6 | Permit Number 44624 | 5982733.735 | 2098287.5322 | 37.7404978321239 | -122.502302505611 | (37.7404978321239, -122.502302505611) | |
179294 | 179294 | 218220 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 300 Claremont Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 5993448.22771 | 2098043.70132 | 37.7404520434185 | -122.46523855682301 | (37.7404520434185, -122.465238556823) | |||
180522 | 180522 | 250985 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 169 Seal Rock Dr | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5981053.81587 | 2112927.8042099997 | 37.7805969621145 | -122.509197833038 | (37.7805969621145, -122.509197833038) | |||
180771 | 180771 | 31306 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 561 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34946 | 6005105.48028119 | 2111430.55673025 | 37.7778745481219 | -122.425884980842 | (37.7778745481219, -122.425884980842) | |
182701 | 182701 | 210097 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 300 Junipero Serra Blvd | 46 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991383.70914 | 2094347.6763 | 37.7301844215576 | -122.47210744821699 | (37.7301844215576, -122.472107448217) | |||
182887 | 182887 | 37113 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4523 IRVING ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39706 | 5981665.2 | 2106185.8 | 37.7621214108202 | -122.506582640723 | (37.7621214108202, -122.506582640723) | |
186695 | 186695 | 193542 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 610 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6016043.65792 | 2103986.82395 | 37.7580477514291 | -122.387526213378 | (37.7580477514291, -122.387526213378) | |||
187630 | 187630 | 47074 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 106 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 0 | Permit Number 45062 | 5996796.88091549 | 2112360.28017641 | 37.7799542788822 | -122.454694357616 | (37.7799542788822, -122.454694357616) | |
18168 | 18168 | 28136 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 412 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4X4 | 6006951.93492 | 2097890.14157 | 37.7407998823106 | -122.41853703365 | (37.7407998823106, -122.41853703365) | |||
20692 | 20692 | 15069 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1X Minerva St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 11 | 5995941.11063 | 2089006.6713400001 | 37.715781972331 | -122.455966040227 | (37.715781972331, -122.455966040227) | |||
27255 | 27255 | 193544 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6012476.687390001 | 2103624.0786200003 | 37.75685352098429 | -122.39983692765499 | (37.7568535209843, -122.399836927655) | ||||
34976 | 34976 | 210093 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1x Minerva St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5996144.00036 | 2089001.40747 | 37.715779161942 | -122.45526438373899 | (37.715779161942, -122.455264383739) | |||
40612 | 40612 | 193546 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 56 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6012511.31155 | 2102952.5131599996 | 37.7550114792069 | -122.39967003234699 | (37.7550114792069, -122.399670032347) | ||||
49522 | 49522 | 193547 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 65 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012516.839980001 | 2102871.66546 | 37.7547897972265 | -122.39964523714501 | (37.7547897972265, -122.399645237145) | ||||
63329 | 63329 | 193545 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6012471.27665 | 2103561.30428 | 37.7566808547541 | -122.399851232248 | (37.7566808547541, -122.399851232248) | ||||
81132 | 81132 | 15073 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 30X Minerva St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996426.1222644 | 2089040.1488729 | 37.7159017196126 | -122.45429204268801 | (37.7159017196126, -122.454292042688) | |||
89003 | 89003 | 15081 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 80X Minerva St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996060.1066716 | 2089044.9734463 | 37.7158939701237 | -122.455557504311 | (37.7158939701237, -122.455557504311) | |||
128164 | 128164 | 27505 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1761 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2x2 | 6001633.12831 | 2112159.85861 | 37.779680182688104 | -122.43794928965201 | (37.7796801826881, -122.437949289652) | |||
131557 | 131557 | 210095 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1x Minerva St | 47 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5996479.95925 | 2088997.21564 | 37.7157869222034 | -122.454102858955 | (37.7157869222034, -122.454102858955) | |||
138688 | 138688 | 15075 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 42 Minerva St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 11 | 5996338.306623099 | 2089041.3064001 | 37.7158998615697 | -122.454595656346 | (37.7158998615697, -122.454595656346) | |||
159827 | 159827 | 193548 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1300x De Haro St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012271.58863 | 2102171.1791 | 37.7528527402726 | -122.400444188549 | (37.7528527402726, -122.400444188549) | ||||
169128 | 169128 | 210094 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1x Minerva St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5996151.37066 | 2089000.9708099999 | 37.715778385846896 | -122.45523887719801 | (37.7157783858469, -122.455238877198) | |||
127824 | 127824 | 24841 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 200X Alemany Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/12/1996 12:00:00 AM | 8 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) |
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");